id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
entities_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_recursive
tinyint(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
name
varchar(255)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
version
varchar(255)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
port
varchar(10)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
path
varchar(255)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
size
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
databaseinstancetypes_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
databaseinstancecategories_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
locations_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
manufacturers_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
users_id_tech
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
groups_id_tech
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
states_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
itemtype
varchar(100)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
items_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_onbackup
tinyint(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_active
tinyint(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_deleted
tinyint(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_helpdesk_visible
tinyint(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_dynamic
tinyint(4)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
autoupdatesystems_id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
date_creation
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
date_mod
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
date_lastboot
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
date_lastbackup
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
comment
text
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
