mapping table Gesamt - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
Dimensionstabelle patients_new
Spaltenname | Datentyp | Eigenschaften | Quelldatenbank | Quelltabelle | Quellspalte |
---|---|---|---|---|---|
Id | NVARCHAR(36) | PRIMARY KEY | Datenbanktabellen | patients | Id |
BIRTHDATE_YEAR | DATE | DEFAULT NULL | Datenbanktabellen | patients | YEAR(BIRTHDATE) |
DEATHDATE | DATE | DEFAULT NULL | Datenbanktabellen | patients | DEATHDATE |
SSN | NVARCHAR(50) | DEFAULT NULL | Datenbanktabellen | patients | SSN |
SUFFIX | NVARCHAR(10) | DEFAULT NULL | Datenbanktabellen | patients | SUFFIX |
MAIDEN | NVARCHAR(50) | DEFAULT NULL | Datenbanktabellen | patients | MAIDEN |
MARITAL | CHAR(1) | DEFAULT NULL | Datenbanktabellen | patients | MARITAL |
RACE | NVARCHAR(10) | DEFAULT NULL | Datenbanktabellen | patients | RACE |
ETHNICITY | NVARCHAR(50) | DEFAULT NULL | Datenbanktabellen | patients | ETHNICITY |
GENDER | CHAR(1) | DEFAULT NULL | Datenbanktabellen | patients | GENDER |
BIRTHPLACE | NVARCHAR(50) | DEFAULT NULL | Datenbanktabellen | patients | BIRTHPLACE |
CITY | NVARCHAR(50) | DEFAULT NULL | Datenbanktabellen | patients | CITY |
STATE | NVARCHAR(50) | DEFAULT NULL | Datenbanktabellen | patients | STATE |
COUNTRY | NVARCHAR(50) | DEFAULT NULL | Datenbanktabellen | patients | COUNTRY |
ZIP | NVARCHAR(4) | DEFAULT NULL | Datenbanktabellen | patients | ZIP |
HEALTHCARE_EXPENSES | FLOAT | DEFAULT NULL | Datenbanktabellen | patients | HEALTHCARE_EXPENSES |
HEALTHCARE_EXPENSES | FLOAT | DEFAULT NULL | Datenbanktabellen | patients | HEALTHCARE_EXPENSES |
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 |
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 |
Dimensionstabelle medications_new
Spaltenname | Datentyp | Eigenschaften | Quelldatenbank | Quelltabelle | Quellspalte |
---|---|---|---|---|---|
MEDICATIONS_ID | INT | PRIMARY KEY | Datenbanktabellen | AUTOINCREMENT | -- |
START | NVARCHAR(20) | NOT NULL | Datenbanktabellen | medications | START |
STOP | nvarchar(20) | DEFAULT NULL | Datenbanktabellen | medications | STOP |
PATIENT | NVARCHAR(36) | FOREIGN KEY, NOT NULL | Datenbanktabellen | patients_new | Id |
PAYER | NVARCHAR(50) | NOT NULL | Datenbanktabellen | medications | PAYER |
ENCOUNTER | NVARCHAR(50) | NOT NULL | Datenbanktabellen | medications | ENCOUNTER |
CODE | INT | NOT NULL | Datenbanktabellen | medications | CODE |
DESCRIPTION | NVARCHAR(256) | NOT NULL | Datenbanktabellen | medications | DESCRIPTION |
BASE_COST | FLOAT | NOT NULL | Datenbanktabellen | medications | BASE_COST |
PAYER_COVERAGE | FLOAT | NOT NULL | Datenbanktabellen | medications | PAYER_COVERAGE |
DISPENSES | INT | NOT NULL | Datenbanktabellen | medications | DISPENSES |
TOTALCOST | FLOAT | NOT NULL | Datenbanktabellen | medications | TOTALCOST |
REASONCODE | FLOAT | NOT NULL | Datenbanktabellen | medications | REASONCODE |
REASONDESCRIPTION | NVARCHAR(50) | NOT NULL | Datenbanktabellen | medications | REASONDESCRIPTION |
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 |
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 |