home fit

Tables (9)

asset_infos

  • asset_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • monthly_income — DECIMAL(15,0) — NOT NULL
  • financial_asset — DECIMAL(15,0) — NOT NULL
  • real_estate_asset — DECIMAL(15,0) — NOT NULL
  • vehicle_asset — DECIMAL(15,0) — NOT NULL
  • other_asset — DECIMAL(15,0) — NOT NULL
  • total_debt — DECIMAL(15,0) — NOT NULL
  • recorded_at — DATETIME — NOT NULL

eligibility_rules

  • rule_id — BIGINT — Primary key — NOT NULL
  • notice_id — BIGINT — Foreign key → housing_notices.notice_id — NOT NULL
  • target_type — VARCHAR(50)
  • rule_type — VARCHAR(50) — NOT NULL
  • comparison_operator — VARCHAR(10) — NOT NULL
  • threshold_value — DECIMAL(15,2)
  • threshold_unit — VARCHAR(20)
  • is_required — BOOLEAN — NOT NULL
  • description — TEXT
  • source_page — INT

housing_notices

  • notice_id — BIGINT — Primary key — NOT NULL
  • external_notice_id — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • housing_type — VARCHAR(50) — NOT NULL
  • target_type — VARCHAR(50)
  • region_code — VARCHAR(20)
  • announced_at — DATE
  • application_start_at — DATETIME
  • application_end_at — DATETIME
  • original_url — VARCHAR(1000)
  • application_url — VARCHAR(1000)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

housing_units

  • unit_id — BIGINT — Primary key — NOT NULL
  • notice_id — BIGINT — Foreign key → housing_notices.notice_id — NOT NULL
  • complex_name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(500)
  • exclusive_area — DECIMAL(8,2)
  • supply_count — INT
  • deposit — DECIMAL(15,0)
  • monthly_rent — DECIMAL(15,0)

match_details

  • match_detail_id — BIGINT — Primary key — NOT NULL
  • match_result_id — BIGINT — Foreign key → match_results.match_result_id — NOT NULL
  • rule_id — BIGINT — Foreign key → eligibility_rules.rule_id — NOT NULL
  • result_status — VARCHAR(20) — NOT NULL
  • user_value — DECIMAL(15,2)
  • required_value — DECIMAL(15,2)
  • difference_value — DECIMAL(15,2)
  • reason — TEXT

match_results

  • match_result_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • notice_id — BIGINT — Foreign key → housing_notices.notice_id — NOT NULL
  • asset_id — BIGINT — Foreign key → asset_infos.asset_id — NOT NULL
  • result_status — VARCHAR(20) — NOT NULL
  • recommendation_score — DECIMAL(5,2)
  • estimated_loan — DECIMAL(15,0)
  • required_cash — DECIMAL(15,0)
  • summary — TEXT
  • evaluated_at — DATETIME — NOT NULL

subscription_accounts

  • account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • has_account — BOOLEAN — NOT NULL
  • account_type — VARCHAR(50)
  • opened_at — DATE
  • payment_count — INT
  • total_payment — DECIMAL(15,0)
  • updated_at — DATETIME — NOT NULL

user_profiles

  • profile_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • birth_date — DATE — NOT NULL
  • region_code — VARCHAR(20) — NOT NULL
  • residence_start_date — DATE
  • household_count — INT — NOT NULL
  • is_homeless — BOOLEAN — NOT NULL
  • has_house_ownership_history — BOOLEAN — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • login_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL