|
user_id
|
int(11)
|
|
|
|
|
user_type
|
int(1)
|
|
|
0
|
|
user_active
|
tinyint(1)
|
|
|
1
|
|
user_date_created
|
datetime
|
|
|
2026-06-22 07:14:09.000000
|
|
user_date_modified
|
datetime
|
|
|
2026-06-22 07:14:09.000000
|
|
user_language
|
varchar(255)
|
|
|
system
|
|
user_name
|
text
|
|
|
|
|
user_company
|
text
|
|
|
|
|
user_address_1
|
text
|
|
|
|
|
user_address_2
|
text
|
|
|
|
|
user_city
|
text
|
|
|
|
|
user_state
|
text
|
|
|
|
|
user_zip
|
text
|
|
|
|
|
user_country
|
text
|
|
|
|
|
user_invoicing_contact
|
varchar(50)
|
|
|
|
|
user_phone
|
text
|
|
|
|
|
user_fax
|
text
|
|
|
|
|
user_mobile
|
text
|
|
|
|
|
user_email
|
text
|
|
|
|
|
user_password
|
varchar(60)
|
|
|
|
|
user_web
|
text
|
|
|
|
|
user_vat_id
|
text
|
|
|
|
|
user_tax_code
|
text
|
|
|
|
|
user_psalt
|
text
|
|
|
|
|
user_all_clients
|
int(1)
|
|
|
0
|
|
user_passwordreset_token
|
varchar(100)
|
|
|
|
|
user_subscribernumber
|
varchar(40)
|
|
|
|
|
user_bank
|
varchar(100)
|
|
|
|
|
user_iban
|
varchar(34)
|
|
|
|
|
user_bic
|
varchar(11)
|
|
|
|
|
user_remittance_text
|
varchar(105)
|
|
|
|
|
user_gln
|
bigint(13)
|
|
|
|
|
user_rcc
|
varchar(7)
|
|
|
|