cutom_field_reservation_ERD

Tables (7)

EMPLOYEE_TB

  • EMP_ID — VARCHAR(255) — Primary key — NOT NULL
  • EMP_NM — VARCHAR(255)
  • ORG — VARCHAR(255)
  • POSITION — VARCHAR(255)
  • EMAIL — VARCHAR(255)
  • TELEPHONE_NUM — VARCHAR(255)
  • PHONE_NUM — VARCHAR(255)

EQUIPMENT_CLASS_TB

  • ID — VARCHAR(255) — Primary key — NOT NULL — 0:Thera, 1:Conf
  • NAME — VARCHAR(255)

EQUIPMENT_CUSTOM_FIELD_TB

  • EQUIPMENT_CLASS_ID — VARCHAR(255) — Foreign key → EQUIPMENT_CLASS_TB.ID — NOT NULL
  • KEY — VARCHAR(255)

EQUIPMENT_TB

  • EQUIP_ID — VARCHAR(255) — Primary key — NOT NULL
  • EQUIPMENT_CLASS_ID — VARCHAR(255) — Foreign key → EQUIPMENT_CLASS_TB.ID — NOT NULL
  • CUSTOM_FIELD — XMLTYPE

RESERVATION_CLASS_TB

  • ID — VARCHAR(255) — Primary key — NOT NULL
  • NAME — VARCHAR(255)

RESERVATION_CUSTOM_FIELD_TB

  • RESERVATION_CLASS_ID — VARCHAR(255) — Foreign key → RESERVATION_CLASS_TB.ID — NOT NULL
  • KEY — VARCHAR(255)

RESERVATION_TB

  • RESERVATION_ID — VARCHAR(255) — Primary key — NOT NULL
  • EMP_ID — VARCHAR(255) — Foreign key → EMPLOYEE_TB.EMP_ID — NOT NULL
  • EQUIP_ID — VARCHAR(255) — Foreign key → EQUIPMENT_TB.EQUIP_ID — NOT NULL
  • CREATE_DATE — DATE(19)
  • USE_ST_DATE — DATE(19)
  • USE_ED_DATE — DATE(19)
  • USE_ST_TIME — VARCHAR(255)
  • USE_ED_TIME — VARCHAR(255)
  • CUSTOM_FIELD — XMLTYPE
  • RESERVATION_CLASS_ID — VARCHAR(255) — Foreign key → RESERVATION_CLASS_TB.ID — NOT NULL