Skip to content

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