PayTalk

Tables (11)

bank_code

  • name — TEXT
  • code — TEXT

intra_bank_transfer_record

  • uuid — TEXT
  • sender_id — INTEGER
  • recipient_id — INTEGER
  • amount — INTEGER
  • status_code — TEXT
  • created_at — TIMESTAMP

member

  • id — SERIAL
  • password — TEXT
  • name — TEXT
  • phone_number — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

other_bank_account

  • uuid — TEXT
  • account_number — TEXT
  • bk_code — TEXT
  • account_name — TEXT
  • account_balance — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

other_bank_transfer_record

  • uuid — TEXT
  • sender_id — INTEGER
  • res_account_number — TEXT
  • res_bk_code — TEXT
  • amount — INTEGER
  • status_code — TEXT
  • created_at — TIMESTAMP

pay_member

  • Key — Primary key — NOT NULL
  • uuid — TEXT
  • id — INTEGER
  • password — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

request_record

  • uuid — TEXT
  • sender_id — INTEGER
  • recipient_id — INTEGER
  • account_yn — BOOLEAN
  • account_number — TEXT
  • bk_code — TEXT
  • amount — INTEGER
  • status_code — TEXT
  • created_at — TIMESTAMP

settlement_detail

  • detail_uuid — SERIAL
  • uuid — INTEGER
  • id — INTEGER
  • round — INTEGER
  • status_code — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

settlement_record

  • uuid — TEXT
  • sender_id — INTEGER
  • recipient_id — INTEGER
  • total_amount — INTEGER
  • total_status — TEXT
  • round_amount — INTEGER
  • kind_cd — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

status_code

  • name — TEXT
  • code — TEXT

wallet

  • uuid — TEXT
  • money — INTEGER