danhan / hcat-savi

0 stars 0 forks source link

[Design] Design the table schema in HBase #5

Open danhan opened 11 years ago

danhan commented 11 years ago

Six tables: 1 HCA description 2 Patient + Service requirement 3 Service description 4 Appointment 5 Service Record 6 Media

Will focus on Appointment and Patient first, then ServiceRecord

danhan commented 11 years ago

The priority: 1 Patient ==> patient (this is geospatial data) 2 ServiceRecord & Media File ===> record (this is time-series data)

danhan commented 11 years ago

Patient ===> patient spatial & patient desc (geospatial data) ServiceRecord&MediaMessage ===> record (Timeseries data) Appointment ==> appointment ==> describe information (also using Timeseries 3-D schema)

danhan commented 11 years ago

Now, we have 1) patient-spatial, 2) appointment, 3) record(servicerecord+mediamessage), 4) patient-desc(patient+servicerquirement)

TODO List: 1 HCA 2 Refine: Patient-spatial (remove redundant info ), Patient-desc (put the service requirement in a right way)