acq.claim_policy_action

Cascading Deletes: Deleting rows from this table will cascade to: acq.claim_policy.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.claim_policy_action_id_seq'::regclass)
claim_policy FK	`integer`	No		→ acq.claim_policy(id)
action_interval	`interval`	No
action FK	`integer`	No		→ acq.claim_event_type(id)

id PK

integer

nextval('acq.claim_policy_action_id_seq'::regclass)

claim_policy FK

integer

→ acq.claim_policy(id)

action_interval

interval

action FK

integer

→ acq.claim_event_type(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`action`	acq.claim_event_type(id)	NO ACTION	NO ACTION	DEFERRED	`claim_policy_action_action_fkey`
`claim_policy`	acq.claim_policy(id)	CASCADE	NO ACTION	DEFERRED	`claim_policy_action_claim_policy_fkey`

action

acq.claim_event_type(id)

NO ACTION

DEFERRED

claim_policy_action_action_fkey

claim_policy

acq.claim_policy(id)

CASCADE

NO ACTION

DEFERRED

claim_policy_action_claim_policy_fkey

Unique Constraints

action_sequence: (claim_policy, action_interval)

Indexes

Index Method Definition

Index	Method	Definition
`claim_policy_action_pkey` PK	btree	`CREATE UNIQUE INDEX claim_policy_action_pkey ON acq.claim_policy_action USING btree (id)`
`action_sequence` UNIQUE	btree	`CREATE UNIQUE INDEX action_sequence ON acq.claim_policy_action USING btree (claim_policy, action_interval)`

claim_policy_action_pkey PK

btree

CREATE UNIQUE INDEX claim_policy_action_pkey ON acq.claim_policy_action USING btree (id)

action_sequence UNIQUE

btree

CREATE UNIQUE INDEX action_sequence ON acq.claim_policy_action USING btree (claim_policy, action_interval)