账单数据模型
2020-03-10 11:19:02 1 举报
基于账单模型设计的数据库表
作者其他创作
大纲/内容
bill
+ bill_no+ client_no+ bill_date+ repay_date
create()
refund_order
+ refund_no+ month_bill_no+ amount+ status+ payment_no + pay_no+ used_amount
+ refundCofirm()+ changeBalance()
bill_balance_detail
+ bill_no+ balance_no+ amount+ direction+ voucher_no+ voucher_type+ limit_before+ limit_after
+ changeBalance()
has many
repay_order
+ repay_no+ month_bill_no+ amount+ status+ payment_no + voucher_no+ voucher_type
+ repayCofirm()+ changeBalance()
账单系统数据库模型
has one
pay_order
+ pay_no+ month_bill_no+ amount+ status+ payment_no+ pay_time
+ payCofirm()
month_bill
+ bill_no+ bill_status+ month_bill_no+ total_amount+ repay_date+ back_status+ bill_month_date
+ create()+ chargeOff()+ billOverdue()+ billClear()
bill_balance
+ bill_no+ balance_no+ balance_amount
0 条评论
下一页