-- Table: public.detections_plates_allowed
|
|
-- DROP TABLE public.detections_plates_allowed;
|
|
CREATE TABLE public.detections_plates_allowed
|
(
|
location text COLLATE pg_catalog."default" NOT NULL,
|
insertiontimestamp bigint NOT NULL,
|
detectiontimestamp bigint NOT NULL,
|
ticketabsolutenumber bigint,
|
tickettimetoleave bigint,
|
timetoleavereal bigint,
|
priority boolean,
|
parking text COLLATE pg_catalog."default",
|
manual boolean,
|
detectionplate text COLLATE pg_catalog."default" NOT NULL,
|
detectionlane integer,
|
detectioncountry text COLLATE pg_catalog."default",
|
ticketrelativenumber bigint,
|
tickettimestamp bigint,
|
length double precision,
|
value jsonb,
|
CONSTRAINT detections_plates_allowed_pkey1 PRIMARY KEY (detectionplate)
|
USING INDEX TABLESPACE artic
|
)
|
WITH (
|
OIDS = FALSE
|
)
|
TABLESPACE artic;
|
|
ALTER TABLE public.detections_plates_allowed
|
OWNER to aluvisa;
|
|
-- Index: detectiontimestampallowedn
|
|
-- DROP INDEX public.detectiontimestampallowedn;
|
|
CREATE INDEX detectiontimestampallowedn
|
ON public.detections_plates_allowed USING btree
|
(detectiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: insertiontimestampallowedn
|
|
-- DROP INDEX public.insertiontimestampallowedn;
|
|
CREATE INDEX insertiontimestampallowedn
|
ON public.detections_plates_allowed USING btree
|
(insertiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: locationallowedn
|
|
-- DROP INDEX public.locationallowedn;
|
|
CREATE INDEX locationallowedn
|
ON public.detections_plates_allowed USING btree
|
(location COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: manualallowedn
|
|
-- DROP INDEX public.manualallowedn;
|
|
CREATE INDEX manualallowedn
|
ON public.detections_plates_allowed USING btree
|
(manual)
|
TABLESPACE artic;
|
|
-- Index: parkingallowedn
|
|
-- DROP INDEX public.parkingallowedn;
|
|
CREATE INDEX parkingallowedn
|
ON public.detections_plates_allowed USING btree
|
(parking COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: priorityallowedn
|
|
-- DROP INDEX public.priorityallowedn;
|
|
CREATE INDEX priorityallowedn
|
ON public.detections_plates_allowed USING btree
|
(priority)
|
TABLESPACE artic;
|
|
-- Index: ticketabsolutenumberallowedn
|
|
-- DROP INDEX public.ticketabsolutenumberallowedn;
|
|
CREATE INDEX ticketabsolutenumberallowedn
|
ON public.detections_plates_allowed USING btree
|
(ticketabsolutenumber)
|
TABLESPACE artic;
|
|
-- Index: tickettimetoleaveallowedn
|
|
-- DROP INDEX public.tickettimetoleaveallowedn;
|
|
CREATE INDEX tickettimetoleaveallowedn
|
ON public.detections_plates_allowed USING btree
|
(tickettimetoleave)
|
TABLESPACE artic;
|
|
-- Index: timetoleaverealallowedn
|
|
-- DROP INDEX public.timetoleaverealallowedn;
|
|
CREATE INDEX timetoleaverealallowedn
|
ON public.detections_plates_allowed USING btree
|
(timetoleavereal)
|
TABLESPACE artic;
|
|
|
|
-- Table: public.detections_plates_border
|
|
-- DROP TABLE public.detections_plates_border;
|
|
CREATE TABLE public.detections_plates_border
|
(
|
location text COLLATE pg_catalog."default" NOT NULL,
|
insertiontimestamp bigint NOT NULL,
|
detectiontimestamp bigint NOT NULL,
|
ticketabsolutenumber bigint,
|
tickettimetoleave bigint,
|
timetoleavereal bigint,
|
timestampexit bigint,
|
timestampbarrier1 bigint,
|
timestampbarrier2 bigint,
|
priority boolean,
|
parking text COLLATE pg_catalog."default",
|
manual boolean,
|
accessmethodbarrier2 integer,
|
detectionplate text COLLATE pg_catalog."default" NOT NULL,
|
detectionlane integer,
|
detectioncountry text COLLATE pg_catalog."default",
|
ticketrelativenumber bigint,
|
tickettimestamp bigint,
|
length double precision,
|
value jsonb,
|
CONSTRAINT detections_plates_border_pkey1 PRIMARY KEY (detectionplate)
|
USING INDEX TABLESPACE artic
|
)
|
WITH (
|
OIDS = FALSE
|
)
|
TABLESPACE artic;
|
|
ALTER TABLE public.detections_plates_border
|
OWNER to aluvisa;
|
|
-- Index: accessbarrier2bordern
|
|
-- DROP INDEX public.accessbarrier2bordern;
|
|
CREATE INDEX accessbarrier2bordern
|
ON public.detections_plates_border USING btree
|
(accessmethodbarrier2)
|
TABLESPACE artic;
|
|
-- Index: detectiontimestampbordern
|
|
-- DROP INDEX public.detectiontimestampbordern;
|
|
CREATE INDEX detectiontimestampbordern
|
ON public.detections_plates_border USING btree
|
(detectiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: insertiontimestampbordern
|
|
-- DROP INDEX public.insertiontimestampbordern;
|
|
CREATE INDEX insertiontimestampbordern
|
ON public.detections_plates_border USING btree
|
(insertiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: locationbordern
|
|
-- DROP INDEX public.locationbordern;
|
|
CREATE INDEX locationbordern
|
ON public.detections_plates_border USING btree
|
(location COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: manualbordern
|
|
-- DROP INDEX public.manualbordern;
|
|
CREATE INDEX manualbordern
|
ON public.detections_plates_border USING btree
|
(manual)
|
TABLESPACE artic;
|
|
-- Index: parkingbordern
|
|
-- DROP INDEX public.parkingbordern;
|
|
CREATE INDEX parkingbordern
|
ON public.detections_plates_border USING btree
|
(parking COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: prioritybordern
|
|
-- DROP INDEX public.prioritybordern;
|
|
CREATE INDEX prioritybordern
|
ON public.detections_plates_border USING btree
|
(priority)
|
TABLESPACE artic;
|
|
-- Index: ticketabsolutenumberbordern
|
|
-- DROP INDEX public.ticketabsolutenumberbordern;
|
|
CREATE INDEX ticketabsolutenumberbordern
|
ON public.detections_plates_border USING btree
|
(ticketabsolutenumber)
|
TABLESPACE artic;
|
|
-- Index: tickettimetoleavebordern
|
|
-- DROP INDEX public.tickettimetoleavebordern;
|
|
CREATE INDEX tickettimetoleavebordern
|
ON public.detections_plates_border USING btree
|
(tickettimetoleave)
|
TABLESPACE artic;
|
|
-- Index: timestampbarrier1bordern
|
|
-- DROP INDEX public.timestampbarrier1bordern;
|
|
CREATE INDEX timestampbarrier1bordern
|
ON public.detections_plates_border USING btree
|
(timestampbarrier1)
|
TABLESPACE artic;
|
|
-- Index: timestampbarrier2bordern
|
|
-- DROP INDEX public.timestampbarrier2bordern;
|
|
CREATE INDEX timestampbarrier2bordern
|
ON public.detections_plates_border USING btree
|
(timestampbarrier2)
|
TABLESPACE artic;
|
|
-- Index: timestampexitbordern
|
|
-- DROP INDEX public.timestampexitbordern;
|
|
CREATE INDEX timestampexitbordern
|
ON public.detections_plates_border USING btree
|
(timestampexit)
|
TABLESPACE artic;
|
|
-- Index: timetoleaverealbordern
|
|
-- DROP INDEX public.timetoleaverealbordern;
|
|
CREATE INDEX timetoleaverealbordern
|
ON public.detections_plates_border USING btree
|
(timetoleavereal)
|
TABLESPACE artic;
|
|
|
-- Table: public.detections_plates_distracted
|
|
-- DROP TABLE public.detections_plates_distracted;
|
|
CREATE TABLE public.detections_plates_distracted
|
(
|
location text COLLATE pg_catalog."default" NOT NULL,
|
insertiontimestamp bigint NOT NULL,
|
detectiontimestamp bigint NOT NULL,
|
ticketabsolutenumber bigint,
|
tickettimetoleave bigint,
|
timetoleavereal bigint,
|
priority boolean,
|
parking text COLLATE pg_catalog."default",
|
manual boolean,
|
detectionplate text COLLATE pg_catalog."default" NOT NULL,
|
detectionlane integer,
|
detectioncountry text COLLATE pg_catalog."default",
|
ticketrelativenumber bigint,
|
tickettimestamp bigint,
|
length double precision,
|
value jsonb,
|
CONSTRAINT detections_plates_distracted_pkey1 PRIMARY KEY (detectionplate)
|
USING INDEX TABLESPACE artic
|
)
|
WITH (
|
OIDS = FALSE
|
)
|
TABLESPACE artic;
|
|
ALTER TABLE public.detections_plates_distracted
|
OWNER to aluvisa;
|
|
-- Index: detectiontimestampdistractedn
|
|
-- DROP INDEX public.detectiontimestampdistractedn;
|
|
CREATE INDEX detectiontimestampdistractedn
|
ON public.detections_plates_distracted USING btree
|
(detectiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: insertiontimestampdistractedn
|
|
-- DROP INDEX public.insertiontimestampdistractedn;
|
|
CREATE INDEX insertiontimestampdistractedn
|
ON public.detections_plates_distracted USING btree
|
(insertiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: locationdistractedn
|
|
-- DROP INDEX public.locationdistractedn;
|
|
CREATE INDEX locationdistractedn
|
ON public.detections_plates_distracted USING btree
|
(location COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: manualdistractedn
|
|
-- DROP INDEX public.manualdistractedn;
|
|
CREATE INDEX manualdistractedn
|
ON public.detections_plates_distracted USING btree
|
(manual)
|
TABLESPACE artic;
|
|
-- Index: parkingdistractedn
|
|
-- DROP INDEX public.parkingdistractedn;
|
|
CREATE INDEX parkingdistractedn
|
ON public.detections_plates_distracted USING btree
|
(parking COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: prioritydistractedn
|
|
-- DROP INDEX public.prioritydistractedn;
|
|
CREATE INDEX prioritydistractedn
|
ON public.detections_plates_distracted USING btree
|
(priority)
|
TABLESPACE artic;
|
|
-- Index: ticketabsolutenumberdistractedn
|
|
-- DROP INDEX public.ticketabsolutenumberdistractedn;
|
|
CREATE INDEX ticketabsolutenumberdistractedn
|
ON public.detections_plates_distracted USING btree
|
(ticketabsolutenumber)
|
TABLESPACE artic;
|
|
-- Index: tickettimetoleavedistractedn
|
|
-- DROP INDEX public.tickettimetoleavedistractedn;
|
|
CREATE INDEX tickettimetoleavedistractedn
|
ON public.detections_plates_distracted USING btree
|
(tickettimetoleave)
|
TABLESPACE artic;
|
|
-- Index: timetoleaverealdistractedn
|
|
-- DROP INDEX public.timetoleaverealdistractedn;
|
|
CREATE INDEX timetoleaverealdistractedn
|
ON public.detections_plates_distracted USING btree
|
(timetoleavereal)
|
TABLESPACE artic;
|
|
|
|
-- Table: public.detections_plates_parking
|
|
-- DROP TABLE public.detections_plates_parking;
|
|
CREATE TABLE public.detections_plates_parking
|
(
|
location text COLLATE pg_catalog."default" NOT NULL,
|
insertiontimestamp bigint NOT NULL,
|
detectiontimestamp bigint NOT NULL,
|
ticketabsolutenumber bigint,
|
tickettimetoleave bigint,
|
timetoleavereal bigint,
|
priority boolean,
|
parking text COLLATE pg_catalog."default",
|
manual boolean,
|
detectionplate text COLLATE pg_catalog."default" NOT NULL,
|
detectionlane integer,
|
detectioncountry text COLLATE pg_catalog."default",
|
ticketrelativenumber bigint,
|
tickettimestamp bigint,
|
length double precision,
|
value jsonb,
|
CONSTRAINT detections_plates_parking_pkey1 PRIMARY KEY (detectionplate)
|
USING INDEX TABLESPACE artic
|
)
|
WITH (
|
OIDS = FALSE
|
)
|
TABLESPACE artic;
|
|
ALTER TABLE public.detections_plates_parking
|
OWNER to aluvisa;
|
|
-- Index: detectiontimestampparkingn
|
|
-- DROP INDEX public.detectiontimestampparkingn;
|
|
CREATE INDEX detectiontimestampparkingn
|
ON public.detections_plates_parking USING btree
|
(detectiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: insertiontimestampparkingn
|
|
-- DROP INDEX public.insertiontimestampparkingn;
|
|
CREATE INDEX insertiontimestampparkingn
|
ON public.detections_plates_parking USING btree
|
(insertiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: locationparkingn
|
|
-- DROP INDEX public.locationparkingn;
|
|
CREATE INDEX locationparkingn
|
ON public.detections_plates_parking USING btree
|
(location COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: manualparkingn
|
|
-- DROP INDEX public.manualparkingn;
|
|
CREATE INDEX manualparkingn
|
ON public.detections_plates_parking USING btree
|
(manual)
|
TABLESPACE artic;
|
|
-- Index: parkingparkingn
|
|
-- DROP INDEX public.parkingparkingn;
|
|
CREATE INDEX parkingparkingn
|
ON public.detections_plates_parking USING btree
|
(parking COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: priorityparkingn
|
|
-- DROP INDEX public.priorityparkingn;
|
|
CREATE INDEX priorityparkingn
|
ON public.detections_plates_parking USING btree
|
(priority)
|
TABLESPACE artic;
|
|
-- Index: ticketabsolutenumberparkingn
|
|
-- DROP INDEX public.ticketabsolutenumberparkingn;
|
|
CREATE INDEX ticketabsolutenumberparkingn
|
ON public.detections_plates_parking USING btree
|
(ticketabsolutenumber)
|
TABLESPACE artic;
|
|
-- Index: tickettimetoleaveparkingn
|
|
-- DROP INDEX public.tickettimetoleaveparkingn;
|
|
CREATE INDEX tickettimetoleaveparkingn
|
ON public.detections_plates_parking USING btree
|
(tickettimetoleave)
|
TABLESPACE artic;
|
|
-- Index: timetoleaverealparkingn
|
|
-- DROP INDEX public.timetoleaverealparkingn;
|
|
CREATE INDEX timetoleaverealparkingn
|
ON public.detections_plates_parking USING btree
|
(timetoleavereal)
|
TABLESPACE artic;
|
|
|
|
-- Table: public.detections_plates_ticket
|
|
-- DROP TABLE public.detections_plates_ticket;
|
|
CREATE TABLE public.detections_plates_ticket
|
(
|
location text COLLATE pg_catalog."default" NOT NULL,
|
insertiontimestamp bigint NOT NULL,
|
detectiontimestamp bigint NOT NULL,
|
ticketabsolutenumber bigint,
|
tickettimetoleave bigint,
|
priority boolean,
|
detectionplate text COLLATE pg_catalog."default" NOT NULL,
|
detectionlane integer,
|
detectioncountry text COLLATE pg_catalog."default",
|
ticketrelativenumber bigint,
|
tickettimestamp bigint,
|
length double precision,
|
value jsonb,
|
CONSTRAINT detections_plates_ticket_pkey PRIMARY KEY (detectionplate)
|
USING INDEX TABLESPACE artic
|
)
|
WITH (
|
OIDS = FALSE
|
)
|
TABLESPACE artic;
|
|
ALTER TABLE public.detections_plates_ticket
|
OWNER to aluvisa;
|
|
-- Index: detectiontimestampticket
|
|
-- DROP INDEX public.detectiontimestampticket;
|
|
CREATE INDEX detectiontimestampticket
|
ON public.detections_plates_ticket USING btree
|
(detectiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: insertiontimestampticket
|
|
-- DROP INDEX public.insertiontimestampticket;
|
|
CREATE INDEX insertiontimestampticket
|
ON public.detections_plates_ticket USING btree
|
(insertiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: locationticket
|
|
-- DROP INDEX public.locationticket;
|
|
CREATE INDEX locationticket
|
ON public.detections_plates_ticket USING btree
|
(location COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: priorityticket
|
|
-- DROP INDEX public.priorityticket;
|
|
CREATE INDEX priorityticket
|
ON public.detections_plates_ticket USING btree
|
(priority)
|
TABLESPACE artic;
|
|
-- Index: ticketabsolutenumberticket
|
|
-- DROP INDEX public.ticketabsolutenumberticket;
|
|
CREATE INDEX ticketabsolutenumberticket
|
ON public.detections_plates_ticket USING btree
|
(ticketabsolutenumber)
|
TABLESPACE artic;
|
|
-- Index: tickettimetoleaveticket
|
|
-- DROP INDEX public.tickettimetoleaveticket;
|
|
CREATE INDEX tickettimetoleaveticket
|
ON public.detections_plates_ticket USING btree
|
(tickettimetoleave)
|
TABLESPACE artic;
|
|
|
|
-- Table: public.detections_plates_transit
|
|
-- DROP TABLE public.detections_plates_transit;
|
|
CREATE TABLE public.detections_plates_transit
|
(
|
location text COLLATE pg_catalog."default" NOT NULL,
|
insertiontimestamp bigint NOT NULL,
|
detectiontimestamp bigint NOT NULL,
|
ticketabsolutenumber bigint,
|
tickettimetoleave bigint,
|
timetoleavereal bigint,
|
timestampexit bigint,
|
timestampbarrier1 bigint,
|
timestampbarrier2 bigint,
|
priority boolean,
|
parking text COLLATE pg_catalog."default",
|
manual boolean,
|
accessmethodbarrier2 integer,
|
detectionplate text COLLATE pg_catalog."default" NOT NULL,
|
detectionlane integer,
|
detectioncountry text COLLATE pg_catalog."default",
|
ticketrelativenumber bigint,
|
tickettimestamp bigint,
|
length double precision,
|
value jsonb,
|
CONSTRAINT detections_plates_transit_pkey1 PRIMARY KEY (detectionplate)
|
USING INDEX TABLESPACE artic
|
)
|
WITH (
|
OIDS = FALSE
|
)
|
TABLESPACE artic;
|
|
ALTER TABLE public.detections_plates_transit
|
OWNER to aluvisa;
|
|
-- Index: accessbarrier2transitn
|
|
-- DROP INDEX public.accessbarrier2transitn;
|
|
CREATE INDEX accessbarrier2transitn
|
ON public.detections_plates_transit USING btree
|
(accessmethodbarrier2)
|
TABLESPACE artic;
|
|
-- Index: detectiontimestamptransitn
|
|
-- DROP INDEX public.detectiontimestamptransitn;
|
|
CREATE INDEX detectiontimestamptransitn
|
ON public.detections_plates_transit USING btree
|
(detectiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: insertiontimestamptransitn
|
|
-- DROP INDEX public.insertiontimestamptransitn;
|
|
CREATE INDEX insertiontimestamptransitn
|
ON public.detections_plates_transit USING btree
|
(insertiontimestamp)
|
TABLESPACE artic;
|
|
-- Index: locationtransitn
|
|
-- DROP INDEX public.locationtransitn;
|
|
CREATE INDEX locationtransitn
|
ON public.detections_plates_transit USING btree
|
(location COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: manualtransitn
|
|
-- DROP INDEX public.manualtransitn;
|
|
CREATE INDEX manualtransitn
|
ON public.detections_plates_transit USING btree
|
(manual)
|
TABLESPACE artic;
|
|
-- Index: parkingtransitn
|
|
-- DROP INDEX public.parkingtransitn;
|
|
CREATE INDEX parkingtransitn
|
ON public.detections_plates_transit USING btree
|
(parking COLLATE pg_catalog."default")
|
TABLESPACE artic;
|
|
-- Index: prioritytransitn
|
|
-- DROP INDEX public.prioritytransitn;
|
|
CREATE INDEX prioritytransitn
|
ON public.detections_plates_transit USING btree
|
(priority)
|
TABLESPACE artic;
|
|
-- Index: ticketabsolutenumbertransitn
|
|
-- DROP INDEX public.ticketabsolutenumbertransitn;
|
|
CREATE INDEX ticketabsolutenumbertransitn
|
ON public.detections_plates_transit USING btree
|
(ticketabsolutenumber)
|
TABLESPACE artic;
|
|
-- Index: tickettimetoleavetransitn
|
|
-- DROP INDEX public.tickettimetoleavetransitn;
|
|
CREATE INDEX tickettimetoleavetransitn
|
ON public.detections_plates_transit USING btree
|
(tickettimetoleave)
|
TABLESPACE artic;
|
|
-- Index: timestampbarrier1transitn
|
|
-- DROP INDEX public.timestampbarrier1transitn;
|
|
CREATE INDEX timestampbarrier1transitn
|
ON public.detections_plates_transit USING btree
|
(timestampbarrier1)
|
TABLESPACE artic;
|
|
-- Index: timestampbarrier2transitn
|
|
-- DROP INDEX public.timestampbarrier2transitn;
|
|
CREATE INDEX timestampbarrier2transitn
|
ON public.detections_plates_transit USING btree
|
(timestampbarrier2)
|
TABLESPACE artic;
|
|
-- Index: timestampexittransitn
|
|
-- DROP INDEX public.timestampexittransitn;
|
|
CREATE INDEX timestampexittransitn
|
ON public.detections_plates_transit USING btree
|
(timestampexit)
|
TABLESPACE artic;
|
|
-- Index: timetoleaverealtransitn
|
|
-- DROP INDEX public.timetoleaverealtransitn;
|
|
CREATE INDEX timetoleaverealtransitn
|
ON public.detections_plates_transit USING btree
|
(timetoleavereal)
|
TABLESPACE artic;
|
|
|
|
-- Table: public.ticket_machine_plates
|
|
-- DROP TABLE public.ticket_machine_plates;
|
|
CREATE TABLE public.ticket_machine_plates
|
(
|
"timestamp" bigint NOT NULL,
|
plate text COLLATE pg_catalog."default" NOT NULL,
|
absolutenumber bigint,
|
relativenumber bigint,
|
parking text COLLATE pg_catalog."default",
|
priority boolean,
|
manual boolean,
|
result integer,
|
timetoleave bigint,
|
type integer,
|
value jsonb,
|
CONSTRAINT ticket_machine_plates_pkey PRIMARY KEY ("timestamp", plate)
|
USING INDEX TABLESPACE artic
|
)
|
WITH (
|
OIDS = FALSE
|
)
|
TABLESPACE artic;
|
|
ALTER TABLE public.ticket_machine_plates
|
OWNER to aluvisa;
|
|
|
|
|
|
