|
id
|
int(11) unsigned
|
|
|
|
|
contract_number
|
varchar(200)
|
|
|
|
|
contract_name
|
varchar(200)
|
|
|
|
|
content
|
longtext
|
|
|
|
|
vendor
|
int(11)
|
|
|
|
|
pur_order
|
int(11)
|
|
|
|
|
contract_value
|
decimal(15,2)
|
|
|
|
|
start_date
|
date
|
|
|
|
|
end_date
|
date
|
|
|
|
|
buyer
|
int(11)
|
|
|
|
|
time_payment
|
date
|
|
|
|
|
add_from
|
int(11)
|
|
|
|
|
signed
|
int(32)
|
|
|
0
|
|
note
|
longtext
|
|
|
|
|
signer
|
int(11)
|
|
|
|
|
signed_date
|
date
|
|
|
|
|
signed_status
|
varchar(50)
|
|
|
|
|
service_category
|
text
|
|
|
|
|
project
|
int(11)
|
|
|
|
|
payment_terms
|
text
|
|
|
|
|
payment_amount
|
decimal(15,2)
|
|
|
|
|
payment_cycle
|
varchar(50)
|
|
|
|
|
department
|
int(11)
|
|
|
|