|
id
|
int(11)
|
|
|
|
|
content
|
longtext
|
|
|
|
|
description
|
text
|
|
|
|
|
subject
|
varchar(191)
|
|
|
|
|
client
|
int(11)
|
|
|
|
|
datestart
|
date
|
|
|
|
|
dateend
|
date
|
|
|
|
|
contract_type
|
int(11)
|
|
|
|
|
addedfrom
|
int(11)
|
|
|
|
|
dateadded
|
datetime
|
|
|
2026-05-27 16:01:18.000000
|
|
isexpirynotified
|
int(11)
|
|
|
0
|
|
contract_value
|
decimal(15,2)
|
|
|
|
|
trash
|
tinyint(1)
|
|
|
0
|
|
not_visible_to_client
|
tinyint(1)
|
|
|
0
|
|
hash
|
varchar(32)
|
|
|
|
|
signed
|
tinyint(1)
|
|
|
0
|
|
signature
|
varchar(40)
|
|
|
|
|
acceptance_firstname
|
varchar(50)
|
|
|
|
|
acceptance_lastname
|
varchar(50)
|
|
|
|
|
acceptance_email
|
varchar(100)
|
|
|
|
|
acceptance_date
|
datetime
|
|
|
|
|
acceptance_ip
|
varchar(40)
|
|
|
|