| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| customer_id |
smallint unsigned |
5 |
|
√ |
|
| payment.customer_id
|
fk_payment_customer R |
| rental.customer_id
|
fk_rental_customer R |
|
|
| store_id |
tinyint unsigned |
3 |
|
|
|
|
| store.store_id
|
fk_customer_store R |
|
| first_name |
varchar |
45 |
|
|
|
|
|
| last_name |
varchar |
45 |
|
|
|
|
|
| email |
varchar |
50 |
√ |
|
null |
|
|
| address_id |
smallint unsigned |
5 |
|
|
|
|
| address.address_id
|
fk_customer_address R |
|
| active |
bit |
0 |
|
|
1 |
|
|
| create_date |
datetime |
19 |
|
|
|
|
|
| last_update |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
Table contained 541 rows at Thu Aug 12 09:42 MDT 2010
|
