--
-- Host: localhost    Database: assifact_reservedarea
-- ------------------------------------------------------


--
-- Temporary table structure for view `object_13`
--

/*!50001 DROP VIEW IF EXISTS `object_13`*/;
/*!50001 CREATE TABLE `object_13` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `nome` tinyint NOT NULL,
  `utenti` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_4`
--

/*!50001 DROP VIEW IF EXISTS `object_4`*/;
/*!50001 CREATE TABLE `object_4` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_9`
--

/*!50001 DROP VIEW IF EXISTS `object_9`*/;
/*!50001 CREATE TABLE `object_9` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `Utente` tinyint NOT NULL,
  `DataConferma` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_1`
--

/*!50001 DROP VIEW IF EXISTS `object_1`*/;
/*!50001 CREATE TABLE `object_1` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `reference` tinyint NOT NULL,
  `calculated` tinyint NOT NULL,
  `showAsFilter` tinyint NOT NULL,
  `filterSortOrder` tinyint NOT NULL,
  `exportNewsletterProvider` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_2`
--

/*!50001 DROP VIEW IF EXISTS `object_2`*/;
/*!50001 CREATE TABLE `object_2` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `group__id` tinyint NOT NULL,
  `group__type` tinyint NOT NULL,
  `reference` tinyint NOT NULL,
  `calculated` tinyint NOT NULL,
  `useAsTargetGroup` tinyint NOT NULL,
  `targetGroup` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_12`
--

/*!50001 DROP VIEW IF EXISTS `object_12`*/;
/*!50001 CREATE TABLE `object_12` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `nome` tinyint NOT NULL,
  `utenti` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_11`
--

/*!50001 DROP VIEW IF EXISTS `object_11`*/;
/*!50001 CREATE TABLE `object_11` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `utente__id` tinyint NOT NULL,
  `utente__type` tinyint NOT NULL,
  `azienda__id` tinyint NOT NULL,
  `azienda__type` tinyint NOT NULL,
  `cedentiPerTurnover` tinyint NOT NULL,
  `cedentiAttivi` tinyint NOT NULL,
  `debitoriCeduti` tinyint NOT NULL,
  `debitoriCedutiImprese` tinyint NOT NULL,
  `debitoriCedutiPersoneFisiche` tinyint NOT NULL,
  `turnoverDomestico` tinyint NOT NULL,
  `piemonte` tinyint NOT NULL,
  `valleDaosta` tinyint NOT NULL,
  `liguria` tinyint NOT NULL,
  `lombardia` tinyint NOT NULL,
  `trentinoAltoAdige` tinyint NOT NULL,
  `veneto` tinyint NOT NULL,
  `friuliVeneziaGiulia` tinyint NOT NULL,
  `emiliaRomagna` tinyint NOT NULL,
  `marche` tinyint NOT NULL,
  `toscana` tinyint NOT NULL,
  `umbria` tinyint NOT NULL,
  `lazio` tinyint NOT NULL,
  `abruzzo` tinyint NOT NULL,
  `molise` tinyint NOT NULL,
  `campania` tinyint NOT NULL,
  `puglia` tinyint NOT NULL,
  `basilicata` tinyint NOT NULL,
  `calabria` tinyint NOT NULL,
  `sicilia` tinyint NOT NULL,
  `sardegna` tinyint NOT NULL,
  `turnoverInternazionale` tinyint NOT NULL,
  `import` tinyint NOT NULL,
  `export` tinyint NOT NULL,
  `notNotification` tinyint NOT NULL,
  `maturityFactoring` tinyint NOT NULL,
  `debitiFornitura` tinyint NOT NULL,
  `oggettoAssicurazione` tinyint NOT NULL,
  `totaleAttivi` tinyint NOT NULL,
  `totaleTurnover` tinyint NOT NULL,
  `totaleOutstanding` tinyint NOT NULL,
  `piccoleImpreseAttivi` tinyint NOT NULL,
  `piccoleImpreseTurnover` tinyint NOT NULL,
  `piccoleImpreseOutstanding` tinyint NOT NULL,
  `medieImpreseAttivi` tinyint NOT NULL,
  `medieImpreseTurnover` tinyint NOT NULL,
  `medieImpreseOutstanding` tinyint NOT NULL,
  `corporateAttivi` tinyint NOT NULL,
  `corporateTurnover` tinyint NOT NULL,
  `corporateOutstanding` tinyint NOT NULL,
  `largeCorporateAttivi` tinyint NOT NULL,
  `largeCorporateTurnover` tinyint NOT NULL,
  `largeCorporateOutstanding` tinyint NOT NULL,
  `nonClassificatiAttivi` tinyint NOT NULL,
  `nonClassificatiTurnover` tinyint NOT NULL,
  `nonClassificatiOutstanding` tinyint NOT NULL,
  `merceologicoTotaleAttivi` tinyint NOT NULL,
  `merceologicoTotaleTurnover` tinyint NOT NULL,
  `merceologicoTotaleOutstanding` tinyint NOT NULL,
  `merceologicoManifatturaAttivi` tinyint NOT NULL,
  `merceologicoManifatturaTurnover` tinyint NOT NULL,
  `merceologicoManifatturaOutstanding` tinyint NOT NULL,
  `merceologicoIngrossoAttivi` tinyint NOT NULL,
  `merceologicoIngrossoTurnover` tinyint NOT NULL,
  `merceologicoIngrossoOutstanding` tinyint NOT NULL,
  `merceologicoServiziAttivi` tinyint NOT NULL,
  `merceologicoServiziTurnover` tinyint NOT NULL,
  `merceologicoServiziOutstanding` tinyint NOT NULL,
  `merceologicoTrasportiAttivi` tinyint NOT NULL,
  `merceologicoTrasportiTurnover` tinyint NOT NULL,
  `merceologicoTrasportiOutstanding` tinyint NOT NULL,
  `merceologicoDettaglioAttivi` tinyint NOT NULL,
  `merceologicoDettaglioTurnover` tinyint NOT NULL,
  `merceologicoDettaglioOutstanding` tinyint NOT NULL,
  `merceologicoCostruzioniAttivi` tinyint NOT NULL,
  `merceologicoCostruzioniTurnover` tinyint NOT NULL,
  `merceologicoCostruzioniOutstanding` tinyint NOT NULL,
  `merceologicoAltroAttivi` tinyint NOT NULL,
  `merceologicoAltroTurnover` tinyint NOT NULL,
  `merceologicoAltroOutstanding` tinyint NOT NULL,
  `merceologicoCedentiEsteriAttivi` tinyint NOT NULL,
  `merceologicoCedentiEsteriTurnover` tinyint NOT NULL,
  `merceologicoCedentiEsteriOutstanding` tinyint NOT NULL,
  `merceologicoNonClassificatiAttivi` tinyint NOT NULL,
  `merceologicoNonClassificatiTurnover` tinyint NOT NULL,
  `merceologicoNonClassificatiOutstanding` tinyint NOT NULL,
  `interessiAttivi` tinyint NOT NULL,
  `interessiAnticipiCedente` tinyint NOT NULL,
  `interessiDilazioneDebitore` tinyint NOT NULL,
  `interessiDiMora` tinyint NOT NULL,
  `numeriComputisticiFactoring` tinyint NOT NULL,
  `numeriComputisticiAnticipi` tinyint NOT NULL,
  `numeriComputisticiDilazione` tinyint NOT NULL,
  `commissioniAttivePerFactoring` tinyint NOT NULL,
  `commissioniPerFactoring` tinyint NOT NULL,
  `altriOneri` tinyint NOT NULL,
  `interessiPassiviGestionali` tinyint NOT NULL,
  `commissioniPassive` tinyint NOT NULL,
  `lordeEsposizioni` tinyint NOT NULL,
  `lordeEsposizioniBonis` tinyint NOT NULL,
  `lordeEsposizioniScadute` tinyint NOT NULL,
  `lordeInadempienze` tinyint NOT NULL,
  `lordeSofferenze` tinyint NOT NULL,
  `rettifiche` tinyint NOT NULL,
  `rettificheEsposizioniBonis` tinyint NOT NULL,
  `rettificheEsposizioniScadute` tinyint NOT NULL,
  `rettificheInadempienze` tinyint NOT NULL,
  `rettificheSofferenze` tinyint NOT NULL,
  `nuoveRettifiche` tinyint NOT NULL,
  `nuoveRettificheEsposizioniBonis` tinyint NOT NULL,
  `nuoveRettificheEsposizioniScadute` tinyint NOT NULL,
  `nuoveRettificheInadempienze` tinyint NOT NULL,
  `nuoveRettificheSofferenze` tinyint NOT NULL,
  `dataDiRiferimento` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_7`
--

/*!50001 DROP VIEW IF EXISTS `object_7`*/;
/*!50001 CREATE TABLE `object_7` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `roles` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_6`
--

/*!50001 DROP VIEW IF EXISTS `object_6`*/;
/*!50001 CREATE TABLE `object_6` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `active` tinyint NOT NULL,
  `firstname` tinyint NOT NULL,
  `lastname` tinyint NOT NULL,
  `gender` tinyint NOT NULL,
  `birthdate` tinyint NOT NULL,
  `customerLanguage` tinyint NOT NULL,
  `street` tinyint NOT NULL,
  `zip` tinyint NOT NULL,
  `city` tinyint NOT NULL,
  `countryCode` tinyint NOT NULL,
  `email` tinyint NOT NULL,
  `phone` tinyint NOT NULL,
  `profilingConsent` tinyint NOT NULL,
  `manualSegments` tinyint NOT NULL,
  `calculatedSegments` tinyint NOT NULL,
  `password` tinyint NOT NULL,
  `ssoIdentities` tinyint NOT NULL,
  `idEncoded` tinyint NOT NULL,
  `userName` tinyint NOT NULL,
  `confirmationToken` tinyint NOT NULL,
  `lastLogin` tinyint NOT NULL,
  `passwordRequestedAt` tinyint NOT NULL,
  `groups` tinyint NOT NULL,
  `Aziende` tinyint NOT NULL,
  `accountConfermato` tinyint NOT NULL,
  `lastReset` tinyint NOT NULL,
  `commissioni` tinyint NOT NULL,
  `gruppiDiLavoro` tinyint NOT NULL,
  `organiAssociativi` tinyint NOT NULL,
  `altriReferenti` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_3`
--

/*!50001 DROP VIEW IF EXISTS `object_3`*/;
/*!50001 CREATE TABLE `object_3` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `provider` tinyint NOT NULL,
  `identifier` tinyint NOT NULL,
  `profileData` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_14`
--

/*!50001 DROP VIEW IF EXISTS `object_14`*/;
/*!50001 CREATE TABLE `object_14` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `nome` tinyint NOT NULL,
  `utenti` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_8`
--

/*!50001 DROP VIEW IF EXISTS `object_8`*/;
/*!50001 CREATE TABLE `object_8` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `azienda` tinyint NOT NULL,
  `codice` tinyint NOT NULL,
  `tipologia` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_15`
--

/*!50001 DROP VIEW IF EXISTS `object_15`*/;
/*!50001 CREATE TABLE `object_15` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `nome` tinyint NOT NULL,
  `utenti` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_5`
--

/*!50001 DROP VIEW IF EXISTS `object_5`*/;
/*!50001 CREATE TABLE `object_5` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `code` tinyint NOT NULL,
  `attributeType` tinyint NOT NULL,
  `label` tinyint NOT NULL,
  `link` tinyint NOT NULL,
  `active` tinyint NOT NULL,
  `utm_source` tinyint NOT NULL,
  `utm_medium` tinyint NOT NULL,
  `utm_campaign` tinyint NOT NULL,
  `utm_term` tinyint NOT NULL,
  `utm_content` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `object_10`
--

/*!50001 DROP VIEW IF EXISTS `object_10`*/;
/*!50001 CREATE TABLE `object_10` (
  `oo_id` tinyint NOT NULL,
  `oo_classId` tinyint NOT NULL,
  `oo_className` tinyint NOT NULL,
  `utente__id` tinyint NOT NULL,
  `utente__type` tinyint NOT NULL,
  `azienda__id` tinyint NOT NULL,
  `azienda__type` tinyint NOT NULL,
  `turnoverCumulativo` tinyint NOT NULL,
  `proSoluto` tinyint NOT NULL,
  `proSolvendo` tinyint NOT NULL,
  `acquistiTitoloDefinitivo` tinyint NOT NULL,
  `acquistiSottoNominale` tinyint NOT NULL,
  `acquistiCreditiIva` tinyint NOT NULL,
  `montecrediti` tinyint NOT NULL,
  `montecreditiProSoluto` tinyint NOT NULL,
  `montecreditiProSolvendo` tinyint NOT NULL,
  `montecreditiAcquistiTitoloDefinitivo` tinyint NOT NULL,
  `montecreditiAcquistiSottoNominale` tinyint NOT NULL,
  `montecreditiAcquistiCreditiIva` tinyint NOT NULL,
  `anticipiCorrispettiviPagati` tinyint NOT NULL,
  `anticipiCrediti` tinyint NOT NULL,
  `factoringTitoloDefinitivo` tinyint NOT NULL,
  `anticipiAcquistiNominale` tinyint NOT NULL,
  `anticipiAcquistiCrediti` tinyint NOT NULL,
  `supplyChainFinance` tinyint NOT NULL,
  `turnoverReverse` tinyint NOT NULL,
  `mandatiPagamento` tinyint NOT NULL,
  `turnoverConfirming` tinyint NOT NULL,
  `montecreditiReverse` tinyint NOT NULL,
  `debitoriOggetto` tinyint NOT NULL,
  `dataDiRiferimento` tinyint NOT NULL,
  `o_id` tinyint NOT NULL,
  `o_parentId` tinyint NOT NULL,
  `o_type` tinyint NOT NULL,
  `o_key` tinyint NOT NULL,
  `o_path` tinyint NOT NULL,
  `o_index` tinyint NOT NULL,
  `o_published` tinyint NOT NULL,
  `o_creationDate` tinyint NOT NULL,
  `o_modificationDate` tinyint NOT NULL,
  `o_userOwner` tinyint NOT NULL,
  `o_userModification` tinyint NOT NULL,
  `o_classId` tinyint NOT NULL,
  `o_className` tinyint NOT NULL,
  `o_childrenSortBy` tinyint NOT NULL,
  `o_childrenSortOrder` tinyint NOT NULL,
  `o_versionCount` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Final view structure for view `object_13`
--

/*!50001 DROP TABLE IF EXISTS `object_13`*/;
/*!50001 DROP VIEW IF EXISTS `object_13`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_13` AS select `object_query_13`.`oo_id` AS `oo_id`,`object_query_13`.`oo_classId` AS `oo_classId`,`object_query_13`.`oo_className` AS `oo_className`,`object_query_13`.`nome` AS `nome`,`object_query_13`.`utenti` AS `utenti`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_13` join `objects` on(`objects`.`o_id` = `object_query_13`.`oo_id`)) */;

--
-- Final view structure for view `object_4`
--

/*!50001 DROP TABLE IF EXISTS `object_4`*/;
/*!50001 DROP VIEW IF EXISTS `object_4`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_4` AS select `object_query_4`.`oo_id` AS `oo_id`,`object_query_4`.`oo_classId` AS `oo_classId`,`object_query_4`.`oo_className` AS `oo_className`,`object_query_4`.`name` AS `name`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_4` join `objects` on(`objects`.`o_id` = `object_query_4`.`oo_id`)) */;

--
-- Final view structure for view `object_9`
--

/*!50001 DROP TABLE IF EXISTS `object_9`*/;
/*!50001 DROP VIEW IF EXISTS `object_9`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_9` AS select `object_query_9`.`oo_id` AS `oo_id`,`object_query_9`.`oo_classId` AS `oo_classId`,`object_query_9`.`oo_className` AS `oo_className`,`object_query_9`.`Utente` AS `Utente`,`object_query_9`.`DataConferma` AS `DataConferma`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_9` join `objects` on(`objects`.`o_id` = `object_query_9`.`oo_id`)) */;

--
-- Final view structure for view `object_1`
--

/*!50001 DROP TABLE IF EXISTS `object_1`*/;
/*!50001 DROP VIEW IF EXISTS `object_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_1` AS select `object_query_1`.`oo_id` AS `oo_id`,`object_query_1`.`oo_classId` AS `oo_classId`,`object_query_1`.`oo_className` AS `oo_className`,`object_query_1`.`name` AS `name`,`object_query_1`.`reference` AS `reference`,`object_query_1`.`calculated` AS `calculated`,`object_query_1`.`showAsFilter` AS `showAsFilter`,`object_query_1`.`filterSortOrder` AS `filterSortOrder`,`object_query_1`.`exportNewsletterProvider` AS `exportNewsletterProvider`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_1` join `objects` on(`objects`.`o_id` = `object_query_1`.`oo_id`)) */;

--
-- Final view structure for view `object_2`
--

/*!50001 DROP TABLE IF EXISTS `object_2`*/;
/*!50001 DROP VIEW IF EXISTS `object_2`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_2` AS select `object_query_2`.`oo_id` AS `oo_id`,`object_query_2`.`oo_classId` AS `oo_classId`,`object_query_2`.`oo_className` AS `oo_className`,`object_query_2`.`name` AS `name`,`object_query_2`.`group__id` AS `group__id`,`object_query_2`.`group__type` AS `group__type`,`object_query_2`.`reference` AS `reference`,`object_query_2`.`calculated` AS `calculated`,`object_query_2`.`useAsTargetGroup` AS `useAsTargetGroup`,`object_query_2`.`targetGroup` AS `targetGroup`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_2` join `objects` on(`objects`.`o_id` = `object_query_2`.`oo_id`)) */;

--
-- Final view structure for view `object_12`
--

/*!50001 DROP TABLE IF EXISTS `object_12`*/;
/*!50001 DROP VIEW IF EXISTS `object_12`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_12` AS select `object_query_12`.`oo_id` AS `oo_id`,`object_query_12`.`oo_classId` AS `oo_classId`,`object_query_12`.`oo_className` AS `oo_className`,`object_query_12`.`nome` AS `nome`,`object_query_12`.`utenti` AS `utenti`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_12` join `objects` on(`objects`.`o_id` = `object_query_12`.`oo_id`)) */;

--
-- Final view structure for view `object_11`
--

/*!50001 DROP TABLE IF EXISTS `object_11`*/;
/*!50001 DROP VIEW IF EXISTS `object_11`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_11` AS select `object_query_11`.`oo_id` AS `oo_id`,`object_query_11`.`oo_classId` AS `oo_classId`,`object_query_11`.`oo_className` AS `oo_className`,`object_query_11`.`utente__id` AS `utente__id`,`object_query_11`.`utente__type` AS `utente__type`,`object_query_11`.`azienda__id` AS `azienda__id`,`object_query_11`.`azienda__type` AS `azienda__type`,`object_query_11`.`cedentiPerTurnover` AS `cedentiPerTurnover`,`object_query_11`.`cedentiAttivi` AS `cedentiAttivi`,`object_query_11`.`debitoriCeduti` AS `debitoriCeduti`,`object_query_11`.`debitoriCedutiImprese` AS `debitoriCedutiImprese`,`object_query_11`.`debitoriCedutiPersoneFisiche` AS `debitoriCedutiPersoneFisiche`,`object_query_11`.`turnoverDomestico` AS `turnoverDomestico`,`object_query_11`.`piemonte` AS `piemonte`,`object_query_11`.`valleDaosta` AS `valleDaosta`,`object_query_11`.`liguria` AS `liguria`,`object_query_11`.`lombardia` AS `lombardia`,`object_query_11`.`trentinoAltoAdige` AS `trentinoAltoAdige`,`object_query_11`.`veneto` AS `veneto`,`object_query_11`.`friuliVeneziaGiulia` AS `friuliVeneziaGiulia`,`object_query_11`.`emiliaRomagna` AS `emiliaRomagna`,`object_query_11`.`marche` AS `marche`,`object_query_11`.`toscana` AS `toscana`,`object_query_11`.`umbria` AS `umbria`,`object_query_11`.`lazio` AS `lazio`,`object_query_11`.`abruzzo` AS `abruzzo`,`object_query_11`.`molise` AS `molise`,`object_query_11`.`campania` AS `campania`,`object_query_11`.`puglia` AS `puglia`,`object_query_11`.`basilicata` AS `basilicata`,`object_query_11`.`calabria` AS `calabria`,`object_query_11`.`sicilia` AS `sicilia`,`object_query_11`.`sardegna` AS `sardegna`,`object_query_11`.`turnoverInternazionale` AS `turnoverInternazionale`,`object_query_11`.`import` AS `import`,`object_query_11`.`export` AS `export`,`object_query_11`.`notNotification` AS `notNotification`,`object_query_11`.`maturityFactoring` AS `maturityFactoring`,`object_query_11`.`debitiFornitura` AS `debitiFornitura`,`object_query_11`.`oggettoAssicurazione` AS `oggettoAssicurazione`,`object_query_11`.`totaleAttivi` AS `totaleAttivi`,`object_query_11`.`totaleTurnover` AS `totaleTurnover`,`object_query_11`.`totaleOutstanding` AS `totaleOutstanding`,`object_query_11`.`piccoleImpreseAttivi` AS `piccoleImpreseAttivi`,`object_query_11`.`piccoleImpreseTurnover` AS `piccoleImpreseTurnover`,`object_query_11`.`piccoleImpreseOutstanding` AS `piccoleImpreseOutstanding`,`object_query_11`.`medieImpreseAttivi` AS `medieImpreseAttivi`,`object_query_11`.`medieImpreseTurnover` AS `medieImpreseTurnover`,`object_query_11`.`medieImpreseOutstanding` AS `medieImpreseOutstanding`,`object_query_11`.`corporateAttivi` AS `corporateAttivi`,`object_query_11`.`corporateTurnover` AS `corporateTurnover`,`object_query_11`.`corporateOutstanding` AS `corporateOutstanding`,`object_query_11`.`largeCorporateAttivi` AS `largeCorporateAttivi`,`object_query_11`.`largeCorporateTurnover` AS `largeCorporateTurnover`,`object_query_11`.`largeCorporateOutstanding` AS `largeCorporateOutstanding`,`object_query_11`.`nonClassificatiAttivi` AS `nonClassificatiAttivi`,`object_query_11`.`nonClassificatiTurnover` AS `nonClassificatiTurnover`,`object_query_11`.`nonClassificatiOutstanding` AS `nonClassificatiOutstanding`,`object_query_11`.`merceologicoTotaleAttivi` AS `merceologicoTotaleAttivi`,`object_query_11`.`merceologicoTotaleTurnover` AS `merceologicoTotaleTurnover`,`object_query_11`.`merceologicoTotaleOutstanding` AS `merceologicoTotaleOutstanding`,`object_query_11`.`merceologicoManifatturaAttivi` AS `merceologicoManifatturaAttivi`,`object_query_11`.`merceologicoManifatturaTurnover` AS `merceologicoManifatturaTurnover`,`object_query_11`.`merceologicoManifatturaOutstanding` AS `merceologicoManifatturaOutstanding`,`object_query_11`.`merceologicoIngrossoAttivi` AS `merceologicoIngrossoAttivi`,`object_query_11`.`merceologicoIngrossoTurnover` AS `merceologicoIngrossoTurnover`,`object_query_11`.`merceologicoIngrossoOutstanding` AS `merceologicoIngrossoOutstanding`,`object_query_11`.`merceologicoServiziAttivi` AS `merceologicoServiziAttivi`,`object_query_11`.`merceologicoServiziTurnover` AS `merceologicoServiziTurnover`,`object_query_11`.`merceologicoServiziOutstanding` AS `merceologicoServiziOutstanding`,`object_query_11`.`merceologicoTrasportiAttivi` AS `merceologicoTrasportiAttivi`,`object_query_11`.`merceologicoTrasportiTurnover` AS `merceologicoTrasportiTurnover`,`object_query_11`.`merceologicoTrasportiOutstanding` AS `merceologicoTrasportiOutstanding`,`object_query_11`.`merceologicoDettaglioAttivi` AS `merceologicoDettaglioAttivi`,`object_query_11`.`merceologicoDettaglioTurnover` AS `merceologicoDettaglioTurnover`,`object_query_11`.`merceologicoDettaglioOutstanding` AS `merceologicoDettaglioOutstanding`,`object_query_11`.`merceologicoCostruzioniAttivi` AS `merceologicoCostruzioniAttivi`,`object_query_11`.`merceologicoCostruzioniTurnover` AS `merceologicoCostruzioniTurnover`,`object_query_11`.`merceologicoCostruzioniOutstanding` AS `merceologicoCostruzioniOutstanding`,`object_query_11`.`merceologicoAltroAttivi` AS `merceologicoAltroAttivi`,`object_query_11`.`merceologicoAltroTurnover` AS `merceologicoAltroTurnover`,`object_query_11`.`merceologicoAltroOutstanding` AS `merceologicoAltroOutstanding`,`object_query_11`.`merceologicoCedentiEsteriAttivi` AS `merceologicoCedentiEsteriAttivi`,`object_query_11`.`merceologicoCedentiEsteriTurnover` AS `merceologicoCedentiEsteriTurnover`,`object_query_11`.`merceologicoCedentiEsteriOutstanding` AS `merceologicoCedentiEsteriOutstanding`,`object_query_11`.`merceologicoNonClassificatiAttivi` AS `merceologicoNonClassificatiAttivi`,`object_query_11`.`merceologicoNonClassificatiTurnover` AS `merceologicoNonClassificatiTurnover`,`object_query_11`.`merceologicoNonClassificatiOutstanding` AS `merceologicoNonClassificatiOutstanding`,`object_query_11`.`interessiAttivi` AS `interessiAttivi`,`object_query_11`.`interessiAnticipiCedente` AS `interessiAnticipiCedente`,`object_query_11`.`interessiDilazioneDebitore` AS `interessiDilazioneDebitore`,`object_query_11`.`interessiDiMora` AS `interessiDiMora`,`object_query_11`.`numeriComputisticiFactoring` AS `numeriComputisticiFactoring`,`object_query_11`.`numeriComputisticiAnticipi` AS `numeriComputisticiAnticipi`,`object_query_11`.`numeriComputisticiDilazione` AS `numeriComputisticiDilazione`,`object_query_11`.`commissioniAttivePerFactoring` AS `commissioniAttivePerFactoring`,`object_query_11`.`commissioniPerFactoring` AS `commissioniPerFactoring`,`object_query_11`.`altriOneri` AS `altriOneri`,`object_query_11`.`interessiPassiviGestionali` AS `interessiPassiviGestionali`,`object_query_11`.`commissioniPassive` AS `commissioniPassive`,`object_query_11`.`lordeEsposizioni` AS `lordeEsposizioni`,`object_query_11`.`lordeEsposizioniBonis` AS `lordeEsposizioniBonis`,`object_query_11`.`lordeEsposizioniScadute` AS `lordeEsposizioniScadute`,`object_query_11`.`lordeInadempienze` AS `lordeInadempienze`,`object_query_11`.`lordeSofferenze` AS `lordeSofferenze`,`object_query_11`.`rettifiche` AS `rettifiche`,`object_query_11`.`rettificheEsposizioniBonis` AS `rettificheEsposizioniBonis`,`object_query_11`.`rettificheEsposizioniScadute` AS `rettificheEsposizioniScadute`,`object_query_11`.`rettificheInadempienze` AS `rettificheInadempienze`,`object_query_11`.`rettificheSofferenze` AS `rettificheSofferenze`,`object_query_11`.`nuoveRettifiche` AS `nuoveRettifiche`,`object_query_11`.`nuoveRettificheEsposizioniBonis` AS `nuoveRettificheEsposizioniBonis`,`object_query_11`.`nuoveRettificheEsposizioniScadute` AS `nuoveRettificheEsposizioniScadute`,`object_query_11`.`nuoveRettificheInadempienze` AS `nuoveRettificheInadempienze`,`object_query_11`.`nuoveRettificheSofferenze` AS `nuoveRettificheSofferenze`,`object_query_11`.`dataDiRiferimento` AS `dataDiRiferimento`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_11` join `objects` on(`objects`.`o_id` = `object_query_11`.`oo_id`)) */;

--
-- Final view structure for view `object_7`
--

/*!50001 DROP TABLE IF EXISTS `object_7`*/;
/*!50001 DROP VIEW IF EXISTS `object_7`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_7` AS select `object_query_7`.`oo_id` AS `oo_id`,`object_query_7`.`oo_classId` AS `oo_classId`,`object_query_7`.`oo_className` AS `oo_className`,`object_query_7`.`name` AS `name`,`object_query_7`.`roles` AS `roles`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_7` join `objects` on(`objects`.`o_id` = `object_query_7`.`oo_id`)) */;

--
-- Final view structure for view `object_6`
--

/*!50001 DROP TABLE IF EXISTS `object_6`*/;
/*!50001 DROP VIEW IF EXISTS `object_6`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_6` AS select `object_query_6`.`oo_id` AS `oo_id`,`object_query_6`.`oo_classId` AS `oo_classId`,`object_query_6`.`oo_className` AS `oo_className`,`object_query_6`.`active` AS `active`,`object_query_6`.`firstname` AS `firstname`,`object_query_6`.`lastname` AS `lastname`,`object_query_6`.`gender` AS `gender`,`object_query_6`.`birthdate` AS `birthdate`,`object_query_6`.`customerLanguage` AS `customerLanguage`,`object_query_6`.`street` AS `street`,`object_query_6`.`zip` AS `zip`,`object_query_6`.`city` AS `city`,`object_query_6`.`countryCode` AS `countryCode`,`object_query_6`.`email` AS `email`,`object_query_6`.`phone` AS `phone`,`object_query_6`.`profilingConsent` AS `profilingConsent`,`object_query_6`.`manualSegments` AS `manualSegments`,`object_query_6`.`calculatedSegments` AS `calculatedSegments`,`object_query_6`.`password` AS `password`,`object_query_6`.`ssoIdentities` AS `ssoIdentities`,`object_query_6`.`idEncoded` AS `idEncoded`,`object_query_6`.`userName` AS `userName`,`object_query_6`.`confirmationToken` AS `confirmationToken`,`object_query_6`.`lastLogin` AS `lastLogin`,`object_query_6`.`passwordRequestedAt` AS `passwordRequestedAt`,`object_query_6`.`groups` AS `groups`,`object_query_6`.`Aziende` AS `Aziende`,`object_query_6`.`accountConfermato` AS `accountConfermato`,`object_query_6`.`lastReset` AS `lastReset`,`object_query_6`.`commissioni` AS `commissioni`,`object_query_6`.`gruppiDiLavoro` AS `gruppiDiLavoro`,`object_query_6`.`organiAssociativi` AS `organiAssociativi`,`object_query_6`.`altriReferenti` AS `altriReferenti`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_6` join `objects` on(`objects`.`o_id` = `object_query_6`.`oo_id`)) */;

--
-- Final view structure for view `object_3`
--

/*!50001 DROP TABLE IF EXISTS `object_3`*/;
/*!50001 DROP VIEW IF EXISTS `object_3`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_3` AS select `object_query_3`.`oo_id` AS `oo_id`,`object_query_3`.`oo_classId` AS `oo_classId`,`object_query_3`.`oo_className` AS `oo_className`,`object_query_3`.`provider` AS `provider`,`object_query_3`.`identifier` AS `identifier`,`object_query_3`.`profileData` AS `profileData`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_3` join `objects` on(`objects`.`o_id` = `object_query_3`.`oo_id`)) */;

--
-- Final view structure for view `object_14`
--

/*!50001 DROP TABLE IF EXISTS `object_14`*/;
/*!50001 DROP VIEW IF EXISTS `object_14`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_14` AS select `object_query_14`.`oo_id` AS `oo_id`,`object_query_14`.`oo_classId` AS `oo_classId`,`object_query_14`.`oo_className` AS `oo_className`,`object_query_14`.`nome` AS `nome`,`object_query_14`.`utenti` AS `utenti`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_14` join `objects` on(`objects`.`o_id` = `object_query_14`.`oo_id`)) */;

--
-- Final view structure for view `object_8`
--

/*!50001 DROP TABLE IF EXISTS `object_8`*/;
/*!50001 DROP VIEW IF EXISTS `object_8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_8` AS select `object_query_8`.`oo_id` AS `oo_id`,`object_query_8`.`oo_classId` AS `oo_classId`,`object_query_8`.`oo_className` AS `oo_className`,`object_query_8`.`azienda` AS `azienda`,`object_query_8`.`codice` AS `codice`,`object_query_8`.`tipologia` AS `tipologia`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_8` join `objects` on(`objects`.`o_id` = `object_query_8`.`oo_id`)) */;

--
-- Final view structure for view `object_15`
--

/*!50001 DROP TABLE IF EXISTS `object_15`*/;
/*!50001 DROP VIEW IF EXISTS `object_15`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_15` AS select `object_query_15`.`oo_id` AS `oo_id`,`object_query_15`.`oo_classId` AS `oo_classId`,`object_query_15`.`oo_className` AS `oo_className`,`object_query_15`.`nome` AS `nome`,`object_query_15`.`utenti` AS `utenti`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_15` join `objects` on(`objects`.`o_id` = `object_query_15`.`oo_id`)) */;

--
-- Final view structure for view `object_5`
--

/*!50001 DROP TABLE IF EXISTS `object_5`*/;
/*!50001 DROP VIEW IF EXISTS `object_5`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_5` AS select `object_query_5`.`oo_id` AS `oo_id`,`object_query_5`.`oo_classId` AS `oo_classId`,`object_query_5`.`oo_className` AS `oo_className`,`object_query_5`.`code` AS `code`,`object_query_5`.`attributeType` AS `attributeType`,`object_query_5`.`label` AS `label`,`object_query_5`.`link` AS `link`,`object_query_5`.`active` AS `active`,`object_query_5`.`utm_source` AS `utm_source`,`object_query_5`.`utm_medium` AS `utm_medium`,`object_query_5`.`utm_campaign` AS `utm_campaign`,`object_query_5`.`utm_term` AS `utm_term`,`object_query_5`.`utm_content` AS `utm_content`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_5` join `objects` on(`objects`.`o_id` = `object_query_5`.`oo_id`)) */;

--
-- Final view structure for view `object_10`
--

/*!50001 DROP TABLE IF EXISTS `object_10`*/;
/*!50001 DROP VIEW IF EXISTS `object_10`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`assifact_it`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `object_10` AS select `object_query_10`.`oo_id` AS `oo_id`,`object_query_10`.`oo_classId` AS `oo_classId`,`object_query_10`.`oo_className` AS `oo_className`,`object_query_10`.`utente__id` AS `utente__id`,`object_query_10`.`utente__type` AS `utente__type`,`object_query_10`.`azienda__id` AS `azienda__id`,`object_query_10`.`azienda__type` AS `azienda__type`,`object_query_10`.`turnoverCumulativo` AS `turnoverCumulativo`,`object_query_10`.`proSoluto` AS `proSoluto`,`object_query_10`.`proSolvendo` AS `proSolvendo`,`object_query_10`.`acquistiTitoloDefinitivo` AS `acquistiTitoloDefinitivo`,`object_query_10`.`acquistiSottoNominale` AS `acquistiSottoNominale`,`object_query_10`.`acquistiCreditiIva` AS `acquistiCreditiIva`,`object_query_10`.`montecrediti` AS `montecrediti`,`object_query_10`.`montecreditiProSoluto` AS `montecreditiProSoluto`,`object_query_10`.`montecreditiProSolvendo` AS `montecreditiProSolvendo`,`object_query_10`.`montecreditiAcquistiTitoloDefinitivo` AS `montecreditiAcquistiTitoloDefinitivo`,`object_query_10`.`montecreditiAcquistiSottoNominale` AS `montecreditiAcquistiSottoNominale`,`object_query_10`.`montecreditiAcquistiCreditiIva` AS `montecreditiAcquistiCreditiIva`,`object_query_10`.`anticipiCorrispettiviPagati` AS `anticipiCorrispettiviPagati`,`object_query_10`.`anticipiCrediti` AS `anticipiCrediti`,`object_query_10`.`factoringTitoloDefinitivo` AS `factoringTitoloDefinitivo`,`object_query_10`.`anticipiAcquistiNominale` AS `anticipiAcquistiNominale`,`object_query_10`.`anticipiAcquistiCrediti` AS `anticipiAcquistiCrediti`,`object_query_10`.`supplyChainFinance` AS `supplyChainFinance`,`object_query_10`.`turnoverReverse` AS `turnoverReverse`,`object_query_10`.`mandatiPagamento` AS `mandatiPagamento`,`object_query_10`.`turnoverConfirming` AS `turnoverConfirming`,`object_query_10`.`montecreditiReverse` AS `montecreditiReverse`,`object_query_10`.`debitoriOggetto` AS `debitoriOggetto`,`object_query_10`.`dataDiRiferimento` AS `dataDiRiferimento`,`objects`.`o_id` AS `o_id`,`objects`.`o_parentId` AS `o_parentId`,`objects`.`o_type` AS `o_type`,`objects`.`o_key` AS `o_key`,`objects`.`o_path` AS `o_path`,`objects`.`o_index` AS `o_index`,`objects`.`o_published` AS `o_published`,`objects`.`o_creationDate` AS `o_creationDate`,`objects`.`o_modificationDate` AS `o_modificationDate`,`objects`.`o_userOwner` AS `o_userOwner`,`objects`.`o_userModification` AS `o_userModification`,`objects`.`o_classId` AS `o_classId`,`objects`.`o_className` AS `o_className`,`objects`.`o_childrenSortBy` AS `o_childrenSortBy`,`objects`.`o_childrenSortOrder` AS `o_childrenSortOrder`,`objects`.`o_versionCount` AS `o_versionCount` from (`object_query_10` join `objects` on(`objects`.`o_id` = `object_query_10`.`oo_id`)) */;


