root@srvdeepdb:/opt/NinjaRMMAgent/programfiles# show databases

Command 'show' not found, but can be installed with:

apt install mailutils-mh # version 1:3.14-1, or
apt install mmh # version 0.4-4
apt install nmh # version 1.7.1-11
root@srvdeepdb:/opt/NinjaRMMAgent/programfiles# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5448796
Server version: 10.6.21-MariaDB-0ubuntu0.22.04.2-log Ubuntu 22.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;

+--------------------+
| Database |
+--------------------+
| c0_deepser |
| dbispconfig |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| sys |
+--------------------+
7 rows in set (0.000 sec)

MariaDB [(none)]> use c0_deepser;

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [c0_deepser]> show tables;
+--------------------------------------------------------------+
| Tables_in_c0_deepser |
+--------------------------------------------------------------+
| admin_assert |
| admin_change_username_queue |
| admin_role |
| admin_rule |
| admin_user |
| admin_user_association |
| admin_user_company |
| admin_user_model_access |
| cms_block |
| cms_block_store |
| cms_page |
| cms_page_store |
| core_cache |
| core_cache_option |
| core_cache_tag |
| core_config_data |
| core_email_queue |
| core_email_queue_recipients |
| core_email_template |
| core_flag |
| core_layout_link |
| core_layout_update |
| core_resource |
| core_session |
| core_store |
| core_store_group |
| core_translate |
| core_url_rewrite |
| core_variable |
| core_variable_value |
| core_website |
| cron_schedule |
| custom_consuntivazione_consuntivazione |
| custom_consuntivazione_consuntivazione_change |
| custom_consuntivazione_consuntivazione_change_history_change |
| custom_consuntivazione_consuntivazione_history_change |
| custom_crmutil_accountutil |
| custom_crmutil_accountutil_history |
| custom_crmutil_accountutil_history_change |
| custom_csat_casehistory |
| custom_csat_casehistory_history_change |
| custom_csat_reference |
| custom_datimps_dispositivo |
| custom_datirmm_dispositivo |
| custom_datirmm_dispositivo_history |
| custom_datirmm_dispositivo_history_change |
| custom_datisap_bollariga |
| custom_datisap_bollariga_history |
| custom_datisap_bollariga_history_change |
| custom_datisap_bollatestata |
| custom_datisap_bollatestata_history |
| custom_datisap_bollatestata_history_change |
| custom_datisap_cliente |
| custom_datisap_cliente_history |
| custom_datisap_cliente_history_change |
| custom_datisap_fatturariga |
| custom_datisap_fatturariga_history |
| custom_datisap_fatturariga_history_change |
| custom_datisap_fatturatestata |
| custom_datisap_fatturatestata_history |
| custom_datisap_fatturatestata_history_change |
| custom_datisap_indirizzo |
| custom_datisap_indirizzo_history |
| custom_datisap_indirizzo_history_change |
| custom_datisap_magazzino |
| custom_datisap_magazzino_history |
| custom_datisap_magazzino_history_change |
| custom_datisap_ordineriga |
| custom_datisap_ordineriga_history |
| custom_datisap_ordineriga_history_change |
| custom_datisap_ordinetestata |
| custom_datisap_ordinetestata_history |
| custom_datisap_ordinetestata_history_change |
| custom_datisap_parte |
| custom_datisap_parte_history |
| custom_datisap_parte_history_change |
| custom_datisap_parteutilizzata |
| custom_datisap_parteutilizzata_history |
| custom_datisap_parteutilizzata_history_change |
| custom_datisap_prodotticategoria |
| custom_datisap_prodotticategoria_history |
| custom_datisap_prodotticategoria_history_change |
| custom_datisap_prodotto |
| custom_datisap_prodotto_history |
| custom_datisap_prodotto_history_change |
| custom_datisap_utente |
| custom_datisap_utente_history |
| custom_datisap_utente_history_change |
| custom_monitoring_nagios |
| custom_monitoring_nagios_history_change |
| custom_monitoring_ninjarmm |
| custom_monitoring_ninjarmm_history_change |
| dataflow_batch |
| dataflow_batch_export |
| dataflow_batch_import |
| dataflow_import_data |
| dataflow_profile |
| dataflow_profile_history |
| dataflow_session |
| deep_activity_activity |
| deep_address_address |
| deep_address_address_history_change |
| deep_address_address_type |
| deep_announcement_announcement |
| deep_announcement_announcement_portal |
| deep_announcement_announcement_tag |
| deep_announcement_announcement_type |
| deep_announcement_announcement_user |
| deep_api_token |
| deep_approval_approval |
| deep_approval_approval_history_change |
| deep_approval_item |
| deep_approval_item_user |
| deep_approval_item_user_history_change |
| deep_approval_token |
| deep_asset_bios |
| deep_asset_cpu |
| deep_asset_device |
| deep_asset_hddlogical |
| deep_asset_ip |
| deep_asset_monitoring_event |
| deep_asset_monitoring_rule |
| deep_asset_motherboard |
| deep_asset_networkinterface |
| deep_asset_os |
| deep_asset_pingsweep |
| deep_asset_ram |
| deep_asset_remotecollector |
| deep_asset_rmm_eventlog |
| deep_asset_rmm_job |
| deep_asset_rule |
| deep_asset_script |
| deep_asset_script_runhistory |
| deep_asset_snmp |
| deep_asset_snmptype_map |
| deep_asset_snmpvendor_map |
| deep_asset_software |
| deep_asset_ssh |
| deep_asset_subnet |
| deep_asset_subtype |
| deep_asset_systemchassis |
| deep_asset_type |
| deep_asset_update |
| deep_asset_update_status |
| deep_asset_wmi |
| deep_attachment_attachment |
| deep_attachment_auditlog |
| deep_attachment_type |
| deep_attachment_type_group |
| deep_board_board |
| deep_board_entry |
| deep_board_lane |
| deep_board_role |
| deep_calendar_backlog |
| deep_calendar_calendar |
| deep_calendar_external_calendar |
| deep_calendar_external_event |
| deep_calendar_external_job |
| deep_calendar_external_map |
| deep_calendar_external_source |
| deep_calendar_filter |
| deep_calendar_group |
| deep_calendar_source |
| deep_catalog_pricelist |
| deep_catalog_pricelist_rule |
| deep_catalog_pricelist_rule_product |
| deep_catalog_pricelist_type |
| deep_catalog_product |
| deep_catalog_product_history_change |
| deep_catalog_product_link |
| deep_catalog_product_type |
| deep_catalog_relation_pricelist_account |
| deep_category_category |
| deep_category_group |
| deep_category_model |
| deep_chat_attachment |
| deep_chat_bot |
| deep_chat_mention |
| deep_chat_message |
| deep_chat_room |
| deep_chat_room_user |
| deep_chat_user_status |
| deep_chat_widgetconfiguration |
| deep_chat_workinghours |
| deep_cmdb_ci |
| deep_cmdb_ci_history_change |
| deep_cmdb_class |
| deep_cmdb_class_group |
| deep_cmdb_subtype |
| deep_cmdb_type |
| deep_company_company |
| deep_company_email_domain |
| deep_connector_job |
| deep_connector_job_folder |
| deep_contract_contract |
| deep_contract_contract_history_change |
| deep_contract_contract_role |
| deep_contract_line |
| deep_contract_line_history_change |
| deep_contract_line_role |
| deep_contract_line_type |
| deep_contract_line_type_group |
| deep_contract_type |
| deep_contract_type_group |
| deep_crm_account |
| deep_crm_account_group |
| deep_crm_account_history_change |
| deep_crm_contact |
| deep_crm_contact_history_change |
| deep_crm_contact_type |
| deep_crm_contact_type_group |
| deep_crm_opportunity |
| deep_crm_opportunity_history_change |
| deep_crm_opportunity_type |
| deep_crm_opportunity_type_group |
| deep_crm_paymentcondition |
| deep_crm_paymentcondition_history_change |
| deep_customfield_constraint |
| deep_customfield_event |
| deep_customfield_field |
| deep_customfield_index |
| deep_customfield_index_map |
| deep_customfield_model |
| deep_dashboard_chart |
| deep_dashboard_panel |
| deep_dashboard_panel_group |
| deep_email_attachment |
| deep_email_event |
| deep_email_mailbox |
| deep_email_mailbox_blacklist |
| deep_email_mailbox_log |
| deep_email_mailbox_webclient_group |
| deep_email_mailtemplate |
| deep_email_message |
| deep_email_rule |
| deep_escalation_rule |
| deep_escalation_rule_model |
| deep_flow_context |
| deep_flow_flow |
| deep_flow_flow_header |
| deep_flow_node |
| deep_flow_node_runtimevalue |
| deep_flow_node_value |
| deep_flow_stage |
| deep_flow_stage_runtimevalue |
| deep_flow_stageset |
| deep_flow_stageset_template |
| deep_flow_subflow_io |
| deep_flow_trigger |
| deep_flow_variable |
| deep_flow_variable_runtimevalue |
| deep_formtemplate_button |
| deep_formtemplate_field |
| deep_formtemplate_fieldset |
| deep_formtemplate_formtemplate |
| deep_formtemplate_tab |
| deep_formtemplate_tab_group |
| deep_grid_column |
| deep_grid_grid |
| deep_grid_group |
| deep_group_group |
| deep_group_rule |
| deep_group_user |
| deep_import_field |
| deep_import_import |
| deep_import_import_group |
| deep_import_importhistory |
| deep_integration_baramundi_asset |
| deep_integration_baramundi_asset_type |
| deep_integration_baramundi_connection |
| deep_integration_baramundi_endpoint |
| deep_integration_baramundi_folder |
| deep_integration_baramundi_jobdefinition |
| deep_integration_baramundi_jobinstance |
| deep_integration_baramundi_logicalgroup |
| deep_integration_datto_rmm_alert |
| deep_integration_datto_rmm_connection |
| deep_integration_datto_rmm_device |
| deep_integration_datto_rmm_site |
| deep_integration_digitalocean_connection |
| deep_integration_digitalocean_domain |
| deep_integration_digitalocean_domain_record |
| deep_integration_digitalocean_droplet |
| deep_integration_digitalocean_image |
| deep_integration_digitalocean_region |
| deep_integration_digitalocean_size |
| deep_integration_digitalocean_sshkey |
| deep_integration_digitalocean_vpc |
| deep_integration_fic_client |
| deep_integration_fic_client_history_change |
| deep_integration_fic_company |
| deep_integration_fic_company_history_change |
| deep_integration_fic_connection |
| deep_integration_fic_document |
| deep_integration_fic_document_history_change |
| deep_integration_fic_document_item |
| deep_integration_fic_document_item_history_change |
| deep_integration_fic_document_payment |
| deep_integration_fic_document_payment_history_change |
| deep_integration_fic_payment_account |
| deep_integration_fic_payment_account_history_change |
| deep_integration_fic_payment_method |
| deep_integration_fic_payment_method_history_change |
| deep_integration_fic_product |
| deep_integration_fic_product_history_change |
| deep_integration_fic_vat |
| deep_integration_fic_vat_history_change |
| deep_integration_microsoft_teams_appconfig |
| deep_integration_microsoft_teams_channel |
| deep_integration_microsoft_teams_channel_relation_group |
| deep_integration_ninjaone_activity |
| deep_integration_ninjaone_connection |
| deep_integration_ninjaone_device |
| deep_integration_ninjaone_disk |
| deep_integration_ninjaone_location |
| deep_integration_ninjaone_organization |
| deep_integration_ninjaone_os |
| deep_integration_opmanager_alarm |
| deep_integration_opmanager_connection |
| deep_integration_opmanager_customer |
| deep_integration_opmanager_device |
| deep_integration_opmanager_probe |
| deep_integration_opmanager_relation_customer_probe |
| deep_inventory_item |
| deep_inventory_movement |
| deep_inventory_warehouse |
| deep_inventory_warehouse_type |
| deep_kb_article |
| deep_kb_article_fulltext |
| deep_kb_article_tag |
| deep_kb_kb |
| deep_kb_kb_group_edit |
| deep_kb_kb_group_view |
| deep_ldap_ldap |
| deep_list_list |
| deep_list_listclass |
| deep_list_listvalue |
| deep_list_listvalue_group |
| deep_list_listvalue_model |
| deep_list_permission |
| deep_log_system_audit_entry |
| deep_mailchimp_account |
| deep_mailchimp_audience |
| deep_mailchimp_contact |
| deep_mailchimp_tag |
| deep_mailchimp_tag_contact |
| deep_marketing_campaign |
| deep_marketing_campaign_history_change |
| deep_marketing_conversion |
| deep_marketing_conversion_history_change |
| deep_multifactor_auth |
| deep_multifactor_auth_history_change |
| deep_multifactor_config |
| deep_multifactor_config_group |
| deep_multifactor_totp_secret |
| deep_oauth_client |
| deep_oauth_tokenmap |
| deep_password_auditlog |
| deep_password_map |
| deep_password_passphrase |
| deep_password_password |
| deep_password_password_history_change |
| deep_password_role |
| deep_payment_bank |
| deep_payment_bank_history_change |
| deep_payment_method |
| deep_payment_method_history_change |
| deep_payment_terms |
| deep_payment_terms_history_change |
| deep_portal_column |
| deep_portal_container |
| deep_portal_group |
| deep_portal_group_request |
| deep_portal_page |
| deep_portal_permission_map |
| deep_portal_portal |
| deep_portal_request |
| deep_portal_row |
| deep_portal_widget |
| deep_project_asset |
| deep_project_assignment |
| deep_project_calendar |
| deep_project_calendar_exception |
| deep_project_link |
| deep_project_project |
| deep_project_project_role |
| deep_project_project_type |
| deep_quickreply_groupmap |
| deep_quickreply_modelmap |
| deep_quickreply_reply |
| deep_quickreply_type |
| deep_relation_graphview |
| deep_relation_graphview_role |
| deep_relation_palette |
| deep_relation_palette_item |
| deep_relation_relation |
| deep_relation_role |
| deep_report_folder |
| deep_report_folder_group |
| deep_report_report |
| deep_report_reporthistory |
| deep_report_scheduledreport |
| deep_routing_rule |
| deep_routing_type |
| deep_sales_forecast |
| deep_sales_forecast_accrualitem |
| deep_sales_forecast_category |
| deep_sales_forecast_category_row |
| deep_sales_forecast_history_change |
| deep_sales_forecast_revenueitem |
| deep_sales_invoice |
| deep_sales_invoice_history_change |
| deep_sales_invoice_item |
| deep_sales_invoice_item_related_model |
| deep_sales_invoice_payment |
| deep_sales_invoice_process |
| deep_sales_invoice_related_model |
| deep_sales_invoice_rule |
| deep_sales_invoice_type |
| deep_sales_order |
| deep_sales_order_history_change |
| deep_sales_order_item |
| deep_sales_order_type |
| deep_sales_quote |
| deep_sales_quote_history_change |
| deep_sales_quote_item |
| deep_sales_quote_type |
| deep_sales_relation_forecast_category_row_product |
| deep_sales_shipment |
| deep_sales_shipment_history_change |
| deep_sales_shipment_item |
| deep_sales_shipment_type |
| deep_saml_client |
| deep_service_operation |
| deep_service_operation_history_change |
| deep_service_type |
| deep_service_type_group |
| deep_sla_calendar |
| deep_sla_goal |
| deep_sla_metric |
| deep_sla_timer |
| deep_survey_answer |
| deep_survey_choicelist |
| deep_survey_question |
| deep_survey_question_template |
| deep_survey_result |
| deep_survey_result_user |
| deep_survey_survey |
| deep_survey_survey_resultrole |
| deep_survey_survey_template |
| deep_survey_survey_template_resultrole |
| deep_task_task |
| deep_task_type |
| deep_task_type_model |
| deep_tax_tax |
| deep_tax_tax_history_change |
| deep_teamviewer_session |
| deep_userregistration_step |
| deep_userregistration_stepdata |
| deep_util_code |
| deep_util_mergeinfo |
| deep_util_mergemap |
| deep_webpush_subscription |
| design_change |
| directory_country |
| directory_country_format |
| directory_country_region |
| directory_country_region_name |
| directory_currency_rate |
| modulecreator_module |
| permission_block |
| permission_variable |
| widget |
| widget_instance |
| widget_instance_page |
| widget_instance_page_layout |
+--------------------------------------------------------------+
476 rows in set (0.001 sec)

MariaDB [c0_deepser]> show columns from deep_service_operation;

+-------------------------------------+------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key | Default |
Extra |
+-------------------------------------+------------------+------+-----+---------
+----------------+
| entity_id | int(11) | NO | PRI | NULL |
auto_increment |
| type_id | int(10) unsigned | NO | MUL | NULL |
|
| source | varchar(128) | YES | | NULL |
|
| token | varchar(255) | YES | MUL | NULL |
|
| increment_id | varchar(255) | YES | | NULL |
|
| title | varchar(500) | YES | | NULL |
|
| description | longtext | YES | | NULL |
|
| solution | longtext | YES | | NULL |
|
| priority_id | int(10) unsigned | NO | | NULL |
|
| urgency_id | int(10) unsigned | NO | | NULL |
|
| requester_email | varchar(255) | YES | | NULL |
|
| requester_username | varchar(255) | YES | MUL | NULL |
|
| requester_company_id | int(11) | NO | | 0 |
|
| assigned_username | varchar(255) | YES | MUL | NULL |
|
| assigned_group_id | int(10) unsigned | NO | MUL | NULL |
|
| submit_username | varchar(255) | YES | | NULL |
|
| contract_id | int(10) unsigned | NO | MUL | NULL |
|
| deleted | smallint(6) | NO | MUL | NULL |
|
| deleted_at | datetime | YES | | NULL |
|
| archived | smallint(6) | NO | MUL | NULL |
|
| archived_at | datetime | YES | | NULL |
|
| closed_at | datetime | YES | | NULL |
|
| mailbox_id | int(10) unsigned | NO | | NULL |
|
| disable_routing | int(11) | NO | | 0 |
|
| current_version | int(10) unsigned | NO | | NULL |
|
| due_date | datetime | YES | | NULL |
|
| updated_by | varchar(255) | YES | | NULL |
|
| category1 | int(10) unsigned | NO | MUL | NULL |
|
| category2 | int(10) unsigned | NO | MUL | NULL |
|
| category3 | int(10) unsigned | NO | MUL | NULL |
|
| category4 | int(10) unsigned | NO | | NULL |
|
| status | smallint(6) | NO | MUL | NULL |
|
| formtemplate_id | int(10) unsigned | NO | | NULL |
|
| updated_at | timestamp | YES | | NULL |
|
| last_comment_created_at | datetime | YES | | NULL |
|
| last_comment_updated_at | datetime | YES | | NULL |
|
| created_at | timestamp | YES | | NULL |
|
| device_id | int(11) | YES | | NULL |
|
| mobile_model | int(11) | YES | | NULL |
|
| ci_id | int(11) | YES | | NULL |
|
| cust_ci_id | int(11) | NO | | NULL |
|
| cust_mobile_model | int(11) | YES | | NULL |
|
| cust_satisfaction_level | varchar(255) | YES | | NULL |
|
| cust_phone_number | varchar(255) | YES | | NULL |
|
| cust_signature | longtext | YES | | NULL |
|
| cust_service_catalog_model | int(11) | YES | | NULL |
|
| cust_resolver_group | int(11) | NO | | NULL |
|
| cust_owner_company_id | int(11) | NO | MUL | NULL |
|
| cust_external_code | varchar(255) | YES | | NULL |
|
| cust_address | int(11) | YES | | NULL |
|
| cust_codice_esterno | varchar(255) | YES | | NULL |
|
| cust_operation_scadenza | int(11) | YES | | NULL |
|
| cust_order_id | int(11) | NO | | NULL |
|
| cust_is_commessa | int(11) | YES | | NULL |
|
| cust_fatturabile | int(11) | YES | | NULL |
|
| cust_sla_type_id | int(11) | YES | | NULL |
|
| cust_target_presa_in_carico_id | int(11) | NO | | NULL |
|
| cust_on_site | int(11) | NO | | NULL |
|
| cust_chiamato_h24 | int(11) | NO | | NULL |
|
| cust_nr_contratto | varchar(255) | NO | | NULL |
|
| cust_codice_raggruppamento | int(11) | NO | | NULL |
|
| cust_categoria_commessa | varchar(255) | YES | | NULL |
|
| cust_ore_remote_totali | decimal(12,4) | NO | | NULL |
|
| cust_force_send_report | int(11) | NO | | NULL |
|
| cust_data_avvio_attivita | datetime | YES | | NULL |
|
| cust_data_kickoff | datetime | YES | | NULL |
|
| cust_tag | varchar(255) | YES | | NULL |
|
| cust_in_gestione_fornitore_id | varchar(255) | YES | | NULL |
|
| cust_codice_raggruppamento_contract | int(11) | YES | | NULL |
|
| cust_contract_category_code | varchar(255) | YES | | NULL |
|
| cust_communication_type | int(11) | NO | | NULL |
|
| cust_tam | varchar(255) | YES | | NULL |
|
| cust_fatturare_a | int(11) | NO | | NULL |
|
| cust_forza_contratto | int(11) | NO | | NULL |
|
| cust_new_access | longtext | NO | | NULL |
|
| cust_previous_assigned | longtext | NO | | NULL |
|
| cust_stato_materiale | int(11) | NO | | NULL |
|
| cust_doc_fine_progetto | varchar(255) | YES | | NULL |
|
| cust_backup | int(11) | NO | | NULL |
|
| cust_previous_stato_materiale | varchar(255) | NO | | NULL |
|
| cust_tipo_contratto | varchar(255) | YES | | NULL |
|
| cust_unregistered_user | longtext | NO | | NULL |
|
| cust_closed_banner | longtext | NO | | NULL |
|
| cust_activity_block | datetime | YES | | NULL |
|
| cust_removed_assigned | varchar(255) | NO | | NULL |
|
| cust_nota | varchar(255) | YES | | NULL |
|
| cust_prefisso | int(11) | NO | | NULL |
|
| cust_id_monitoraggio | int(11) | NO | | NULL |
|
| cust_stato_monitoraggio | int(11) | NO | | NULL |
|
| cust_ticket_collegato_monitoraggio | varchar(255) | YES | | NULL |
|
| cust_contatore_sistemi_monitoraggio | int(11) | NO | | NULL |
|
| cust_data_ricezione_email | datetime | YES | | NULL |
|
| cust_mps_address | varchar(255) | YES | | NULL |
|
| cust_department | varchar(255) | YES | | NULL |
|
| cust_office | varchar(255) | YES | | NULL |
|
| cust_contract_status | varchar(255) | YES | | NULL |
|
| cust_categoria_ticket_pm | varchar(255) | YES | | NULL |
|
| cust_totale_ore_progetto | decimal(12,4) | NO | | NULL |
|
| cust_cookbook | longtext | NO | | NULL |
|
| cust_stato_kickoff | varchar(255) | NO | | NULL |
|
| cust_winrate | varchar(255) | NO | | NULL |
|
| cust_info_progetti_persi | varchar(255) | NO | | NULL |
|
| cust_produttori | varchar(255) | NO | | NULL |
|
+-------------------------------------+------------------+------+-----+---------
+----------------+
103 rows in set (0.001 sec)

MariaDB [c0_deepser]> show columns from deep_activity_activity;

+---------------------------------+----------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key | Default |
Extra |
+---------------------------------+----------------------+------+-----+---------
+----------------+
| entity_id | int(11) | NO | PRI | NULL |
auto_increment |
| type | int(10) unsigned | NO | MUL | NULL |
|
| description | longtext | YES | | NULL |
|
| portal_visibility | smallint(6) | NO | | NULL |
|
| frontend_visibility | smallint(5) unsigned | NO | | NULL |
|
| started_at | datetime | YES | MUL | NULL |
|
| ended_at | datetime | YES | | NULL |
|
| duration | int(11) | YES | | NULL |
|
| contract_id | int(10) unsigned | NO | MUL | NULL |
|
| contract_line_id | int(10) unsigned | NO | MUL | NULL |
|
| contract_line_qty | decimal(12,4) | NO | | NULL |
|
| created_by | varchar(255) | NO | | NULL |
|
| model_alias | varchar(255) | NO | MUL | NULL |
|
| model_id | int(10) unsigned | NO | | NULL |
|
| status | smallint(6) | YES | | NULL |
|
| formtemplate_id | int(10) unsigned | NO | | NULL |
|
| disable_routing | smallint(6) | NO | | NULL |
|
| updated_at | timestamp | YES | | NULL |
|
| created_at | timestamp | YES | | NULL |
|
| cust_pausa_pranzo | int(11) | YES | | NULL |
|
| cust_note_interne | longtext | YES | | NULL |
|
| cust_fatturabile | int(11) | YES | MUL | NULL |
|
| cust_fatturabile_solo_parti | int(11) | YES | MUL | NULL |
|
| cust_nome_cliente | varchar(255) | YES | | NULL |
|
| cust_signature | longtext | YES | | NULL |
|
| cust_duration | int(11) | NO | | NULL |
|
| cust_dutata_ore | decimal(12,4) | YES | | NULL |
|
| cust_ore_straordinario | decimal(12,4) | NO | | NULL |
|
| cust_ore_standard | decimal(12,4) | YES | | NULL |
|
| cust_ore_notturno | decimal(12,4) | YES | | NULL |
|
| cust_onsite | int(11) | NO | | NULL |
|
| cust_categoria1_listino_servizi | int(11) | YES | | NULL |
|
| cust_categoria2_listino_servizi | int(11) | YES | | NULL |
|
| cust_ore_viaggio | int(11) | NO | | NULL |
|
| cust_zona_maggiorazione | int(11) | NO | | NULL |
|
| cust_owner_company_id | int(11) | NO | | NULL |
|
| cust_potenziale_dfc | int(11) | NO | | NULL |
|
| cust_dfc | int(11) | NO | | NULL |
|
| cust_is_first_activity | int(11) | NO | | NULL |
|
| cust_contract_number | varchar(255) | NO | | NULL |
|
| cust_uso_effettivo | int(11) | NO | | NULL |
|
| cust_disable_mail_event | int(11) | NO | | NULL |
|
| cust_ore_fatturabili | int(11) | NO | | NULL |
|
| cust_durata_effettiva | int(11) | NO | | NULL |
|
| cust_activity_block | datetime | YES | | NULL |
|
| cust_dispositivo_serial_number | varchar(255) | YES | | NULL |
|
| cust_dispositivo_descrizione | varchar(255) | YES | | NULL |
|
| cust_dispositivo_ubicazione | int(11) | NO | | NULL |
|
| cust_disable_status_change | int(11) | NO | | NULL |
|
| cust_invio_mail_ticket_chiuso | int(11) | NO | | NULL |
|
| cust_categoria_commessa | varchar(255) | YES | | NULL |
|
| cust_contract_category_code | varchar(255) | YES | | NULL |
|
| cust_codice_raggruppamento | varchar(255) | YES | | NULL |
|
| cust_diritto_fisso | int(11) | NO | | NULL |
|
+---------------------------------+----------------------+------+-----+---------
+----------------+
54 rows in set (0.001 sec)

MariaDB [c0_deepser]> show columns from deep_contract_contract;

+--------------------------------+------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------------------------------+------------------+------+-----+---------
+----------------+
| entity_id | int(11) | NO | PRI | NULL |
auto_increment |
| type_id | int(10) unsigned | NO | MUL | NULL |
|
| increment_id | varchar(255) | YES | | NULL |
|
| contract_number | varchar(255) | NO | MUL | NULL |
|
| category1 | int(10) unsigned | NO | | NULL |
|
| category2 | int(10) unsigned | NO | | NULL |
|
| category3 | int(10) unsigned | NO | | NULL |
|
| category4 | int(10) unsigned | NO | | NULL |
|
| paymentcondition_id | int(10) unsigned | YES | | NULL |
|
| payment_method_id | int(10) unsigned | NO | | NULL |
|
| payment_terms_id | int(10) unsigned | NO | | NULL |
|
| bank_id | int(10) unsigned | NO | | NULL |
|
| pricelist_id | int(10) unsigned | YES | | NULL |
|
| billing_address_id | int(10) unsigned | YES | | NULL |
|
| billing_address_data | longtext | YES | | NULL |
|
| billing_mode | varchar(255) | YES | | NULL |
|
| billing_recurring_type | varchar(255) | YES | | NULL |
|
| billing_recurring_qty | decimal(12,4) | YES | | NULL |
|
| billing_last_date | date | YES | | NULL |
|
| currency_code | varchar(255) | YES | | NULL |
|
| base_currency_code | varchar(255) | YES | | NULL |
|
| base_to_currency_rate | decimal(12,4) | YES | | NULL |
|
| billing_next_date | date | YES | | NULL |
|
| billing_expiration_date | date | YES | | NULL |
|
| name | varchar(255) | NO | | NULL |
|
| description | longtext | YES | | NULL |
|
| signing_date | datetime | YES | | NULL |
|
| start_date | datetime | YES | | NULL |
|
| expiration_date | datetime | YES | | NULL |
|
| delivery_date | datetime | YES | | NULL |
|
| cancellation_date | datetime | YES | | NULL |
|
| closed_at | datetime | YES | | NULL |
|
| is_recurring | smallint(6) | NO | | NULL |
|
| recurring_type | varchar(255) | NO | | NULL |
|
| recurring_qty | int(11) | NO | | NULL |
|
| recurring_increment_percentage | decimal(12,4) | NO | | NULL |
|
| supplier_company_id | int(10) unsigned | NO | | NULL |
|
| supplier_name | varchar(255) | YES | | NULL |
|
| vendor_account_id | int(10) unsigned | NO | | NULL |
|
| vendor_name | varchar(255) | YES | | NULL |
|
| customer_company_id | int(10) unsigned | NO | | NULL |
|
| owner_company_id | int(10) unsigned | NO | | NULL |
|
| owner_group_id | int(10) unsigned | NO | | NULL |
|
| owner_username | varchar(255) | YES | | NULL |
|
| assigned_company_id | int(10) unsigned | NO | | NULL |
|
| assigned_group_id | int(10) unsigned | NO | | NULL |
|
| assigned_username | varchar(255) | YES | | NULL |
|
| expired | smallint(6) | NO | | NULL |
|
| renewed_id | int(11) | NO | | NULL |
|
| total_amount | decimal(12,4) | YES | | NULL |
|
| lines_recurring_amount | decimal(12,4) | YES | | NULL |
|
| lines_non_recurring_amount | decimal(12,4) | YES | | NULL |
|
| lines_total_amount | decimal(12,4) | YES | | NULL |
|
| use_contract | smallint(6) | NO | | NULL |
|
| search_name | mediumtext | NO | | NULL |
|
| mailbox_id | int(10) unsigned | NO | | NULL |
|
| current_version | varchar(255) | NO | | NULL |
|
| updated_by | varchar(255) | YES | | NULL |
|
| status | smallint(6) | NO | | NULL |
|
| formtemplate_id | int(10) unsigned | NO | | NULL |
|
| disable_routing | smallint(6) | NO | | NULL |
|
| updated_at | timestamp | YES | | NULL |
|
| created_at | timestamp | YES | | NULL |
|
| cust_contract_category_code | varchar(255) | YES | | NULL |
|
| cust_sla_type_id | int(11) | YES | | NULL |
|
| cust_codice_raggruppamento | int(11) | YES | | NULL |
|
| cust_subcontracting | int(11) | YES | | NULL |
|
| cust_address | int(11) | YES | | NULL |
|
| cust_ticket_fatturabili | int(11) | NO | | NULL |
|
| cust_priority_id | int(11) | NO | | NULL |
|
| cust_urgency_id | int(11) | NO | | NULL |
|
| cust_target_presa_in_carico_id | int(11) | NO | | NULL |
|
| cust_suggerisci_richiedente | varchar(255) | YES | | NULL |
|
| cust_on_site | int(11) | NO | | NULL |
|
| cust_numero_ordine | varchar(255) | NO | | NULL |
|
| cust_data_ordine | datetime | YES | | NULL |
|
| cust_chiamato_h24 | int(11) | NO | | NULL |
|
| cust_cig | varchar(255) | NO | | NULL |
|
| cust_dettaglio_allegato | int(11) | NO | | NULL |
|
| cust_progetto | varchar(255) | NO | | NULL |
|
| cust_partner | int(11) | NO | | NULL |
|
| cust_distributore | int(11) | NO | | NULL |
|
| cust_fatturare_a | int(11) | NO | | NULL |
|
| cust_promo | varchar(255) | YES | | NULL |
|
| cust_duplica_contratto | int(11) | NO | | NULL |
|
| cust_nota_fatturazione | varchar(255) | NO | | NULL |
|
| cust_in_scadenza | int(11) | NO | | NULL |
|
| cust_owner_username | varchar(255) | YES | | NULL |
|
| cust_send_survey | int(11) | NO | | NULL |
|
| cust_tam | varchar(255) | YES | | NULL |
|
| cust_infragruppo | int(11) | NO | | NULL |
|
| cust_ordine_collegato | varchar(255) | YES | | NULL |
|
| cust_canone_mese | decimal(12,4) | NO | | NULL |
|
| cust_canone_anno | decimal(12,4) | NO | | NULL |
|
| cust_tov | decimal(12,4) | NO | | NULL |
|
| cust_cup | varchar(255) | YES | | NULL |
|
| cust_backup | int(11) | NO | | NULL |
|
| cust_tipo_contratto | int(11) | NO | | NULL |
|
| cust_eula | varchar(255) | YES | | NULL |
|
| cust_destinatari_eula | longtext | NO | | NULL |
|
| cust_user | varchar(255) | NO | | NULL |
|
| cust_total_attachments | varchar(255) | NO | | NULL |
|
| cust_last_status_change | datetime | YES | | NULL |
|
| cust_data_invio_email_eula | datetime | YES | | NULL |
|
| cust_trigger_eula_flow | varchar(255) | NO | | NULL |
|
| cust_total_quantity | decimal(12,4) | NO | | NULL |
|
| cust_pam | varchar(255) | YES | | NULL |
|
| cust_kam | varchar(255) | YES | | NULL |
|
| cust_area_manager | varchar(255) | NO | | NULL |
|
| cust_pec | varchar(255) | YES | | NULL |
|
| cust_cookbook | longtext | NO | | NULL |
|
+--------------------------------+------------------+------+-----+---------
+----------------+
111 rows in set (0.001 sec)

MariaDB [c0_deepser]> show columns from deep_contract_line;

+--------------------------------+------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------------------------------+------------------+------+-----+---------
+----------------+
| entity_id | int(11) | NO | PRI | NULL |
auto_increment |
| contract_id | int(11) | NO | MUL | NULL |
|
| type_id | int(11) | NO | MUL | NULL |
|
| pricelist_id | int(10) unsigned | YES | | NULL |
|
| product_id | int(10) unsigned | YES | | NULL |
|
| product_name | varchar(255) | YES | | NULL |
|
| product_sku | varchar(255) | YES | | NULL |
|
| product_qty | decimal(12,4) | YES | | NULL |
|
| product_price | decimal(12,4) | YES | | NULL |
|
| product_recurring_type | varchar(255) | YES | | NULL |
|
| product_recurring_qty | decimal(12,4) | YES | | NULL |
|
| billing_mode | varchar(255) | YES | | NULL |
|
| billing_recurring_type | varchar(255) | YES | | NULL |
|
| billing_recurring_qty | decimal(12,4) | YES | | NULL |
|
| billing_last_date | date | YES | | NULL |
|
| billing_next_date | date | YES | | NULL |
|
| billing_expiration_date | date | YES | | NULL |
|
| line_number | int(11) | NO | | NULL |
|
| name | varchar(255) | NO | | NULL |
|
| total_amount | decimal(12,4) | YES | | NULL |
|
| expired | smallint(6) | NO | | NULL |
|
| renewed_id | int(11) | NO | | NULL |
|
| signing_date | datetime | YES | | NULL |
|
| start_date | datetime | YES | | NULL |
|
| expiration_date | datetime | YES | | NULL |
|
| delivery_date | datetime | YES | | NULL |
|
| cancellation_date | datetime | YES | | NULL |
|
| closed_at | datetime | YES | | NULL |
|
| is_recurring | smallint(6) | NO | | NULL |
|
| recurring_type | varchar(255) | NO | | NULL |
|
| recurring_qty | int(11) | NO | | NULL |
|
| recurring_increment_percentage | decimal(12,4) | NO | | NULL |
|
| use_line | smallint(6) | NO | | NULL |
|
| calculation_type | int(10) unsigned | NO | | NULL |
|
| total_qty | decimal(12,4) | NO | | NULL |
|
| spent_qty | decimal(12,4) | NO | | NULL |
|
| remaining_qty | decimal(12,4) | NO | | NULL |
|
| total_time | int(11) | NO | | NULL |
|
| spent_time | int(11) | NO | | NULL |
|
| remaining_time | int(11) | NO | | NULL |
|
| current_version | int(11) | NO | | NULL |
|
| updated_by | varchar(255) | YES | | NULL |
|
| status | smallint(6) | NO | | NULL |
|
| formtemplate_id | int(10) unsigned | NO | | NULL |
|
| disable_routing | smallint(6) | NO | | NULL |
|
| updated_at | timestamp | YES | | NULL |
|
| created_at | timestamp | YES | | NULL |
|
| cust_sla_type_id | int(11) | YES | | NULL |
|
| cust_matricola_asset | varchar(255) | YES | | NULL |
|
| cust_ci_id | int(11) | NO | | NULL |
|
| cust_valore_riscatto | decimal(12,4) | NO | | NULL |
|
| cust_subcontracting | int(11) | NO | | NULL |
|
| cust_supplier_company_id | int(11) | NO | | NULL |
|
| cust_note | longtext | NO | | NULL |
|
| cust_note_interne | longtext | NO | | NULL |
|
| cust_id_tesis | varchar(255) | YES | | NULL |
|
| cust_bkp_billing_next_date | datetime | YES | | NULL |
|
| cust_bkp_billing_last_date | datetime | YES | | NULL |
|
| cust_progetto | varchar(255) | YES | | NULL |
|
| cust_tot_line | decimal(12,4) | NO | | NULL |
|
| cust_visible_to_portal | int(11) | NO | | NULL |
|
| cust_canone_anno | decimal(12,4) | NO | | NULL |
|
| cust_asset_collegato | varchar(255) | NO | | NULL |
|
| cust_quantita_licenze_mssp | decimal(12,4) | NO | | NULL |
|
+--------------------------------+------------------+------+-----+---------
+----------------+
64 rows in set (0.001 sec)

MariaDB [c0_deepser]>