mirror of
https://github.com/paralus/paralus.git
synced 2026-08-24 15:47:19 +00:00
Signed-off-by: niravparikh05 <nir.parikh05@gmail.com> Signed-off-by: Nirav Parikh <52062717+niravparikh05@users.noreply.github.com> Co-authored-by: Akshay Gaikwad <akshay196@users.noreply.github.com>
18 lines
667 B
SQL
18 lines
667 B
SQL
CREATE TABLE IF NOT EXISTS cluster_metro (
|
|
id uuid NOT NULL default uuid_generate_v4(),
|
|
name character varying(256) NOT NULL,
|
|
created_at timestamp with time zone NOT NULL,
|
|
modified_at timestamp with time zone NOT NULL,
|
|
trash boolean NOT NULL default false,
|
|
latitude character varying(16) NOT NULL,
|
|
longitude character varying(16) NOT NULL,
|
|
city character varying(64),
|
|
state character varying(64),
|
|
country character varying(64),
|
|
cc character varying(2),
|
|
st character varying(3),
|
|
organization_id uuid,
|
|
partner_id uuid NOT NULL
|
|
);
|
|
|
|
ALTER TABLE ONLY cluster_metro ADD CONSTRAINT cluster_metro_pkey PRIMARY KEY (id); |