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