Off-Plan

CREATE TABLE wp_szwsihsz_offplan_property_detail ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, project_id BIGINT(20) NOT NULL, -- Amenities: array of { id, icon{url,metadata}, amenity{id,name,icon} } project_amenities LONGTEXT DEFAULT NULL, -- Map points: array of { map_point_name, distance, time } project_map_points LONGTEXT DEFAULT NULL, -- Parking info: array of { id, name, unit_type, parking_space, unit_bedrooms } parkings LONGTEXT DEFAULT NULL, -- Payment plans: array of { id, name, duration_months, steps[], ... } payment_plans LONGTEXT DEFAULT NULL, -- Floor plans: array of { id, name, file (URL), file_type, description } floor_plans LONGTEXT DEFAULT NULL, -- Buildings: array of { id, name, floors_count, building_type, cover_image, ... } buildings LONGTEXT DEFAULT NULL, -- Typical units: array (often empty but can contain unit-type summaries) typical_units LONGTEXT DEFAULT NULL, -- Gallery images stored as separate arrays general_plan LONGTEXT DEFAULT NULL, lobby LONGTEXT DEFAULT NULL, interior LONGTEXT DEFAULT NULL, architecture LONGTEXT DEFAULT NULL, -- Scalar detail fields not in the listing table escrow_number VARCHAR(100) DEFAULT NULL, readiness_progress INT(3) DEFAULT NULL, service_charge VARCHAR(100) DEFAULT NULL, furnishing VARCHAR(100) DEFAULT NULL, post_handover TINYINT(1) DEFAULT NULL, deposit_description TEXT DEFAULT NULL, marketing_brochure TEXT DEFAULT NULL, -- Full response — never lose a field you didn't break into its own column. -- Pull anything extra from here; promote to a column only when you need -- to query or filter on it. raw_json LONGTEXT DEFAULT NULL, detail_fetched_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY project_id (project_id) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;