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)