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 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()
