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