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