Postgres

The main postgres instance and its replica are located in us-east-2

FloatMeAPI_userloansmodel

Float

Columns

  • loan_id (uuid) - primary key

  • user_id_id (varchar) - references userID in user table

  • loan_type (varchar) - NORMAL or PINLESS

  • loan_amount (varchar)

  • created_date (timestamp with tz)

  • ach_credit_id (varchar) - usio credit reference id - New floats should match to a payment record in payment-service. All floats should match to a record in usio-credit-transactions dynamo table.

  • ach_credit_status (varchar) - unused

  • ach_credit_date (timestamp with tz) - unused

  • ach_debit_id (varchar) - usio debit reference id from latest float collection. Gets overriden when a new collection attempt is made. For a completed float, this will be the reference id for a successful completed payment. This will be empty for floats that have not had a collection attempt.

  • ach_debit_status (varchar) - current float status - SCHEDULING, COMPLETED, RETRY, ACHSENT, DEFAULTED

  • ach_debit_date (timestamp with tz) - float due date