import 'package:drift/drift.dart';

class ArticoliConPromo extends Table {
  IntColumn get idArticolo => integer().named('idArticolo')();
  TextColumn get codArticolo => text().named('codArticolo').nullable()();
  TextColumn get descrizione => text().named('descrizione').nullable()();
  RealColumn get prezzoBase => real().named('prezzoBase').nullable()();
  IntColumn get attivo => integer().named('attivo').nullable()();
  IntColumn get nonDisponibile =>
      integer().named('nonDisponibile').nullable()();
  IntColumn get inPromo => integer().named('inPromo').nullable()();
  RealColumn get ultimoPrezzo => real().named('ultimoPrezzo').nullable()();
  TextColumn get lastDateSold => text().named('lastDateSold').nullable()();

  @override
  Set<Column> get primaryKey => {idArticolo};

  @override
  String get tableName => 'ArticoloConPromo';

  @override
  bool get withoutRowId => true;
}