-- Schema: fineract_extra-datatables-and-code-values
CREATE SCHEMA IF NOT EXISTS "fineract_extra-datatables-and-code-values";

-- Table: extra_client_details
CREATE TABLE "fineract_extra-datatables-and-code-values"."extra_client_details" (
    "client_id" BIGINT NOT NULL,
    "Business" TEXT,
    "Years" TEXT,
    "Gender_cd" INTEGER,
    "Education_cv" VARCHAR(60) DEFAULT NULL::character varying,
    "Next" TEXT,
    "Highest" TEXT,
    "Comment" TEXT,
    CONSTRAINT "extra_client_details_pkey" PRIMARY KEY ("client_id")
);

-- Table: extra_family_details
CREATE TABLE "fineract_extra-datatables-and-code-values"."extra_family_details" (
    "id" BIGINT NOT NULL DEFAULT nextval('"fineract_extra-datatables-and-code-values".extra_family_details_id_seq'::regclass),
    "client_id" BIGINT NOT NULL,
    "Name" VARCHAR(40) DEFAULT NULL::character varying,
    "Date" TEXT,
    "Points" TEXT,
    "Education_cd_Highest" INTEGER,
    "Other" TEXT,
    CONSTRAINT "extra_family_details_pkey" PRIMARY KEY ("id")
);

-- Table: extra_loan_details
CREATE TABLE "fineract_extra-datatables-and-code-values"."extra_loan_details" (
    "loan_id" BIGINT NOT NULL,
    "Business" TEXT,
    "Years" TEXT,
    "Gender_cd" INTEGER,
    "Education_cv" VARCHAR(60) DEFAULT NULL::character varying,
    "Next" TEXT,
    "Highest" TEXT,
    "Comment" TEXT,
    CONSTRAINT "extra_loan_details_pkey" PRIMARY KEY ("loan_id")
);
