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

        점포 (stores)

          좋아요 (likes)