| id |
int(11)
|
|
|
|
| content |
longtext
|
utf8mb4_unicode_ci
|
|
|
| description |
mediumtext
|
utf8mb4_unicode_ci
|
|
|
| subject |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| client |
int(11)
|
|
|
|
| datestart |
date
|
|
|
|
| dateend |
date
|
|
|
|
| contract_type |
int(11)
|
|
|
|
| project_id |
int(11)
|
|
|
|
| addedfrom |
int(11)
|
|
|
|
| dateadded |
datetime
|
|
|
|
| isexpirynotified |
int(11)
|
|
|
|
| contract_value |
decimal(15,2)
|
|
|
|
| trash |
tinyint(1)
|
|
|
|
| not_visible_to_client |
tinyint(1)
|
|
|
|
| hash |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| signed |
tinyint(1)
|
|
|
|
| signature |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| marked_as_signed |
tinyint(1)
|
|
|
|
| acceptance_firstname |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| acceptance_lastname |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| acceptance_email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| acceptance_date |
datetime
|
|
|
|
| acceptance_ip |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| short_link |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| last_sent_at |
datetime
|
|
|
|
| contacts_sent_to |
mediumtext
|
utf8mb4_unicode_ci
|
|
|
| last_sign_reminder_at |
datetime
|
|
|
|
