mapping table conditions_new - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
Dimensionstabelle conditions_new :
Spaltenname | Datentyp | Eigenschaften | Quelldatenbank | Quelltabelle | Quellspalte |
---|---|---|---|---|---|
CONDITIONS_ID | INT | PRIMARY KEY | Datenbanktabellen | AUTOINCREMENT | -- |
START | DATE | NOT NULL | Datenbanktabellen | conditions | START |
STOP | DATE | DEFAULT NULL | Datenbanktabellen | conditions | STOP |
PATIENT | NVARCHAR(36) | FOREIGN KEY, NOT NULL | Datenbanktabellen | patients_new | Id |
ENCOUNTER | NVARCHAR(50) | NOT NULL | Datenbanktabellen | conditions | ENCOUNTER |
CODE | INT | NOT NULL | Datenbanktabellen | conditions | CODE |
DESCRIPTION | NVARCHAR(256) | NOT NULL | Datenbanktabellen | conditions | DESCRIPTION |