issuance

743 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('serial.issuance_id_seq'::regclass)
item.issuance item_issuance_fkey C
materialized_holding_code.issuance materialized_holding_code_issuance_fkey C
creator int4 10 null
usr.id issuance_creator_fkey R
editor int4 10 null
usr.id issuance_editor_fkey R
create_date timestamptz 35,6 now()
edit_date timestamptz 35,6 now()
subscription int4 10 null
subscription.id issuance_subscription_fkey C
label text 2147483647 √ null
date_published timestamptz 35,6 √ null
caption_and_pattern int4 10 √ null
caption_and_pattern.id issuance_caption_and_pattern_fkey C
holding_code text 2147483647 √ null
holding_type text 2147483647 √ null
holding_link_id int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
issuance_pkey Primary key Asc id
serial_issuance_caption_and_pattern_idx Performance Asc caption_and_pattern
serial_issuance_date_published_idx Performance Asc date_published
serial_issuance_sub_idx Performance Asc subscription

Check Constraints

Constraint Name Constraint
issuance_holding_code_check (((holding_code IS NULL) OR could_be_serial_holding_code(holding_code)))
issuance_holding_code_check1 (((holding_code IS NULL) OR is_json(holding_code)))
valid_holding_type (((holding_type IS NULL) OR (holding_type = ANY (ARRAY['basic'::text, 'supplement'::text, 'index'::text]))))

Relationships

Close relationships within degrees of separation