ora

Tables (4)

call

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → user.id — NOT NULL
  • session_id — VARCHAR(64)
  • started_at — DATETIME(6)
  • ended_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted — TINYINT(1) — NOT NULL

call_content

  • id — BINARY(16) — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • type — ENUM('q','a') — NOT NULL
  • request_id — VARCHAR(64)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted — TINYINT(1) — NOT NULL

conversation

  • id — BINARY(16) — Primary key — NOT NULL
  • call_content_id — BINARY(16) — Foreign key → call_content.id — NOT NULL
  • call_id — BINARY(16) — Foreign key → call.id — NOT NULL
  • index — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted — TINYINT(1) — NOT NULL

user

  • id — BINARY(16) — Primary key — NOT NULL
  • phone — VARCHAR(13)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted — TINYINT(1) — NOT NULL