userid
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
company
varchar(200)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
vat
varchar(200)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
phonenumber
varchar(30)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
country
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
city
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
zip
varchar(15)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
state
varchar(50)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
address
text
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
website
varchar(150)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
datecreated
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
active
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
leadid
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
billing_street
varchar(200)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
billing_city
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
billing_state
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
billing_zip
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
billing_country
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
shipping_street
varchar(200)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
shipping_city
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
shipping_state
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
shipping_zip
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
shipping_country
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
longitude
varchar(191)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
latitude
varchar(191)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
default_language
varchar(40)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
default_currency
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
show_primary_contact
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
stripe_id
varchar(40)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
registration_confirmed
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
addedfrom
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
category
text
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
bank_detail
text
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
payment_terms
text
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
vendor_code
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
return_within_day
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
return_order_fee
decimal(15,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
return_policies
text
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
