ㄴㄴㅁㅇㅁㄴ
Tables (9)
DEPARTMENT
- Deptno — INT
- Depname — VARCHAR(100)
- Floor — INT
DEPENDENT
- Empno — INT
- Depname — VARCHAR(100)
- Sex — CHAR(1)
EMPLOYEE
- Empno — INT
- Empname — VARCHAR(100)
- Title — VARCHAR(50)
- Salary — DECIMAL(15,2)
- City — VARCHAR(50)
- Ku — VARCHAR(50)
- Dong — VARCHAR(50)
- Deptno — INT
PART
- Partno — INT
- Partname — VARCHAR(100)
- Price — DECIMAL(15,2)
- Subpartno — INT
PROJECT
- Projno — INT
- Projname — VARCHAR(100)
- Budget — DECIMAL(15,2)
- StartDate — DATE
- Manager — INT
PROJ_LOC
- Projno — INT
- Location — VARCHAR(100)
SUPPLIER
- Suppno — INT
- Suppname — VARCHAR(100)
- Credit — INT
SUPPLY
- Suppno — INT
- Projno — INT
- Partno — INT
- Quantity — INT
WORKS_FOR
- Empno — INT
- Projno — INT
- Duration — INT
- Responsibility — VARCHAR(100)