TEST01

Tables (13)

HR_CALCPAY

  • YM — VARCHAR2(20) — Primary key — NOT NULL
  • NO_EMP — NUMBER — Foreign key → MA_EMP.사원번호
  • CD_PAY — VARCHAR2(20) — NOT NULL
  • AM_TOTPAY — NUMBER
  • CD_DEDUCT — VARCHAR2(20) — NOT NULL
  • AM_TOTDEDUCT — NUMBER

HR_DCALCPAY

  • NO_EMP — NUMBER — Foreign key → MA_EMP.사원번호 — NOT NULL
  • YM — VARCHAR2(20) — Foreign key → HR_CALCPAY.YM — NOT NULL
  • CD_DEDUCT01 — VARCHAR2(20)
  • CD_DEDUCT02 — VARCHAR2(20)
  • CD_DEDUCT03 — VARCHAR2(20)
  • CD_DEDUCT04 — VARCHAR2(20)
  • NM_DEDUCT01 — VARCHAR2(50)
  • NM_DEDUCT02 — VARCHAR2(50)
  • NM_DEDUCT03 — VARCHAR2(50)
  • NM_DEDUCT04 — VARCHAR2(50)
  • AM_DEDUCT01 — NUMBER
  • AM_DEDUCT02 — NUMBER
  • AM_DEDUCT03 — NUMBER
  • AM_DEDUCT04 — NUMBER

HR_PAYLIST

  • NO_EMP — NUMBER — Foreign key → MA_EMP.사원번호
  • PAY_PER_HOUR — NUMBER
  • PAY_PER_DAY — NUMBER
  • PAY_PER_MONTH — NUMBER
  • PAY_PER_YEAR — NUMBER

HR_PAYREPORT

  • CD_PAYREPORT — VARCHAR2(50) — NOT NULL
  • NM_PAYREPORT — VARCHAR2(50) — NOT NULL

HR_PCALCPAY

  • NO_EMP — NUMBER — NOT NULL
  • YM — VARCHAR2(20) — Foreign key → HR_CALCPAY.YM — NOT NULL
  • CD_PAY01 — VARCHAR2(20)
  • CD_PAY02 — VARCHAR2(20)
  • CD_PAY03 — VARCHAR2(20)
  • CD_PAY04 — VARCHAR2(20)
  • NM_PAY01 — VARCHAR2(50)
  • NM_PAY02 — VARCHAR2(50)
  • NM_PAY03 — VARCHAR2(50)
  • NM_PAY04 — VARCHAR2(50)
  • AM_PAY01 — NUMBER
  • AM_PAY02 — NUMBER
  • AM_PAY03 — NUMBER
  • AM_PAY04 — NUMBER

MA_BOARD

  • B_NO — NUMBER
  • NO_EMP — NUMBER — Foreign key → MA_EMP.사원번호
  • SUBJECT — VARCHAR2(50) — NOT NULL
  • CONTENT — VARCHAR2(3000)
  • REG_DATE — DATE
  • READCOUNT — NUMBER — NOT NULL
  • PRINT_NO — NUMBER — NOT NULL

MA_CODE_EMP

  • CD_EMP — VARCHAR2(20)
  • NM_CD_EMP — VARCHAR2(20) — NOT NULL

MA_DEPT

  • CD_DEPT — VARCHAR2(20)
  • NM_DEPT — VARCHAR2(30) — NOT NULL

MA_EMP

  • 사원번호 (NO_EMP) — NUMBER
  • 사원이름 (NM_EMP) — VARCHAR2(20) — NOT NULL
  • 어쩌구 저쩌구 (ENTER_DATE) — DATE — NOT NULL
  • BIRTH_DATE — DATE — NOT NULL
  • RETIRE_DATE — DATE
  • CD_EMP — VARCHAR2(20) — Foreign key → MA_CODE_EMP.CD_EMP
  • CD_DEPT — VARCHAR2(20) — Foreign key → MA_DEPT.CD_DEPT — NOT NULL
  • CD_JIK — VARCHAR2(20) — Foreign key → MA_JIKUP.CD_JIK — NOT NULL

MA_EMP_PRIVATE

  • NO_EMP — NUMBER — Foreign key → MA_EMP.사원번호
  • EMAIL — VARCHAR2(50)
  • NM_ADDR — VARCHAR2(200)
  • NO_RES — VARCHAR2(20) — NOT NULL

MA_JIKUP

  • CD_JIK — VARCHAR2(20)
  • NM_JIK — VARCHAR2(30) — NOT NULL

MA_RE_BOARD

  • B_NO — NUMBER
  • NO_EMP — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(3000) — NOT NULL
  • REG_DATE — DATE
  • PRINT_LEVEL — NUMBER — NOT NULL

MA_USER

  • NO_EMP — NUMBER — Foreign key → MA_EMP.사원번호
  • USER_ID — VARCHAR2(50) — NOT NULL
  • USER_PWD — VARCHAR2(50) — NOT NULL
  • YN_ADMIN — VARCHAR2(50) — NOT NULL