session_tracker

17 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('vandelay.session_tracker_id_seq'::regclass)
session_key text 2147483647 null
name text 2147483647 null
usr int4 10 null
usr.id session_tracker_usr_fkey R
workstation int4 10 null
workstation.id session_tracker_workstation_fkey C
record_type text 2147483647 'bib'::text
queue int8 19 null
create_time timestamptz 35,6 now()
update_time timestamptz 35,6 now()
state text 2147483647 'active'::text
action_type text 2147483647 'enqueue'::text
total_actions int4 10 0
actions_performed int4 10 0

Indexes

Constraint Name Type Sort Column(s)
session_tracker_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
vand_tracker_valid_state ((state = ANY (ARRAY['active'::text, 'error'::text, 'complete'::text])))
vand_tracker_valid_action_type ((action_type = ANY (ARRAY['upload'::text, 'enqueue'::text, 'import'::text])))
vand_tracker_valid_record_type ((record_type = ANY (ARRAY['bib'::text, 'authority'::text])))

Relationships

Close relationships within degrees of separation