import 'package:drift/drift.dart';

@DataClassName('Cliente')
class Clienti extends Table {
  IntColumn get idCliente => integer().named('idCliente').autoIncrement()();
  IntColumn get idClienteRemoto =>
      integer().named('idClienteRemoto').nullable()();
  TextColumn get codCliente => text().named('codCliente').nullable()();
  TextColumn get ragioneSociale => text().named('ragioneSociale').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 partitaIva => text().named('partitaIva').nullable()();
  TextColumn get codiceFiscale => text().named('codiceFiscale').nullable()();
  TextColumn get note => text().named('note').nullable()();
  TextColumn get noteOrdine => text().named('noteOrdine').nullable()();
  TextColumn get stato =>
      text().named('stato').withDefault(const Constant('N'))();
  IntColumn get attivo =>
      integer().named('attivo').withDefault(const Constant(1))();
  IntColumn get idPagamento => integer().named('idPagamento').nullable()();
  IntColumn get idListino => integer().named('idListino').nullable()();
  TextColumn get dataModifica => text().named('dataModifica').nullable()();
  TextColumn get sdi => text().named('sdi').nullable()();
  TextColumn get pec => text().named('pec').nullable()();
  TextColumn get altreNote => text().named('altreNote').nullable()();
  TextColumn get numeroCivico => text().named('numeroCivico').nullable()();
  TextColumn get pod => text().named('pod').nullable()();
  TextColumn get pdr => text().named('pdr').nullable()();
  TextColumn get ubicazione => text().named('ubicazione').nullable()();
  TextColumn get banca => text().named('banca').nullable()();
  TextColumn get bancaFiliale => text().named('bancaFiliale').nullable()();
  TextColumn get codBlocco => text().named('codBlocco').nullable()();
  TextColumn get creditScoreColor => text().named('creditScoreColor').nullable()();
  TextColumn get dataCreditScore => text().named('dataCreditScore').nullable()();

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