channel

Tables (5)

agents

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

event_logs

  • id — BIGSERIAL
  • ticket_id — BIGINT — Foreign key → tickets.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • agent_id — BIGINT — Foreign key → agents.id
  • event_type — VARCHAR(50) — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • occurred_at — TIMESTAMP — NOT NULL

messages

  • id — BIGSERIAL
  • ticket_id — BIGINT — Foreign key → tickets.id — NOT NULL
  • sender_user_id — BIGINT — Foreign key → users.id
  • sender_agent_id — BIGINT — Foreign key → agents.id
  • sender_role — VARCHAR(20) — NOT NULL
  • body — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tickets

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • agent_id — BIGINT — Foreign key → agents.id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • assigned_at — TIMESTAMP
  • closed_at — TIMESTAMP

users

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL