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