clienti.dart 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. import 'package:drift/drift.dart';
  2. @DataClassName('Cliente')
  3. class Clienti extends Table {
  4. IntColumn get idCliente => integer().named('idCliente').autoIncrement()();
  5. IntColumn get idClienteRemoto =>
  6. integer().named('idClienteRemoto').nullable()();
  7. TextColumn get codCliente => text().named('codCliente').nullable()();
  8. TextColumn get ragioneSociale => text().named('ragioneSociale').nullable()();
  9. TextColumn get indirizzo => text().named('indirizzo').nullable()();
  10. TextColumn get citta => text().named('citta').nullable()();
  11. TextColumn get provincia => text().named('provincia').nullable()();
  12. TextColumn get cap => text().named('cap').nullable()();
  13. TextColumn get frazione => text().named('frazione').nullable()();
  14. TextColumn get nazione => text().named('nazione').nullable()();
  15. TextColumn get telefono => text().named('telefono').nullable()();
  16. TextColumn get cellulare => text().named('cellulare').nullable()();
  17. TextColumn get fax => text().named('fax').nullable()();
  18. TextColumn get email => text().named('email').nullable()();
  19. TextColumn get partitaIva => text().named('partitaIva').nullable()();
  20. TextColumn get codiceFiscale => text().named('codiceFiscale').nullable()();
  21. TextColumn get note => text().named('note').nullable()();
  22. TextColumn get noteOrdine => text().named('noteOrdine').nullable()();
  23. TextColumn get stato =>
  24. text().named('stato').withDefault(const Constant('N'))();
  25. IntColumn get attivo =>
  26. integer().named('attivo').withDefault(const Constant(1))();
  27. IntColumn get idPagamento => integer().named('idPagamento').nullable()();
  28. IntColumn get idListino => integer().named('idListino').nullable()();
  29. TextColumn get dataModifica => text().named('dataModifica').nullable()();
  30. TextColumn get sdi => text().named('sdi').nullable()();
  31. TextColumn get pec => text().named('pec').nullable()();
  32. TextColumn get altreNote => text().named('altreNote').nullable()();
  33. TextColumn get numeroCivico => text().named('numeroCivico').nullable()();
  34. TextColumn get pod => text().named('pod').nullable()();
  35. TextColumn get pdr => text().named('pdr').nullable()();
  36. TextColumn get ubicazione => text().named('ubicazione').nullable()();
  37. TextColumn get banca => text().named('banca').nullable()();
  38. TextColumn get bancaFiliale => text().named('bancaFiliale').nullable()();
  39. TextColumn get codBlocco => text().named('codBlocco').nullable()();
  40. TextColumn get creditScoreColor => text().named('creditScoreColor').nullable()();
  41. TextColumn get dataCreditScore => text().named('dataCreditScore').nullable()();
  42. @override
  43. String get tableName => 'Clienti';
  44. }