company
Tables (7)
DEPARTMENT (Untitled)
- dept_nb (Key) — CHAR(8) — Primary key — NOT NULL
- dept_name (Field) — CHAR(32)
DEPENDENT (Untitled4)
- dep_nb (Key) — CHAR(8) — Primary key — NOT NULL
- Field
DEPT-LOC (Untitled7)
- dept_nb (Key) — CHAR(8) — Primary key — NOT NULL
- loc_nb (Field) — INT(2)
- startdate (Field2) — DATE
EMPLOYEE (Untitled3)
- emp_id (Key) — CAHR(30) — Primary key — NOT NULL
- dept_id (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dept_nb — NOT NULL
- minit (Field2) — CHAR(30)
- lname (Field3) — CHAR(30)
- bdate (Field4) — date
- address (Field5) — VARCHAR
- sex (Field6) — CHAR(30)
- salary (Field7) — INT(30)
- superssn (Field8) — CHAR(30)
LOCATION (Untitled2)
- loc_nb (Key) — INT2 — Primary key — NOT NULL
- address (Field) — VARCHAR
- name (Field2) — CHAR(30)
PROJECT (Untitled5)
- pro_id (Key) — CHAR(30) — Primary key — NOT NULL
- name (Field) — CHAR(30)
- plocation (Field2) — CHAR(30)
WORKSON (Untitled6)
- work_id (Key) — CHAR(30) — Primary key — NOT NULL
- emp_id (Field) — CHAR(30)
- pro_id (Field2) — CHAR(30)
- hour (Field3) — INT(3)