provider_contact_address

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.provider_contact_address_id_seq'::regclass)
valid bool 1 true
address_type text 2147483647 √ null
contact int4 10 null
provider_contact.id provider_contact_address_contact_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
fax_phone text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
provider_contact_address_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation