seed
Tables (26)
builder_store
- id — BIGINT
- store_owner_id — VARCHAR(36) — Foreign key → store_owner.id — NOT NULL
- industry_id — BIGINT — Foreign key → industry.id — NOT NULL
- region_id — BIGINT — Foreign key → region.id — NOT NULL
- store_name — VARCHAR(150) — NOT NULL
- area — INTEGER — NOT NULL
- expected_monthly_sales — BIGINT — NOT NULL
- expected_profit_rate — DOUBLE — NOT NULL
- investment_payback_months — INTEGER — NOT NULL
- property_score — INTEGER — NOT NULL
- monthly_rent — BIGINT
- description — VARCHAR(1000)
- like_count — BIGINT — NOT NULL
- comment_count — BIGINT — NOT NULL
- active — BOOLEAN — NOT NULL
- uploaded_at — DATETIME — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
builder_store_bookmark
- id — BIGINT
- builder_store_id — BIGINT — Foreign key → builder_store.id — NOT NULL
- bookmarker_id — VARCHAR(36) — Foreign key → store_owner.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
builder_store_comment
- builder_store_comment_id — BIGINT
- builder_store_id — BIGINT — Foreign key → builder_store.id — NOT NULL
- parent_id — BIGINT — Foreign key → builder_store_comment.builder_store_comment_id
- author_id — VARCHAR(36) — Foreign key → store_owner.id — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- deleted — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
builder_store_like
- builder_store_like_id — BIGINT
- builder_store_id — BIGINT — Foreign key → builder_store.id — NOT NULL
- liker_id — VARCHAR(36) — Foreign key → store_owner.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
builder_store_ranking_snapshot
- id — BIGINT
- builder_store_id — BIGINT — Foreign key → builder_store.id — NOT NULL
- ranking_type — VARCHAR(30) — NOT NULL
- ranking — INTEGER — NOT NULL
- reference_year_month — DATE — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
commercial_district_snapshot
- id — BIGINT
- region_id — BIGINT — Foreign key → region.id
- reference_date — DATE — NOT NULL
- population_change_rate — DOUBLE — NOT NULL
- floating_population — DOUBLE — NOT NULL
- summary_label — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
community_comment
- id — BIGINT
- post_id — BIGINT — Foreign key → community_post.id — NOT NULL
- parent_id — BIGINT — Foreign key → community_comment.id
- author_id — VARCHAR(36) — Foreign key → store_owner.id — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- deleted — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
community_like
- id — BIGINT
- community_post_id — BIGINT — Foreign key → community_post.id — NOT NULL
- liker_id — VARCHAR(36) — Foreign key → store_owner.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
community_post
- id — BIGINT
- author_id — VARCHAR(36) — Foreign key → store_owner.id — NOT NULL
- category — VARCHAR(20) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — VARCHAR(5000) — NOT NULL
- like_count — BIGINT — NOT NULL
- comment_count — BIGINT — NOT NULL
- share_count — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
community_post_image
- id — BIGINT
- community_post_id — BIGINT — Foreign key → community_post.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INTEGER — NOT NULL
industry
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
industry_region_metric
- id — BIGINT
- region_id — BIGINT — Foreign key → region.id
- industry_id — BIGINT — Foreign key → industry.id
- reference_date — DATE — NOT NULL
- average_sales — DOUBLE — NOT NULL
- sales_change_rate — DOUBLE — NOT NULL
- floating_population — DOUBLE — NOT NULL
- cost_rate — DOUBLE — NOT NULL
- rank — INTEGER — NOT NULL
industry_trend_metric
- id — BIGINT
- region_id — BIGINT — Foreign key → region.id
- industry_id — BIGINT — Foreign key → industry.id
- period_type — VARCHAR(20) — NOT NULL
- point_date — DATE — NOT NULL
- sales_amount — DOUBLE — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
market_indicator
- id — BIGINT
- indicator_type — VARCHAR(30)
- name — VARCHAR(255) — NOT NULL
- value — DOUBLE — NOT NULL
- unit — VARCHAR(255) — NOT NULL
- change_value — DOUBLE — NOT NULL
- change_rate — DOUBLE — NOT NULL
- reference_date — DATE — NOT NULL
news_article
- id — BIGINT
- category — VARCHAR(20) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- summary — VARCHAR(2000) — NOT NULL
- source_name — VARCHAR(100)
- source_url — VARCHAR(500)
- view_count — BIGINT — NOT NULL
- published_at — DATETIME — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
property_score_summary
- id — BIGINT
- region_id — BIGINT — Foreign key → region.id
- reference_date — DATE — NOT NULL
- income_score — DOUBLE — NOT NULL
- risk_score — DOUBLE — NOT NULL
- liquidity_score — DOUBLE — NOT NULL
- total_score — DOUBLE — NOT NULL
- percentage_rank — INTEGER — NOT NULL
- grade — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
real_estate_event
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- event_date — DATE — NOT NULL
- description — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
recent_transaction
- id — BIGINT
- region_id — BIGINT — Foreign key → region.id
- transaction_price — DOUBLE — NOT NULL
- cap_rate — DOUBLE — NOT NULL
- transaction_date — DATE — NOT NULL
- building_name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
region
- id — BIGINT
- parent_id — BIGINT — Foreign key → region.id
- name — VARCHAR(255) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
store_owner
- id — VARCHAR(36)
- created_at — DATETIME
- updated_at — DATETIME
게시글 (posts)
게시글 이미지 (images)
댓글 (comments)
유저 (users)
- Key — Primary key — NOT NULL