{
  "formatVersion": 1,
  "database": {
    "version": 16,
    "identityHash": "0609508b3a8434bb8d3e3cc99e766d67",
    "entities": [
      {
        "tableName": "articoli_griglia",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`articolo_griglia_id` INTEGER PRIMARY KEY AUTOINCREMENT, `cod_mart` TEXT, `descrizione` TEXT, `unt_mis` TEXT, `qta_cnf` REAL NOT NULL, `bar_code` TEXT, `merce_da_ric` REAL NOT NULL, `media_sett` REAL NOT NULL, `flag_qta_multipla` TEXT, `qta_min_ordinabile` REAL NOT NULL, `gg_scadenza` INTEGER NOT NULL, `giacenza` REAL NOT NULL, `qta_prevista_vendita` REAL NOT NULL, `qta_proposta` REAL NOT NULL, `qta_ord` REAL NOT NULL, `id_griglia` INTEGER NOT NULL, `new_no_promo` INTEGER NOT NULL, FOREIGN KEY(`id_griglia`) REFERENCES `griglie`(`griglia_id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
        "fields": [
          {
            "fieldPath": "articoloGrigliaId",
            "columnName": "articolo_griglia_id",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codMart",
            "columnName": "cod_mart",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "descrizione",
            "columnName": "descrizione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "untMis",
            "columnName": "unt_mis",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "qtaCnf",
            "columnName": "qta_cnf",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "barCode",
            "columnName": "bar_code",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "merceDaRic",
            "columnName": "merce_da_ric",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "mediaSett",
            "columnName": "media_sett",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "flagQtaMultipla",
            "columnName": "flag_qta_multipla",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "qtaMinOrdinabile",
            "columnName": "qta_min_ordinabile",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "ggScadenza",
            "columnName": "gg_scadenza",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "giacenza",
            "columnName": "giacenza",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "qtaPrevistaVendita",
            "columnName": "qta_prevista_vendita",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "qtaProposta",
            "columnName": "qta_proposta",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "qtaOrd",
            "columnName": "qta_ord",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "idGriglia",
            "columnName": "id_griglia",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "newNoPromo",
            "columnName": "new_no_promo",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "articolo_griglia_id"
          ]
        },
        "indices": [
          {
            "name": "index_articoli_griglia_id_griglia",
            "unique": false,
            "columnNames": [
              "id_griglia"
            ],
            "orders": [],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_articoli_griglia_id_griglia` ON `${TABLE_NAME}` (`id_griglia`)"
          }
        ],
        "foreignKeys": [
          {
            "table": "griglie",
            "onDelete": "CASCADE",
            "onUpdate": "NO ACTION",
            "columns": [
              "id_griglia"
            ],
            "referencedColumns": [
              "griglia_id"
            ]
          }
        ]
      },
      {
        "tableName": "griglie",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`griglia_id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cod_alis` TEXT, `descr_lisa` TEXT, `descr_depo` TEXT)",
        "fields": [
          {
            "fieldPath": "grigliaId",
            "columnName": "griglia_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "codAlis",
            "columnName": "cod_alis",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "descrLisa",
            "columnName": "descr_lisa",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "descrDepo",
            "columnName": "descr_depo",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "griglia_id"
          ]
        },
        "indices": [
          {
            "name": "index_griglie_cod_alis",
            "unique": true,
            "columnNames": [
              "cod_alis"
            ],
            "orders": [],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_griglie_cod_alis` ON `${TABLE_NAME}` (`cod_alis`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ordini",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`ordine_id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `data_ins` INTEGER, `annotazioni` TEXT, `transmitted` INTEGER NOT NULL, `transmission_date` INTEGER, `gestione` TEXT, `data_ord` INTEGER, `num_ord` INTEGER, `cod_mdep` TEXT, `id_griglia` INTEGER, `cod_alis` TEXT)",
        "fields": [
          {
            "fieldPath": "ordineId",
            "columnName": "ordine_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dataIns",
            "columnName": "data_ins",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "annotazioni",
            "columnName": "annotazioni",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "transmitted",
            "columnName": "transmitted",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "transmissionDate",
            "columnName": "transmission_date",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "gestione",
            "columnName": "gestione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataOrd",
            "columnName": "data_ord",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "numOrd",
            "columnName": "num_ord",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codMdep",
            "columnName": "cod_mdep",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "idGriglia",
            "columnName": "id_griglia",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codAlis",
            "columnName": "cod_alis",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "ordine_id"
          ]
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "articoli_ordine",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`articolo_ordine_id` INTEGER PRIMARY KEY AUTOINCREMENT, `cod_mart` TEXT, `descrizione` TEXT, `unt_mis` TEXT, `qta_cnf` REAL NOT NULL, `bar_code` TEXT, `merce_da_ric` REAL NOT NULL, `media_sett` REAL NOT NULL, `flag_qta_multipla` TEXT, `qta_min_ordinabile` REAL NOT NULL, `id_ordine` INTEGER NOT NULL, `qta_ord` REAL NOT NULL, `data_ins` INTEGER, `new_no_promo` INTEGER NOT NULL, `system_note` TEXT, `cod_alis` TEXT, FOREIGN KEY(`id_ordine`) REFERENCES `ordini`(`ordine_id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
        "fields": [
          {
            "fieldPath": "articoloOrdineId",
            "columnName": "articolo_ordine_id",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codMart",
            "columnName": "cod_mart",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "descrizione",
            "columnName": "descrizione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "untMis",
            "columnName": "unt_mis",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "qtaCnf",
            "columnName": "qta_cnf",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "barCode",
            "columnName": "bar_code",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "merceDaRic",
            "columnName": "merce_da_ric",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "mediaSett",
            "columnName": "media_sett",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "flagQtaMultipla",
            "columnName": "flag_qta_multipla",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "qtaMinOrdinabile",
            "columnName": "qta_min_ordinabile",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "idOrdine",
            "columnName": "id_ordine",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "qtaOrd",
            "columnName": "qta_ord",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "dataIns",
            "columnName": "data_ins",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "newNoPromo",
            "columnName": "new_no_promo",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "systemNote",
            "columnName": "system_note",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codAlis",
            "columnName": "cod_alis",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "articolo_ordine_id"
          ]
        },
        "indices": [
          {
            "name": "index_articoli_ordine_id_ordine",
            "unique": false,
            "columnNames": [
              "id_ordine"
            ],
            "orders": [],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_articoli_ordine_id_ordine` ON `${TABLE_NAME}` (`id_ordine`)"
          },
          {
            "name": "index_articoli_ordine_id_ordine_cod_mart",
            "unique": true,
            "columnNames": [
              "id_ordine",
              "cod_mart"
            ],
            "orders": [],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_articoli_ordine_id_ordine_cod_mart` ON `${TABLE_NAME}` (`id_ordine`, `cod_mart`)"
          }
        ],
        "foreignKeys": [
          {
            "table": "ordini",
            "onDelete": "CASCADE",
            "onUpdate": "NO ACTION",
            "columns": [
              "id_ordine"
            ],
            "referencedColumns": [
              "ordine_id"
            ]
          }
        ]
      },
      {
        "tableName": "mtb_colt",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `username` TEXT, `gestione` TEXT, `data_collo` INTEGER, `ser_collo` TEXT, `num_collo` INTEGER, `rif_ord` TEXT, `cod_anag` TEXT, `cod_vdes` TEXT, `cod_mdep` TEXT, `cod_vlis` TEXT, `cod_dtip` TEXT, `cod_tcol` TEXT, `ser_doc` TEXT, `annotazioni` TEXT, `posizione` TEXT, `cod_dtip_provv` TEXT, `ser_doc_provv` TEXT, `cod_jfas` TEXT, `data_ord` INTEGER, `data_doc` INTEGER, `data_doc_provv` INTEGER, `cod_mgrp` TEXT, `data_vers` INTEGER, `segno` INTEGER, `num_ord` INTEGER, `num_doc` INTEGER, `num_doc_provv` INTEGER)",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "username",
            "columnName": "username",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "gestione",
            "columnName": "gestione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataCollo",
            "columnName": "data_collo",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "serCollo",
            "columnName": "ser_collo",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "numCollo",
            "columnName": "num_collo",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "rifOrd",
            "columnName": "rif_ord",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codAnag",
            "columnName": "cod_anag",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codVdes",
            "columnName": "cod_vdes",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codMdep",
            "columnName": "cod_mdep",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codVlis",
            "columnName": "cod_vlis",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codDtip",
            "columnName": "cod_dtip",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codTcol",
            "columnName": "cod_tcol",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "serDoc",
            "columnName": "ser_doc",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "annotazioni",
            "columnName": "annotazioni",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "posizione",
            "columnName": "posizione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codDtipProvv",
            "columnName": "cod_dtip_provv",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "serDocProvv",
            "columnName": "ser_doc_provv",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codJfas",
            "columnName": "cod_jfas",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataOrd",
            "columnName": "data_ord",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "dataDoc",
            "columnName": "data_doc",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "dataDocProvv",
            "columnName": "data_doc_provv",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codMgrp",
            "columnName": "cod_mgrp",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataVers",
            "columnName": "data_vers",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "segno",
            "columnName": "segno",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "numOrd",
            "columnName": "num_ord",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "numDoc",
            "columnName": "num_doc",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "numDocProvv",
            "columnName": "num_doc_provv",
            "affinity": "INTEGER",
            "notNull": false
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "id"
          ]
        },
        "indices": [
          {
            "name": "index_mtb_colt_data_collo_ser_collo_num_collo_gestione",
            "unique": true,
            "columnNames": [
              "data_collo",
              "ser_collo",
              "num_collo",
              "gestione"
            ],
            "orders": [],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_mtb_colt_data_collo_ser_collo_num_collo_gestione` ON `${TABLE_NAME}` (`data_collo`, `ser_collo`, `num_collo`, `gestione`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "mtb_colr",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `id_collo` INTEGER NOT NULL, `data_collo` INTEGER, `gestione` TEXT, `ser_collo` TEXT, `descrizione` TEXT, `num_collo` INTEGER, `riga` INTEGER, `riga_ord` INTEGER, `cod_mart` TEXT, `cod_barre` TEXT, `cod_col` TEXT, `cod_tagl` TEXT, `partita_mag` TEXT, `gestione_rif` TEXT, `ser_collo_rif` TEXT, `note` TEXT, `data_ord` INTEGER, `data_collo_rif` INTEGER, `qta_cnf` REAL, `qta_col` REAL, `num_ord` INTEGER, `num_etich` INTEGER, `num_collo_rif` INTEGER, `datetime_row` INTEGER, `cod_jcom` TEXT, `num_cnf` REAL, `causale` TEXT, `utente` TEXT, `cod_anag_doc` TEXT, `cod_dtip_doc` TEXT, `data_doc` INTEGER, `ser_doc` TEXT, `num_doc` INTEGER, `id_riga_doc` INTEGER, `unt_mis` TEXT, `data_scad` INTEGER, FOREIGN KEY(`id_collo`) REFERENCES `mtb_colt`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "idCollo",
            "columnName": "id_collo",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dataCollo",
            "columnName": "data_collo",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "gestione",
            "columnName": "gestione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "serCollo",
            "columnName": "ser_collo",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "descrizione",
            "columnName": "descrizione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "numCollo",
            "columnName": "num_collo",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "riga",
            "columnName": "riga",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "rigaOrd",
            "columnName": "riga_ord",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codMart",
            "columnName": "cod_mart",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codBarre",
            "columnName": "cod_barre",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codCol",
            "columnName": "cod_col",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codTagl",
            "columnName": "cod_tagl",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "partitaMag",
            "columnName": "partita_mag",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "gestioneRif",
            "columnName": "gestione_rif",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "serColloRif",
            "columnName": "ser_collo_rif",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "note",
            "columnName": "note",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataOrd",
            "columnName": "data_ord",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "dataColloRif",
            "columnName": "data_collo_rif",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "qtaCnf",
            "columnName": "qta_cnf",
            "affinity": "REAL",
            "notNull": false
          },
          {
            "fieldPath": "qtaCol",
            "columnName": "qta_col",
            "affinity": "REAL",
            "notNull": false
          },
          {
            "fieldPath": "numOrd",
            "columnName": "num_ord",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "numEtich",
            "columnName": "num_etich",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "numColloRif",
            "columnName": "num_collo_rif",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "datetimeRow",
            "columnName": "datetime_row",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codJcom",
            "columnName": "cod_jcom",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "numCnf",
            "columnName": "num_cnf",
            "affinity": "REAL",
            "notNull": false
          },
          {
            "fieldPath": "causale",
            "columnName": "causale",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "utente",
            "columnName": "utente",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codAnagDoc",
            "columnName": "cod_anag_doc",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codDtipDoc",
            "columnName": "cod_dtip_doc",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataDoc",
            "columnName": "data_doc",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "serDoc",
            "columnName": "ser_doc",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "numDoc",
            "columnName": "num_doc",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "idRigaDoc",
            "columnName": "id_riga_doc",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "untMis",
            "columnName": "unt_mis",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataScad",
            "columnName": "data_scad",
            "affinity": "INTEGER",
            "notNull": false
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "id"
          ]
        },
        "indices": [
          {
            "name": "index_mtb_colr_data_collo_ser_collo_num_collo_gestione_riga",
            "unique": true,
            "columnNames": [
              "data_collo",
              "ser_collo",
              "num_collo",
              "gestione",
              "riga"
            ],
            "orders": [],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_mtb_colr_data_collo_ser_collo_num_collo_gestione_riga` ON `${TABLE_NAME}` (`data_collo`, `ser_collo`, `num_collo`, `gestione`, `riga`)"
          },
          {
            "name": "index_mtb_colr_id_collo",
            "unique": false,
            "columnNames": [
              "id_collo"
            ],
            "orders": [],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_mtb_colr_id_collo` ON `${TABLE_NAME}` (`id_collo`)"
          }
        ],
        "foreignKeys": [
          {
            "table": "mtb_colt",
            "onDelete": "CASCADE",
            "onUpdate": "NO ACTION",
            "columns": [
              "id_collo"
            ],
            "referencedColumns": [
              "id"
            ]
          }
        ]
      },
      {
        "tableName": "inventari",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`_id` INTEGER PRIMARY KEY AUTOINCREMENT, `id_inventario` INTEGER, `cod_mdep` TEXT NOT NULL, `data_inventario` INTEGER, `data_reg` INTEGER, `data_ver` INTEGER, `filtro` TEXT, `flag_stato` TEXT, `flag_operazione` TEXT, `cod_anag` TEXT, `cod_dtip` TEXT, `inserito_da` TEXT, `registrato_da` TEXT, `verificato_da` TEXT, `data_ora_inizio` INTEGER, `data_ora_fine` INTEGER, `causale` TEXT, `zona` TEXT, `new` INTEGER, `remote_sync_date` INTEGER)",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "_id",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "idInventario",
            "columnName": "id_inventario",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codMdep",
            "columnName": "cod_mdep",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "dataInventario",
            "columnName": "data_inventario",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "dataReg",
            "columnName": "data_reg",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "dataVer",
            "columnName": "data_ver",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "filtro",
            "columnName": "filtro",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "flagStato",
            "columnName": "flag_stato",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "flagOperazione",
            "columnName": "flag_operazione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codAnag",
            "columnName": "cod_anag",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "codDtip",
            "columnName": "cod_dtip",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "inseritoDa",
            "columnName": "inserito_da",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "registratoDa",
            "columnName": "registrato_da",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "verificatoDa",
            "columnName": "verificato_da",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dataOraInizio",
            "columnName": "data_ora_inizio",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "dataOraFine",
            "columnName": "data_ora_fine",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "causale",
            "columnName": "causale",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "zona",
            "columnName": "zona",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "isNew",
            "columnName": "new",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "remoteSyncDate",
            "columnName": "remote_sync_date",
            "affinity": "INTEGER",
            "notNull": false
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "_id"
          ]
        },
        "indices": [
          {
            "name": "index_inventari__id",
            "unique": false,
            "columnNames": [
              "_id"
            ],
            "orders": [],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_inventari__id` ON `${TABLE_NAME}` (`_id`)"
          },
          {
            "name": "index_inventari_id_inventario",
            "unique": false,
            "columnNames": [
              "id_inventario"
            ],
            "orders": [],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_inventari_id_inventario` ON `${TABLE_NAME}` (`id_inventario`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "inventario_rows",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`_id` INTEGER PRIMARY KEY AUTOINCREMENT, `parent_id` INTEGER, `cod_mart` TEXT, `partita_mag` TEXT, `descrizione` TEXT, `qta` REAL NOT NULL DEFAULT 0, `num_cnf` REAL NOT NULL DEFAULT 0, `qta_cnf` REAL NOT NULL DEFAULT 0, `unt_mis` TEXT NOT NULL DEFAULT '0', `data_ora_inv` INTEGER, `scan_cod_barre` TEXT, `zona` TEXT, `remote_sync_date` INTEGER, FOREIGN KEY(`parent_id`) REFERENCES `inventari`(`_id`) ON UPDATE NO ACTION ON DELETE NO ACTION )",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "_id",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "parentId",
            "columnName": "parent_id",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "codMart",
            "columnName": "cod_mart",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "partitaMag",
            "columnName": "partita_mag",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "descrizione",
            "columnName": "descrizione",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "qta",
            "columnName": "qta",
            "affinity": "REAL",
            "notNull": true,
            "defaultValue": "0"
          },
          {
            "fieldPath": "numConf",
            "columnName": "num_cnf",
            "affinity": "REAL",
            "notNull": true,
            "defaultValue": "0"
          },
          {
            "fieldPath": "qtaConf",
            "columnName": "qta_cnf",
            "affinity": "REAL",
            "notNull": true,
            "defaultValue": "0"
          },
          {
            "fieldPath": "untMis",
            "columnName": "unt_mis",
            "affinity": "TEXT",
            "notNull": true,
            "defaultValue": "'0'"
          },
          {
            "fieldPath": "dataOraInv",
            "columnName": "data_ora_inv",
            "affinity": "INTEGER",
            "notNull": false
          },
          {
            "fieldPath": "scanCodBarre",
            "columnName": "scan_cod_barre",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "zona",
            "columnName": "zona",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "remoteSyncDate",
            "columnName": "remote_sync_date",
            "affinity": "INTEGER",
            "notNull": false
          }
        ],
        "primaryKey": {
          "autoGenerate": true,
          "columnNames": [
            "_id"
          ]
        },
        "indices": [
          {
            "name": "index_inventario_rows__id",
            "unique": false,
            "columnNames": [
              "_id"
            ],
            "orders": [],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_inventario_rows__id` ON `${TABLE_NAME}` (`_id`)"
          },
          {
            "name": "index_inventario_rows_parent_id",
            "unique": false,
            "columnNames": [
              "parent_id"
            ],
            "orders": [],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_inventario_rows_parent_id` ON `${TABLE_NAME}` (`parent_id`)"
          }
        ],
        "foreignKeys": [
          {
            "table": "inventari",
            "onDelete": "NO ACTION",
            "onUpdate": "NO ACTION",
            "columns": [
              "parent_id"
            ],
            "referencedColumns": [
              "_id"
            ]
          }
        ]
      }
    ],
    "views": [],
    "setupQueries": [
      "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
      "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, '0609508b3a8434bb8d3e3cc99e766d67')"
    ]
  }
}