subscription

27 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('serial.subscription_id_seq'::regclass)
caption_and_pattern.subscription caption_and_pattern_subscription_fkey C
distribution.subscription distribution_subscription_fkey C
issuance.subscription issuance_subscription_fkey C
subscription_note.subscription subscription_note_subscription_fkey C
owning_lib int4 10 1
org_unit.id subscription_owning_lib_fkey N
start_date timestamptz 35,6 null
end_date timestamptz 35,6 √ null
record_entry int8 19 √ null
record_entry.id subscription_record_entry_fkey N
expected_date_offset interval 49,6 √ null

Indexes

Constraint Name Type Sort Column(s)
subscription_pkey Primary key Asc id
serial_subscription_owner_idx Performance Asc owning_lib
serial_subscription_record_idx Performance Asc record_entry

Relationships

Close relationships within degrees of separation