Staging schema (data/staging.duckdb)
buildings_raw (259,202 rows)
actual_area VARCHAR, actual_common_area VARCHAR, area_id VARCHAR, area_name_ar VARCHAR, area_name_en VARCHAR, bld_levels VARCHAR, building_number VARCHAR, built_up_area VARCHAR, car_parks VARCHAR, common_area VARCHAR, creation_date VARCHAR, elevators VARCHAR, flats VARCHAR, floors VARCHAR, is_free_hold VARCHAR, is_lease_hold VARCHAR, is_registered VARCHAR, land_number VARCHAR, land_sub_number VARCHAR, land_type_ar VARCHAR, land_type_en VARCHAR, land_type_id VARCHAR, master_project_ar VARCHAR, master_project_en VARCHAR, master_project_id VARCHAR, offices VARCHAR, parcel_id VARCHAR, parent_property_id VARCHAR, pre_registration_number VARCHAR, project_id VARCHAR, project_name_ar VARCHAR, project_name_en VARCHAR, property_id VARCHAR, property_sub_type_ar VARCHAR, property_sub_type_en VARCHAR, property_sub_type_id VARCHAR, property_type_ar VARCHAR, property_type_en VARCHAR, property_type_id VARCHAR, rooms VARCHAR, rooms_ar VARCHAR, rooms_en VARCHAR, shops VARCHAR, swimming_pools VARCHAR, zone_id VARCHAR, load_timestamp VARCHAR
developers (2,370 rows)
developer_id BIGINT, developer_number BIGINT, developer_name_en VARCHAR, legal_status_en VARCHAR, registration_date DATE, license_source_en VARCHAR, license_type_en VARCHAR
dld_sale_index (159 rows)
month DATE, all_monthly_index VARCHAR, all_monthly_price_index VARCHAR, all_quarterly_index VARCHAR, all_quarterly_price_index VARCHAR, all_yearly_index VARCHAR, all_yearly_price_index VARCHAR, flat_monthly_index VARCHAR, flat_monthly_price_index VARCHAR, flat_quarterly_index VARCHAR, flat_quarterly_price_index VARCHAR, flat_yearly_index VARCHAR, flat_yearly_price_index VARCHAR, villa_monthly_index VARCHAR, villa_monthly_price_index VARCHAR, villa_quarterly_index VARCHAR, villa_quarterly_price_index VARCHAR, villa_yearly_index VARCHAR, villa_yearly_price_index VARCHAR
lkp_areas (301 rows)
area_id INTEGER, area_name_en VARCHAR, municipality_number VARCHAR
lkp_procedures (64 rows)
group_id INTEGER, procedure_id INTEGER, is_pre_registration INTEGER, name_en VARCHAR
projects (3,474 rows)
project_id BIGINT, project_number BIGINT, project_name VARCHAR, master_project_en VARCHAR, area_id INTEGER, area_name_en VARCHAR, developer_id BIGINT, developer_name VARCHAR, master_developer_name VARCHAR, project_status VARCHAR, percent_completed DOUBLE, project_start_date DATE, project_end_date DATE, completion_date DATE, cancellation_date DATE, no_of_buildings INTEGER, no_of_villas INTEGER, no_of_units INTEGER, no_of_lands INTEGER, escrow_agent_name VARCHAR, project_classification_id VARCHAR, project_type_id VARCHAR, zoning_authority_en VARCHAR, project_description_en VARCHAR
sales_residential (1,115,144 rows)
txn_id VARCHAR, date DATE, month DATE, txn_group VARCHAR, procedure_id INTEGER, procedure_name VARCHAR, registration VARCHAR, is_offplan BOOLEAN, usage VARCHAR, property_type VARCHAR, property_sub_type VARCHAR, segment VARCHAR, rooms_raw VARCHAR, bedrooms INTEGER, area_sqm DOUBLE, area_sqft DOUBLE, price_aed DOUBLE, price_aed_sqft DOUBLE, area_id INTEGER, area_name_en VARCHAR, master_project VARCHAR, project_number BIGINT, project_name VARCHAR, building_name VARCHAR, has_parking BOOLEAN, parties_1 INTEGER, parties_2 INTEGER, nearest_metro VARCHAR, nearest_mall VARCHAR, nearest_landmark VARCHAR, q_date_ok BOOLEAN, q_price_ok BOOLEAN, q_area_ok BOOLEAN
service_charges (169,109 rows)
budget_year INTEGER, master_community_id BIGINT, master_community_name_en VARCHAR, project_id BIGINT, project_name VARCHAR, property_group_id BIGINT, property_group_name_en VARCHAR, service_category_id INTEGER, service_category_name_en VARCHAR, usage_id INTEGER, usage_name_en VARCHAR, aed_per_sqft DOUBLE, management_company_id BIGINT, management_company_name_en VARCHAR
transactions (1,814,844 rows)
txn_id VARCHAR, date DATE, month DATE, txn_group VARCHAR, procedure_id INTEGER, procedure_name VARCHAR, registration VARCHAR, is_offplan BOOLEAN, usage VARCHAR, property_type VARCHAR, property_sub_type VARCHAR, segment VARCHAR, rooms_raw VARCHAR, bedrooms INTEGER, area_sqm DOUBLE, area_sqft DOUBLE, price_aed DOUBLE, price_aed_sqft DOUBLE, area_id INTEGER, area_name_en VARCHAR, master_project VARCHAR, project_number BIGINT, project_name VARCHAR, building_name VARCHAR, has_parking BOOLEAN, parties_1 INTEGER, parties_2 INTEGER, nearest_metro VARCHAR, nearest_mall VARCHAR, nearest_landmark VARCHAR, q_date_ok BOOLEAN, q_price_ok BOOLEAN, q_area_ok BOOLEAN
units (2,388,184 rows)
property_id BIGINT, parent_property_id BIGINT, area_id INTEGER, area_name_en VARCHAR, master_project_en VARCHAR, project_id BIGINT, project_name_en VARCHAR, land_number BIGINT, parcel_id BIGINT, building_number VARCHAR, unit_number VARCHAR, floor DOUBLE, property_type_en VARCHAR, property_sub_type_en VARCHAR, rooms_en VARCHAR, bedrooms INTEGER, actual_area_sqm DOUBLE, actual_area_sqft DOUBLE, balcony_area_sqm DOUBLE, is_free_hold INTEGER, creation_date DATE
valuations (91,751 rows)
date DATE, month TIMESTAMP, area_id INTEGER, area_name_en VARCHAR, property_type_en VARCHAR, property_sub_type_en VARCHAR, procedure_name_en VARCHAR, actual_worth DOUBLE, property_total_value DOUBLE, procedure_area_sqm DOUBLE, actual_area_sqm DOUBLE