actor.address_alert

↑ actor schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.address_alert_id_seq'::regclass)
owner FK	`integer`	No		→ actor.org_unit(id)
active	`boolean`	No	true
match_all	`boolean`	No	true
alert_message	`text`	No
street1	`text`	Yes
street2	`text`	Yes
city	`text`	Yes
county	`text`	Yes
state	`text`	Yes
country	`text`	Yes
post_code	`text`	Yes
mailing_address	`boolean`	No	false
billing_address	`boolean`	No	false

id PK

integer

nextval('actor.address_alert_id_seq'::regclass)

owner FK

integer

→ actor.org_unit(id)

active

boolean

true

match_all

boolean

true

alert_message

text

street1

text

Yes

street2

text

Yes

city

text

Yes

county

text

Yes

state

text

Yes

country

text

Yes

post_code

text

Yes

mailing_address

boolean

false

billing_address

boolean

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owner`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`address_alert_owner_fkey`

owner

actor.org_unit(id)

NO ACTION

DEFERRED

address_alert_owner_fkey

Indexes

Index Method Definition

Index	Method	Definition
`address_alert_pkey` PK	btree	`CREATE UNIQUE INDEX address_alert_pkey ON actor.address_alert USING btree (id)`

address_alert_pkey PK

btree

CREATE UNIQUE INDEX address_alert_pkey ON actor.address_alert USING btree (id)