salarify

Tables (4)

PrepaymentApplication (Untitled4)

  • user (id) — Foreign key → User.id — NOT NULL
  • date — date
  • request_amount — int
  • fees — int
  • pay_date — date
  • status — choices
  • created
  • modified

PrepaymentMonthlyStatus (Untitled6)

  • user — Foreign key → User.id — NOT NULL
  • month — choices
  • credit_score — int
  • prepayment_limit — int
  • prepayment_amount — int
  • prepayment_available_amount — int
  • total_fees — int
  • prepayment_count — int
  • repayment_amount — int
  • created — date
  • modified — date

User (Untitled)

  • id — Primary key — NOT NULL
  • name — char
  • phonenumber — char
  • birthday — date
  • status — boolean
  • created — date
  • modified — date

UserSalaryInfo (Untitled2)

  • user — Foreign key → User.id — NOT NULL
  • salarytype — choices
  • salaryday — int
  • salary — int
  • bank — char
  • account_number — char
  • credit_score — int
  • email — char
  • created — date
  • modified — date