Table: address

Columns
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('lilo_address_id_seq'::regclass)
organization.address_id fk_account_address R
user.address_id fk_user_address R
company varchar 255  √  null
firstname varchar 255  √  null
lastname varchar 255  √  null
address varchar 255  √  null
zipcode varchar 45  √  null
city varchar 45  √  null
state varchar 255  √  null
country varchar 2  √  null
phone varchar 255  √  null
fax varchar 255  √  null
website varchar 255  √  null
vatid varchar 255  √  null

Table contained 14 rows at Mon Apr 04 23:14 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc lilo_address_pkey

Close relationships  within of separation: