[inClass]company(20200909)
Tables (7)
DAPARTMENT_LOCATION (Untitled6)
- dno (Key) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
- lNo (Key2) — CHAR(8) — Foreign key → LOCATION.lNo — NOT NULL
DEPARTMENT (Untitled)
- dno (Key) — CHAR(8) — Primary key — NOT NULL
- dName (Field) — CHAR(32)
- mgrStartDate (Field2) — date
- mgrssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled7)
- dSsn (Key) — CHAR(10) — Primary key — NOT NULL
- dName (Field) — CHAR(30)
- gender (Field2) — CHAR(10)
- bDate (Field3) — date
- relation (Field4) — CHAR(50)
- ssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled2)
- ssn (Key) — CHAR(30) — Primary key — NOT NULL
- fName (Field) — CHAR(30
- minIt (Field2) — CHAR(4)
- lName (Field3) — CHAR(30)
- bDate (Field4) — date
- address (Field5) — CHAR(40)
- gender (Field7) — CHAR(10)
- salary (Field8) — int(20)
- dno (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
- superssn (Key3) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
LOCATION (Untitled5)
- lNo (Key) — CHAR(8) — Primary key — NOT NULL
- lName (Field) — CHAR(30)
- phone (Field2) — CHAR(20)
PROJECT (Untitled3)
- pNo (Key) — CHAR(8) — Primary key — NOT NULL
- pName (Field) — CHAR(30)
- dno (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
WORKSON (Untitled4)
- ssn (Key) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
- pNo (Key2) — CHAR(8) — Foreign key → PROJECT.pNo — NOT NULL
- hour (Field) — int(3)