COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
DEPARTMENT_ID | NUMBER(4,0) | No | null | 1 | Primary key column of departments table. |
DEPARTMENT_NAME | VARCHAR2(30 BYTE) | No | null | 2 | A not null column that shows name of a department. Administration, Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public Relations, Sales, Finance, and Accounting. |
MANAGER_ID | NUMBER(6,0) | Yes | null | 3 | Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column. |
LOCATION_ID | NUMBER(4,0) | Yes | null | 4 | Location id where a department is located. Foreign key to location_id column of locations table. |