mapping patient_careplans - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
Faktentabelle patient_careplans :
| Spaltenname | Datentyp | Eigenschaften | Quelltabelle | Quellspalte |
|---|---|---|---|---|
| CAREPLAN_ID | INT | -- | -- | AUTOINCREMENT |
| PATIENT_ID | INT | FOREIGN KEY, NOT NULL | patients_new | Id |
| CONDITIONS_ID | INT | FOREIGN KEY, NOT NULL | conditions_new | CONDITIONS_ID |
| CARE_TYPE | NVARCHAR(20) | name der Tabelle | -- | -- |
| TABLE_ID | INT | FOREIGN KEY, NOT NULL | procedures_new, medications_new, observations_new | PROCEDURES_ID, MEDICATIONS_ID, OBSERVATIONS_ID |