mapping table procedures_new - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
Dimensionstabelle procedures_new
Spaltenname | Datentyp | Eigenschaften | Quelldatenbank | Quelltabelle | Quellspalte |
---|---|---|---|---|---|
PROCEDURES_ID | INT | PRIMARY KEY | Datenbanktabellen | AUTOINCREMENT | -- |
DATE | NVARCHAR(20) | NOT NULL | Datenbanktabellen | procedures | DATA |
PATIENT | NVARCHAR(36) | FOREIGN KEY, NOT NULL | Datenbanktabellen | patients_new | Id |
ENCOUNTER | NVARCHAR(50) | NOT NULL | Datenbanktabellen | procedures | ENCOUNTER |
CODE | INT | NOT NULL | Datenbanktabellen | procedures | CODE |
DESCRIPTION | NVARCHAR(256) | NOT NULL | Datenbanktabellen | procedures | DESCRIPTION |
BASE_COST | FLOAT | NOT NULL | Datenbanktabellen | procedures | BASE_COST |
REASONCODE | FLOAT | NOT NULL | Datenbanktabellen | procedures | REASONCODE |
REASONDESCRIPTION | NVARCHAR(50) | NOT NULL | Datenbanktabellen | procedures | REASONDESCRIPTION |