caption_and_pattern

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('serial.caption_and_pattern_id_seq'::regclass)
issuance.caption_and_pattern issuance_caption_and_pattern_fkey C
subscription int4 10 null
subscription.id caption_and_pattern_subscription_fkey C
type text 2147483647 null
create_date timestamptz 35,6 now()
start_date timestamptz 35,6 now()
end_date timestamptz 35,6 √ null
active bool 1 false
pattern_code text 2147483647 null
enum_1 text 2147483647 √ null
enum_2 text 2147483647 √ null
enum_3 text 2147483647 √ null
enum_4 text 2147483647 √ null
enum_5 text 2147483647 √ null
enum_6 text 2147483647 √ null
chron_1 text 2147483647 √ null
chron_2 text 2147483647 √ null
chron_3 text 2147483647 √ null
chron_4 text 2147483647 √ null
chron_5 text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
caption_and_pattern_pkey Primary key Asc id
serial_caption_and_pattern_sub_idx Performance Asc subscription

Check Constraints

Constraint Name Constraint
cap_type ((type = ANY (ARRAY['basic'::text, 'supplement'::text, 'index'::text])))

Relationships

Close relationships within degrees of separation