address

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
address_id serial 10 √ nextval('address_address_id_seq'::regclass)
customer.address_id customer_address_id_fkeyR
staff.address_id staff_address_id_fkeyR
store.address_id store_address_id_fkeyR
address varchar 50 null
address2 varchar 50 √ null
district varchar 20 null
city_id int2 5 null
city.city_id address_city_id_fkeyR
postal_code varchar 10 √ null
phone varchar 20 null
last_update timestamp 29,6 now()

Indexes

Constraint Name Type Sort Column(s)
address_pkey Primary key Asc address_id
idx_fk_city_id Performance Asc city_id

Relationships

Close relationships within degrees of separation