w09SeXEE

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