| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| address_id |
serial |
10 |
|
√ |
nextval('address_address_id_seq'::regclass) |
| customer.address_id
|
customer_address_id_fkey R |
| staff.address_id
|
staff_address_id_fkey R |
| store.address_id
|
store_address_id_fkey R |
|
|
| address |
varchar |
50 |
|
|
|
|
|
| address2 |
varchar |
50 |
√ |
|
null |
|
|
| district |
varchar |
20 |
|
|
|
|
|
| city_id |
int2 |
5 |
|
|
|
|
| city.city_id
|
address_city_id_fkey R |
|
| postal_code |
varchar |
10 |
√ |
|
null |
|
|
| phone |
varchar |
20 |
|
|
|
|
|
| last_update |
timestamp |
29,6 |
|
|
now() |
|
|
Table contained 603 rows at Mon Feb 20 18:07 CET 2023
|
