| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| address_id |
smallint unsigned |
5 |
|
√ |
|
| customer.address_id
|
fk_customer_address R |
| staff.address_id
|
fk_staff_address R |
| store.address_id
|
fk_store_address R |
|
|
| address |
varchar |
50 |
|
|
|
|
|
| address2 |
varchar |
50 |
√ |
|
null |
|
|
| district |
varchar |
20 |
|
|
|
|
|
| city_id |
smallint unsigned |
5 |
|
|
|
|
| city.city_id
|
fk_address_city R |
|
| postal_code |
varchar |
10 |
√ |
|
null |
|
|
| phone |
varchar |
20 |
|
|
|
|
|
| last_update |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
Table contained 589 rows at Thu Aug 12 09:42 MDT 2010
|
