sql bootcamp 1
Tables (4)
DEPARTMENT (Untitled)
- deptID (Key) — char(3) — Primary key — NOT NULL
- deptName (Field) — char(20)
- ManageStartDate (Field3) — date
- deptManager (Key2) — char(20) — Foreign key → EMPLOYEE.employeeID — NOT NULL
EMPLOYEE (Untitled3)
- employeeID (Key) — char(10) — Primary key — NOT NULL
- employeeName (Field3) — char(30)
- ssn (Field) — char(10)
- address (Field8) — char(30)
- salary (Field2) — integer
- gender (Field4) — char(1)
- birthDate (Field5) — date
- boss (Field7) — char(10)
- deptID (Key2) — char(20) — Foreign key → DEPARTMENT.deptID — NOT NULL
LOCATION (Untitled2)
- locationID (Key) — char(10) — Primary key — NOT NULL
- locationName (Field) — char(20)
- phone (Field2) — char(20)
- fax (Field3) — char(20)
LOCATION_DEPARTMENT (Untitled4)
- deptID (Key3) — char(3) — Foreign key → DEPARTMENT.deptID — NOT NULL
- locationID (Key) — char(10) — Foreign key → LOCATION.locationID — NOT NULL