|
id
|
int(10) unsigned
|
|
|
|
|
entities_id
|
int(10) unsigned
|
|
|
0
|
|
name
|
varchar(255)
|
|
|
|
|
date_mod
|
timestamp
|
|
|
|
|
contact
|
varchar(255)
|
|
|
|
|
contact_num
|
varchar(255)
|
|
|
|
|
users_id_tech
|
int(10) unsigned
|
|
|
0
|
|
groups_id_tech
|
int(10) unsigned
|
|
|
0
|
|
comment
|
text
|
|
|
|
|
serial
|
varchar(255)
|
|
|
|
|
otherserial
|
varchar(255)
|
|
|
|
|
size
|
decimal(5,2)
|
|
|
0.00
|
|
have_micro
|
tinyint(4)
|
|
|
0
|
|
have_speaker
|
tinyint(4)
|
|
|
0
|
|
have_subd
|
tinyint(4)
|
|
|
0
|
|
have_bnc
|
tinyint(4)
|
|
|
0
|
|
have_dvi
|
tinyint(4)
|
|
|
0
|
|
have_pivot
|
tinyint(4)
|
|
|
0
|
|
have_hdmi
|
tinyint(4)
|
|
|
0
|
|
have_displayport
|
tinyint(4)
|
|
|
0
|
|
locations_id
|
int(10) unsigned
|
|
|
0
|
|
monitortypes_id
|
int(10) unsigned
|
|
|
0
|
|
monitormodels_id
|
int(10) unsigned
|
|
|
0
|
|
manufacturers_id
|
int(10) unsigned
|
|
|
0
|
|
is_global
|
tinyint(4)
|
|
|
0
|
|
is_deleted
|
tinyint(4)
|
|
|
0
|
|
is_template
|
tinyint(4)
|
|
|
0
|
|
template_name
|
varchar(255)
|
|
|
|
|
users_id
|
int(10) unsigned
|
|
|
0
|
|
groups_id
|
int(10) unsigned
|
|
|
0
|
|
states_id
|
int(10) unsigned
|
|
|
0
|
|
ticket_tco
|
decimal(20,4)
|
|
|
0.0000
|
|
is_dynamic
|
tinyint(4)
|
|
|
0
|
|
autoupdatesystems_id
|
int(10) unsigned
|
|
|
0
|
|
uuid
|
varchar(255)
|
|
|
|
|
date_creation
|
timestamp
|
|
|
|
|
is_recursive
|
tinyint(4)
|
|
|
0
|