HSLynk PostgreSQL operational database schema locations and documentation

• Note: The HSLynk Big Data Warehouse also contains all the element listed below, but the schemas additionally show the relationships between the elements. The HSLynk Big Data Warehouse also has element descriptions within the views. Additionally, here is a listing of the data elements in the Big Data Warehouse: https://docs.hslynk.com/db/metadata/metadata.html .

Entity Relational Diagram (ERD) files and docs are listed below. Apache Marmotta is also implemented as a W3C Link Data Platform (LDP) data lake, with the data lake's project IDs linked to the HSLynk global project ids within the base schema.

HMIS Version Specific Schemas

• 2020 https://github.com/servinglynk/hslynk-open-source/blob/master/hmis-model-v2020/HMISModel_v2020.sql

• 2017 https://api.hslynk.com/db/2017/dbdocs/index.html source DDL file: https://github.com/servinglynk/hslynk-open-source/blob/master/hmis-model-v2017/HMISModel_v2017.sql

• 2016 https://api.hslynk.com/db/2016/dbdocs/index.html source DDL file: https://github.com/servinglynk/hslynk-open-source/blob/master/hmis-model-v2016/HMISModel_v2016.sql

• 2015 https://api.hslynk.com/db/2015/dbdocs/index.html source DDL file: https://github.com/servinglynk/hslynk-open-source/blob/master/hmis-model-v2015/HMISModel_v2015.sql

• 2014 https://api.hslynk.com/db/2014/dbdocs/index.html source DDL file: https://github.com/servinglynk/hslynk-open-source/blob/master/hmis-model-v2014/HMISModel_v2014.sql

Global Client/Enrollment Schemas

• to be added soon (issue #590)

Base Schema

• preliminary diagram contains Golden View (needs to be updated), dedupe IDs, global, and generic tables (generics will be split out soon)

Notification Schemas

• link to DDL file, check if changed with addition of Active MQ.

Survey and Housing Match CES Schemas

• https://api.hslynk.com/db/survey/dbdocs/index.html source DDL file: https://github.com/hserv/coordinated-entry/blob/master/hmis-survey-api/survey_model.sql

• https://api.hslynk.com/db/housinginventory/dbdocs/index.html source DDL file: https://github.com/hserv/coordinated-entry/blob/master/housing_inventory/housing_inventory_model.sql

Also, you can directly view each schema using the following technique:

~/git/hslynk-open-source$ find ./ -type f -name *.sql ./hmis-model-v2014/HMISModel_v2014.sql ./hmis-model-v2014/HMISModel_stagv2014.sql ./hmis-notification-core/notificationdb.sql ./hmis-model-v2017/HMISModel_v2017.sql ./hmis-base-model/HMISBase_Model.sql ./hmis-base-model/SSN_DOB_Encryption.sql ./hmis-base-model/MasterData.sql ./hmis-base-model/Client_Consent.sql ./hmis-model-v2015/HMISModel_stagv2015.sql ./hmis-model-v2015/HMISModel_v2015.sql ./hmis-model-v2016/HMISModel_v2016.sql

~/git/coordinated-entry$ find ./ -type f -name *.sql ./housing_inventory/housing_inventory_model.sql ./hmis-survey-api/survey_model.sql ./housing-matching/src/main/resources/models/housing-matching.sql

Big Data Warehouse default data element list

• https://docs.hslynk.com/db/metadata/metadata.html