Spaces:
Running
Running
| -- WARNING: This schema is for context only and is not meant to be run. | |
| -- Table order and constraints may not be valid for execution. | |
| CREATE TABLE public.Cities ( | |
| id smallint GENERATED ALWAYS AS IDENTITY NOT NULL, | |
| name character varying, | |
| created_at timestamp with time zone NOT NULL DEFAULT now(), | |
| CONSTRAINT Cities_pkey PRIMARY KEY (id) | |
| ); | |
| CREATE TABLE public.Districts ( | |
| id integer GENERATED ALWAYS AS IDENTITY NOT NULL, | |
| name character varying, | |
| lname character varying, | |
| city smallint, | |
| created_at timestamp with time zone NOT NULL DEFAULT now(), | |
| CONSTRAINT Districts_pkey PRIMARY KEY (id), | |
| CONSTRAINT Districts_city_fkey FOREIGN KEY (city) REFERENCES public.Cities(id) | |
| ); | |
| CREATE TABLE public.Positions ( | |
| id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, | |
| long real, | |
| lat real, | |
| type character varying, | |
| speed json, | |
| light smallint, | |
| created_at timestamp with time zone NOT NULL DEFAULT now(), | |
| CONSTRAINT Positions_pkey PRIMARY KEY (id) | |
| ); | |
| CREATE TABLE public.StreetPosition ( | |
| id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, | |
| pos_id bigint, | |
| street_id bigint, | |
| created_at timestamp with time zone NOT NULL DEFAULT now(), | |
| CONSTRAINT StreetPosition_pkey PRIMARY KEY (id) | |
| ); | |
| CREATE TABLE public.Streets ( | |
| id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, | |
| name character varying, | |
| type character varying, | |
| district_id integer, | |
| city_id smallint, | |
| ban_id smallint, | |
| parking_id smallint, | |
| length smallint, | |
| direction smallint, | |
| speed smallint, | |
| lane_1 character varying, | |
| lane_2 character varying, | |
| lane_n smallint, | |
| toll smallint, | |
| flooding smallint, | |
| created_at timestamp with time zone NOT NULL DEFAULT now(), | |
| CONSTRAINT Streets_pkey PRIMARY KEY (id), | |
| CONSTRAINT Streets_city_id_fkey FOREIGN KEY (city_id) REFERENCES public.Cities(id), | |
| CONSTRAINT Streets_district_id_fkey FOREIGN KEY (district_id) REFERENCES public.Districts(id) | |
| ); |