Description
contains the names and heads of the various departments in the sporting goods company
Table properties
| name | value |
|---|
| name | GROUPO.Departments |
| row count | 5 |
| Maximum size of a single row | 48 bytes |
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| DepartmentID | integer | 4 | | no
| yes
| |
| |
| DepartmentName | char(40) | 40 | | no
|
| |
| |
| DepartmentHeadID | integer | 4 | | yes
|
| Employees.EmployeeID
|
| |
References
Referenced by
Foreign key graph
Foreign keys
| name | columns | foreign columns | type | comment |
|---|
| FK_DepartmentHeadID_EmployeeID | DepartmentHeadID | Employees.EmployeeID |
| |
Triggers
Dependency graph
Objects that depend on GROUPO.Departments
Sample rows
| DepartmentID | DepartmentName | DepartmentHeadID |
|---|
| 100
| R & D
| 501
|
| 200
| Sales
| 902
|
| 300
| Finance
| 1293
|
| 400
| Marketing
| 1576
|
| 500
| Shipping
| 703
|
Code
CREATE TABLE "GROUPO"."Departments" (
"DepartmentID" integer NOT NULL
,"DepartmentName" char(40) NOT NULL
,"DepartmentHeadID" integer NULL
,CONSTRAINT "DepartmentsKey" PRIMARY KEY ("DepartmentID")
)