| id |
int(10)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| created_by |
int(11)
|
|
|
|
| per_page |
int(11)
|
|
|
|
| site_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| qr_code |
int(11)
|
|
|
|
| qr_text |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| display_asset_name |
int(11)
|
|
|
|
| display_checkout_date |
int(11)
|
|
|
|
| display_eol |
int(11)
|
|
|
|
| auto_increment_assets |
int(11)
|
|
|
|
| auto_increment_prefix |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| load_remote |
tinyint(1)
|
|
|
|
| logo |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| header_color |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| nav_link_color |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| link_light_color |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| link_dark_color |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| alert_email |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| alerts_enabled |
tinyint(1)
|
|
|
|
| default_eula_text |
longtext
|
utf8mb4_unicode_ci
|
|
|
| webhook_endpoint |
text
|
utf8mb4_unicode_ci
|
|
|
| webhook_channel |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| webhook_botname |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| webhook_selected |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| default_currency |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| custom_css |
text
|
utf8mb4_unicode_ci
|
|
|
| brand |
tinyint(4)
|
|
|
|
| ldap_enabled |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_server |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_uname |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_pword |
longtext
|
utf8mb4_unicode_ci
|
|
|
| ldap_basedn |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_default_group |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_filter |
text
|
utf8mb4_unicode_ci
|
|
|
| ldap_username_field |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_lname_field |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_fname_field |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_display_name |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_auth_filter_query |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_version |
int(11)
|
|
|
|
| ldap_active_flag |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_dept |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_emp_num |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_email |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_phone_field |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_mobile |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_jobtitle |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_manager |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_address |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_city |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_state |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_zip |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_country |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_location |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| full_multiple_companies_support |
tinyint(1)
|
|
|
|
| scope_locations_fmcs |
tinyint(1)
|
|
|
|
| ldap_server_cert_ignore |
tinyint(1)
|
|
|
|
| locale |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| week_start |
tinyint(4)
|
|
|
|
| labels_per_page |
tinyint(4)
|
|
|
|
| labels_width |
decimal(6,5)
|
|
|
|
| labels_height |
decimal(6,5)
|
|
|
|
| labels_pmargin_left |
decimal(6,5)
|
|
|
|
| labels_pmargin_right |
decimal(6,5)
|
|
|
|
| labels_pmargin_top |
decimal(6,5)
|
|
|
|
| labels_pmargin_bottom |
decimal(6,5)
|
|
|
|
| labels_display_bgutter |
decimal(6,5)
|
|
|
|
| labels_display_sgutter |
decimal(6,5)
|
|
|
|
| labels_fontsize |
tinyint(4)
|
|
|
|
| labels_pagewidth |
decimal(7,5)
|
|
|
|
| labels_pageheight |
decimal(7,5)
|
|
|
|
| labels_display_name |
tinyint(4)
|
|
|
|
| labels_display_serial |
tinyint(4)
|
|
|
|
| labels_display_tag |
tinyint(4)
|
|
|
|
| alt_barcode_enabled |
tinyint(1)
|
|
|
|
| alert_interval |
int(11)
|
|
|
|
| alert_threshold |
int(11)
|
|
|
|
| name_display_format |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| email_domain |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| email_format |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| username_format |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| is_ad |
tinyint(1)
|
|
|
|
| ad_domain |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_port |
varchar(5)
|
utf8mb4_unicode_ci
|
|
|
| ldap_tls |
tinyint(1)
|
|
|
|
| zerofill_count |
int(11)
|
|
|
|
| ldap_pw_sync |
tinyint(1)
|
|
|
|
| two_factor_enabled |
tinyint(4)
|
|
|
|
| require_accept_signature |
tinyint(1)
|
|
|
|
| date_display_format |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| time_display_format |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| next_auto_tag_base |
bigint(20)
|
|
|
|
| login_note |
text
|
utf8mb4_unicode_ci
|
|
|
| thumbnail_max_h |
int(11)
|
|
|
|
| pwd_secure_uncommon |
tinyint(1)
|
|
|
|
| pwd_secure_complexity |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| pwd_secure_min |
int(11)
|
|
|
|
| audit_interval |
int(11)
|
|
|
|
| audit_warning_days |
int(11)
|
|
|
|
| show_url_in_emails |
tinyint(1)
|
|
|
|
| custom_forgot_pass_url |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| show_alerts_in_menu |
tinyint(1)
|
|
|
|
| labels_display_company_name |
tinyint(1)
|
|
|
|
| show_archived_in_list |
tinyint(1)
|
|
|
|
| dashboard_message |
text
|
utf8mb4_unicode_ci
|
|
|
| support_footer |
char(5)
|
utf8mb4_unicode_ci
|
|
|
| footer_text |
text
|
utf8mb4_unicode_ci
|
|
|
| modellist_displays |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| login_remote_user_enabled |
tinyint(1)
|
|
|
|
| login_common_disabled |
tinyint(1)
|
|
|
|
| login_remote_user_custom_logout_url |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| skin |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| show_images_in_email |
tinyint(1)
|
|
|
|
| admin_cc_email |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| admin_cc_always |
tinyint(1)
|
|
|
|
| labels_display_model |
tinyint(1)
|
|
|
|
| privacy_policy_link |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| version_footer |
char(5)
|
utf8mb4_unicode_ci
|
|
|
| unique_serial |
tinyint(1)
|
|
|
|
| logo_print_assets |
tinyint(1)
|
|
|
|
| depreciation_method |
char(10)
|
utf8mb4_unicode_ci
|
|
|
| favicon |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| default_avatar |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| email_logo |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| label_logo |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| acceptance_pdf_logo |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| allow_user_skin |
tinyint(1)
|
|
|
|
| show_assigned_assets |
tinyint(1)
|
|
|
|
| login_remote_user_header_name |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| ad_append_domain |
tinyint(1)
|
|
|
|
| saml_enabled |
tinyint(1)
|
|
|
|
| saml_idp_metadata |
mediumtext
|
utf8mb4_unicode_ci
|
|
|
| saml_attr_mapping_username |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| saml_forcelogin |
tinyint(1)
|
|
|
|
| saml_slo |
tinyint(1)
|
|
|
|
| saml_sp_x509cert |
text
|
utf8mb4_unicode_ci
|
|
|
| saml_sp_privatekey |
text
|
utf8mb4_unicode_ci
|
|
|
| saml_custom_settings |
text
|
utf8mb4_unicode_ci
|
|
|
| saml_sp_x509certNew |
text
|
utf8mb4_unicode_ci
|
|
|
| digit_separator |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| ldap_client_tls_cert |
text
|
utf8mb4_unicode_ci
|
|
|
| ldap_client_tls_key |
text
|
utf8mb4_unicode_ci
|
|
|
| dash_chart_type |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_enable |
tinyint(1)
|
|
|
|
| label2_template |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_title |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_asset_logo |
tinyint(1)
|
|
|
|
| label2_1d_type |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_2d_type |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_2d_prefix |
char(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_2d_target |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_fields |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| label2_empty_row_count |
int(10)
|
|
|
|
| google_login |
tinyint(1)
|
|
|
|
| google_client_id |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| google_client_secret |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| profile_edit |
tinyint(1)
|
|
|
|
| require_checkinout_notes |
tinyint(1)
|
|
|
|
| shortcuts_enabled |
tinyint(1)
|
|
|
|
| due_checkin_days |
int(11)
|
|
|
|
| ldap_invert_active_flag |
tinyint(1)
|
|
|
|
| manager_view_enabled |
tinyint(1)
|
|
|
|
