시스템분석론 예재
테이블 (4)
DEPARTMENT (Untitled)
- departmentID (Key) — character(10) — 기본 키 — NOT NULL
- departmentName (Field) — character(20)
- departmentManager (Field2) — int(10)
- manageStartDate (Field3) — date
EMPLOYEE (Untitled2)
- employeeID (Key) — int(13) — 기본 키 — NOT NULL
- employeeName (Field) — character(20)
- employeeAdress (Field2) — character(30)
- employeeSex (Field3) — character(1)
- employeeBirthday (Field4) — int(8)
- employeeDepartment (Field5) — character(10)
- employeeSuperviser (Field8) — character(20)
- employeeProject (Field6) — character(30)
- employeeWorkTime (Field7) — int(3)
FAMILY (Untitled4)
- employeeName (Key) — character(20) — 기본 키 — NOT NULL
- familyName (Field) — character(20)
- familySex (Field2) — character(1)
- familyBirthday (Field3) — int(8)
- familyRelationship (Field4) — character(10)
PROJECT (Untitled3)
- projectNo (Key) — int(20) — 기본 키 — NOT NULL
- projectName (Field) — character(30)
- projectLocation (Field2) — character(30)
- projectControllingDepartment (Field3) — character(20)