맴매

테이블 (10)

Untitled

  • Key — 기본 키 — NOT NULL
  • Field

Untitled3

    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

    복사 (Untitled2)