---

CREATE TABLE ourpension.pension_scheme (
    id int4 NOT NULL,
    account_type_on_on_accum varchar(3) NULL,
    account_type_on_on_pay varchar(3) NULL,
    allowed_in_agreement varchar(5) NULL,
    close_date date NULL,
    created timestamp NOT NULL,
    duration_max int4 NULL,
    duration_min int4 NULL,
    inheritance_on_accum varchar(5) NULL,
    inheritance_on_pay varchar(5) NULL,
    lifetime_pension varchar(5) NULL,
    max_first_pension_value numeric(24, 2) NULL,
    min_deposite_value numeric(24, 2) NULL,
    min_income_rate numeric(24, 2) NULL,
    min_pension_value numeric(24, 2) NULL,
    "name" varchar(500) NOT NULL,
    "number" varchar(100) NULL,
    pension_params_changed_allowed varchar(5) NULL,
    pension_rules_date date NULL,
    pension_rules_number varchar(100) NULL,
    quarterly_payment varchar(5) NULL,
    registration_date date NULL,
    scheme_changed_allowed varchar(5) NULL,
    contract_type varchar(10) NULL,
    termination_on_pay varchar(5) NULL,
    "version" timestamp NULL,
    parent_scheme_id int4 NULL,
    account_type_on_accum text NULL,
    account_type_on_pay text NULL,
    scheme_change_allowed varchar(5) NULL,
    pension_params_change_allowed varchar(5) NULL,
    min_deposit_value numeric(24, 2) NULL,
    "service_type" varchar(10) NULL,
    first_payment_not_same varchar(5) NULL,
    max_first_pension_percent int4 NULL,
    exhaustionpension varchar(5) DEFAULT 'false'::character varying NULL,
    exhaustion_pension varchar(5) DEFAULT 'false'::character varying NULL,
    semiannually_payment varchar(5) DEFAULT 'false'::character varying NULL,
    yearly_payment varchar(5) DEFAULT 'false'::character varying NULL,
    agreement_with_application varchar(5) NULL,
    urgent_pension varchar(5) DEFAULT 'true'::character varying NULL,
    multisharer_application varchar(5) NULL,
    scheme_type varchar(10) DEFAULT 'PERSONAL'::character varying NULL,
    min_income_rate_on_pay numeric(24, 2) NULL,
    scheme_id_1c varchar(64) NULL,
    code int4 NULL,
    depositor_type_enum_set_value text NULL,
    depositor_type_enum_set_id int4 NULL,
    accumulation_period_pension_account_type_enum_set_id int4 NULL,
    payoff_period_pension_account_type_enumset_id int4 NULL,
    pension_premium_frequency_enum_set_value text NULL,
    pension_premium_frequency_enum_set_id int4 NULL,
    is_accumulation_period_termination_by_depositor varchar(5) NULL,
    is_accumulation_period_termination_by_participant varchar(5) NULL,
    is_payoff_period_termination_by_depositor varchar(5) NULL,
    is_payoff_period_termination_by_participant varchar(5) NULL,
    payment_period_enum_set_value text NULL,
    payment_period_enum_set_id int4 NULL,
    oud numeric(10, 2) NULL,
    depositor_can_change_payment_scheme varchar(5) NULL,
    participant_can_change_payment_scheme varchar(5) NULL,
    is_life_annuity varchar(5) NULL,
    is_taxable varchar(5) NULL,
    coefficient_a numeric(1) NULL,
    coefficient_v numeric(1) NULL,
    coefficient_m numeric(1) NULL,
    is_new_scheme varchar(5) NULL,
    is_before_exhaustion varchar(5) NULL,
    pension_payment_commission text NULL,
    redemption_payment_commission text NULL,
    is_payment_agreement varchar(5) NULL,
    name_pension_rights text NULL,
    short_description_scheme text NULL,
    investment_portfolio_name text NULL,
    full_pension_rights text NULL,
    payment_period_enums_as_json json NULL,
    payment_periodicity_enums_as_json json NULL,
    payment_schemes_as_json json NULL,
    payment_period_enums_as_array _text NULL,
    payment_periodicity_enums_as_array _text NULL,
    payment_schemes_as_array _text NULL,
    contract_acceptance bool DEFAULT false NOT NULL,
    index_scheme varchar NULL,
    prod_line_pens_scheme_id int4 NULL,
    CONSTRAINT pension_scheme_pkey PRIMARY KEY (id),
    CONSTRAINT pension_scheme_scheme_type_check CHECK (((scheme_type)::text = ANY (ARRAY[('PERSONAL'::character varying)::text, ('JOINT'::character varying)::text]))),
    CONSTRAINT fk83b1506j4lpqda5egida01adf FOREIGN KEY (parent_scheme_id) REFERENCES ourpension.pension_scheme(id),
    CONSTRAINT pension_scheme_prod_line_pens_scheme_id_fkey FOREIGN KEY (prod_line_pens_scheme_id) REFERENCES prod_line.pens_scheme(id)
);
CREATE INDEX pension_scheme_lifetime_pension_idx ON ourpension.pension_scheme USING btree (lifetime_pension);
CREATE INDEX pension_scheme_number_index ON ourpension.pension_scheme USING btree (number);