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