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