MIS_60210872_박상민
테이블 (12)
BELONGS
- Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
- Deptno — int — 외래 키 → DEPARTMENT.Deptno — NOT NULL
CONTAINS
- Partno — int — 외래 키 → PART.Partno — NOT NULL
DEPARTMENT
- Deptno — int — 기본 키 — NOT NULL
- Depname — varchar
- Floor — int
DEPENDENT
- Depname — varchar — 기본 키 — NOT NULL
- Sex — varchar
EMPLOYEE (EMPLOYEE_1)
- Empno — int — 기본 키 — NOT NULL
- Empname — varchar
- Title — varchar
- Salary — decimal
- City
- Ku
- Dong
MANAGES
- Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
- Projno — int — 외래 키 → PROJECT.Projno — NOT NULL
- Startdate
PART
- Partno — int — 기본 키 — NOT NULL
- Partname — varchar
- Price — decimal
POLICY
- Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
- Depname — varchar — 외래 키 → DEPENDENT.Depname — NOT NULL
PROJECT
- Projno — int — 기본 키 — NOT NULL
- Projname — varchar
- Budget — decimal
- Location — varchar
SUPPLIER
- Suppno — int — 기본 키 — NOT NULL
- Suppname — varchar
- Credit — int
SUPPLIES
- Projno — int — 외래 키 → PROJECT.Projno — NOT NULL
- Partno — int — 외래 키 → PART.Partno — NOT NULL
- Suppno — int — 외래 키 → SUPPLIER.Suppno — NOT NULL
- Quantity
WORKS_FOR
- Projno — int — 외래 키 → PROJECT.Projno — NOT NULL
- Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
- Druation
- Responsibility