|
id
|
int(11)
|
|
|
|
|
transaction_type
|
enum
|
-- |
|
|
|
category_id
|
int(11)
|
|
|
|
|
amount
|
decimal(12,2)
|
|
|
|
|
transaction_date
|
date
|
|
|
|
|
description
|
varchar(255)
|
|
|
|
|
reference_number
|
varchar(50)
|
|
|
|
|
payment_method
|
enum
|
-- |
|
cash
|
|
related_person_type
|
varchar(50)
|
|
|
|
|
related_person_id
|
int(11)
|
|
|
|
|
related_student_id
|
int(11)
|
|
|
|
|
related_salary_id
|
int(11)
|
|
|
|
|
related_lesson_payment_id
|
int(11)
|
|
|
|
|
created_by
|
varchar(100)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|