mapping table observations_new - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
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 |