CustomField version 회의실 + 건강관리실

테이블 (7)

EMPLOYEE_TB

  • EMP_ID — VARCHAR(255) — 기본 키 — NOT NULL
  • EMP_NM — VARCHAR(255)
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)

EQUIPMENT_CLASS_TB

  • ID — VARCHAR(255) — 기본 키 — NOT NULL
  • NAME — VARCHAR(255)

EQUIPMENT_CUSTOM_FIELD_TB

  • EQUIPMENT_CLASS_ID — VARCHAR(255) — 외래 키 → EQUIPMENT_CLASS_TB.ID — NOT NULL
  • KEY — VARCHAR(255)

EQUIPMENT_TB

  • EQUIP_ID — VARCHAR(255) — 기본 키 — NOT NULL
  • EQUIPMENT_CLASS_ID — VARCHAR(255) — 외래 키 → EQUIPMENT_CLASS_TB.ID — NOT NULL
  • CUSTOM_FIELD — XMLTYPE

RESERVATION_CLASS_TB

  • ID — VARCHAR(255) — 기본 키 — NOT NULL
  • NAME — VARCHAR(255)

RESERVATION_CUSTOM_FIELD_TB

  • RESERVATION_CLASS_ID — VARCHAR(255) — 외래 키 → RESERVATION_CLASS_TB.ID — NOT NULL
  • KEY — VARCHAR(255)

RESERVATION_TB

  • RESERVATION_ID — VARCHAR(255) — 기본 키 — NOT NULL
  • EMP_ID — VARCHAR(255) — 외래 키 → EMPLOYEE_TB.EMP_ID — NOT NULL
  • EQUIP_ID — VARCHAR(255) — 외래 키 → EQUIPMENT_TB.EQUIP_ID — NOT NULL
  • CREATE_DATE — VARCHAR(255)
  • USE_ST_DATE — VARCHAR(255)
  • USE_ED_DATE — VARCHAR(255)
  • USE_ST_TIME — VARCHAR(255)
  • USE_ED_TIME — VARCHAR(255)
  • CUSTOM_FIELD — XMLTYPE
  • RESERVATION_CLASS_ID — VARCHAR(255) — 외래 키 → RESERVATION_CLASS_TB.ID — NOT NULL