고도화
테이블 (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