길목(기존)
테이블 (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)