맴매
테이블 (10)
Untitled
- Key — 기본 키 — NOT NULL
- Field
chat_messages
- id — BIGINT — 기본 키 — NOT NULL
- chat_session_id — BIGINT — 외래 키 → chat_sessions.id — NOT NULL
- sender_type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- model_name — VARCHAR(100)
- input_token_count — INT
- output_token_count — INT
- created_at — DATETIME — NOT NULL
chat_sessions
- id — BIGINT — 기본 키 — NOT NULL
- store_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- solution_id — BIGINT
- title — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notifications
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- notification_type — VARCHAR(30) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- related_entity_type — VARCHAR(30)
- related_entity_id — BIGINT
- scheduled_at — DATETIME
- sent_at — DATETIME
- read_at — DATETIME
- created_at — DATETIME — NOT NULL
ranking_entries
- id — BIGINT — 기본 키 — NOT NULL
- ranking_snapshot_id — BIGINT — 외래 키 → ranking_snapshots.id — NOT NULL
- ranking_profile_id — BIGINT — 외래 키 → ranking_profiles.id — NOT NULL
- rank_no — INT — NOT NULL
- growth_rate — DECIMAL(10,4) — NOT NULL
- selected_period_sales — DECIMAL(14,2) — NOT NULL
- comparison_period_sales — DECIMAL(14,2) — NOT NULL
- created_at — DATETIME — NOT NULL
ranking_profiles
- id — BIGINT — 기본 키 — NOT NULL
- store_id — BIGINT — NOT NULL
- anonymous_nickname — VARCHAR(50) — NOT NULL
- opted_in_at — DATETIME — NOT NULL
- opted_out_at — DATETIME
- created_at — DATETIME — NOT NULL
ranking_snapshots
- id — BIGINT — 기본 키 — NOT NULL
- period_start — DATE — NOT NULL
- period_end — DATE — NOT NULL
- comparison_start — DATE — NOT NULL
- comparison_end — DATE — NOT NULL
- calculated_at — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
saved_solutions
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- solution_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL