import 'package:drift/drift.dart';

/*
create view v_righe_ordine as
select ro.*, a.codArticolo, a.descrizione, l.codListino, l.descrizione Listino
from righe_ordine ro
join articoli a on a.idarticolo = ro.idarticolo
left JOIN Listini l on l.idlistino = ro.idlistino
*/
class VRigheOrdine extends Table {
  IntColumn get idRigaOrdine => integer().named('idRigaOrdine')();
  IntColumn get idOrdine => integer().named('idOrdine').nullable()();
  IntColumn get idArticolo => integer().named('idArticolo').nullable()();
  IntColumn get idListino => integer().named('idListino').nullable()();
  RealColumn get quantita => real().named('quantita').nullable()();
  RealColumn get prezzoLordo => real().named('prezzoLordo').nullable()();
  RealColumn get sconto1 => real().named('sconto1').nullable()();
  RealColumn get sconto2 => real().named('sconto2').nullable()();
  RealColumn get sconto3 => real().named('sconto3').nullable()();
  RealColumn get sconto4 => real().named('sconto4').nullable()();
  RealColumn get sconto5 => real().named('sconto5').nullable()();
  RealColumn get prezzoNetto => real().named('prezzoNetto').nullable()();
  RealColumn get scontoMerce => real().named('scontoMerce').nullable()();
  RealColumn get totale => real().named('totale').nullable()();
  TextColumn get dataConsegna => text().named('dataConsegna').nullable()();
  TextColumn get dataModifica => text().named('dataModifica').nullable()();
  RealColumn get qtaEvasa => real().named('qtaEvasa').nullable()();
  TextColumn get stato => text().named('stato').nullable()();
  RealColumn get colli => real().named('colli').nullable()();
  IntColumn get promozione => integer().named('promozione').nullable()();
  IntColumn get rigaPromozione => integer().named('rigaPromozione').nullable()();
  IntColumn get prezzoManuale => integer().named('prezzoManuale').nullable()();

  TextColumn get codArticolo => text().named('codArticolo').nullable()();
  TextColumn get descrizione => text().named('descrizione').nullable()();
  TextColumn get codListino => text().named('codListino').nullable()();
  TextColumn get listino => text().named('Listino').nullable()();

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

  @override
  String get tableName => 'v_righe_ordine';

  @override
  bool get withoutRowId => true;
}