teample2
Tables (5)
cafe_if (Untitled)
- cafe_id (Key) — null — Primary key — NOT NULL
- name (Field1) — not null
- address (Field3) — notnull
- biz_code (Field4) — not null
- latitude (Field5) — not null
- longitude (Field6) — not null
- rp_key (Key2) — null — Foreign key → resident_population.rp_key — NOT NULL
cafe_review (Untitled4)
- review_id (Key) — null — Primary key — NOT NULL
- review_score (Field) — null
- review_count (Field2) — null
- review_text (Field3) — not null
- cafe_id (Key2) — not null — Foreign key → cafe_if.cafe_id — NOT NULL
cafe_sales (Untitled2)
- sales_id (Key) — null — Primary key — NOT NULL
- date (Field1) — not null
- price (Field3) — not null
- visitor_count (Field6) — null
- aov (Field7) — null
- cafe_id (Key2) — not null — Foreign key → cafe_if.cafe_id — NOT NULL
- sales (Field2) — not null
cafe_trend_ai (Untitled5)
- trend_id (Key) — null — Primary key — NOT NULL
- is_risk_area (Field1) — null
- is_trendy (Field2) — null
- is_growth_expectation (Field3) — not null
- recommendation_level (Field4) — null
- predicted_growth_rate (Field5) — null
- investment_opportunity (Field6) — not null
- rp_key (Key3) — null — Foreign key → resident_population.rp_key — NOT NULL
resident_population (Untitled6)
- rp_key (Key) — null — Primary key — NOT NULL
- total_population (Field4) — null
- population_per_ages (Field5) — null
- income_avg (Field6) — null
- rent_avg (Field7) — null
- traffic_level (Field9) — null