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 Default(Sat):
patient_nummer = Columns.TextColumn(
) # dit staat niet zo in FHIR, hier geplaatst voor het testen.
# active = Columns.BoolColumn() # patient record active?
# gender = Columns.RefColumn(RefTypes.geslacht_types)
birthdate = Columns.DateColumn()
gender = Columns.TextColumn(
default_value=AbstractPerson.GenderTypes.unknown)
deceased_boolean = Columns.BoolColumn()
deceased_datetime = Columns.DateTimeColumn()
extra = Columns.JsonColumn()
extra2 = Columns.JsonColumn()
multiple_birth_boolean = Columns.BoolColumn()
multiple_birth_integer = Columns.IntColumn()
class Default(Sat):
start = Columns.DateTimeColumn()
eind = Columns.DateTimeColumn('sluit_datum')
status = Columns.TextColumn()
class Default(Sat):
naam = Columns.TextColumn()
start = Columns.DateTimeColumn()
eind = Columns.DateTimeColumn('sluit_datum')
nummer = Columns.IntColumn()
status = Columns.TextColumn()
class Inschrijving(Sat):
bsn = Columns.TextColumn()
inschrijfnummer = Columns.TextColumn()
inschrijfdatum = Columns.DateTimeColumn()
class Default(Sat):
naam = Columns.TextColumn()
dbc_activiteit_code = Columns.TextColumn()
datum = Columns.DateTimeColumn()
class Currentversion(AbstractOrderderTable):
__dbschema__ = 'sys'
schemaname = Columns.TextColumn(pk=True, unique=True)
version = Columns.FloatColumn(unique=True)
date = Columns.DateTimeColumn()
