7tCTwPNM

1CREATE TABLE "ALIM"."ALI_LIGNES"(
2	"ObjectID" int4 NOT NULL,
3	"ALI_LIS_ID" varchar(10) NOT NULL,
4	"ALI_LIS_CLE" varchar(100) NOT NULL,
5	"ALI_LIS_MODE" varchar(10) NOT NULL,
6	"ALI_LIS_IDLIG" integer NOT NULL,
7	"ALI_LIS_NOMLIG" varchar(255) NOT NULL,
8	"ALI_LIS_LIGCOM" varchar(30) NOT NULL,
9	"ALI_LIS_INDICE" varchar(3) NOT NULL,
10	"ALI_LIS_LIT_MARK" boolean DEFAULT false,
11	"SHAPE" geometry NOT NULL,
12	CONSTRAINT "PK_ALI_LIS_ID" PRIMARY KEY ("ALI_LIS_ID")
13
14);
15
16-- object: "ALIM"."ALI_POINTS_ARRET" | type: TABLE --
17-- DROP TABLE IF EXISTS "ALIM"."ALI_POINTS_ARRET" CASCADE;
18CREATE TABLE "ALIM"."ALI_POINTS_ARRET"(
19	"ObjectID" int4 NOT NULL,
20	"ALI_PAS_ID" varchar(10) NOT NULL,
21	"ALI_PAS_CLE" varchar(100) NOT NULL,
22	"ALI_PAS_LIS_INDICE" varchar(5) NOT NULL,
23	"ALI_PAS_MODE" varchar(10) NOT NULL,
24	"ALI_PAS_IDPTAR" integer NOT NULL,
25	"ALI_PAS_NOMPTAR" varchar(100) NOT NULL,
26	"ALI_PAS_IDNOEUD" integer NOT NULL,
27	"ALI_PAS_IDLIG" integer NOT NULL,
28	"ALI_PAS_LIGCOM" varchar(30) NOT NULL,
29	"ALI_PAS_IDPROP" integer,
30	"ALI_PAS_CI" integer,
31	"ALI_PAS_OPE" varchar(10),
32	"ALI_PAS_IDEMPL" integer,
33	"SHAPE" geometry NOT NULL,
34	CONSTRAINT "PK_ALI_PAS_ID" PRIMARY KEY ("ALI_PAS_ID")
35
36);
37
38ALTER TABLE "ALIM"."ALI_POINTS_ARRET" ADD CONSTRAINT "FK_ALI_POINTS_ARRET_LIGNES" FOREIGN KEY ("ALI_PAS_LIS_INDICE")
39REFERENCES "ALIM"."ALI_LIGNES" ("ALI_LIS_INDICE") MATCH FULL
40ON DELETE NO ACTION ON UPDATE NO ACTION;