2023-03-15 13:06:42 +00:00
|
|
|
CREATE TABLE IF NOT EXISTS "unit" (
|
|
|
|
id UUID PRIMARY KEY,
|
|
|
|
project_id UUID NOT NULL,
|
|
|
|
price_usd FLOAT8 NOT NULL,
|
|
|
|
unit_type VARCHAR NOT NULL,
|
|
|
|
rooms SMALLINT NOT NULL,
|
2023-05-10 16:52:20 +00:00
|
|
|
bathrooms FLOAT4 NOT NULL,
|
2023-03-15 13:06:42 +00:00
|
|
|
area FLOAT4 NOT NULL,
|
|
|
|
description TEXT NOT NULL,
|
|
|
|
media TEXT NOT NULL,
|
|
|
|
admin_tag VARCHAR,
|
|
|
|
time_created TIMESTAMPTZ NOT NULL,
|
|
|
|
last_updated TIMESTAMPTZ NOT NULL
|
|
|
|
);
|