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