Pro, let you design a staging system, how to design the instalments of the several tables

Pro, let you design a staging system, how to design the order form of the installment repayment
Monthly repayment of the kind, such as 12 months, there is early repayment, overdue ah, etc.

Reply content:

Pro, let you design a staging system, how to design the order form of the installment repayment
Monthly repayment of the kind, such as 12 months, there is early repayment, overdue ah, etc.

• A user application staging form, with information such as user and instalment periods, a record indicating the total record of user's application for staging information

• A user instalment per-issue reimbursement form, one record indicating a reimbursement record

I think I need at least the following tables:

1. Order: Order number, order amount, period length, creation time, repayment date

2. Commodities: Items included in the order

3. Repayment record form: includes three types (normal repayment, early repayment, overdue repayment), repayment time, repayment amount, installment period, whether pay off

4. Rewards and punishments information: the reasons for rewards and punishments (if the early repayment is why, if overdue repayment), preferential type (custom some preferential types)

