import 'package:drift/drift.dart';

@DataClassName('Filiale')
class Filiali extends Table {
  IntColumn get idFiliale => integer().autoIncrement()();
  IntColumn get idFilialeRemoto => integer().named('idFilialeRemoto').nullable()();
  IntColumn get idCliente => integer().named('idCliente').nullable()();
  IntColumn get idAgente => integer().named('idAgente').nullable()();
  TextColumn get codFiliale => text().named('codFiliale').nullable()();
  TextColumn get descrizione => text().named('descrizione').nullable()();
  TextColumn get indirizzo => text().named('indirizzo').nullable()();
  TextColumn get citta => text().named('citta').nullable()();
  TextColumn get provincia => text().named('provincia').nullable()();
  TextColumn get cap => text().named('cap').nullable()();
  TextColumn get frazione => text().named('frazione').nullable()();
  TextColumn get nazione => text().named('nazione').nullable()();
  TextColumn get telefono => text().named('telefono').nullable()();
  TextColumn get cellulare => text().named('cellulare').nullable()();
  TextColumn get fax => text().named('fax').nullable()();
  TextColumn get email => text().named('email').nullable()();
  TextColumn get stato => text().named('stato').nullable()();
  IntColumn get attivo => integer().named('attivo').withDefault(const Constant(1))();
  TextColumn get note => text().named('note').nullable()();

  @override
  String get tableName => 'Filiali';
}