ERD E

Tables (13)

areas

  • area_code — VARCHAR(20) — Primary key — NOT NULL
  • area_name — VARCHAR(100) — NOT NULL
  • district_name — VARCHAR(100)
  • geometry — TEXT

business_stats

  • ID — VARCHAR(36) — Primary key — NOT NULL
  • area_code2 — VARCHAR(20) — NOT NULL
  • survival_score — FLOAT
  • closure_rate — FLOAT
  • total_businesses — INTEGER
  • area_code — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

category

  • category_code — VARCHAR(20) — Primary key — NOT NULL
  • category_name — VARCHAR(100)

category_peak_hours

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • peak_start — SMALLINT
  • peak_end — SMALLINT
  • category_code — VARCHAR(20) — NOT NULL

category_stats

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • area_code — VARCHAR(20) — NOT NULL
  • category_code2 — VARCHAR(20) — NOT NULL
  • survival_rate — FLOAT
  • closure_rate — FLOAT
  • total_businesses — INTEGER
  • area_code (area_code2) — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

interest_areas

  • id — VARCHAR(36) — Primary key — NOT NULL
  • clerk_user_id — VARCHAR(255) — NOT NULL
  • area_code — VARCHAR(20) — NOT NULL
  • category_code — VARCHAR(20) — NOT NULL
  • memo — TEXT
  • created_at — TIMESTAMP
  • area_code (area_code2) — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

monthly_stats

  • category_code — VARCHAR(20) — Primary key — NOT NULL
  • year_month — VARCHAR(7) — Primary key — NOT NULL
  • area_code — VARCHAR(20) — NOT NULL
  • survival_rate — FLOAT
  • avg_population — FLOAT
  • closure_rate — FLOAT
  • open_rate — FLOAT
  • area_code (area_code2) — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

population_heatmap

  • day_of_week — VARCHAR(3) — Primary key — NOT NULL
  • hour — SMALLINT — Primary key — NOT NULL
  • area_code — VARCHAR(20) — NOT NULL
  • category_code2 — VARCHAR(20) — NOT NULL
  • avg_population — FLOAT
  • area_code (area_code2) — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

population_stats

  • id — VARCHAR(36) — Primary key — NOT NULL
  • area_code — VARCHAR(20) — NOT NULL
  • avg_daily_population — FLOAT
  • area_code (area_code2) — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

recent_areas

  • id — VARCHAR(36) — Primary key — NOT NULL
  • clerk_user_id — VARCHAR(255) — NOT NULL
  • area_code — VARCHAR(20) — NOT NULL
  • viewed_at — TIMESTAMP
  • area_code (area_code2) — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

rent_stats

  • id — VARCHAR(36) — Primary key — NOT NULL
  • area_code — VARCHAR(20) — NOT NULL — 복합유니크
  • avg_rent_per_sqm — FLOAT
  • avg_deposit — FLOAT
  • reference_year — INTEGER — 복합유니크
  • reference_quarter — SMALLINT — 복합유니크
  • floor_type — VARCHAR(20) — NOT NULL — 복합유니크
  • area_code (area_code2) — VARCHAR(20) — Foreign key → areas.area_code — NOT NULL

reports

  • id — VARCHAR(36) — Primary key — NOT NULL
  • clerk_user_id — VARCHAR(255) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • area_code — VARCHAR(20)
  • area_name — VARCHAR(100)
  • category_code — VARCHAR(20)
  • category_name — VARCHAR(100)
  • content — TEXT
  • memo — TEXT
  • share_token — VARCHAR(64)
  • created_at — TIMESTAMP

users

  • clerk_user_id — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP