옴니채널 티켓 모듈 ERD
테이블 (12)
TICKET_CHANNEL_TB
- ID — NUMBER — 기본 키 — NOT NULL
- NAME — VARCHAR(65000) — NOT NULL
TICKET_COMMENT_TB
- ID — NUMBER — 기본 키 — NOT NULL
- TICKET_ID — NUMBER — 외래 키 → TICKET_TB.ID — NOT NULL
- CREATED_TIMESTAMP — TIMESTAMP — NOT NULL
- MODIFIED_TIMESTAMP — TIMESTAMP — NOT NULL
- IS_ANSWER — NUMBER — NOT NULL
- COMMENT — VARCHAR(65000) — NOT NULL
- INPUT_TICKET_CHANNEL_ID — NUMBER — 외래 키 → TICKET_CHANNEL_TB.ID
- OUTPUT_TICKET_CHANNEL_ID — NUMBER — 외래 키 → TICKET_CHANNEL_TB.ID
TICKET_STATUS_TB
- ID — NUMBER — 기본 키 — NOT NULL
- NAME — VARCHAR(20) — NOT NULL
TICKET_TB
- ID — NUMBER — 기본 키 — NOT NULL
- REQUESTER_ID — NUMBER — 외래 키 → USER_TB.ID — NOT NULL
- TICKET_TYPE_ID — NUMBER — 외래 키 → TICKET_TYPE_ID_TB.ID — NOT NULL
- STATUS_ID — NUMBER — 외래 키 → TICKET_STATUS_TB.ID — NOT NULL
- INPUT_TICKET_CHANNEL_ID — NUMBER — 외래 키 → TICKET_CHANNEL_TB.ID — NOT NULL
- TITLE — VARCHAR(65000) — NOT NULL
- REQUEST — VARCHAR(65000) — NOT NULL
- CREATED_TIMESTAMP — TIMESTAMP — NOT NULL
- MODIFIED_TIMESTAMP — TIMESTAMP — NOT NULL
- IS_TICKET — NUMBER — NOT NULL
TICKET_TYPE_1_TB
- ID — NUMBER — 외래 키 → TICKET_TB.ID — NOT NULL
- VERSION — NUMBER — NOT NULL
- PROCESSOR — NUMBER — NOT NULL
- CLASS — VARCHAR(50) — NOT NULL
- TICKET_TYPE_ID — NUMBER — 외래 키 → TICKET_TYPE_ID_TB.ID — NOT NULL
TICKET_TYPE_2_TB
- ID — NUMBER — 외래 키 → TICKET_TB.ID — NOT NULL
- VERSION — NUMBER — NOT NULL
- PROCESSOR — NUMBER — NOT NULL
- CLASS — VARCHAR(50) — NOT NULL
- TICKET_TYPE_ID — NUMBER — 외래 키 → TICKET_TYPE_ID_TB.ID — NOT NULL
TICKET_TYPE_3_TB
- ID — NUMBER — 외래 키 → TICKET_TB.ID — NOT NULL
- CLASS — VARCHAR(50) — NOT NULL
- DURATION — NUMBER — NOT NULL
- USER_NUM — NUMBER — NOT NULL
- TICKET_TYPE_ID — NUMBER — 외래 키 → TICKET_TYPE_ID_TB.ID — NOT NULL
TICKET_TYPE_4_TB
- ID — NUMBER — 외래 키 → TICKET_TB.ID — NOT NULL
- CLASS — VARCHAR(50) — NOT NULL
- DURATION — NUMBER — NOT NULL
- USER_NUM — NUMBER — NOT NULL
- TICKET_TYPE_ID — NUMBER — 외래 키 → TICKET_TYPE_ID_TB.ID — NOT NULL
TICKET_TYPE_5_TB
- ID — NUMBER — 외래 키 → TICKET_TB.ID — NOT NULL
- PRODUCT_NAME — VARCHAR(65000) — NOT NULL
- TICKET_TYPE_ID — NUMBER — 외래 키 → TICKET_TYPE_ID_TB.ID — NOT NULL
TICKET_TYPE_6_TB
- ID — NUMBER — 외래 키 → TICKET_TB.ID — NOT NULL
- PRODUCT_NAME — VARCHAR(65000) — NOT NULL
- TICKET_TYPE_ID — NUMBER — 외래 키 → TICKET_TYPE_ID_TB.ID — NOT NULL
TICKET_TYPE_ID_TB
- ID — NUMBER — 기본 키 — NOT NULL
- NAME — VARCHAR(65000) — NOT NULL
- DESCRIPTION — VARCHAR(65000) — NOT NULL
USER_TB
- ID — NUMBER — 기본 키 — NOT NULL