actor.org_address

↑ actor schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.org_address_id_seq'::regclass)

valid

boolean

No

true

address_type

text

No

'MAILING'::text

org_unit FK

integer

No

→ actor.org_unit(id)

street1

text

No

street2

text

Yes

city

text

No

county

text

Yes

state

text

Yes

country

text

No

post_code

text

No

san

text

Yes

latitude

double precision

Yes

longitude

double precision

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

org_unit

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

org_address_org_unit_fkey

Indexes

Index Method Definition

org_address_pkey PK

btree

CREATE UNIQUE INDEX org_address_pkey ON actor.org_address USING btree (id)

actor_org_address_org_unit_idx

btree

CREATE INDEX actor_org_address_org_unit_idx ON actor.org_address USING btree (org_unit)

Referenced By

The following tables have foreign keys pointing to actor.org_address (4 referencing table(s)):

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

actor.org_unit

billing_address

id

actor_org_unit_billing_address_fkey

actor.org_unit

holds_address

id

actor_org_unit_holds_address_fkey

actor.org_unit

ill_address

id

actor_org_unit_ill_address_fkey

actor.org_unit

mailing_address

id

actor_org_unit_mailing_address_fkey
Previous
Next