org_address

70 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.org_address_id_seq'::regclass)
org_unit.billing_address actor_org_unit_billing_address_fkey R
org_unit.holds_address actor_org_unit_holds_address_fkey R
org_unit.ill_address actor_org_unit_ill_address_fkey R
org_unit.mailing_address actor_org_unit_mailing_address_fkey R
valid bool 1 true
address_type text 2147483647 'MAILING'::text
org_unit int4 10 null
org_unit.id org_address_org_unit_fkey R
street1 text 2147483647 null
street2 text 2147483647 √ null
city text 2147483647 null
county text 2147483647 √ null
state text 2147483647 √ null
country text 2147483647 null
post_code text 2147483647 null
passwd_type.code Implied Constraint R
san text 2147483647 √ null
latitude float8 17,17 √ null
longitude float8 17,17 √ null

Indexes

Constraint Name Type Sort Column(s)
org_address_pkey Primary key Asc id
actor_org_address_org_unit_idx Performance Asc org_unit

Relationships

Close relationships within degrees of separation