|
id
|
int(10) unsigned
|
|
|
|
|
entities_id
|
int(10) unsigned
|
|
|
0
|
|
is_recursive
|
tinyint(4)
|
|
|
0
|
|
name
|
varchar(255)
|
|
|
|
|
serial
|
varchar(255)
|
|
|
|
|
otherserial
|
varchar(255)
|
|
|
|
|
contact
|
varchar(255)
|
|
|
|
|
contact_num
|
varchar(255)
|
|
|
|
|
date_mod
|
timestamp
|
|
|
|
|
comment
|
text
|
|
|
|
|
locations_id
|
int(10) unsigned
|
|
|
0
|
|
networks_id
|
int(10) unsigned
|
|
|
0
|
|
manufacturers_id
|
int(10) unsigned
|
|
|
0
|
|
is_deleted
|
tinyint(4)
|
|
|
0
|
|
users_id
|
int(10) unsigned
|
|
|
0
|
|
groups_id
|
int(10) unsigned
|
|
|
0
|
|
states_id
|
int(10) unsigned
|
|
|
0
|
|
users_id_tech
|
int(10) unsigned
|
|
|
0
|
|
groups_id_tech
|
int(10) unsigned
|
|
|
0
|
|
is_dynamic
|
tinyint(4)
|
|
|
0
|
|
date_creation
|
timestamp
|
|
|
|
|
autoupdatesystems_id
|
int(10) unsigned
|
|
|
0
|
|
sysdescr
|
text
|
|
|
|
|
agents_id
|
int(10) unsigned
|
|
|
0
|
|
itemtype
|
varchar(100)
|
|
|
|
|
accepted
|
tinyint(4)
|
|
|
0
|
|
hub
|
tinyint(4)
|
|
|
0
|
|
ip
|
varchar(255)
|
|
|
|
|
snmpcredentials_id
|
int(10) unsigned
|
|
|
0
|
|
last_inventory_update
|
timestamp
|
|
|
|