2022-05-02 WS
Tables (3)
DEPT (Untitled3)
- DEPTNO (부서코드) — CHAR(2) — Primary key — NOT NULL
- DEPTNAME (부서명) — VARCHARAR(20)
- DEPTLOC (부서위치) — VARCHAR(20)
- Field
- EMPNO (아이디) — CHAR(4) — Foreign key → EMP.EMPNO — NOT NULL
EMP (Untitled)
- EMPNO (아이디) — CHAR(4) — Primary key — NOT NULL
- TITLENO (직급) — CHAR(2)
- DEPTNO (부서) — CHAR(2)
- EMPNAME (이름) — VARCHAR(10)
- MANAGER (관리자) — CHAR(4)
- SALARY (연봉) — INT(5)
- HDATE (입사일) — DATE
- Field
TITLE (Untitled2)
- TITLENO (코드) — VARCHAR(2) — Primary key — NOT NULL
- TITLENAME (직급명) — VARCHAR(20)
- Field
- EMPNO (아이디) — CHAR(4) — Foreign key → EMP.EMPNO — NOT NULL