-- Schema: fineract_0001b-gk-datatables
CREATE SCHEMA IF NOT EXISTS "fineract_0001b-gk-datatables";

-- Table: risk_analysis
CREATE TABLE "fineract_0001b-gk-datatables"."risk_analysis" (
    "client_id" BIGINT NOT NULL,
    "proposed_loan_amount" NUMERIC(19,6) DEFAULT NULL::numeric,
    "assets_cash" NUMERIC(19,6) DEFAULT NULL::numeric,
    "assets_bank_accounts" NUMERIC(19,6) DEFAULT NULL::numeric,
    "assets_accounts_receivable" NUMERIC(19,6) DEFAULT NULL::numeric,
    "assets_inventory" NUMERIC(19,6) DEFAULT NULL::numeric,
    "assets_total_fixed_business" NUMERIC(19,6) DEFAULT NULL::numeric,
    "assets_total_business" NUMERIC(19,6) DEFAULT NULL::numeric,
    "assets_total_household" NUMERIC(19,6) DEFAULT NULL::numeric,
    "liabilities_accounts_payable" NUMERIC(19,6) DEFAULT NULL::numeric,
    "liabilities_business_debts" NUMERIC(19,6) DEFAULT NULL::numeric,
    "liabilities_total_business" NUMERIC(19,6) DEFAULT NULL::numeric,
    "liabilities_equity_working_capital" NUMERIC(19,6) DEFAULT NULL::numeric,
    "liabilities_total_household" NUMERIC(19,6) DEFAULT NULL::numeric,
    "liabilities_household_equity" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_cash_sales" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_cash_sales2" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_cost_goods_sold" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_cost_goods_sold2" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_gross_profit" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_other_income1" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_total_income2" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_household_expense" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_payments_to_savings" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_operational_expenses" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_disposable_income" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_amount_loan_installment" NUMERIC(19,6) DEFAULT NULL::numeric,
    "cashflow_available_surplus" NUMERIC(19,6) DEFAULT NULL::numeric,
    "fi_inventory_turnover" NUMERIC(19,6) DEFAULT NULL::numeric,
    "fi_gross_margin" NUMERIC(19,6) DEFAULT NULL::numeric,
    "fi_indebtedness" NUMERIC(19,6) DEFAULT NULL::numeric,
    "fi_loan_recommendation" NUMERIC(19,6) DEFAULT NULL::numeric,
    "fi_roe" NUMERIC(19,6) DEFAULT NULL::numeric,
    "fi_repayment_capacity" NUMERIC(19,6) DEFAULT NULL::numeric,
    CONSTRAINT "risk_analysis_pkey" PRIMARY KEY ("client_id")
);
