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)