class Runs(AbstractOrderderTable):
__dbschema__ = 'sys'
runid = Columns.FloatColumn(pk=True)
rundate = Columns.DateTimeColumn(nullable=False)
finish_date = Columns.DateTimeColumn(indexed=True)
exceptions = Columns.BoolColumn()
sor_versions = Columns.TextColumn()
dv_version = Columns.FloatColumn()
pyelt_version = Columns.TextColumn()
class Default(Sat):
text = Columns.TextColumn()
date = Columns.DateColumn()
datetime = Columns.DateTimeColumn()
int = Columns.IntColumn()
float = Columns.FloatColumn()
ref = Columns.RefColumn('types')
class DvValueset(AbstractOrderderTable):
__dbschema__ = 'valset'
_id = Columns.SerialColumn()
_runid = Columns.FloatColumn()
_source_system = Columns.TextColumn()
_valid = Columns.BoolColumn()
_validation_msg = Columns.TextColumn()
_insert_date = Columns.DateTimeColumn()
_finish_date = Columns.TextColumn()
_active = Columns.BoolColumn(default_value=True, indexed=True)
_revision = Columns.IntColumn()
valueset_naam = Columns.TextColumn(unique=True)
code = Columns.TextColumn(unique=True, indexed=True)
omschrijving = Columns.TextColumn()
class Financieel(Sat):
kostprijs = Columns.FloatColumn()
vraagprijs = Columns.FloatColumn()
korting = Columns.FloatColumn()
btw = Columns.FloatColumn()
class Currentversion(AbstractOrderderTable):
__dbschema__ = 'sys'
schemaname = Columns.TextColumn(pk=True, unique=True)
version = Columns.FloatColumn(unique=True)
date = Columns.DateTimeColumn()
