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