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