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