real-esetate
Tables (24)
academy
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- field — VARCHAR(50) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- dong_id — BIGINT — NOT NULL
apartment
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- approval_date — DATE — NOT NULL
- sale_household_count — INT — NOT NULL
- public_rental_count — INT — NOT NULL
- private_rental_count — INT — NOT NULL
- heating_type — VARCHAR(50) — NOT NULL
- corridor_type — VARCHAR(50) — NOT NULL
- constructor — VARCHAR(100) — NOT NULL
- developer — VARCHAR(100) — NOT NULL
- building_structure — VARCHAR(50) — NOT NULL
- building_count — INT — NOT NULL
- household_count — INT — NOT NULL
- elevator_count — INT — NOT NULL
- cctv_count — INT — NOT NULL
- parking_ground_count — INT — NOT NULL
- parking_underground_count — INT — NOT NULL
- max_floor — INT — NOT NULL
- underground_floor — INT — NOT NULL
- dong_id — BIGINT — NOT NULL
apartment_lease_price
- id — BIGINT — Primary key — NOT NULL
- price_index — DECIMAL(10,2) — NOT NULL
- price_index_change — DECIMAL(10,2) — NOT NULL
- transaction_volume — INT — NOT NULL
- transaction_index — DECIMAL(10,2) — NOT NULL
- transaction_change — DECIMAL(10,2) — NOT NULL
- district_id — BIGINT — NOT NULL
apartment_lease_transaction
- id — BIGINT — Primary key — NOT NULL
- lease_type — VARCHAR(20) — NOT NULL
- exclusive_area — DECIMAL(10,2) — NOT NULL
- deposit — BIGINT — NOT NULL
- monthly_rent — BIGINT — NOT NULL
- floor — INT — NOT NULL
- contract_type — VARCHAR(50) — NOT NULL
- contract_date — CHAR(8) — NOT NULL
- prev_deposit — BIGINT — NOT NULL
- prev_monthly_rent — BIGINT — NOT NULL
- apartment_id — BIGINT — NOT NULL
apartment_sale_price
- id — BIGINT — Primary key — NOT NULL
- lease_ratio — DECIMAL(5,2) — NOT NULL
- price_index — DECIMAL(10,2) — NOT NULL
- price_index_change — DECIMAL(10,2) — NOT NULL
- transaction_volume — INT — NOT NULL
- transaction_index — DECIMAL(10,2) — NOT NULL
- transaction_change — DECIMAL(10,2) — NOT NULL
- district_id — BIGINT — NOT NULL
apartment_sale_transaction
- id — BIGINT — Primary key — NOT NULL
- exclusive_area — DECIMAL(10,2) — NOT NULL
- contract_date — CHAR(8) — NOT NULL
- transaction_amount — BIGINT — NOT NULL
- floor — INT — NOT NULL
- buyer — VARCHAR(100) — NOT NULL
- seller — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- transaction_type — VARCHAR(50) — NOT NULL
- apartment_id — BIGINT — NOT NULL
apartment_supply
- id — BIGINT — Primary key — NOT NULL
- year_month — CHAR(6) — NOT NULL
- move_in_complex — INT — NOT NULL
- move_in_household — INT — NOT NULL
- sale_complex — INT — NOT NULL
- sale_total_household — INT — NOT NULL
- sale_union_household — INT — NOT NULL
- sale_union_ratio — DECIMAL(5,2) — NOT NULL
- sale_general_household — INT — NOT NULL
- sale_general_ratio — DECIMAL(5,2) — NOT NULL
- rental_household — INT — NOT NULL
- rental_ratio — DECIMAL(5,2) — NOT NULL
- other_household — INT — NOT NULL
- other_ratio — DECIMAL(5,2) — NOT NULL
- unsold_count — INT — NOT NULL
- unsold_change — DECIMAL(5,2) — NOT NULL
- district_id — BIGINT — NOT NULL
bus_stop
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- dong_id — BIGINT — NOT NULL
commercial_area
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- area_size — DECIMAL(10,2) — NOT NULL
- dong_id — BIGINT — NOT NULL
construction_cost_index
- id — BIGINT — Primary key — NOT NULL
- index_date — DATE — NOT NULL
- residential — DECIMAL(10,2) — NOT NULL
- repair — DECIMAL(10,2) — NOT NULL
- total — DECIMAL(10,2) — NOT NULL
district
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
dong
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- district_id — BIGINT — NOT NULL
household_loan_balance
- id — BIGINT — Primary key — NOT NULL
- year_quarter — CHAR(6) — NOT NULL
- mortgage_balance — BIGINT — NOT NULL
- mortgage_change — DECIMAL(5,2) — NOT NULL
- other_balance — BIGINT — NOT NULL
- other_change — DECIMAL(5,2) — NOT NULL
interest_rate
- id — BIGINT — Primary key — NOT NULL
- year_month — CHAR(6) — NOT NULL
- base_rate — DECIMAL(5,2) — NOT NULL
- household_loan_new — DECIMAL(5,2) — NOT NULL
- small_loan_new — DECIMAL(5,2) — NOT NULL
- mortgage_loan_new — DECIMAL(5,2) — NOT NULL
- deposit_new — DECIMAL(5,2) — NOT NULL
- guarantee_new — DECIMAL(5,2) — NOT NULL
- credit_new — DECIMAL(5,2) — NOT NULL
- group_new — DECIMAL(5,2) — NOT NULL
- household_loan_balance — DECIMAL(5,2) — NOT NULL
- small_loan_balance — DECIMAL(5,2) — NOT NULL
- mortgage_loan_balance — DECIMAL(5,2) — NOT NULL
- deposit_balance — DECIMAL(5,2) — NOT NULL
- guarantee_balance — DECIMAL(5,2) — NOT NULL
- credit_balance — DECIMAL(5,2) — NOT NULL
- group_balance — DECIMAL(5,2) — NOT NULL
- bank_deposit_6m — DECIMAL(5,2) — NOT NULL
- bank_deposit_12m — DECIMAL(5,2) — NOT NULL
- bank_deposit_24m — DECIMAL(5,2) — NOT NULL
- bank_deposit_36m — DECIMAL(5,2) — NOT NULL
- short_term_rate — DECIMAL(5,2) — NOT NULL
library
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- dong_id — BIGINT — NOT NULL
loan_policy
- id — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- announced_date — DATE — NOT NULL
medical_facility
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- specialty — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- dong_id — BIGINT — NOT NULL
news
- id — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- published_date — DATE — NOT NULL
- district_id — BIGINT — NOT NULL
park
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- dong_id — BIGINT — NOT NULL
population_distribution
- id — BIGINT — Primary key — NOT NULL
- total — INT — NOT NULL
- age_0 — INT — NOT NULL
- age_10 — INT — NOT NULL
- age_20 — INT — NOT NULL
- age_30 — INT — NOT NULL
- age_40 — INT — NOT NULL
- age_50 — INT — NOT NULL
- age_60 — INT — NOT NULL
- age_70 — INT — NOT NULL
- age_80 — INT — NOT NULL
- age_90 — INT — NOT NULL
- age_100 — INT — NOT NULL
- foreign_ratio — DECIMAL(5,2) — NOT NULL
- district_id — BIGINT — NOT NULL
railway_station
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- line — VARCHAR(50) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- dong_id — BIGINT — NOT NULL
real_estate_policy
- id — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- announced_date — DATE — NOT NULL
- district_id — BIGINT — NOT NULL
school
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- establishment — VARCHAR(50) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- dong_id — BIGINT — NOT NULL
sports_facility
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- latitude — DECIMAL(11,8) — NOT NULL
- dong_id — BIGINT — NOT NULL