my_data
Tables (13)
account_transactions
- trans_id — BIGSERIAL
- account_num — VARCHAR(20)
- trans_dtime — TIMESTAMP — NOT NULL
- trans_no — VARCHAR(64)
- trans_type — VARCHAR(2) — NOT NULL
- trans_class — VARCHAR(15)
- currency_code — VARCHAR(3)
- trans_amt — DECIMAL(18,3) — NOT NULL
- balance_amt — DECIMAL(18,3) — NOT NULL
- trans_memo — VARCHAR(90)
- created_at — TIMESTAMP
- INDEX — idx_account_trans
- INDEX — idx_trans_date
accounts
- account_num — VARCHAR(20)
- user_id — VARCHAR(50)
- org_code — VARCHAR(10) — NOT NULL
- seqno — VARCHAR(7)
- prod_name — VARCHAR(300) — NOT NULL
- account_type — VARCHAR(4) — NOT NULL
- account_status — VARCHAR(2) — NOT NULL
- is_foreign_deposit — BOOLEAN
- is_minus — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_user_accounts
- INDEX — idx_account_type
card_transactions
- trans_id — BIGSERIAL
- card_id — VARCHAR(64)
- approved_num — VARCHAR(21) — NOT NULL
- approved_dtime — TIMESTAMP — NOT NULL
- status — VARCHAR(2) — NOT NULL
- pay_type — VARCHAR(2) — NOT NULL
- merchant_name — VARCHAR(75)
- merchant_regno — VARCHAR(12)
- approved_amt — DECIMAL(15,0) — NOT NULL
- currency_code — VARCHAR(3)
- total_install_cnt — INTEGER
- created_at — TIMESTAMP
- INDEX — idx_card_trans
- INDEX — idx_trans_date
card_transactions_2024_01
card_transactions_2024_02
cards
- card_id — VARCHAR(64)
- user_id — VARCHAR(50)
- org_code — VARCHAR(10) — NOT NULL
- card_num — VARCHAR(19) — NOT NULL
- card_name — VARCHAR(300) — NOT NULL
- card_type — VARCHAR(2) — NOT NULL
- card_member — VARCHAR(1) — NOT NULL
- card_brand — VARCHAR(3) — NOT NULL
- issue_date — DATE — NOT NULL
- annual_fee — INTEGER
- created_at — TIMESTAMP
- INDEX — idx_user_cards
- INDEX — idx_card_org
deposit_accounts
- account_num — VARCHAR(20)
- currency_code — VARCHAR(3)
- balance_amt — DECIMAL(18,3) — NOT NULL
- withdrawable_amt — DECIMAL(18,3) — NOT NULL
- offered_rate — DECIMAL(7,5)
- saving_method — VARCHAR(2)
- issue_date — DATE — NOT NULL
- exp_date — DATE
- commit_amt — DECIMAL(18,3)
- monthly_paid_in_amt — DECIMAL(18,3)
- last_updated — TIMESTAMP
fund_accounts
- account_num — VARCHAR(20)
- standard_fund_code — VARCHAR(12) — NOT NULL
- balance_amt — DECIMAL(18,3) — NOT NULL
- eval_amt — DECIMAL(18,3) — NOT NULL
- inv_principal — DECIMAL(18,3) — NOT NULL
- fund_num — DECIMAL(18,3)
- paid_in_type — VARCHAR(2) — NOT NULL
- issue_date — DATE — NOT NULL
- exp_date — DATE
- last_updated — TIMESTAMP
irp_accounts
- account_num — VARCHAR(20)
- user_id — VARCHAR(50)
- org_code — VARCHAR(10) — NOT NULL
- prod_name — VARCHAR(300) — NOT NULL
- accum_amt — DECIMAL(18,3) — NOT NULL
- eval_amt — DECIMAL(18,3) — NOT NULL
- employer_amt — DECIMAL(18,3) — NOT NULL
- employee_amt — DECIMAL(18,3) — NOT NULL
- issue_date — DATE — NOT NULL
- first_deposit_date — DATE
- created_at — TIMESTAMP
- INDEX — idx_user_irp
loan_accounts
- account_num — VARCHAR(20)
- balance_amt — DECIMAL(18,3) — NOT NULL
- loan_principal — DECIMAL(18,3) — NOT NULL
- issue_date — DATE — NOT NULL
- exp_date — DATE — NOT NULL
- last_offered_rate — DECIMAL(7,5) — NOT NULL
- repay_date — VARCHAR(2)
- repay_method — VARCHAR(2) — NOT NULL
- repay_org_code — VARCHAR(8)
- repay_account_num — VARCHAR(20)
- next_repay_date — DATE
- last_updated — TIMESTAMP
user_auth
- auth_id — BIGSERIAL
- user_id — VARCHAR(50)
- access_token — VARCHAR(1500)
- refresh_token — VARCHAR(1500)
- token_expires_at — TIMESTAMP
- org_code — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_user_org
user_consents
- consent_id — BIGSERIAL
- user_id — VARCHAR(50)
- org_code — VARCHAR(10) — NOT NULL
- asset_type — VARCHAR(20) — NOT NULL
- asset_id — VARCHAR(64) — NOT NULL
- is_consent — BOOLEAN
- consent_date — TIMESTAMP
- end_date — DATE — NOT NULL
- INDEX — idx_user_consent
users
- user_id — VARCHAR(50)
- name — VARCHAR(100) — NOT NULL
- ci — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_ci