Organization table (ORG)

The organization table describes the organization of the corporation.

The organization table is created with the following CREATE TABLE statement:

CREATE TABLE ORG 
             (DEPTNUMB SMALLINT NOT NULL, 
              DEPTNAME VARCHAR(14),
              MANAGER SMALLINT, 
              DIVISION VARCHAR(10), 
              LOCATION VARCHAR(13))

The table below gives the contents of the columns.

Column name Description
DEPTNUMB Department number
DEPTNAME Department name
MANAGER Manager number for the department
DIVISION Division of the department
LOCATION Location of the department