dev-chiefworks
65 lines
2.0 KiB
SQL
65 lines
2.0 KiB
SQL
-- -------------------------------------------------------------
|
|
-- TablePlus 2.12(282)
|
|
--
|
|
-- https://tableplus.com/
|
|
--
|
|
-- Database: savvy
|
|
-- Generation Time: 2020-01-11 13:31:52.8090
|
|
-- -------------------------------------------------------------
|
|
|
|
|
|
-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup.
|
|
|
|
-- Sequence and defined type
|
|
CREATE SEQUENCE IF NOT EXISTS geofence_area_id_seq;
|
|
|
|
-- Table Definition
|
|
CREATE TABLE "public"."geofence_area" (
|
|
"id" int4 NOT NULL DEFAULT nextval('geofence_area_id_seq'::regclass),
|
|
"name" varchar(100),
|
|
"area" varchar(100),
|
|
"city_id" int4,
|
|
"country" varchar(2),
|
|
"latitude" float8,
|
|
"longitude" float8,
|
|
"location" geography(Point, 4326),
|
|
"type" varchar(15),
|
|
"boundaries" json,
|
|
PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup.
|
|
|
|
-- Sequence and defined type
|
|
CREATE SEQUENCE IF NOT EXISTS geofence_area_city_id_seq;
|
|
|
|
-- Table Definition
|
|
CREATE TABLE "public"."geofence_area_city" (
|
|
"id" int4 NOT NULL DEFAULT nextval('geofence_area_city_id_seq'::regclass),
|
|
"city" varchar(100),
|
|
"country" varchar(2),
|
|
"latitude" float8,
|
|
"longitude" float8,
|
|
"location" geography(Point, 4326),
|
|
"radius" int4,
|
|
PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup.
|
|
|
|
-- Sequence and defined type
|
|
CREATE SEQUENCE IF NOT EXISTS geofence_area_country_id_seq;
|
|
|
|
-- Table Definition
|
|
CREATE TABLE "public"."geofence_area_country" (
|
|
"id" int4 NOT NULL DEFAULT nextval('geofence_area_country_id_seq'::regclass),
|
|
"country" varchar(2),
|
|
"latitude" float8,
|
|
"longitude" float8,
|
|
"location" geography(Point, 4326),
|
|
"radius" int4,
|
|
PRIMARY KEY ("id")
|
|
);
|
|
|
|
|