3차_단위
테이블 (6)
DB Vector(1) (외국인 국적)
- Country (Key2) — object — 기본 키 — NOT NULL
- Customer_ID (Key) — object — 외래 키 → Ecommerce_Consumer_Behavior_Analysis_Data.Customer_ID — NOT NULL
- Product_Purchase_Ratio (Field) — int64
- Purchase_Amount (Field2) — object
- Purchase_Category (Field3) — object
- Frequency_of_Purchase (Field4) — int64
- Field5
- Field6
DB Vector(2) (매장정보)
- Region (Key) — object — 외래 키 → retail_store_inventory.Region — NOT NULL
- Product ID (Field) — object
- Seasonality (Field2) — object
- Price (Field3) — float64
- Category (Field4) — object
- Field5
- Field6
Ecommerce_Consumer_Behavior_Analysis_Data (외국인의 선호제품)
- Customer_ID (Key) — object — 기본 키 — NOT NULL
- Age (Field) — int64
- Gender (Field2) — object
- Income_Level (Field3) — object
- Marital_Status (Field4) — object
- Education_Level (Field5) — object
- Occupation (Field6) — object
- Location (Field7) — object
- Purchase_Category (Field8) — object
- Purchase_Amount (Field9) — object
- Frequency_of_Purchase (Field10) — int64
- Purchase_Channel (Field11) — object
- Brand_Loyalty (Field12) — int64
- Product_Rating (Field13) — int64
- Time_Spent_on_Product_Research (Field14) — float64
- Social_Media_Influence (Field15) — object
- Discount_Sensitivity (Field16) — object
- Return_Rate (Field17) — int64
- Customer_Satisfaction (Field18) — int64
- Engagement_with_Ads (Field19) — object
- Device_Used_for_Shopping (Field20) — object
- Payment_Method (Field21) — object
- Time_of_Purchase (Field22) — object
- Discount_Used (Field23) — bool
- Customer_Loyalty_Program_Member (Field24) — bool
- Purchase_Intent (Field25) — object
- Shipping_Preference (Field26) — object
- Time_to_Decision (Field27) — int64
LLM Answer (Untitled)
- Country (Key2) — object — 외래 키 → DB Vector(1).Country — NOT NULL
- Region (Key) — object — 외래 키 → DB Vector(2).Region — NOT NULL
- Query (Key3) — object — 외래 키 → User Question.Query — NOT NULL
- User_Region (Key22) — object — 외래 키 → User Question.User_Region — NOT NULL
- User_Country (Key32) — object — 외래 키 → User Question.User_Country — NOT NULL
- LLM Answer (Field) — object
User Question (Untitled2)
- Query (Key) — object — 기본 키 — NOT NULL
- User_Region (Key2) — object — 기본 키 — NOT NULL
- User_Country (Key3) — object — 기본 키 — NOT NULL
retail_store_inventory (지역별 매장 정보)
- Region (Key) — object — 기본 키 — NOT NULL
- Date (Field) — object
- Store ID (Field2) — object
- Product ID (Field3) — object
- Category (Field4) — object
- Inventory Level (Field6) — int64
- Units Sold (Field7) — int64
- Units Ordered (Field8) — int64
- Demand Forecast (Field9) — float64
- Discount (Field10) — int64
- Weather Condition (Field11) — object
- Holiday/Promotion (Field12) — int64
- Competitor Pricing (Field13) — float64
- Seasonality (Field14) — object
- Price (Field15) — float64