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