staff

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
staff_id serial 10 √ nextval('staff_staff_id_seq'::regclass)
payment.staff_id payment_staff_id_fkeyR
payment_p2007_01.staff_id payment_p2007_01_staff_id_fkeyR
payment_p2007_02.staff_id payment_p2007_02_staff_id_fkeyR
payment_p2007_03.staff_id payment_p2007_03_staff_id_fkeyR
payment_p2007_04.staff_id payment_p2007_04_staff_id_fkeyR
payment_p2007_05.staff_id payment_p2007_05_staff_id_fkeyR
payment_p2007_06.staff_id payment_p2007_06_staff_id_fkeyR
rental.staff_id rental_staff_id_fkeyR
store.manager_staff_id store_manager_staff_id_fkeyR
first_name varchar 45 null
last_name varchar 45 null
address_id int2 5 null
address.address_id staff_address_id_fkeyR
email varchar 50 √ null
store_id int2 5 null
store.store_id staff_store_id_fkeyR
active bool 1 true
username varchar 16 null
password varchar 40 √ null
last_update timestamp 29,6 now()
picture bytea 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
staff_pkey Primary key Asc staff_id

Relationships

Close relationships within degrees of separation