UdMjEa0Y

1create table if not exists master.temp_property
2(
3	id varchar(64) not null
4		constraint property_pk
5			primary key,
6	name varchar(64) not null,
7	address varchar,
8	property_type_id varchar(40) not null,
9	created_date timestamp(0),
10	created_by varchar(64),
11	is_deleted boolean default false not null,
12	updated_by varchar(64),
13	updated_date timestamp(0),
14	deleted_date timestamp(0),
15	deleted_by varchar(64),
16	logo varchar(500) not null,
17	province_id varchar(64),
18	city_id varchar(64),
19	sub_district_id varchar(64),
20	website varchar,
21	zipcode integer,
22	active boolean default false not null,
23	developer_id varchar(64) not null
24		constraint property_developer_id_fk
25			references master.temp_developer
26);