Datenbanktabellen - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
conditions
| Spaltenname | Datentyp | Eigenschaften |
|---|---|---|
| START | DATE | NOT NULL |
| STOP | DATE | DEFAULT NULL |
| PATIENT | NVARCHAR(36) | FOREIGN KEY REFERENCES patients (Id), NOT NULL |
| ENCOUNTER | NVARCHAR(50) | NOT NULL |
| CODE | INT | NOT NULL |
| DESCRIPTION | NVARCHAR(256) | NOT NULL |
medications
| Spaltenname | Datentyp | Eigenschaften |
|---|---|---|
| START | NVARCHAR(20) | NOT NULL |
| STOP | nvarchar(20) | DEFAULT NULL |
| PATIENT | NVARCHAR(36) | FOREIGN KEY REFERENCES patients (Id), NOT NULL |
| PAYER | NVARCHAR(50) | NOT NULL |
| ENCOUNTER | NVARCHAR(50) | NOT NULL |
| CODE | INT | NOT NULL |
| DESCRIPTION | NVARCHAR(256) | NOT NULL |
| BASE_COST | FLOAT | NOT NULL |
| PAYER_COVERAGE | FLOAT | NOT NULL |
| DISPENSES | INT | NOT NULL |
| TOTALCOST | FLOAT | NOT NULL |
| REASONCODE | FLOAT | NOT NULL |
| REASONDESCRIPTION | NVARCHAR(50) | NOT NULL |
procedures
| Spaltenname | Datentyp | Eigenschaften |
|---|---|---|
| DATE | NVARCHAR(20) | NOT NULL |
| PATIENT | NVARCHAR(36) | FOREIGN KEY REFERENCES patients (Id) , NOT NULL |
| ENCOUNTER | NVARCHAR(50) | NOT NULL |
| CODE | INT | NOT NULL |
| DESCRIPTION | NVARCHAR(256) | NOT NULL |
| BASE_COST | FLOAT | NOT NULL |
| REASONCODE | FLOAT | NOT NULL |
| REASONDESCRIPTION | NVARCHAR(50) | NOT NULL |
patients
| 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 |
observations
| Spaltenname | Datentyp | Eigenschaften |
|---|---|---|
| DATE | NVARCHAR(20) | NOT NULL |
| PATIENT | NVARCHAR(36) | FOREIGN KEY REFERENCES patients (Id), NOT NULL |
| ENCOUNTER | NVARCHAR(50) | NOT NULL |
| CODE | INT | NOT NULL |
| DESCRIPTION | NVARCHAR(256) | NOT NULL |
| VALUE | FLOAT | NOT NULL |
| UNITS | NVARCHAR(10) | NOT NULL |
| TYPE | NVARCHAR(10) | NOT NULL |