Difference between revisions of "Data Description"

From SICDB Doc
Jump to navigation Jump to search
(Created page with "The SICdb dataset consists of X tables. The main tables are cases, d_references,")
 
Line 1: Line 1:
The SICdb dataset consists of X tables. The main tables are [[Table: Cases | cases]], [[Reference_Table | d_references]],
The SICdb dataset consists of X tables. The main tables are [[Table: Cases | cases]], [[Reference_Table | d_references]], [[Medication_Data | medication]] and the data tables [[data_float_h]] and [[data_ref]]. Each admission creates one entry in table [[Table: Cases | cases]] and data is relationally connected via the field CaseID, which is available in each of the related tables. Time values are stored in field offset, which is time in seconds from admission.
 
Nearly all fields in the SICdb dataset, that can be encoded, are referenced in d_references, where field ReferenceGlobalID is connected to specified field.

Revision as of 15:43, 18 September 2022

The SICdb dataset consists of X tables. The main tables are cases, d_references, medication and the data tables data_float_h and data_ref. Each admission creates one entry in table cases and data is relationally connected via the field CaseID, which is available in each of the related tables. Time values are stored in field offset, which is time in seconds from admission.

Nearly all fields in the SICdb dataset, that can be encoded, are referenced in d_references, where field ReferenceGlobalID is connected to specified field.