길목(기존)

테이블 (9)

ai_recommendations

  • id — bigint — 기본 키 — NOT NULL
  • event_id — bigint — 외래 키 → event.id — NOT NULL
  • applied — bit(1) — NOT NULL
  • applied_policy_version — int
  • input_window_sec — int — NOT NULL
  • metrics_snapshot_json — text — NOT NULL
  • recommended_policy_json — text — NOT NULL
  • rationale — text
  • created_by_user_id — bigint — NOT NULL
  • created_at — datetime(6)

auth_sessions

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • refresh_token_hash — varchar(255) — NOT NULL
  • created_ip — varchar(45)
  • user_agent — varchar(512)
  • issued_at — datetime(6) — NOT NULL
  • revoked_at — datetime(6) — NOT NULL
  • last_used_at — datetime(6) — NOT NULL
  • expires_at — datetime(6) — NOT NULL

event

  • id — bigint — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • description — text
  • status — varchar(20) — NOT NULL
  • starts_at — datetime(6)
  • ends_at — datetime(6)
  • created_at — datetime(6)
  • updated_at — datetime(6)

event_policies

  • id — bigint — 기본 키 — NOT NULL
  • event_id — bigint — 외래 키 → event.id — NOT NULL
  • policy_version — bigint — NOT NULL
  • admission_rps — int — NOT NULL
  • admission_concurrency — int — NOT NULL
  • max_requests_per_second — int — NOT NULL
  • block_duration_minutes — int — NOT NULL
  • gate_mode — varchar(20)
  • block_rules_json — text
  • updated_by_user_id — bigint
  • updated_by_username — varchar(50)
  • updated_at — datetime(6)

policy_histories

  • id — bigint — 기본 키 — NOT NULL
  • event_id — bigint — 외래 키 → event.id — NOT NULL
  • policy_version — bigint — NOT NULL
  • admission_rps — int — NOT NULL
  • admission_concurrency — int — NOT NULL
  • max_requests_per_second — int — NOT NULL
  • block_duration_minutes — int — NOT NULL
  • gate_mode — varchar(20)
  • block_rules — text
  • updated_by_user_id — bigint
  • updated_by_username — varchar(50)
  • created_at — datetime(6)

request_logs

  • id — bigint — 기본 키 — NOT NULL
  • event_id — bigint
  • request_id — varchar(64)
  • path — varchar(255)
  • method — varchar(10)
  • status_code — int
  • latency_ms — bigint
  • ts — datetime(6) — NOT NULL

reservation

  • id — bigint — 기본 키 — NOT NULL
  • reservation_code — varchar(36) — NOT NULL
  • event_id — bigint — 외래 키 → event.id — NOT NULL
  • seat_id — bigint — 외래 키 → seat.id — NOT NULL
  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • username — varchar(255)
  • quantity — int — NOT NULL
  • status — varchar(20) — NOT NULL
  • confirmed_at — datetime(6)
  • cancelled_at — datetime(6)
  • created_at — datetime(6)
  • updated_at — datetime(6)

seat

  • id — bigint — 기본 키 — NOT NULL
  • event_id — bigint — 외래 키 → event.id — NOT NULL
  • section — varchar(10) — NOT NULL
  • price — int — NOT NULL
  • total_count — int — NOT NULL
  • reserved_count — int — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

users

  • id — bigint — 기본 키 — NOT NULL
  • username — varchar(50) — NOT NULL
  • password_hash — varchar(100) — NOT NULL
  • role — varchar(20) — NOT NULL
  • status — varchar(20) — NOT NULL
  • last_login_at — datetime(6)
  • created_at — datetime(6)
  • updated_at — datetime(6)