SIG-AI

Tables (3)

member

  • member_id (Key) — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone_number — varchar(20) — NOT NULL

store

  • store_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • dong — varchar(50) — NOT NULL
  • gu — varchar(50) — NOT NULL
  • is_franchise — bit — NOT NULL
  • opening_date — date — NOT NULL
  • service_area — enum('SA_3110001', 'SA_3110002', 'SA_...') — NOT NULL
  • service_industry — enum('CS100001', 'CS100002', 'CS200001', 'CS300001', 'CS300043', 'CS...') — NOT NULL
  • store_name — varchar(100) — NOT NULL

store_revenue

  • id (Key) — Primary key — NOT NULL
  • store_id (Key2) — Foreign key → store.store_id — NOT NULL
  • member_id (Key22) — Foreign key → store.member_id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • delivery_sales_ratio — float
  • male_2030_ratio — float
  • male_40plus_ratio — float
  • returning_customer_ratio — float
  • revenue_month — int — NOT NULL
  • reveunue_year — int — NOT NULL
  • revenue — decimal(15,2) — NOT NULL