Table staff
This table lists all staff members, including information for email address, login information, and picture. The table refers to the store and address tables using foreign keys, and is referred to by the rental, payment, and store tables.
Schema
This table belongs to schema sakila.
Columns
This table contains 11 columns.
staff_id
-
smallint
·NOT NULL
A surrogate primary key that uniquely identifies the staff member.
first_name
-
character varying(45)
·NOT NULL
The first name of the staff member.
last_name
-
character varying(45)
·NOT NULL
The last name of the staff member.
address_id
-
smallint
·NOT NULL
A foreign key to the staff member address in the address table.
picture
-
bytea
A BLOB containing a photograph of the employee.
email
-
character varying(50)
·NULL::character varying
The staff member email address.
store_id
-
smallint
·NOT NULL
The staff member home store. The employee can work at other stores but is generally assigned to the store listed.
active
-
boolean
·NOT NULL
·true
Whether this is an active employee. If employees leave, their rows are not deleted from this table; instead, this column is set to
FALSE
. username
-
character varying(16)
·NOT NULL
The user name used by the staff member to access the rental system.
password
-
character varying(40)
·NULL::character varying
The password used by the staff member to access the rental system. The password should be stored as a secure hash.
last_update
-
timestamp(0) without time zone
·NOT NULL
·CURRENT_TIMESTAMP
Primary key
This table has a primary key.
staff
-
staff_id
Foreign keys
This table has one foreign key.
fk_staff_address
-
address_id
»sakila.address (address_id)
·ON UPDATE CASCADE
·ON DELETE RESTRICT
fk_staff_store
-
store_id
»sakila.store (store_id)
·ON UPDATE CASCADE
·ON DELETE RESTRICT
Indices
This table has 3 indices.
staff_pkey
-
staff_id
idx_staff_fk_address_id
-
address_id
idx_staff_fk_store_id
-
store_id