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

  • 2024-01-01) — TO

card_transactions_2024_02

  • 2024-02-01) — TO

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