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