|
id
|
int(11)
|
|
|
|
|
application_id
|
int(11)
|
|
|
浏览不相关的值
|
|
amount
|
decimal(10,2)
|
|
|
|
|
payment_date
|
date
|
|
|
|
|
month_year
|
varchar(7)
|
|
|
|
|
payment_type
|
varchar(50)
|
|
|
|
|
payment_method
|
enum
|
-- |
|
cash
|
|
status
|
enum
|
-- |
|
confirmed
|
|
receipt_number
|
varchar(50)
|
|
|
|
|
notes
|
text
|
|
|
|
|
journal_entry_id
|
int(11)
|
|
|
|
|
receivable_id
|
int(11)
|
|
|
|
|
created_by
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|