filiali.dart 1.4 KB

1234567891011121314151617181920212223242526272829
  1. import 'package:drift/drift.dart';
  2. @DataClassName('Filiale')
  3. class Filiali extends Table {
  4. IntColumn get idFiliale => integer().named('idFiliale').autoIncrement()();
  5. IntColumn get idFilialeRemoto =>
  6. integer().named('idFilialeRemoto').nullable()();
  7. IntColumn get idCliente => integer().named('idCliente').nullable()();
  8. IntColumn get idAgente => integer().named('idAgente').nullable()();
  9. TextColumn get codFiliale => text().named('codFiliale').nullable()();
  10. TextColumn get descrizione => text().named('descrizione').nullable()();
  11. TextColumn get indirizzo => text().named('indirizzo').nullable()();
  12. TextColumn get citta => text().named('citta').nullable()();
  13. TextColumn get provincia => text().named('provincia').nullable()();
  14. TextColumn get cap => text().named('cap').nullable()();
  15. TextColumn get frazione => text().named('frazione').nullable()();
  16. TextColumn get nazione => text().named('nazione').nullable()();
  17. TextColumn get telefono => text().named('telefono').nullable()();
  18. TextColumn get cellulare => text().named('cellulare').nullable()();
  19. TextColumn get fax => text().named('fax').nullable()();
  20. TextColumn get email => text().named('email').nullable()();
  21. TextColumn get stato => text().named('stato').nullable()();
  22. IntColumn get attivo =>
  23. integer().named('attivo').withDefault(const Constant(1))();
  24. TextColumn get note => text().named('note').nullable()();
  25. @override
  26. String get tableName => 'Filiali';
  27. }