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