옴니채널 티켓 모듈 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