medications - Fuenfgeld/DMA2022DataProjectB GitHub Wiki
Information aus der Datei medications.csv
| 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 |