| id |
int(10)
|
|
|
|
| entities_id |
int(10)
|
|
|
|
| is_recursive |
tinyint(4)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| num |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| contracttypes_id |
int(10)
|
|
|
|
| locations_id |
int(10)
|
|
|
|
| begin_date |
date
|
|
|
|
| duration |
int(11)
|
|
|
|
| notice |
int(11)
|
|
|
|
| periodicity |
int(11)
|
|
|
|
| billing |
int(11)
|
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
| accounting_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| is_deleted |
tinyint(4)
|
|
|
|
| week_begin_hour |
time
|
|
|
|
| week_end_hour |
time
|
|
|
|
| saturday_begin_hour |
time
|
|
|
|
| saturday_end_hour |
time
|
|
|
|
| use_saturday |
tinyint(4)
|
|
|
|
| sunday_begin_hour |
time
|
|
|
|
| sunday_end_hour |
time
|
|
|
|
| use_sunday |
tinyint(4)
|
|
|
|
| max_links_allowed |
int(11)
|
|
|
|
| alert |
int(11)
|
|
|
|
| renewal |
int(11)
|
|
|
|
| template_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| is_template |
tinyint(4)
|
|
|
|
| states_id |
int(10)
|
|
|
|
| date_mod |
timestamp
|
|
|
|
| date_creation |
timestamp
|
|
|
|
