import 'package:drift/drift.dart';

@DataClassName('Articolo')
class Articoli extends Table {
  IntColumn get idArticolo => integer().named('idArticolo').autoIncrement()();
  IntColumn get posizione => integer().named('posizione').nullable()();
  TextColumn get codArticolo => text().named('codArticolo')();
  TextColumn get descrizione => text().named('descrizione').nullable()();
  TextColumn get ean => text().named('ean').nullable()();
  IntColumn get idIva => integer().named('idIva').nullable()();
  IntColumn get idClassifica1 => integer().named('idClassifica1').nullable()();
  IntColumn get idClassifica2 => integer().named('idClassifica2').nullable()();
  IntColumn get idClassifica3 => integer().named('idClassifica3').nullable()();
  IntColumn get idClassifica4 => integer().named('idClassifica4').nullable()();
  RealColumn get peso => real().named('peso').nullable()();
  RealColumn get giacenza => real().named('giacenza').nullable()();
  TextColumn get unitaMisura => text().named('unitaMisura').nullable()();
  IntColumn get attivo =>
      integer().named('attivo').withDefault(const Constant(1))();
  IntColumn get nonDisponibile =>
      integer().named('nonDisponibile').nullable()();
  RealColumn get pezziConfezione =>
      real().named('pezziConfezione').nullable()();
  TextColumn get fileFoto => text().named('fileFoto').nullable()();
  TextColumn get schedaProdotto => text().named('schedaProdotto').nullable()();
  TextColumn get prezzoBase => text().named('prezzoBase').nullable()();
  TextColumn get stato => text().named('stato').nullable()();
  TextColumn get dataModifica => text().named('dataModifica').nullable()();
  TextColumn get gruppo => text().named('gruppo').nullable()();
  TextColumn get categoria => text().named('categoria').nullable()();
  TextColumn get colliPerStrato => text().named('colliPerStrato').nullable()();
  TextColumn get stratiPerPallet =>
      text().named('stratiPerPallet').nullable()();

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