nHxHZHLC

1DROP TABLE IF EXISTS "paises";
2CREATE TABLE "public"."paises" (
3    "PK_pais" integer NOT NULL,
4    "nombre_pais" character varying(50) NOT NULL,
5    CONSTRAINT "paises_PK_pais" PRIMARY KEY ("PK_pais")
6) WITH (oids = false);
7
8
9
10CREATE TABLE "public"."ciudades" (
11    "PK_ciudad" integer NOT NULL,
12    "nombre_ciudad" character varying(50) NOT NULL,
13    "PK_pais" integer NOT NULL,
14    CONSTRAINT "ciudades_PK_ciudad" PRIMARY KEY ("PK_ciudad"),
15    CONSTRAINT "ciudades_PK_pais" UNIQUE ("PK_pais"),
16    CONSTRAINT "ciudades_PK_pais_fkey" FOREIGN KEY ("PK_pais") REFERENCES paises("PK_pais") NOT DEFERRABLE
17) WITH (oids = false);