RisingHome

Tables (39)

ai_risk_items

  • risk_item_id — BIGINT
  • ai_summary_id — BIGINT — Foreign key → ai_summaries.ai_summary_id — NOT NULL
  • risk_type — VARCHAR(80) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT
  • severity — ENUM('LOW','MEDIUM','HIGH') — NOT NULL
  • display_order — INT — NOT NULL

ai_summaries

  • ai_summary_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • document_id — BIGINT — Foreign key → auction_documents.document_id
  • summary_status — ENUM('PENDING','SUCCESS','FAILED','NO_DOCUMENT') — NOT NULL
  • overview_summary — TEXT
  • location_summary — TEXT
  • price_summary — TEXT
  • rights_risk_summary — TEXT
  • pre_bid_check_summary — TEXT
  • error_message — TEXT
  • model_name — VARCHAR(80)
  • generated_at — DATETIME

api_request_logs

  • api_request_log_id — BIGINT
  • data_source_id — BIGINT — Foreign key → data_sources.data_source_id — NOT NULL
  • endpoint_name — VARCHAR(150) — NOT NULL
  • request_key — VARCHAR(200)
  • request_params — TEXT
  • http_status — INT
  • provider_result_code — VARCHAR(50)
  • provider_result_message — VARCHAR(300)
  • raw_response_path — VARCHAR(500)
  • requested_at — DATETIME — NOT NULL

auction_checklist_items

  • checklist_item_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • category — VARCHAR(80)
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT
  • required — BOOLEAN — NOT NULL
  • display_order — INT — NOT NULL

auction_documents

  • document_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • document_type — ENUM('APPRAISAL','SALE_NOTICE','PROPERTY_STATEMENT','REGISTRY','FIELD_REPORT','ETC') — NOT NULL
  • file_path — VARCHAR(500)
  • extracted_text — LONGTEXT
  • source_url — VARCHAR(500)
  • parse_status — ENUM('PENDING','SUCCESS','FAILED','NO_DOCUMENT') — NOT NULL
  • created_at — DATETIME — NOT NULL

auction_items

  • auction_item_id — BIGINT
  • source_system — ENUM('ONBID', 'COURT', 'CSV', 'MANUAL') — NOT NULL
  • onbid_cltr_mng_no — VARCHAR(50) — 온비드 물건관리번호 cltrMngNo
  • onbid_pbct_cdtn_no — VARCHAR(50) — 온비드 공매조건번호 pbctCdtnNo
  • case_no — VARCHAR(80)
  • item_no — VARCHAR(80)
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id
  • dong_code — VARCHAR(10) — Foreign key → dong_codes.dong_code
  • title — VARCHAR(250) — NOT NULL
  • item_type — VARCHAR(80)
  • category_full_name — VARCHAR(250)
  • road_address — VARCHAR(300)
  • jibun_address — VARCHAR(300)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • appraisal_price — BIGINT
  • minimum_sale_price — BIGINT
  • bid_deposit — BIGINT
  • sale_date — DATE
  • bid_start_at — DATETIME
  • bid_end_at — DATETIME
  • failed_bid_count — INT — NOT NULL
  • court_name — VARCHAR(120)
  • disposal_agency — VARCHAR(150)
  • institution_name — VARCHAR(150)
  • disposal_method — VARCHAR(80)
  • bid_method — VARCHAR(80)
  • risk_status — ENUM('SAFE', 'CAUTION', 'NEW', 'FAILED_BID', 'UNKNOWN') — NOT NULL
  • building_area_m2 — DECIMAL(12, 3)
  • land_area_m2 — DECIMAL(12, 3)
  • data_base_date — DATE
  • status — ENUM('SCHEDULED', 'BIDDING', 'CLOSED', 'HIDDEN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

auction_nearby_places

  • auction_nearby_place_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • place_id — BIGINT — Foreign key → nearby_places.place_id — NOT NULL
  • radius_m — INT — NOT NULL
  • distance_m — DECIMAL(10,2)

auction_price_comparisons

  • comparison_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id
  • nearest_house_deal_id — BIGINT — Foreign key → house_deals.house_deal_id
  • comparison_basis — ENUM('SAME_COMPLEX','SAME_DONG','RADIUS') — NOT NULL
  • nearby_average_price — BIGINT
  • recent_deal_price — BIGINT
  • current_asking_price — BIGINT
  • discount_rate — DECIMAL(7,3)
  • price_gap_rate — DECIMAL(7,3)
  • calculated_at — DATE — NOT NULL

auction_related_deals

  • auction_related_deal_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • house_deal_id — BIGINT — Foreign key → house_deals.house_deal_id — NOT NULL
  • distance_m — DECIMAL(10,2)
  • relation_type — ENUM('SAME_COMPLEX','SAME_DONG','NEARBY') — NOT NULL

auction_related_news

  • auction_related_news_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • news_id — BIGINT — Foreign key → news_articles.news_id — NOT NULL
  • relevance_reason — VARCHAR(300)

auction_status_badges

  • badge_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • badge_type — VARCHAR(50) — NOT NULL
  • label — VARCHAR(50) — NOT NULL
  • color — VARCHAR(30)

building_infos

  • building_info_id — BIGINT
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id — NOT NULL
  • main_use — VARCHAR(100)
  • sub_use — VARCHAR(100)
  • approval_date — DATE
  • structure_type — VARCHAR(100)
  • roof_type — VARCHAR(100)
  • total_floor_area_m2 — DECIMAL(12,3)
  • building_area_m2 — DECIMAL(12,3)
  • floor_area_ratio — DECIMAL(8,3)
  • building_coverage_ratio — DECIMAL(8,3)
  • ground_floors — INT
  • basement_floors — INT
  • parking_count — INT
  • elevator_count — INT
  • data_source — VARCHAR(100)
  • data_base_date — DATE

complex_area_types

  • area_type_id — BIGINT
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id — NOT NULL
  • exclusive_area_m2 — DECIMAL(10,3) — NOT NULL
  • supply_area_m2 — DECIMAL(10,3)
  • area_label — VARCHAR(50)
  • household_count — INT

complex_price_snapshots

  • snapshot_id — BIGINT
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id — NOT NULL
  • area_type_id — BIGINT — Foreign key → complex_area_types.area_type_id
  • snapshot_date — DATE — NOT NULL
  • recent_sale_price — BIGINT
  • highest_sale_price — BIGINT
  • average_sale_price — BIGINT
  • average_jeonse_price — BIGINT
  • jeonse_rate — DECIMAL(6,2)
  • deal_count — INT — NOT NULL

content_reports

  • report_id — BIGINT
  • reporter_id — BIGINT — Foreign key — NOT NULL
  • target_type — ENUM('REVIEW','INQUIRY','NOTICE','NEWS') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — ENUM('ABUSE','SPAM','FALSE_INFO','ETC') — NOT NULL
  • reason_detail — TEXT
  • status — ENUM('RECEIVED','ACCEPTED','REJECTED') — NOT NULL
  • handled_by — BIGINT — Foreign key
  • created_at — DATETIME — NOT NULL
  • handled_at — DATETIME

data_import_errors

  • import_error_id — BIGINT
  • import_job_id — BIGINT — Foreign key → data_import_jobs.import_job_id — NOT NULL
  • source_identifier — VARCHAR(200)
  • raw_payload — LONGTEXT
  • error_code — VARCHAR(80)
  • error_message — TEXT
  • created_at — DATETIME — NOT NULL

data_import_jobs

  • import_job_id — BIGINT
  • data_source_id — BIGINT — Foreign key → data_sources.data_source_id — NOT NULL
  • target_domain — ENUM('HOUSE_DEAL','ONBID_AUCTION','NEARBY_PLACE','NEWS','AI_SUMMARY') — NOT NULL
  • trigger_type — ENUM('SCHEDULED','MANUAL','FALLBACK_CSV') — NOT NULL
  • status — ENUM('RUNNING','SUCCESS','FAILED','PARTIAL_SUCCESS') — NOT NULL
  • success_count — INT — NOT NULL
  • fail_count — INT — NOT NULL
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME
  • requested_by — BIGINT — Foreign key

data_sources

  • data_source_id — BIGINT
  • source_name — VARCHAR(150) — NOT NULL
  • source_type — ENUM('OPEN_API','RSS','CSV','MANUAL','KAKAO_API','AI') — NOT NULL
  • provider — VARCHAR(150)
  • base_url — VARCHAR(500)
  • active — BOOLEAN — NOT NULL

dong_codes

  • dong_code — VARCHAR(10)
  • sido — VARCHAR(40) — NOT NULL
  • sigungu — VARCHAR(60) — NOT NULL
  • eupmyeondong — VARCHAR(80) — NOT NULL
  • ri — VARCHAR(80)
  • center_latitude — DECIMAL(10,7)
  • center_longitude — DECIMAL(10,7)

house_deals

  • house_deal_id — BIGINT
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id
  • area_type_id — BIGINT — Foreign key → complex_area_types.area_type_id
  • molit_apt_seq — VARCHAR(50)
  • lawd_cd — VARCHAR(5) — NOT NULL
  • umd_cd — VARCHAR(10)
  • umd_name — VARCHAR(80)
  • apt_name — VARCHAR(200) — NOT NULL
  • apt_dong — VARCHAR(80)
  • jibun — VARCHAR(50)
  • bonbun — VARCHAR(10)
  • bubun — VARCHAR(10)
  • road_name — VARCHAR(200)
  • road_name_code — VARCHAR(30)
  • deal_type — ENUM('SALE', 'JEONSE', 'MONTHLY_RENT') — NOT NULL
  • deal_amount — BIGINT — NOT NULL — 만원 단위
  • deposit_amount — BIGINT
  • monthly_rent — BIGINT
  • exclusive_area_m2 — DECIMAL(10, 3) — NOT NULL
  • floor — INT
  • building_dong — VARCHAR(50)
  • deal_date — DATE — NOT NULL
  • built_year — INT
  • transaction_method — ENUM('BROKERAGE', 'DIRECT', 'UNKNOWN')
  • buyer_type — VARCHAR(30)
  • seller_type — VARCHAR(30)
  • estate_agent_sgg_name — VARCHAR(100)
  • cancel_deal_type — VARCHAR(30)
  • cancel_deal_date — DATE
  • registration_date — DATE
  • land_leasehold_type — VARCHAR(10)
  • source_name — VARCHAR(100) — NOT NULL
  • data_base_date — DATE
  • source_request_lawd_cd — VARCHAR(5) — NOT NULL
  • source_request_deal_ymd — VARCHAR(6) — NOT NULL
  • created_at — DATETIME — NOT NULL

inquiries

  • inquiry_id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • inquiry_type — ENUM('AUCTION_INFO','DATA','PAYMENT','ACCOUNT','ETC') — NOT NULL
  • title — VARCHAR(250) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('RECEIVED','ANSWERED','CLOSED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inquiry_answers

  • answer_id — BIGINT
  • inquiry_id — BIGINT — Foreign key → inquiries.inquiry_id — NOT NULL
  • admin_id — BIGINT — Foreign key — NOT NULL
  • content — TEXT — NOT NULL
  • answered_at — DATETIME — NOT NULL

inquiry_attachments

  • attachment_id — BIGINT
  • inquiry_id — BIGINT — Foreign key → inquiries.inquiry_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • file_size — BIGINT
  • content_type — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

interest_areas

  • interest_area_id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • dong_code — VARCHAR(10) — Foreign key — NOT NULL
  • created_at — DATETIME — NOT NULL

interest_auctions

  • interest_auction_id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • auction_item_id — BIGINT — Foreign key — NOT NULL
  • created_at — DATETIME — NOT NULL

interest_deals

  • interest_deal_id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • house_deal_id — BIGINT — Foreign key — NOT NULL
  • created_at — DATETIME — NOT NULL

land_infos

  • land_info_id — BIGINT
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id — NOT NULL
  • land_category — VARCHAR(80)
  • zoning — VARCHAR(100)
  • land_area_m2 — DECIMAL(12,3)
  • official_land_price — BIGINT
  • data_source — VARCHAR(100)
  • data_base_date — DATE

nearby_places

  • place_id — BIGINT
  • place_name — VARCHAR(200) — NOT NULL
  • category — ENUM('RESTAURANT','CAFE','CONVENIENCE','HOSPITAL','PHARMACY','SCHOOL','TRANSPORT','PUBLIC_OFFICE','ETC') — NOT NULL
  • road_address — VARCHAR(300)
  • jibun_address — VARCHAR(300)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • source_name — VARCHAR(100)
  • external_place_id — VARCHAR(100)

news_articles

  • news_id — BIGINT
  • title — VARCHAR(300) — NOT NULL
  • summary — TEXT
  • category — ENUM('POLICY','AUCTION','LOCAL_DEVELOPMENT','INTEREST_RATE','COMMERCIAL_AREA','ETC') — NOT NULL
  • source_name — VARCHAR(100) — NOT NULL
  • original_url — VARCHAR(500)
  • published_date — DATE
  • collected_at — DATETIME
  • registration_type — ENUM('API','RSS','CSV','MANUAL') — NOT NULL
  • status — ENUM('VISIBLE','HIDDEN','DELETED') — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id

notices

  • notice_id — BIGINT
  • author_id — BIGINT — Foreign key — NOT NULL
  • title — VARCHAR(250) — NOT NULL
  • content — TEXT — NOT NULL
  • notice_type — ENUM('NOTICE','EVENT','NEWS') — NOT NULL
  • view_count — INT — NOT NULL
  • pinned — BOOLEAN — NOT NULL
  • status — ENUM('VISIBLE','HIDDEN','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

onbid_appraisals

  • appraisal_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • appraisal_agency — VARCHAR(150)
  • appraisal_amount — BIGINT
  • appraisal_date — DATE
  • appraisal_document_url — VARCHAR(500)
  • display_order — INT — NOT NULL

onbid_area_details

  • area_detail_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • area_type — VARCHAR(80) — NOT NULL
  • area_m2 — DECIMAL(12,3)
  • area_description — VARCHAR(300)
  • display_order — INT — NOT NULL

onbid_photos

  • photo_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • photo_url — VARCHAR(500) — NOT NULL
  • caption — VARCHAR(200)
  • display_order — INT — NOT NULL

property_complexes

  • complex_id — BIGINT
  • complex_name — VARCHAR(200) — NOT NULL
  • complex_type — VARCHAR(50) — NOT NULL
  • road_address — VARCHAR(300)
  • jibun_address — VARCHAR(300)
  • dong_code — VARCHAR(10) — Foreign key → dong_codes.dong_code
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • built_year — INT
  • total_households — INT
  • total_buildings — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

real_estate_listings

  • listing_id — BIGINT
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id — NOT NULL
  • area_type_id — BIGINT — Foreign key → complex_area_types.area_type_id
  • listing_type — ENUM('SALE','JEONSE','MONTHLY_RENT') — NOT NULL
  • price — BIGINT
  • deposit_amount — BIGINT
  • monthly_rent — BIGINT
  • exclusive_area_m2 — DECIMAL(10,3)
  • floor — INT
  • broker_name — VARCHAR(120)
  • contact_masked — VARCHAR(80)
  • listed_date — DATE
  • status — ENUM('ACTIVE','CLOSED','HIDDEN') — NOT NULL

review_comments

  • review_id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • auction_item_id — BIGINT — Foreign key — NOT NULL
  • rating — INT
  • content — TEXT — NOT NULL
  • status — ENUM('VISIBLE','BLINDED','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

terms

  • terms_id — BIGINT
  • terms_type — ENUM('SERVICE','PRIVACY','AI_NOTICE','AUCTION_NOTICE','DATA_SOURCE') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • version — VARCHAR(30) — NOT NULL
  • required — BOOLEAN — NOT NULL
  • effective_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

user_terms_agreements

  • agreement_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • terms_id — BIGINT — Foreign key → terms.terms_id — NOT NULL
  • agreed — BOOLEAN — NOT NULL
  • agreed_at — DATETIME — NOT NULL

users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(80) — NOT NULL
  • nickname — VARCHAR(80)
  • phone — VARCHAR(30)
  • role — ENUM('VISITOR','USER','AUTHOR','ADMIN') — NOT NULL
  • status — ENUM('ACTIVE','LOCKED','WITHDRAWN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • last_login_at — DATETIME
  • withdrawn_at — DATETIME