RisingHome

Tables (21)

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', 'FIELD_REPORT', 'REGISTRY', 'ETC') — NOT NULL
  • file_path — VARCHAR(500)
  • 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') — NOT NULL
  • onbid_cltr_mng_no — VARCHAR(50) — 온비드 pbctCdtnNo
  • onbid_pbct_cdtn_no — VARCHAR(50)
  • 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(14, 3)
  • land_area_m2 — DECIMAL(14, 3)
  • data_base_date — DATE
  • status — ENUM('SCHEDULED', 'BIDDING', 'CLOSED', 'HIDDEN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

building_infos

  • building_info_id — BIGINT
  • complex_id — BIGINT — Foreign key → property_complexes.complex_id — NOT NULL
  • main_use — VARCHAR(120)
  • sub_use — VARCHAR(120)
  • approval_date — DATE
  • structure_type — VARCHAR(120)
  • roof_type — VARCHAR(120)
  • total_floor_area_m2 — DECIMAL(14,3)
  • building_area_m2 — DECIMAL(14,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(120)
  • 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(80)
  • 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

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
  • source_request_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') — NOT NULL
  • 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(30)
  • source_name — VARCHAR(120) — NOT NULL
  • data_base_date — DATE
  • source_request_deal_ymd — VARCHAR(6) — NOT NULL
  • created_at — DATETIME — NOT NULL

inquiries

  • inquiry_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • inquiry_type — ENUM('AUCTION_INFO', 'DATA', '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 → users.user_id — 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_auctions

  • interest_auction_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • created_at — DATETIME — NOT NULL

interest_deals

  • interest_deal_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • house_deal_id — BIGINT — Foreign key → house_deals.house_deal_id — 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(150)
  • land_area_m2 — DECIMAL(14,3)
  • official_land_price — BIGINT
  • data_source — VARCHAR(120)
  • data_base_date — DATE

nearby_places

  • place_id — BIGINT
  • place_name — VARCHAR(200) — NOT NULL
  • category — ENUM('RESTAURANT', 'CAFE', 'HOSPITAL', 'PHARMACY', 'SCHOOL', 'TRANSPORT', 'PUBLIC_OFFICE', 'CONVENIENCE', 'ETC') — NOT NULL
  • road_address — VARCHAR(300)
  • jibun_address — VARCHAR(300)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • source_name — VARCHAR(120)
  • 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(120) — NOT NULL
  • original_url — VARCHAR(500)
  • published_date — DATE
  • collected_at — DATETIME
  • status — ENUM('VISIBLE', 'HIDDEN', 'DELETED') — NOT NULL

notices

  • notice_id — BIGINT
  • author_id — BIGINT — Foreign key → users.user_id — 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_area_details

  • area_detail_id — BIGINT
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — NOT NULL
  • area_type — VARCHAR(80)
  • area_m2 — DECIMAL(14,3)
  • area_description — VARCHAR(300)
  • appraisal_agency — VARCHAR(150)
  • appraisal_amount — BIGINT
  • appraisal_date — DATE
  • badge_type — VARCHAR(50)
  • 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 — ENUM('APARTMENT', 'MULTI_FAMILY', 'VILLA', 'OFFICETEL', 'COMMERCIAL', 'ETC') — 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

review_comments

  • review_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • auction_item_id — BIGINT — Foreign key → auction_items.auction_item_id — 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

users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(80) — NOT NULL
  • nickname — VARCHAR(80)
  • role — ENUM('USER', '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