servidor.tail8c660a.ts.net / 127.0.0.1 / snipeit

No existen tablas favoritas.

Cambiar la apariencia del panel de navegación.

Panel de navegación

Mostrar las bases de datos navegación como árbol En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo Mostrar el logo en el panel de navegación.
URL para enlace del logo URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace Abrir la página enlazada en la ventana principal (`principal`) o en una nueva (`nueva`).
Permitir destacar Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas Cantidad máxima de tablas favoritas; 0 para desactivar.
Anchura del panel de navegación Asignar 0 para ocular el panel de navegación.

Personalizar el árbol de navegación.

Árbol de navegación

Cantidad máxima de elementos en una rama El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol Si se muestran eventos bajo la base de datos en el árbol de navegación
Expandir la base de datos única Si se debe desglosar automáticamente una base de datos individual en el árbol de navegación.

Opciones para visualizar los servidores.

Servidores

Mostrar la selección de servidores Mostrar la elección de servidor en la parte superior del panel de navegación.
Mostrar los servidores en una lista Mostrar los servidores en una lista en lugar de una caja desplegable.

Opciones para visualizar las bases de datos.

Bases de datos

Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos Cadena que separa bases de datos en diferentes niveles de árbol.

Opciones para visualizar las tablas.

Tablas

Destino para el icono de acceso rápido
Objetivo para el segundo icono de acceso rápido
Separador de árbol de tablas Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas

Suelte aquí los archivos

Carga SQL ( 0 ) x -

Pulse en la barra para deslizarse al tope de la página

Presione Ctrl+Enter para ejecutar la consulta

Colapsar Expandir Mostrar rastro Ocultar rastro Tiempo necesario :

Ningún favorito

Etiqueta: Base de datos de destino: Compartir favorito

Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas en Enter e inserte una nueva línea con Shift+Enter. Para que esto sea permanente, consulte la configuración.
Cambiar al tema oscuro

Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :

Sin título *

v		snipeit accessories
id : int(10) unsigned
name : varchar(191)
category_id : int(11)
created_by : int(11)
qty : int(11)
requestable : tinyint(1)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
location_id : int(11)
purchase_date : date
purchase_cost : decimal(20,2)
order_number : varchar(191)
company_id : int(10) unsigned
min_amt : int(11)
manufacturer_id : int(11)
model_number : varchar(191)
image : varchar(191)
supplier_id : int(11)
notes : text

v		snipeit accessories_checkout
id : int(10) unsigned
created_by : int(11)
accessory_id : int(11)
assigned_to : int(11)
created_at : timestamp
updated_at : timestamp
note : varchar(191)
assigned_type : varchar(191)

v		snipeit action_logs
id : int(10) unsigned
created_by : int(11)
action_type : varchar(191)
target_id : int(11)
target_type : varchar(191)
location_id : int(11)
note : text
filename : text
item_type : varchar(191)
item_id : int(11)
expected_checkin : date
accepted_id : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
thread_id : int(11)
company_id : int(11)
accept_signature : varchar(100)
log_meta : text
action_date : datetime
stored_eula : text
action_source : varchar(191)
remote_ip : varchar(45)
user_agent : varchar(191)

v		snipeit assets
id : int(10) unsigned
name : varchar(191)
asset_tag : varchar(191)
model_id : int(11)
serial : varchar(191)
purchase_date : date
asset_eol_date : date
eol_explicit : tinyint(1)
purchase_cost : decimal(20,2)
order_number : varchar(191)
assigned_to : int(11)
notes : text
image : text
created_by : int(11)
created_at : timestamp
updated_at : timestamp
physical : tinyint(1)
deleted_at : timestamp
status_id : int(11)
archived : tinyint(1)
warranty_months : int(11)
depreciate : tinyint(1)
supplier_id : int(11)
requestable : tinyint(4)
rtd_location_id : int(11)
accepted : varchar(191)
last_checkout : datetime
last_checkin : datetime
expected_checkin : date
company_id : int(10) unsigned
assigned_type : varchar(191)
last_audit_date : datetime
next_audit_date : date
location_id : int(11)
checkin_counter : int(11)
checkout_counter : int(11)
requests_counter : int(11)
byod : tinyint(1)
_snipeit_memoria_ram_2 : text
_snipeit_procesador_3 : text
_snipeit_disco_duro_4 : text
_snipeit_sistema_operativo_5 : text
_snipeit_anydesk_6 : text
_snipeit_concesionarias_7 : text

v		snipeit asset_logs
id : int(10) unsigned
user_id : int(11)
action_type : varchar(191)
asset_id : int(11)
checkedout_to : int(11)
location_id : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
asset_type : varchar(100)
note : text
filename : text
requested_at : datetime
accepted_at : datetime
accessory_id : int(11)
accepted_id : int(11)
consumable_id : int(11)
expected_checkin : date
component_id : int(11)

v		snipeit asset_uploads
id : int(10) unsigned
user_id : int(11)
filename : varchar(191)
asset_id : int(11)
filenotes : varchar(191)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		snipeit categories
id : int(10) unsigned
name : varchar(191)
tag_color : varchar(191)
created_at : timestamp
updated_at : timestamp
created_by : int(11)
deleted_at : timestamp
eula_text : longtext
use_default_eula : tinyint(1)
require_acceptance : tinyint(1)
alert_on_response : tinyint(1)
category_type : varchar(191)
checkin_email : tinyint(1)
image : varchar(191)
notes : text

v		snipeit checkout_acceptances
id : int(10) unsigned
checkoutable_type : varchar(191)
checkoutable_id : bigint(20) unsigned
assigned_to_id : int(11)
qty : int(10) unsigned
signature_filename : varchar(191)
note : text
alert_on_response_id : bigint(20) unsigned
accepted_at : timestamp
declined_at : timestamp
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
stored_eula : text
stored_eula_file : varchar(191)

v		snipeit checkout_requests
id : int(10) unsigned
user_id : int(11)
requestable_id : int(11)
requestable_type : varchar(191)
quantity : int(11)
created_at : timestamp
updated_at : timestamp
canceled_at : datetime
fulfilled_at : datetime
deleted_at : datetime

v		snipeit companies
id : int(10) unsigned
name : varchar(191)
tag_color : varchar(191)
fax : varchar(20)
email : varchar(150)
phone : varchar(20)
created_at : timestamp
updated_at : timestamp
image : varchar(191)
created_by : bigint(20) unsigned
notes : text

v		snipeit components
id : int(10) unsigned
name : varchar(191)
category_id : int(11)
location_id : int(11)
company_id : int(11)
created_by : int(11)
supplier_id : int(11)
qty : int(11)
order_number : varchar(191)
purchase_date : date
purchase_cost : decimal(20,2)
model_number : varchar(191)
manufacturer_id : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
min_amt : int(11)
serial : varchar(191)
image : varchar(191)
notes : text

v		snipeit components_assets
id : int(10) unsigned
created_by : int(11)
assigned_qty : int(11)
component_id : int(11)
asset_id : int(11)
created_at : timestamp
updated_at : timestamp
note : text

v		snipeit consumables
id : int(10) unsigned
name : varchar(191)
category_id : int(11)
location_id : int(11)
created_by : int(11)
supplier_id : int(11)
qty : int(11)
requestable : tinyint(1)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
purchase_date : date
purchase_cost : decimal(20,2)
order_number : varchar(191)
company_id : int(10) unsigned
min_amt : int(11)
model_number : varchar(191)
manufacturer_id : int(11)
item_no : varchar(191)
image : varchar(191)
notes : text

v		snipeit consumables_users
id : int(10) unsigned
created_by : int(11)
consumable_id : int(11)
assigned_to : int(11)
created_at : timestamp
updated_at : timestamp
note : text

v		snipeit custom_fields
id : int(10) unsigned
name : varchar(191)
format : varchar(191)
element : varchar(191)
created_at : timestamp
updated_at : timestamp
created_by : int(11)
field_values : text
field_encrypted : tinyint(1)
db_column : varchar(191)
help_text : text
show_in_email : tinyint(1)
show_in_requestable_list : tinyint(1)
is_unique : tinyint(1)
display_in_user_view : tinyint(1)
auto_add_to_fieldsets : tinyint(1)
show_in_listview : tinyint(1)
display_checkin : tinyint(1)
display_checkout : tinyint(1)
display_audit : tinyint(1)

v		snipeit custom_fieldsets
id : int(10) unsigned
name : varchar(191)
created_at : timestamp
updated_at : timestamp
created_by : int(11)

v		snipeit custom_field_custom_fieldset
id : bigint(20) unsigned
custom_field_id : int(11)
custom_fieldset_id : int(11)
order : int(11)
required : tinyint(1)

v		snipeit departments
id : int(10) unsigned
name : varchar(191)
tag_color : varchar(191)
fax : varchar(20)
phone : varchar(20)
created_by : int(11)
company_id : int(11)
location_id : int(11)
manager_id : int(11)
notes : varchar(191)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
image : varchar(191)

v		snipeit depreciations
id : int(10) unsigned
name : varchar(191)
months : int(11)
depreciation_min : decimal(8,2)
depreciation_type : varchar(191)
created_at : timestamp
updated_at : timestamp
created_by : int(11)

v		snipeit imports
id : int(10) unsigned
name : varchar(191)
file_path : varchar(191)
filesize : int(11)
import_type : varchar(191)
created_at : timestamp
updated_at : timestamp
header_row : text
first_row : text
field_map : text
created_by : bigint(20) unsigned

v		snipeit kits
id : int(10) unsigned
name : varchar(191)
created_at : timestamp
updated_at : timestamp
created_by : bigint(20) unsigned

v		snipeit kits_accessories
id : int(10) unsigned
kit_id : int(11)
accessory_id : int(11)
quantity : int(11)
created_at : timestamp
updated_at : timestamp
created_by : bigint(20) unsigned

v		snipeit kits_consumables
id : int(10) unsigned
kit_id : int(11)
consumable_id : int(11)
quantity : int(11)
created_at : timestamp
updated_at : timestamp
created_by : bigint(20) unsigned

v		snipeit kits_licenses
id : int(10) unsigned
kit_id : int(11)
license_id : int(11)
quantity : int(11)
created_at : timestamp
updated_at : timestamp
created_by : bigint(20) unsigned

v		snipeit kits_models
id : int(10) unsigned
kit_id : int(11)
model_id : int(11)
quantity : int(11)
created_at : timestamp
updated_at : timestamp
created_by : bigint(20) unsigned

v		snipeit licenses
id : int(10) unsigned
name : varchar(191)
serial : text
purchase_date : date
purchase_cost : decimal(20,2)
order_number : varchar(50)
seats : int(11)
notes : text
created_by : int(11)
depreciation_id : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
license_name : varchar(120)
license_email : varchar(191)
depreciate : tinyint(1)
supplier_id : int(11)
expiration_date : date
purchase_order : varchar(191)
termination_date : date
maintained : tinyint(1)
reassignable : tinyint(1)
company_id : int(10) unsigned
manufacturer_id : int(11)
category_id : int(11)
min_amt : int(11)

v		snipeit license_seats
id : int(10) unsigned
license_id : int(11)
assigned_to : int(11)
unreassignable_seat : tinyint(1)
notes : text
created_by : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
asset_id : int(11)

v		snipeit locations
id : int(10) unsigned
name : varchar(191)
tag_color : varchar(191)
city : varchar(191)
state : varchar(191)
country : varchar(191)
created_at : timestamp
updated_at : timestamp
created_by : int(11)
address : varchar(191)
address2 : varchar(191)
zip : varchar(10)
fax : varchar(20)
phone : varchar(20)
deleted_at : timestamp
parent_id : int(11)
currency : varchar(10)
ldap_ou : varchar(191)
manager_id : int(11)
image : varchar(191)
company_id : int(10) unsigned
notes : text

v		snipeit login_attempts
id : int(10) unsigned
username : varchar(191)
remote_ip : varchar(45)
user_agent : varchar(191)
successful : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		snipeit maintenances
id : int(10) unsigned
asset_id : int(10) unsigned
supplier_id : int(11)
asset_maintenance_type : varchar(191)
name : varchar(100)
url : text
is_warranty : tinyint(1)
start_date : date
completion_date : date
asset_maintenance_time : int(11)
notes : longtext
image : text
cost : decimal(20,2)
deleted_at : datetime
created_at : timestamp
updated_at : timestamp
created_by : int(11)

v		snipeit manufacturers
id : int(10) unsigned
name : varchar(191)
tag_color : varchar(191)
created_at : timestamp
updated_at : timestamp
created_by : int(11)
deleted_at : timestamp
url : varchar(191)
support_url : varchar(191)
warranty_lookup_url : varchar(191)
support_phone : varchar(191)
support_email : varchar(191)
image : varchar(191)
notes : text

v		snipeit migrations
id : int(10) unsigned
migration : varchar(191)
batch : int(11)

v		snipeit models
id : int(10) unsigned
name : varchar(191)
model_number : varchar(191)
min_amt : int(11)
manufacturer_id : int(11)
category_id : int(11)
require_serial : tinyint(1)
created_at : timestamp
updated_at : timestamp
depreciation_id : int(11)
created_by : int(11)
eol : int(11)
image : varchar(191)
deprecated_mac_address : tinyint(1)
deleted_at : timestamp
fieldset_id : int(11)
notes : text
requestable : tinyint(4)

v		snipeit models_custom_fields
id : int(10) unsigned
asset_model_id : int(11)
custom_field_id : int(11)
default_value : text

v		snipeit oauth_access_tokens
id : varchar(100)
user_id : bigint(20) unsigned
client_id : bigint(20) unsigned
name : varchar(191)
scopes : text
revoked : tinyint(1)
created_at : timestamp
updated_at : timestamp
expires_at : datetime

v		snipeit oauth_auth_codes
id : varchar(100)
user_id : bigint(20) unsigned
client_id : bigint(20) unsigned
scopes : text
revoked : tinyint(1)
expires_at : datetime

v		snipeit oauth_clients
id : bigint(20) unsigned
user_id : bigint(20) unsigned
name : varchar(191)
secret : varchar(100)
provider : varchar(191)
redirect : text
personal_access_client : tinyint(1)
password_client : tinyint(1)
revoked : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		snipeit oauth_personal_access_clients
id : bigint(20) unsigned
client_id : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		snipeit oauth_refresh_tokens
id : varchar(100)
access_token_id : varchar(100)
revoked : tinyint(1)
expires_at : datetime

v		snipeit password_resets
email : varchar(191)
token : varchar(191)
created_at : timestamp
id : int(10) unsigned

v		snipeit permission_groups
id : int(10) unsigned
name : varchar(191)
permissions : text
created_at : timestamp
updated_at : timestamp
created_by : int(11)
notes : text

v		snipeit report_templates
id : bigint(20) unsigned
created_by : int(11)
name : varchar(191)
options : text
deleted_at : timestamp
created_at : timestamp
updated_at : timestamp

v		snipeit requested_assets
id : int(10) unsigned
asset_id : int(11)
user_id : int(11)
accepted_at : datetime
denied_at : datetime
notes : varchar(191)
created_at : timestamp
updated_at : timestamp

v		snipeit requests
id : int(10) unsigned
asset_id : int(11)
user_id : int(11)
request_code : text
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		snipeit saml_nonces
id : bigint(20) unsigned
nonce : varchar(191)
not_valid_after : datetime

v		snipeit settings
id : int(10) unsigned
created_at : timestamp
updated_at : timestamp
created_by : int(11)
per_page : int(11)
site_name : varchar(100)
qr_code : int(11)
qr_text : varchar(32)
display_asset_name : int(11)
display_checkout_date : int(11)
display_eol : int(11)
auto_increment_assets : int(11)
auto_increment_prefix : varchar(191)
load_remote : tinyint(1)
logo : varchar(191)
header_color : varchar(191)
nav_link_color : varchar(191)
link_light_color : varchar(191)
link_dark_color : varchar(191)
alert_email : varchar(191)
alerts_enabled : tinyint(1)
default_eula_text : longtext
webhook_endpoint : text
webhook_channel : varchar(191)
webhook_botname : varchar(191)
webhook_selected : varchar(191)
default_currency : varchar(10)
custom_css : text
brand : tinyint(4)
ldap_enabled : varchar(191)
ldap_server : varchar(191)
ldap_uname : varchar(191)
ldap_pword : longtext
ldap_basedn : varchar(191)
ldap_default_group : varchar(191)
ldap_filter : text
ldap_username_field : varchar(191)
ldap_lname_field : varchar(191)
ldap_fname_field : varchar(191)
ldap_display_name : varchar(191)
ldap_auth_filter_query : varchar(191)
ldap_version : int(11)
ldap_active_flag : varchar(191)
ldap_dept : varchar(191)
ldap_emp_num : varchar(191)
ldap_email : varchar(191)
ldap_phone_field : varchar(191)
ldap_mobile : varchar(191)
ldap_jobtitle : varchar(191)
ldap_manager : varchar(191)
ldap_address : varchar(191)
ldap_city : varchar(191)
ldap_state : varchar(191)
ldap_zip : varchar(191)
ldap_country : varchar(191)
ldap_location : varchar(191)
full_multiple_companies_support : tinyint(1)
scope_locations_fmcs : tinyint(1)
ldap_server_cert_ignore : tinyint(1)
locale : varchar(10)
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)
email_domain : varchar(191)
email_format : varchar(191)
username_format : varchar(191)
is_ad : tinyint(1)
ad_domain : varchar(191)
ldap_port : varchar(5)
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)
time_display_format : varchar(191)
next_auto_tag_base : bigint(20)
login_note : text
thumbnail_max_h : int(11)
pwd_secure_uncommon : tinyint(1)
pwd_secure_complexity : varchar(191)
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)
show_alerts_in_menu : tinyint(1)
labels_display_company_name : tinyint(1)
show_archived_in_list : tinyint(1)
dashboard_message : text
support_footer : char(5)
footer_text : text
modellist_displays : char(191)
login_remote_user_enabled : tinyint(1)
login_common_disabled : tinyint(1)
login_remote_user_custom_logout_url : varchar(191)
skin : char(191)
show_images_in_email : tinyint(1)
admin_cc_email : char(191)
admin_cc_always : tinyint(1)
labels_display_model : tinyint(1)
privacy_policy_link : char(191)
version_footer : char(5)
unique_serial : tinyint(1)
logo_print_assets : tinyint(1)
depreciation_method : char(10)
favicon : char(191)
default_avatar : varchar(191)
email_logo : char(191)
label_logo : char(191)
acceptance_pdf_logo : char(191)
allow_user_skin : tinyint(1)
show_assigned_assets : tinyint(1)
login_remote_user_header_name : varchar(191)
ad_append_domain : tinyint(1)
saml_enabled : tinyint(1)
saml_idp_metadata : mediumtext
saml_attr_mapping_username : varchar(191)
saml_forcelogin : tinyint(1)
saml_slo : tinyint(1)
saml_sp_x509cert : text
saml_sp_privatekey : text
saml_custom_settings : text
saml_sp_x509certNew : text
digit_separator : char(191)
ldap_client_tls_cert : text
ldap_client_tls_key : text
dash_chart_type : varchar(191)
label2_enable : tinyint(1)
label2_template : varchar(191)
label2_title : varchar(191)
label2_asset_logo : tinyint(1)
label2_1d_type : varchar(191)
label2_2d_type : varchar(191)
label2_2d_prefix : char(191)
label2_2d_target : varchar(191)
label2_fields : varchar(191)
label2_empty_row_count : int(10) unsigned
google_login : tinyint(1)
google_client_id : varchar(191)
google_client_secret : varchar(191)
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)

v		snipeit status_labels
id : int(10) unsigned
name : varchar(100)
created_by : int(11)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
deployable : tinyint(1)
pending : tinyint(1)
archived : tinyint(1)
notes : text
color : varchar(10)
show_in_nav : tinyint(1)
default_label : tinyint(1)

v		snipeit suppliers
id : int(10) unsigned
name : varchar(191)
tag_color : varchar(191)
address : varchar(250)
address2 : varchar(250)
city : varchar(191)
state : varchar(191)
country : varchar(2)
phone : varchar(35)
fax : varchar(35)
email : varchar(150)
contact : varchar(100)
notes : text
created_at : timestamp
updated_at : timestamp
created_by : int(11)
deleted_at : timestamp
zip : varchar(10)
url : varchar(250)
image : varchar(191)

v		snipeit telescope_entries
sequence : bigint(20) unsigned
uuid : char(36)
batch_id : char(36)
family_hash : varchar(191)
should_display_on_index : tinyint(1)
type : varchar(20)
content : longtext
created_at : datetime

v		snipeit telescope_entries_tags
entry_uuid : char(36)
tag : varchar(191)

v		snipeit telescope_monitoring
tag : varchar(191)

v		snipeit throttle
id : int(10) unsigned
user_id : int(10) unsigned
ip_address : varchar(191)
attempts : int(11)
suspended : tinyint(1)
banned : tinyint(1)
last_attempt_at : timestamp
suspended_at : timestamp
banned_at : timestamp

v		snipeit users
id : int(10) unsigned
email : varchar(191)
password : varchar(191)
permissions : text
activated : tinyint(1)
created_by : int(11)
activation_code : varchar(191)
activated_at : timestamp
last_login : timestamp
persist_code : varchar(191)
reset_password_code : varchar(191)
first_name : varchar(191)
last_name : varchar(191)
display_name : text
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
website : varchar(191)
country : varchar(191)
gravatar : varchar(191)
location_id : int(11)
phone : varchar(191)
mobile : text
jobtitle : varchar(191)
manager_id : int(11)
employee_num : text
avatar : varchar(191)
username : varchar(191)
notes : text
company_id : int(10) unsigned
remember_token : text
ldap_import : tinyint(1)
locale : varchar(10)
show_in_list : tinyint(1)
two_factor_secret : varchar(32)
two_factor_enrolled : tinyint(1)
two_factor_optin : tinyint(1)
department_id : int(11)
address : varchar(191)
city : varchar(191)
state : varchar(191)
zip : varchar(10)
skin : varchar(191)
nav_link_color : varchar(191)
link_light_color : varchar(191)
link_dark_color : varchar(191)
remote : tinyint(1)
start_date : date
end_date : date
scim_externalid : varchar(191)
autoassign_licenses : tinyint(1)
vip : tinyint(1)
enable_sounds : tinyint(1)
enable_confetti : tinyint(1)

v		snipeit users_groups
user_id : int(10) unsigned
group_id : int(10) unsigned
created_by : bigint(20) unsigned

Crear relación
FOREIGN KEY
on delete
on update