-
Notifications
You must be signed in to change notification settings - Fork 0
mapping table observations_new
MaschaRobota edited this page Jul 21, 2022
·
2 revisions
Dimensionstabelle observations_new
Spaltenname | Datentyp | Eigenschaften | Quelldatenbank | Quelltabelle | Quellspalte |
---|---|---|---|---|---|
OBSERVATION_ID | INT | PRIMARY KEY | Datenbanktabellen | AUTOINCREMENT | -- |
DATE | NVARCHAR(20) | NOT NULL | Datenbanktabellen | observations | DATE |
PATIENT | NVARCHAR(36) | FOREIGN KEY, NOT NULL | Datenbanktabellen | patients_new | Id |
ENCOUNTER | NVARCHAR(50) | NOT NULL | Datenbanktabellen | observations | ENCOUNTER |
CODE | INT | NOT NULL | Datenbanktabellen | observations | CODE |
DESCRIPTION | NVARCHAR(256) | NOT NULL | Datenbanktabellen | observations | DESCRIPTION |
VALUE | FLOAT | NOT NULL | Datenbanktabellen | observations | VALUE |
UNITS | NVARCHAR(10) | NOT NULL | Datenbanktabellen | observations | UNITS |
TYPE | NVARCHAR(10) | NOT NULL | Datenbanktabellen | observations | TYPE |