-- Schema: bird__mondial_geo
CREATE SCHEMA IF NOT EXISTS "bird__mondial_geo";

-- Table: borders
CREATE TABLE "bird__mondial_geo"."borders" (
    "Country1" TEXT NOT NULL DEFAULT ''::text,
    "Country2" TEXT NOT NULL DEFAULT ''::text,
    "Length" DOUBLE PRECISION,
    CONSTRAINT "borders_pkey" PRIMARY KEY ("Country1", "Country2")
);

-- Table: city
CREATE TABLE "bird__mondial_geo"."city" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    "Population" BIGINT,
    "Longitude" DOUBLE PRECISION,
    "Latitude" DOUBLE PRECISION,
    CONSTRAINT "city_pkey" PRIMARY KEY ("Name", "Province")
);

-- Table: continent
CREATE TABLE "bird__mondial_geo"."continent" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Area" DOUBLE PRECISION,
    CONSTRAINT "continent_pkey" PRIMARY KEY ("Name")
);

-- Table: country
CREATE TABLE "bird__mondial_geo"."country" (
    "Name" TEXT NOT NULL,
    "Code" TEXT NOT NULL DEFAULT ''::text,
    "Capital" TEXT,
    "Province" TEXT,
    "Area" DOUBLE PRECISION,
    "Population" BIGINT,
    CONSTRAINT "country_pkey" PRIMARY KEY ("Code")
);

-- Table: desert
CREATE TABLE "bird__mondial_geo"."desert" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Area" DOUBLE PRECISION,
    "Longitude" DOUBLE PRECISION,
    "Latitude" DOUBLE PRECISION,
    CONSTRAINT "desert_pkey" PRIMARY KEY ("Name")
);

-- Table: economy
CREATE TABLE "bird__mondial_geo"."economy" (
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "GDP" DOUBLE PRECISION,
    "Agriculture" DOUBLE PRECISION,
    "Service" DOUBLE PRECISION,
    "Industry" DOUBLE PRECISION,
    "Inflation" DOUBLE PRECISION,
    CONSTRAINT "economy_pkey" PRIMARY KEY ("Country")
);

-- Table: encompasses
CREATE TABLE "bird__mondial_geo"."encompasses" (
    "Country" TEXT NOT NULL,
    "Continent" TEXT NOT NULL,
    "Percentage" DOUBLE PRECISION,
    CONSTRAINT "encompasses_pkey" PRIMARY KEY ("Country", "Continent")
);

-- Table: ethnicGroup
CREATE TABLE "bird__mondial_geo"."ethnicGroup" (
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Percentage" DOUBLE PRECISION,
    CONSTRAINT "ethnicGroup_pkey" PRIMARY KEY ("Country", "Name")
);

-- Table: geo_desert
CREATE TABLE "bird__mondial_geo"."geo_desert" (
    "Desert" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_desert_pkey" PRIMARY KEY ("Desert", "Country", "Province")
);

-- Table: geo_estuary
CREATE TABLE "bird__mondial_geo"."geo_estuary" (
    "River" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_estuary_pkey" PRIMARY KEY ("River", "Country", "Province")
);

-- Table: geo_island
CREATE TABLE "bird__mondial_geo"."geo_island" (
    "Island" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_island_pkey" PRIMARY KEY ("Island", "Country", "Province")
);

-- Table: geo_lake
CREATE TABLE "bird__mondial_geo"."geo_lake" (
    "Lake" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_lake_pkey" PRIMARY KEY ("Lake", "Country", "Province")
);

-- Table: geo_mountain
CREATE TABLE "bird__mondial_geo"."geo_mountain" (
    "Mountain" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_mountain_pkey" PRIMARY KEY ("Mountain", "Country", "Province")
);

-- Table: geo_river
CREATE TABLE "bird__mondial_geo"."geo_river" (
    "River" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_river_pkey" PRIMARY KEY ("River", "Country", "Province")
);

-- Table: geo_sea
CREATE TABLE "bird__mondial_geo"."geo_sea" (
    "Sea" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_sea_pkey" PRIMARY KEY ("Sea", "Country", "Province")
);

-- Table: geo_source
CREATE TABLE "bird__mondial_geo"."geo_source" (
    "River" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "geo_source_pkey" PRIMARY KEY ("River", "Country", "Province")
);

-- Table: isMember
CREATE TABLE "bird__mondial_geo"."isMember" (
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Organization" TEXT NOT NULL DEFAULT ''::text,
    "Type" TEXT DEFAULT 'member'::text,
    CONSTRAINT "isMember_pkey" PRIMARY KEY ("Country", "Organization")
);

-- Table: island
CREATE TABLE "bird__mondial_geo"."island" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Islands" TEXT,
    "Area" DOUBLE PRECISION,
    "Height" DOUBLE PRECISION,
    "Type" TEXT,
    "Longitude" DOUBLE PRECISION,
    "Latitude" DOUBLE PRECISION,
    CONSTRAINT "island_pkey" PRIMARY KEY ("Name")
);

-- Table: islandIn
CREATE TABLE "bird__mondial_geo"."islandIn" (
    "Island" TEXT,
    "Sea" TEXT,
    "Lake" TEXT,
    "River" TEXT
);

-- Table: lake
CREATE TABLE "bird__mondial_geo"."lake" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Area" DOUBLE PRECISION,
    "Depth" DOUBLE PRECISION,
    "Altitude" DOUBLE PRECISION,
    "Type" TEXT,
    "River" TEXT,
    "Longitude" DOUBLE PRECISION,
    "Latitude" DOUBLE PRECISION,
    CONSTRAINT "lake_pkey" PRIMARY KEY ("Name")
);

-- Table: language
CREATE TABLE "bird__mondial_geo"."language" (
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Percentage" DOUBLE PRECISION,
    CONSTRAINT "language_pkey" PRIMARY KEY ("Country", "Name")
);

-- Table: located
CREATE TABLE "bird__mondial_geo"."located" (
    "City" TEXT,
    "Province" TEXT,
    "Country" TEXT,
    "River" TEXT,
    "Lake" TEXT,
    "Sea" TEXT
);

-- Table: locatedOn
CREATE TABLE "bird__mondial_geo"."locatedOn" (
    "City" TEXT NOT NULL DEFAULT ''::text,
    "Province" TEXT NOT NULL DEFAULT ''::text,
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Island" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "locatedOn_pkey" PRIMARY KEY ("City", "Province", "Country", "Island")
);

-- Table: mergesWith
CREATE TABLE "bird__mondial_geo"."mergesWith" (
    "Sea1" TEXT NOT NULL DEFAULT ''::text,
    "Sea2" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "mergesWith_pkey" PRIMARY KEY ("Sea1", "Sea2")
);

-- Table: mountain
CREATE TABLE "bird__mondial_geo"."mountain" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Mountains" TEXT,
    "Height" DOUBLE PRECISION,
    "Type" TEXT,
    "Longitude" DOUBLE PRECISION,
    "Latitude" DOUBLE PRECISION,
    CONSTRAINT "mountain_pkey" PRIMARY KEY ("Name")
);

-- Table: mountainOnIsland
CREATE TABLE "bird__mondial_geo"."mountainOnIsland" (
    "Mountain" TEXT NOT NULL DEFAULT ''::text,
    "Island" TEXT NOT NULL DEFAULT ''::text,
    CONSTRAINT "mountainOnIsland_pkey" PRIMARY KEY ("Mountain", "Island")
);

-- Table: organization
CREATE TABLE "bird__mondial_geo"."organization" (
    "Abbreviation" TEXT NOT NULL,
    "Name" TEXT NOT NULL,
    "City" TEXT,
    "Country" TEXT,
    "Province" TEXT,
    "Established" DATE,
    CONSTRAINT "organization_pkey" PRIMARY KEY ("Abbreviation")
);

-- Table: politics
CREATE TABLE "bird__mondial_geo"."politics" (
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Independence" DATE,
    "Dependent" TEXT,
    "Government" TEXT,
    CONSTRAINT "politics_pkey" PRIMARY KEY ("Country")
);

-- Table: population
CREATE TABLE "bird__mondial_geo"."population" (
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Population_Growth" DOUBLE PRECISION,
    "Infant_Mortality" DOUBLE PRECISION,
    CONSTRAINT "population_pkey" PRIMARY KEY ("Country")
);

-- Table: province
CREATE TABLE "bird__mondial_geo"."province" (
    "Name" TEXT NOT NULL,
    "Country" TEXT NOT NULL,
    "Population" BIGINT,
    "Area" DOUBLE PRECISION,
    "Capital" TEXT,
    "CapProv" TEXT,
    CONSTRAINT "province_pkey" PRIMARY KEY ("Name", "Country")
);

-- Table: religion
CREATE TABLE "bird__mondial_geo"."religion" (
    "Country" TEXT NOT NULL DEFAULT ''::text,
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Percentage" DOUBLE PRECISION,
    CONSTRAINT "religion_pkey" PRIMARY KEY ("Country", "Name")
);

-- Table: river
CREATE TABLE "bird__mondial_geo"."river" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "River" TEXT,
    "Lake" TEXT,
    "Sea" TEXT,
    "Length" DOUBLE PRECISION,
    "SourceLongitude" DOUBLE PRECISION,
    "SourceLatitude" DOUBLE PRECISION,
    "Mountains" TEXT,
    "SourceAltitude" DOUBLE PRECISION,
    "EstuaryLongitude" DOUBLE PRECISION,
    "EstuaryLatitude" DOUBLE PRECISION,
    CONSTRAINT "river_pkey" PRIMARY KEY ("Name")
);

-- Table: sea
CREATE TABLE "bird__mondial_geo"."sea" (
    "Name" TEXT NOT NULL DEFAULT ''::text,
    "Depth" DOUBLE PRECISION,
    CONSTRAINT "sea_pkey" PRIMARY KEY ("Name")
);

-- Table: target
CREATE TABLE "bird__mondial_geo"."target" (
    "Country" TEXT NOT NULL,
    "Target" TEXT,
    CONSTRAINT "target_pkey" PRIMARY KEY ("Country")
);
