KH14-2조 ERD
테이블 (13)
CERT
- CERT_NUMBER — CHAR(6) — 기본 키 — NOT NULL
- CERT_EMAIL — VARCHAR2(60) — NOT NULL
- CERT_TIME — DATE — NOT NULL
CHANGELOG
- ID — NUMBER — 기본 키 — NOT NULL
- STOCKNO — NUMBER — 외래 키 → STOCK.STOCK_NO
- CHANGEDFIELDS — VARCHAR2(4000)
- OLDVALUES — VARCHAR2(4000)
- NEWVALUES — VARCHAR2(4000)
- CHANGEDDATE — TIMESTAMP
DOCUMENT
- DOCUMENT_NO — NUMBER — 기본 키 — NOT NULL
- DOCUMENT_NAME — VARCHAR2(255) — NOT NULL
- DOCUMENT_TYPE — VARCHAR2(90) — NOT NULL
- DOCUMENT_SIZE — NUMBER — NOT NULL
NOTICE
- NOTICE_NO — NUMBER — 기본 키 — NOT NULL
- NOTICE_WRITER — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID
- NOTICE_TITLE — VARCHAR2(100) — NOT NULL
- NOTICE_CONT — VARCHAR2(1000) — NOT NULL
- NOTICE_WTIME — DATE — NOT NULL
- NOTICE_UTIME — DATE
- NOTICE_VIEWS — NUMBER — NOT NULL
- NOTICE_LIKES — NUMBER — NOT NULL
- NOTICE_REPLIES — NUMBER — NOT NULL
- NOTICE_GROUP — NUMBER — NOT NULL
- NOTICE_TARGET — NUMBER — 외래 키 → NOTICE.NOTICE_NO
- NOTICE_DEPTH — NUMBER — NOT NULL
RESERVATION
- RES_ID — NUMBER — 기본 키 — NOT NULL
- ROOM_ID — NUMBER
- PW — NUMBER
- CALDATE — DATE
- ROOM_NAME — VARCHAR2(50)
- GUEST_NAME — VARCHAR2(30) — NOT NULL
- RESYN — VARCHAR2(20)
- STIME — VARCHAR2(30)
- ETIME — VARCHAR2(30)
- LOGINID — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID — NOT NULL
STOCK
- STOCK_NO — NUMBER — 기본 키 — NOT NULL
- STOCK_CATEGORY — VARCHAR2(100)
- STOCK_NAME — VARCHAR2(100)
- STOCK_QUANTITY — NUMBER
- STOCK_DATE — DATE
- IMAGE_URL — VARCHAR2(255)
- EXPIRATION_DATE — DATE
TB_APPROVAL
- APPRO_NO — NUMBER — 기본 키 — NOT NULL
- APPRO_TYPE — VARCHAR2(50) — NOT NULL
- APPRO_DATE — DATE
- APPRO_YN — CHAR(1)
- APPRO_BOSNAME — VARCHAR2(20)
- APPRO_BOSID — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID
- APPLICANTID — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID
TB_APPROVAL_IMAGE
- APPRONO — NUMBER — 외래 키 → TB_APPROVAL.APPRO_NO — NOT NULL
- DOCUMENT — NUMBER — 외래 키 → DOCUMENT.DOCUMENT_NO — NOT NULL
TB_ATTENDANCE
- TA_ATTENDANCE_NO — NUMBER — 기본 키 — NOT NULL
- LOGINID — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID
- CHECK_IN_TIME — TIMESTAMP
- CHECK_OUT_TIME — TIMESTAMP
TB_EMP
- LOGINID — VARCHAR2(20) — 기본 키 — NOT NULL
- USER_TYPE — CHAR(1) — NOT NULL
- EMP_NO — VARCHAR2(10) — NOT NULL
- NAME — VARCHAR2(21) — NOT NULL
- PASSWORD — VARCHAR2(60) — NOT NULL
- EMP_LEVEL — VARCHAR2(9)
- EMP_DEPT — VARCHAR2(5)
- EMP_GENDER — VARCHAR2(1)
- EMP_HP — CHAR(11) — NOT NULL
- EMP_EMAIL — VARCHAR2(254)
- EMP_BIRTH — DATE
- EMP_EDU — VARCHAR2(50)
- EMP_SDATE — DATE — NOT NULL
- EMP_EDATE — DATE
- EMP_FINAL_MONEY — NUMBER
- EMP_REASON — VARCHAR2(300)
- EMP_MEMO — VARCHAR2(300)
- EMP_ACCOUNT_NUMBER — NUMBER
- EMP_BANK — VARCHAR2(10)
- EMP_POST — VARCHAR2(6)
- EMP_ADDRESS1 — VARCHAR2(300)
- EMP_ADDRESS2 — VARCHAR2(300)
- SAL_SAN — NUMBER
- SAL_KO — NUMBER
- SAL_KUN — NUMBER
- SAL_KUK — NUMBER
- SAL_DATE — DATE
- SAL_PRE — NUMBER
- SAL_AFTER — NUMBER
- FILE_NO — NUMBER
- ANNUALLEAVEQUOTA — NUMBER
- ANNUALLEAVEUSED — NUMBER
TB_EMP_IMAGE
- LOGINID — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID — NOT NULL
- DOCUMENT — NUMBER — 외래 키 → DOCUMENT.DOCUMENT_NO — NOT NULL
TB_REPORT
- REPORT_NO — NUMBER — 기본 키 — NOT NULL
- WRITER_ID — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID
- WRITER_DEPT — VARCHAR2(100) — NOT NULL
- WRITER_NAME — VARCHAR2(100) — NOT NULL
- WRITE_DATE — DATE
- REPORT_TITLE — VARCHAR2(100) — NOT NULL
- REPORT_CONTENT — NCLOB — NOT NULL
- REPORT_REJECT — VARCHAR2(4000)
- APPRO_NO — NUMBER — 외래 키 → TB_APPROVAL.APPRO_NO
TB_VACAREQ
- VACA_NO — NUMBER — 기본 키 — NOT NULL
- APPLICANTID — VARCHAR2(20) — 외래 키 → TB_EMP.LOGINID
- VACA_TEL — VARCHAR2(20) — NOT NULL
- VACA_TITLE — VARCHAR2(60) — NOT NULL
- VACA_SDATE — DATE — NOT NULL
- VACA_EDATE — DATE — NOT NULL
- VACA_TYPE — VARCHAR2(50) — NOT NULL
- VACA_REASON — VARCHAR2(4000) — NOT NULL
- VACA_REJECT — VARCHAR2(4000)
- VACA_REQDATE — DATE
- APPRO_NO — NUMBER — 외래 키 → TB_APPROVAL.APPRO_NO