test

Tables (8)

bank_accounts

  • id — SERIAL
  • user_id — UUID — NOT NULL
  • bank_code — VARCHAR(20) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • account_alias — VARCHAR(50)
  • balance — NUMERIC(18,2)
  • created_at — TIMESTAMP

bank_transactions

  • id — SERIAL
  • account_id — INT — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • amount — NUMERIC(18,2) — NOT NULL
  • transaction_time — TIMESTAMP
  • description — TEXT

insurance_payments

  • id — SERIAL
  • insurance_user_id — INT — NOT NULL
  • paid_amount — NUMERIC(18,2) — NOT NULL
  • paid_at — DATE — NOT NULL
  • payment_method — VARCHAR(20)

insurance_users

  • id — SERIAL
  • user_id — UUID — NOT NULL
  • insurance_company_code — VARCHAR(20) — NOT NULL
  • policy_number — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

oauth_clients

  • client_id — VARCHAR(128)
  • client_secret — VARCHAR(256) — NOT NULL
  • redirect_uri — TEXT — NOT NULL
  • grant_types — TEXT
  • scope — TEXT
  • created_at — TIMESTAMP

oauth_tokens

  • token_id — SERIAL
  • access_token — TEXT — NOT NULL
  • refresh_token — TEXT
  • user_id — UUID — NOT NULL
  • client_id — VARCHAR(128)
  • expires_in — INTEGER
  • scope — TEXT
  • created_at — TIMESTAMP

user_connected_services

  • id — SERIAL
  • user_id — UUID — NOT NULL
  • institution_code — VARCHAR(20) — NOT NULL
  • service_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

users

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(150) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP