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