erp
Tables (4)
DI_INFO (부서정보)
- DI_ID (부서번호) — INT — Primary key — NOT NULL
- DI_NAME (부서이름) — VARCHAR2
EMP_INFO (사원정보)
- EMP_ID (사원코드) — INT — Primary key — NOT NULL
- DI_ID (부서번호) — INT — Foreign key → DI_INFO.DI_ID — NOT NULL
- EMP_NAME (사원이름) — VARCHAR2
- EMP_ADDR (주소) — VARCHAR2
- EMP_TEL (연락처) — VARCHAR2
- EMP_BIR (생년월일) — DATE
- EMP_HIR (입사일) — DATE
SAL_HIST (연봉이력)
- SAL_HIST (연봉코드) — INT — Primary key — NOT NULL
- EMP_ID (사원코드) — INT — Foreign key → EMP_INFO.EMP_ID — NOT NULL
- DI_ID (부서번호) — INT — Foreign key → EMP_INFO.DI_ID — NOT NULL
- SAL_YEAR (연도) — DATE — Foreign key → SAL_INFO.SAL_YEAR — NOT NULL
- SAL_RANK (직급) — VARCHAR2 — Foreign key → SAL_INFO.SAL_RANK — NOT NULL
- DI_ID (부서번호2) — INT — Foreign key → SAL_INFO.DI_ID — NOT NULL
SAL_INFO (연봉테이블)
- SAL_YEAR (연도) — DATE — Primary key — NOT NULL
- SAL_RANK (직급) — VARCHAR2 — Primary key — NOT NULL
- DI_ID (부서번호) — INT — Foreign key → DI_INFO.DI_ID — NOT NULL
- SAL_TOTAL (연봉금액) — INT