id | int(6) |
|
|
|
reg_number | varchar(11) |
|
|
|
type | int(1) |
|
|
|
semester | int(1) |
|
|
|
session | int(2) |
|
|
0
|
year | int(4) |
|
|
|
sams_trans_no | varchar(100) |
|
|
|
trans_number | varchar(100) |
|
|
|
bank_ref_no | varchar(100) |
|
|
|
tuition_fee | int(10) |
|
|
|
other_fee | int(10) |
|
|
|
late_fee | int(10) |
|
|
|
date | varchar(100) |
|
|
|
amount | int(11) |
|
|
|
status | char(1) |
|
|
|
remarks | varchar(500) |
|
|
|
date_modified | timestamp |
|
|
CURRENT_TIMESTAMP
|
app_no | int(11) |
|
|
|
reg_id | varchar(11) |
|
|
|
date_old | varchar(100) |
|
|
|
date_created | timestamp |
|
|
CURRENT_TIMESTAMP
|