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