patients - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
Information aus der Datei patients.csv
| Spaltenname | Datentyp | Eigenschaften |
|---|---|---|
| Id | NVARCHAR(36) | PRIMARY KEY |
| BIRTHDATE | DATE | DEFAULT NULL |
| DEATHDATE | DATE | DEFAULT NULL, |
| SSN | NVARCHAR(50) | DEFAULT NULL |
| DRIVERS | NVARCHAR(50) | DEFAULT NULL |
| PASSPORT | NVARCHAR(10) | DEFAULT NULL |
| PREFIX | NVARCHAR(4) | DEFAULT NULL |
| FIRST | NVARCHAR(50) | DEFAULT NULL |
| LAST | NVARCHAR(50) | DEFAULT NULL |
| SUFFIX | NVARCHAR(10) | DEFAULT NULL |
| MAIDEN | NVARCHAR(50) | DEFAULT NULL |
| MARITAL | CHAR(1) | DEFAULT NULL |
| RACE | NVARCHAR(10) | DEFAULT NULL |
| ETHNICITY | NVARCHAR(50) | DEFAULT NULL |
| GENDER | CHAR(1) | DEFAULT NULL |
| BIRTHPLACE | NVARCHAR(50) | DEFAULT NULL |
| ADDRESS | NVARCHAR(50) | DEFAULT NULL |
| CITY | NVARCHAR(50) | DEFAULT NULL |
| STATE | NVARCHAR(50) | DEFAULT NULL |
| COUNTRY | NVARCHAR(50) | DEFAULT NULL |
| ZIP | NVARCHAR(4) | DEFAULT NULL |
| LAT | nvarchar(10) | DEFAULT NULL |
| LON | nvarchar(10) | DEFAULT NULL |
| HEALTHCARE_EXPENSES | FLOAT | DEFAULT NULL |
| HEALTHCARE_EXPENSES | FLOAT | DEFAULT NULL |