chat
Tables (17)
app_user
- id — INT — Primary key — NOT NULL
- email — VARCHAR(200) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
category
- id — INT — Primary key — NOT NULL
- domain_id — INT — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
chat_message
- id — INT — Primary key — NOT NULL
- session_id — INT — NOT NULL
- sender_type — VARCHAR(20)
- sender_id — INT
- message — TEXT — NOT NULL
- created_at — TIMESTAMP
chat_session
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- counselor_id — INT
- domain_id — INT — NOT NULL
- category_id — INT — NOT NULL
- status — VARCHAR(30)
- end_reason — VARCHAR(30)
- requested_at — TIMESTAMP
- assigned_at — TIMESTAMP
- started_at — TIMESTAMP
- ended_at — TIMESTAMP
- duration_sec — INT
counsel_log
- id — INT — Primary key — NOT NULL
- session_id — INT — NOT NULL
- user_id — INT — NOT NULL
- counselor_id — INT — NOT NULL
- domain_id — INT — NOT NULL
- category_id — INT — NOT NULL
- duration_sec — INT
- after_call_sec — INT
- satisfaction_score — INT
- feedback — VARCHAR(500)
- ended_at — TIMESTAMP
- created_at — TIMESTAMP
counselor
- id — INT — Primary key — NOT NULL
- email — VARCHAR(200) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- status — VARCHAR(20)
- current_load — INT
- created_at — TIMESTAMP
counselor_skill
- id — INT — Primary key — NOT NULL
- counselor_id — INT — NOT NULL
- category_id — INT — NOT NULL
- created_at — TIMESTAMP
counselor_stats
- id — INT — Primary key — NOT NULL
- counselor_id — INT — NOT NULL
- stat_date — DATE — NOT NULL
- handled_count — INT
- avg_duration_sec — INT
- avg_score — DECIMAL(3,2)
- response_rate — DECIMAL(5,2)
- success_rate — DECIMAL(5,2)
- created_at — TIMESTAMP
domain
- id — INT — Primary key — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
event
- id — INT — Primary key — NOT NULL
- domain_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- venue — VARCHAR(200)
- thumbnail — VARCHAR(500)
- start_at — TIMESTAMP
- end_at — TIMESTAMP
- status — VARCHAR(20)
- created_at — TIMESTAMP
payment
- id — INT — Primary key — NOT NULL
- order_id — INT — NOT NULL
- payment_key — VARCHAR(100) — NOT NULL
- method — VARCHAR(20)
- amount — INT
- status — VARCHAR(20)
- paid_at — TIMESTAMP
- created_at — TIMESTAMP
reserve_user
- id — INT — Primary key — NOT NULL
- user_id — INT
- real_name — VARCHAR(50)
- phone — VARCHAR(20)
- email — VARCHAR(200)
- is_default — BOOLEAN
- created_at — TIMESTAMP
seat
- id — INT — Primary key — NOT NULL
- section_id — INT — NOT NULL
- row_label — VARCHAR(10)
- seat_number — INT — NOT NULL
- is_reserved — BOOLEAN
ticket
- id — INT — Primary key — NOT NULL
- event_id — INT — NOT NULL
- name — VARCHAR(100)
- price — INT
- total_quantity — INT
- remain_quantity — INT
ticket_order
- id — INT — Primary key — NOT NULL
- user_id — INT
- reserve_user_id — INT
- event_id — INT — NOT NULL
- status — VARCHAR(20)
- total_price — INT
- ordered_at — TIMESTAMP
- paid_at — TIMESTAMP
- cancelled_at — TIMESTAMP
ticket_order_item
- id — INT — Primary key — NOT NULL
- order_id — INT — NOT NULL
- ticket_id — INT — NOT NULL
- seat_id — INT — NOT NULL
- quantity — INT
- unit_price — INT
venue_section
- id — INT — Primary key — NOT NULL
- event_id — INT — NOT NULL
- ticket_id — INT — NOT NULL
- venue — VARCHAR(200)
- code — VARCHAR(50)
- name — VARCHAR(100)
- grade — VARCHAR(20)