import 'package:drift/drift.dart';

@DataClassName('Agente')
class Agenti extends Table {
  IntColumn get idAgente => integer().autoIncrement()();
  TextColumn get codAgente => text().named('codAgente')();
  TextColumn get ragioneSociale => text().named('ragioneSociale').nullable()();
  TextColumn get pwd => text().named('pwd').nullable()();
  TextColumn get telefono => text().named('telefono').nullable()();
  TextColumn get cellulare => text().named('cellulare').nullable()();
  TextColumn get email => text().named('email').nullable()();
  TextColumn get indirizzo => text().named('indirizzo').nullable()();
  TextColumn get citta => text().named('citta').nullable()();
  TextColumn get cap => text().named('cap').nullable()();
  TextColumn get provincia => text().named('provincia').nullable()();
  TextColumn get frazione => text().named('frazione').nullable()();
  IntColumn get attivo => integer().named('attivo').withDefault(const Constant(1))();
  IntColumn get modificaPrezzi => integer().named('modificaPrezzi').nullable()();
  TextColumn get capoArea => text().named('capoArea').nullable()();

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