Changes between Version 25 and Version 26 of i2b2 Database Structure


Ignore:
Timestamp:
02/21/11 10:50:39 (14 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Database Structure

    v25 v26  
    139139Eventually we will have detailed knowledge and understanding of all of these. But for the moment, here are some details:[[br]]
    140140Columns UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD and UPLOAD_ID are administrative/info columns only. Ignore these.
     141
     142||= Key  =||= Column Name =||= Column Definition               =||= Nullable (default=YES) =||
     143|| PK     || encounter_num || Encoded i2b2 patient visit number ||           NO             ||
     144||        || patient_num   || Encoded i2b2 patient number       ||           NO             ||