Ключи

DROP TABLE "Species" IF EXISTS;
DROP TABLE "Series" IF EXISTS;
DROP TABLE "Section" IF EXISTS;
DROP TABLE "Subgenus" IF EXISTS;
DROP TABLE "Genus" IF EXISTS;
DROP TABLE "Subfamily" IF EXISTS;
DROP TABLE "Family" IF EXISTS;
 
 
CREATE TABLE "Family" (
    "Name_Fml" VARCHAR(50) NOT NULL,
    CONSTRAINT "K1" PRIMARY KEY ("Name_Fml")
);
 
CREATE TABLE "Subfamily" (
    "Name_Sbf" VARCHAR(50) NOT NULL,
    "Name_Fml" VARCHAR(50) NOT NULL,
    CONSTRAINT "K2" PRIMARY KEY ("Name_Sbf"),
    CONSTRAINT "С1" FOREIGN KEY ("Name_Fml")
    REFERENCES "Family" ("Name_Fml")
);
 
CREATE TABLE "Genus" (
    "Name_Gn" VARCHAR(50) NOT NULL,
    "Name_Sbf" VARCHAR(50) NOT NULL,
    CONSTRAINT "K3" PRIMARY KEY ("Name_Gn"),
    CONSTRAINT "С2" FOREIGN KEY ("Name_Sbf")
    REFERENCES "Subfamily" ("Name_Sbf")
);
 
CREATE TABLE "Subgenus" (
    "Name_Sbn" VARCHAR(50) NOT NULL,
    "Name_Gn" VARCHAR(50) NOT NULL,
    CONSTRAINT "K4" PRIMARY KEY ("Name_Sbn"),
    CONSTRAINT "С3" FOREIGN KEY ("Name_Gn")
    REFERENCES "Genus" ("Name_Gn")
);
 
CREATE TABLE "Section" (
    "Name_Stn" VARCHAR(50) NOT NULL,
    "Name_Sbn" VARCHAR(50) NOT NULL,
    CONSTRAINT "K5" PRIMARY KEY ("Name_Stn"),
    CONSTRAINT "С4" FOREIGN KEY ("Name_Sbn")
    REFERENCES "Subgenus" ("Name_Sbn")
);
 
CREATE TABLE "Series" (
    "Name_Srs" VARCHAR(50) NOT NULL,
    "Name_Stn" VARCHAR(50) NOT NULL,
    CONSTRAINT "K6" PRIMARY KEY ("Name_Srs"),
    CONSTRAINT "С5" FOREIGN KEY ("Name_Stn")
    REFERENCES "Section" ("Name_Stn")
);
 
CREATE TABLE "Species" (
    "Name_Spc" VARCHAR(50) PRIMARY KEY,
    "Name_Srs" VARCHAR(50) NOT NULL,
    "Equator_d" INTEGER NOT NULL,
    "Polar_axis" INTEGER NOT NULL,
    "Laesura_long" INTEGER NOT NULL,
    "Laesura_wide" INTEGER NOT NULL,
    "Roller_like" INTEGER,
    "Tubercle_along_l" INTEGER,
    "Equatorial_ridge" INTEGER,
    "Equator_ridge_proximal" INTEGER,
    "Equator_ridge_distal" INTEGER,
    "Tubercle_proximal" INTEGER,
    "Tubercle_distal" INTEGER,
    "Folds_proximal" INTEGER,
    "Folds_distal" INTEGER,
    "Form_spore" VARCHAR(50) NOT NULL,
    "Form_distal_side" VARCHAR(50) NOT NULL,
    "Form_proximal_side" VARCHAR(50) NOT NULL,
    "Surface_exosporium" VARCHAR(50) NOT NULL,
    CONSTRAINT "K7" PRIMARY KEY ("Name_Spc"),
    CONSTRAINT "С6" FOREIGN KEY ("Name_Srs")
    REFERENCES "Series" ("Name_Srs")
);