Staff table (STAFF)
The staff table describes the background information about employees.
The staff table is created with the following CREATE TABLE statement:
CREATE TABLE STAFF
(ID SMALLINT NOT NULL,
NAME VARCHAR(9),
DEPT SMALLINT,
JOB CHAR(5),
YEARS SMALLINT,
SALARY DECIMAL(7,2),
COMM DECIMAL(7,2))
The table below shows the contents of the columns.
Column name | Description |
---|---|
ID | Employee number |
NAME | Employee name |
DEPT | Department number |
JOB | Job title |
YEARS | Years with the company |
SALARY | Employee's annual salary |
COMM | Employee's commission |