item

750 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('serial.item_id_seq'::regclass)
serial_claim.item serial_claim_item_fkey R
item_note.item item_note_item_fkey C
creator int4 10 null
usr.id item_creator_fkey R
editor int4 10 null
usr.id item_editor_fkey R
create_date timestamptz 35,6 now()
edit_date timestamptz 35,6 now()
issuance int4 10 null
issuance.id item_issuance_fkey C
stream int4 10 null
stream.id item_stream_fkey C
unit int4 10 √ null
unit.id item_unit_fkey N
uri int4 10 √ null
uri.id item_uri_fkey N
date_expected timestamptz 35,6 √ null
date_received timestamptz 35,6 √ null
status text 2147483647 √ 'Expected'::text
shadowed bool 1 false

Indexes

Constraint Name Type Sort Column(s)
item_pkey Primary key Asc id
serial_item_date_received_idx Performance Asc date_received
serial_item_issuance_idx Performance Asc issuance
serial_item_status_idx Performance Asc status
serial_item_stream_idx Performance Asc stream
serial_item_unit_idx Performance Asc unit
serial_item_uri_idx Performance Asc uri

Check Constraints

Constraint Name Constraint
valid_status ((status = ANY (ARRAY['Bindery'::text, 'Bound'::text, 'Claimed'::text, 'Discarded'::text, 'Expected'::text, 'Not Held'::text, 'Not Published'::text, 'Received'::text])))

Relationships

Close relationships within degrees of separation