import 'package:drift/drift.dart';

@DataClassName('ListinoCliente')
class ListiniCliente extends Table {
  IntColumn get idListinoCliente =>
      integer().named('idListinoCliente').autoIncrement()();
  IntColumn get idListino => integer().named('idListino').nullable()();
  IntColumn get idCliente => integer().named('idCliente').nullable()();
  IntColumn get idArticolo => integer().named('idArticolo').nullable()();
  IntColumn get idSconto => integer().named('idSconto').nullable()();
  TextColumn get validoDa => text().named('validoDa').nullable()();
  TextColumn get validoA => text().named('validoA').nullable()();
  RealColumn get prezzo => real().named('prezzo').nullable()();
  IntColumn get attivo =>
      integer().named('attivo').withDefault(const Constant(1))();
  TextColumn get annullato =>
      text().named('annullato').withDefault(const Constant('N'))();
  TextColumn get listinoSostitutivo =>
      text().named('listinoSostitutivo').nullable()();
  TextColumn get stato => text().named('stato').nullable()();

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