| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| staff_id |
tinyint unsigned |
3 |
|
√ |
|
| payment.staff_id
|
fk_payment_staff R |
| rental.staff_id
|
fk_rental_staff R |
| store.manager_staff_id
|
fk_store_staff R |
|
|
| first_name |
varchar |
45 |
|
|
|
|
|
| last_name |
varchar |
45 |
|
|
|
|
|
| address_id |
smallint unsigned |
5 |
|
|
|
|
| address.address_id
|
fk_staff_address R |
|
| picture |
blob |
65535 |
√ |
|
null |
|
|
| email |
varchar |
50 |
√ |
|
null |
|
|
| store_id |
tinyint unsigned |
3 |
|
|
|
|
| store.store_id
|
fk_staff_store R |
|
| active |
bit |
0 |
|
|
1 |
|
|
| username |
varchar |
16 |
|
|
|
|
|
| password |
varchar |
40 |
√ |
|
null |
|
|
| last_update |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
Table contained 1 rows at Thu Aug 12 09:42 MDT 2010
|
