Untitled

CREATE TABLE ledger_account_schemes
(
    id int,
    custodian_client_id int,
    code text,
    name text,
    allow_negative_balance int,
    balance_datasource text,
    allow_lien int,
    allow_overdraft int,
    classification text,
    account_number_prefix text,
    account_number_length int,
    account_nuban_prefix text,
    enable_instant_running_balance_update int,
    maximum_cumulative_balance int,
    maximum_single_debit int,
    maximum_single_credit int,
    maximum_daily_debit int,
    maximum_daily_credit int,
    maximum_account_overdraft int,
    maximum_drawn_limit int,
    accumulated_drawn_limit int,
    credit_limit_violation_action text,
    transaction_alert_enabled int,
    pnd_alert_enabled int,
    alert_configuration text,
    status int,
    created_on DateTime,
    last_modified_on DateTime,
    enforce_unique_account_name int
);
               
CREATE TABLE kyc_levels
(
    `id` int,
    `ordinal` int,
    `name` text,
    `requires_signature` int,
    `requires_persona_validation` int,
    `requires_residential_address` int,
    `requires_verified_residential_address` int,
    `requires_next_of_kin` int,
    `requires_identification` int,
    `requires_verified_identification` int,
    `requires_cac_certificate` int,
    `requires_verified_cac_certificate` int,
    `requires_indemnity` int,
    `status` int,
    `created_on` DateTime,
    `last_modified_on` DateTime,
    `requires_religion` int,
    `requires_nationality` int,
    `requires_state_of_origin` int,
    `requires_local_government_of_origin` int,
    `requires_marital_status` int,
    `requires_employment` int,
    `requires_verified_employment` int
);


CREATE TABLE ledger_accounts
(
    `id` int,
    `created_on` DateTime,
    `last_modified_on` DateTime,
    `status` int,
    `account_code` text,
    `account_name` text,
    `account_number` text,
    `allow_credit` int,
    `allow_debit` int,
    `allow_own_entry` int,
    `is_header_account` int,
    `currency` text,
    `hierarchy_number` int,
    `running_balance` int,
    `running_balance_updated_on` DateTime,
    `overdraft_limit` int,
    `ledger_account_scheme_id` int,
    `parent_ledger_account_id` int,
    `hierarchy_path` text,
    `regulatory_block` int,
    `is_drawn` int
);
               
CREATE TABLE customers
(
    id int,
    kyc_level_id int
);