routing_list_user

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('serial.routing_list_user_id_seq'::regclass)
stream int4 10 null
stream.id routing_list_user_stream_fkey C
pos int4 10 1
reader int4 10 √ null
usr.id routing_list_user_reader_fkey C
department text 2147483647 √ null
note text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
routing_list_user_pkey Primary key Asc id
one_pos_per_routing_list Must be unique Asc/Asc stream + pos
serial_routing_list_user_reader_idx Performance Asc reader
serial_routing_list_user_stream_idx Performance Asc stream

Check Constraints

Constraint Name Constraint
reader_or_dept ((((reader IS NOT NULL) AND (department IS NULL)) OR ((reader IS NULL) AND (department IS NOT NULL))))

Relationships

Close relationships within degrees of separation