mapping table patients_new - 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 |