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