Every Zendesk ticket. In clean Postgres. In 24 hours.

-- PostgreSQL schema generated by Evicta (AI-mapped custom fields)

CREATE TABLE tickets (
  id               BIGINT PRIMARY KEY,
  subject          TEXT,
  status           VARCHAR(16),   -- open | pending | solved | closed
  priority         VARCHAR(16),   -- low | normal | high | urgent
  requester_id     BIGINT REFERENCES users(id),
  assignee_id      BIGINT REFERENCES users(id),
  organization_id  BIGINT REFERENCES organizations(id),
  created_at       TIMESTAMPTZ,
  updated_at       TIMESTAMPTZ,
  tags             TEXT[],
  -- AI-mapped custom fields (readable names, not Zendesk IDs):
  customer_segment VARCHAR(64),    -- was: custom_field_8321
  resolution_tier  INT2,           -- was: custom_field_9912
  contract_value   NUMERIC(12,2)   -- was: custom_field_11043
);

CREATE TABLE comments (
  id          BIGINT PRIMARY KEY,
  ticket_id   BIGINT REFERENCES tickets(id),
  author_id   BIGINT REFERENCES users(id),
  body        TEXT,
  public      BOOLEAN,
  created_at  TIMESTAMPTZ
);

CREATE TABLE sunshine_sla_agreements (   -- Sunshine Custom Object
  id          TEXT PRIMARY KEY,
  ticket_id   BIGINT REFERENCES tickets(id),
  tier        VARCHAR(32),
  breach_at   TIMESTAMPTZ,
  created_at  TIMESTAMPTZ
);