ZENDESK_TICKET

Tables (6)

ZENDESK_TICKET

  • ticket_id — NUMBER(16) — Primary key — NOT NULL
  • subject — VARCHAR2(100)
  • channel — VARCHAR2(10)
  • created_date — TIMESTAMP(6)
  • description — CLOB

ZENDESK_TICKET_COMMENTS

  • comment_id — NUMBER(16) — Primary key — NOT NULL
  • ticket_id — NUMBER(16) — Foreign key → ZENDESK_TICKET.ticket_id — NOT NULL
  • created_date — TIMESTAMP(6)
  • author_id — NUMBER(16)
  • content — CLOB

ZENDESK_TICKET_FIELD

  • ticket_id — NUMBER(16) — Foreign key → ZENDESK_TICKET.ticket_id — NOT NULL
  • field_id — NUMBER(16) — Foreign key → ZENDESK_TICKET_FIELD_META.field_id — NOT NULL
  • field_name — VARCHAR2(20) — Foreign key → ZENDESK_TICKET_FIELD_META.field_name — NOT NULL
  • field_value — VARCHAR2(50)

ZENDESK_TICKET_FIELD_META

  • field_id — NUMBER(16) — Primary key — NOT NULL
  • field_name — VARCHAR2(20) — Primary key — NOT NULL

ZENDESK_TICKET_KEYWORD

  • keyword — VARCHAR2(100) — Primary key — NOT NULL
  • word_type — VARCHAR2(50)

ZENDESK_TICKET_KEYWORD_LOG

  • keyword — VARCHAR2(100) — Foreign key → ZENDESK_TICKET_KEYWORD.keyword — NOT NULL
  • ticket_id — NUMBER(16) — Foreign key → ZENDESK_TICKET.ticket_id — NOT NULL
  • type — VARCHAR2(10)