자동화 과제
테이블 (7)
Department
- Key (DepNo) — int(5) — 기본 키 — NOT NULL
- Field (Name) — char(20)
- Key (ManagerNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
- Field (ManageStarDate) — Date
Employee
- Key (EmpNo) — int(10) — 기본 키 — NOT NULL
- Field (Name) — varchar(5)
- Field (ID) — int(13)
- Field (Gender) — char(1)
- Field (Address) — varchar(30)
- Field (Wage) — int(10)
- Key (SupervisorNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
- Key (DepNo) — int(5) — 외래 키 → Department.Key — NOT NULL
Untitled (Project)
- Key (ProNo) — int(5) — 기본 키 — NOT NULL
- Field (Name) — varchar(20)
- Key (DepNo) — int(5) — 외래 키 → Department.Key — NOT NULL
- Field (Field2) — 외래 키
Untitled (Family)
- Key (Relation) — char(2) — 기본 키 — NOT NULL
- Field (Name) — varchar(5)
- Field2 (Gender) — char(1)
- Field3 (BDay) — date
- Key (EmpNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
Untitled (Location)
- Key (LocNo) — int(5) — 기본 키 — NOT NULL
- Field (Name) — varchar(20)
- Field (Address) — varchar(30)
Untitled (Department location)
- Key (LocNo) — int(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (DepNo) — int(5) — 외래 키 → Department.Key — NOT NULL
- Field (Field2) — 외래 키
Untitled (JoinProject)
- Key (ProNo) — int(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (EmpNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
- Key (SupervisorNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
- Field (Hours/w) — int2