articoli.dart 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. import 'package:drift/drift.dart';
  2. @DataClassName('Articolo')
  3. class Articoli extends Table {
  4. IntColumn get idArticolo => integer().named('idArticolo').autoIncrement()();
  5. IntColumn get posizione => integer().named('posizione').nullable()();
  6. TextColumn get codArticolo => text().named('codArticolo')();
  7. TextColumn get descrizione => text().named('descrizione').nullable()();
  8. TextColumn get ean => text().named('ean').nullable()();
  9. IntColumn get idIva => integer().named('idIva').nullable()();
  10. IntColumn get idClassifica1 => integer().named('idClassifica1').nullable()();
  11. IntColumn get idClassifica2 => integer().named('idClassifica2').nullable()();
  12. IntColumn get idClassifica3 => integer().named('idClassifica3').nullable()();
  13. IntColumn get idClassifica4 => integer().named('idClassifica4').nullable()();
  14. RealColumn get peso => real().named('peso').nullable()();
  15. RealColumn get giacenza => real().named('giacenza').nullable()();
  16. TextColumn get unitaMisura => text().named('unitaMisura').nullable()();
  17. IntColumn get attivo =>
  18. integer().named('attivo').withDefault(const Constant(1))();
  19. IntColumn get nonDisponibile =>
  20. integer().named('nonDisponibile').nullable()();
  21. RealColumn get pezziConfezione =>
  22. real().named('pezziConfezione').nullable()();
  23. TextColumn get fileFoto => text().named('fileFoto').nullable()();
  24. TextColumn get schedaProdotto => text().named('schedaProdotto').nullable()();
  25. TextColumn get prezzoBase => text().named('prezzoBase').nullable()();
  26. TextColumn get stato => text().named('stato').nullable()();
  27. TextColumn get dataModifica => text().named('dataModifica').nullable()();
  28. TextColumn get gruppo => text().named('gruppo').nullable()();
  29. TextColumn get categoria => text().named('categoria').nullable()();
  30. TextColumn get colliPerStrato => text().named('colliPerStrato').nullable()();
  31. TextColumn get stratiPerPallet =>
  32. text().named('stratiPerPallet').nullable()();
  33. @override
  34. String get tableName => 'Articoli';
  35. }