· 6 years ago · Sep 16, 2019, 07:08 AM
1CREATE TABLE IF NOT EXISTS ai_property (
2 id INT AUTO_INCREMENT PRIMARY KEY,
3 property_price text,
4 property_name text NOT NULL,
5 property_location longtext,
6 property_floor_area text,
7 property_land_area text,
8 property_total_bedroom text,
9 property_total_bathroom text,
10 property_description longtext,
11 property_status text,
12 property_agent_name text,
13 property_agent_phone_number text,
14 last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP
15) ENGINE=INNODB;
16
17-- Informasi rumahdijual.com
18property_price
19property_name
20property_location
21property_floor_area
22property_land_area
23property_total_bedroom
24property_total_bathroom
25property_agent_name
26property_agent_phone_number
27property_description
28
29-- Informasi rumah.com
30property_currency
31property_price
32property_name
33property_location
34property_floor_area
35property_total_bedroom
36property_total_bathroom
37property_status
38property_agent_name
39property_agent_phone_number
40
41-- Informasi rumah123.com
42property_price
43property_pricing
44property_name
45property_location
46property_floor_area
47property_total_bedroom
48property_total_bathroom
49property_status