Chilktc
Tables (14)
agent_audit_log
- id — BIGINT
- message_id — VARCHAR(50) — Foreign key → messages.message_id
- agent_name — VARCHAR(30)
- status — VARCHAR(10)
- llm_calls — INT
- created_at — DATETIME
consents
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- consent_type — VARCHAR(100)
- agreed — BOOLEAN
- agreed_at — DATETIME
entry_tickets
- id — BIGINT
- user_id — BIGINT — NOT NULL
- situation — TEXT — NOT NULL
- thought — TEXT — NOT NULL
- action — TEXT — NOT NULL
- colleague_reaction — TEXT
- status — VARCHAR(30)
- created_at — DATETIME
messages
- id — BIGINT
- message_id — VARCHAR(50)
- session_id — VARCHAR(50) — Foreign key → sessions.session_id
- request_id — VARCHAR(50)
- correlation_id — VARCHAR(50)
- trace_id — VARCHAR(50)
- sender — VARCHAR(30)
- receiver — VARCHAR(30)
- message_type — VARCHAR(10)
- mode — VARCHAR(15)
- payload — JSON
- created_at — DATETIME
notification_logs
- id — BIGINT
- user_id — BIGINT
- type — VARCHAR(50)
- status — VARCHAR(30)
- sent_at — DATETIME
notification_schedules
- id — BIGINT
- user_id — BIGINT
- entry_ticket_id — BIGINT
- next_notify_at — DATETIME
- interval_days — INT
- active — BOOLEAN
organization_users
- id — BIGINT
- organization_id — BIGINT — Foreign key → organizations.id
- user_id — BIGINT
- role — VARCHAR(30)
- status — VARCHAR(30)
organizations
- id — BIGINT
- name — VARCHAR(255)
- created_at — DATETIME
podcasts
- id — BIGINT
- entry_ticket_id — BIGINT — Foreign key → entry_tickets.id — NOT NULL
- script — TEXT
- cover_image_url — VARCHAR(500)
- status — VARCHAR(30)
- generated_at — DATETIME
sessions
- session_id — VARCHAR(50)
- user_id — VARCHAR(50) — NOT NULL
- mode — VARCHAR(15)
- interaction_unit — VARCHAR(10)
- started_at — DATETIME
- ended_at — DATETIME
- status — VARCHAR(15)
- total_messages — INT
tracking_reason_logs
- tracking_id — BIGINT — Foreign key → trackings.id
- reason_id — BIGINT — Foreign key → tracking_reasons.id
- extra_text — TEXT
tracking_reasons
- id — BIGINT
- type — VARCHAR(20)
- label — VARCHAR(255)
trackings
- id — BIGINT
- entry_ticket_id — BIGINT — Foreign key → entry_tickets.id — NOT NULL
- user_id — BIGINT — NOT NULL
- status — VARCHAR(30)
- checked_at — DATETIME
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_id — VARCHAR(255)
- role — VARCHAR(30)
- first_login — BOOLEAN
- created_at — DATETIME
- last_login_at — DATETIME