serial.caption_and_pattern

↑ serial schema

Cascading Deletes: Deleting rows from this table will cascade to: serial.subscription.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: caption_and_pattern_subscription_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('serial.caption_and_pattern_id_seq'::regclass)

subscription FK

integer

No

→ serial.subscription(id)

type

text

No

create_date

timestamp with time zone

No

now()

start_date

timestamp with time zone

No

now()

end_date

timestamp with time zone

Yes

active

boolean

No

false

pattern_code

text

No

enum_1

text

Yes

enum_2

text

Yes

enum_3

text

Yes

enum_4

text

Yes

enum_5

text

Yes

enum_6

text

Yes

chron_1

text

Yes

chron_2

text

Yes

chron_3

text

Yes

chron_4

text

Yes

chron_5

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

subscription

serial.subscription(id)

CASCADE

NO ACTION

DEFERRED

caption_and_pattern_subscription_fkey

Check Constraints

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

Indexes

Index Method Definition

caption_and_pattern_pkey PK

btree

CREATE UNIQUE INDEX caption_and_pattern_pkey ON serial.caption_and_pattern USING btree (id)

serial_caption_and_pattern_sub_idx

btree

CREATE INDEX serial_caption_and_pattern_sub_idx ON serial.caption_and_pattern USING btree (subscription)

Referenced By

The following tables have foreign keys pointing to serial.caption_and_pattern (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

serial.issuance

caption_and_pattern

id

issuance_caption_and_pattern_fkey
Previous
Next