고도화

테이블 (5)

Decision_Logs (Untitled5)

  • log_id (Key) — INT — 기본 키 — NOT NULL
  • user_id (Key2) — INT — 외래 키 → Users.user_id — NOT NULL
  • product_info (Field2) — CHAR(255)
  • diagnosis_code (Field3) — CHAR(5)
  • reasoning_text (Field4) — CHAR(255)
  • alignment_score (Field5) — FLOAT
  • input_source (Field) — VARCHAR(10)

Goal (Untitled2)

  • goal_id (Key) — INT — 기본 키 — NOT NULL
  • user_id (Key2) — INT — 외래 키 → Users.user_id — NOT NULL
  • goal_name (Field2) — VARCHAR(100)
  • target_amount (Field3) — BIGINT
  • current_savings (Field4) — BIGINT
  • priority (Field) — INT
  • status (Field5) — VARCHAR(20)

Inventory (Untitled3)

  • item_id (Key) — INT — 기본 키 — NOT NULL
  • user_id (Key2) — INT — 외래 키 → Users.user_id — NOT NULL
  • product_id (Key3) — INT — 외래 키 → Product_knowledge.product_id — NOT NULL
  • category (Field2) — VARCHAR(50)
  • product_name (Field3) — VARCHAR(255)
  • purchase_date (Field4) — DATE

Product_knowledge (Untitled4)

  • product_id (Key) — INT — 기본 키 — NOT NULL
  • discount_rate (Field) — INT
  • review_score (Field2) — FLOAT
  • product_likes (Field3) — INT
  • platform (Field4) — INT
  • review_count (Field5) — INT
  • is_direct_shipping (Field6) — INT
  • free_shipping (Field7) — INT
  • sim_temptation (Field8) — INT
  • sim_fit_anxiety (Field9) — INT
  • sim_trend_hype (Field10) — INT
  • sim_quality_logic (Field11) — INT
  • sim_bundle (Field12) — INT
  • sim_confidence (Field13) — INT

Users (Untitled)

  • user_id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(50)
  • sbti_type (Field2) — CHAR(3)
  • monthly_budget (Field3) — BIGINT
  • risk_tolerance (Field4) — FLOAT
  • last_login (Field5) — DATETIME