Stream: CARIN IG for Blue Button®
Topic: CARIN Server-ri test database
Stephen Whitney (Apr 13 2020 at 22:52):
Hi. I've got a reference server and auth-server up and running locally. I'm curious to know what the H2 encrypted database looks like. Is there a DDL available at all?
Stephen Whitney (Apr 13 2020 at 22:58):
I was able to open the database locally by passing empty strings for username:password. I'm Interested to learn more about how the patient test data is stored.
Stephen Whitney (Apr 14 2020 at 15:07):
Bump. These are the tables in the database:
TABLE_NAME
CATALOGS
COLLATIONS
COLUMNS
COLUMN_PRIVILEGES
CONSTANTS
CONSTRAINTS
CROSS_REFERENCES
DOMAINS
FUNCTION_ALIASES
FUNCTION_COLUMNS
HELP
HFJ_BINARY_STORAGE_BLOB
HFJ_BLK_EXPORT_COLFILE
HFJ_BLK_EXPORT_COLLECTION
HFJ_BLK_EXPORT_JOB
HFJ_FORCED_ID
HFJ_HISTORY_TAG
HFJ_IDX_CMP_STRING_UNIQ
HFJ_RESOURCE
HFJ_RES_LINK
HFJ_RES_PARAM_PRESENT
HFJ_RES_REINDEX_JOB
HFJ_RES_TAG
HFJ_RES_VER
HFJ_RES_VER_PROV
HFJ_SEARCH
HFJ_SEARCH_INCLUDE
HFJ_SEARCH_RESULT
HFJ_SPIDX_COORDS
HFJ_SPIDX_DATE
HFJ_SPIDX_NUMBER
HFJ_SPIDX_QUANTITY
HFJ_SPIDX_STRING
HFJ_SPIDX_TOKEN
HFJ_SPIDX_URI
HFJ_SUBSCRIPTION_STATS
HFJ_TAG_DEF
INDEXES
IN_DOUBT
KEY_COLUMN_USAGE
LOCKS
QUERY_STATISTICS
REFERENTIAL_CONSTRAINTS
RIGHTS
ROLES
SCHEMATA
SEQUENCES
SESSIONS
SESSION_STATE
SETTINGS
SYNONYMS
TABLES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLE_TYPES
TRIGGERS
TRM_CODESYSTEM
TRM_CODESYSTEM_VER
TRM_CONCEPT
TRM_CONCEPT_DESIG
TRM_CONCEPT_MAP
TRM_CONCEPT_MAP_GROUP
TRM_CONCEPT_MAP_GRP_ELEMENT
TRM_CONCEPT_MAP_GRP_ELM_TGT
TRM_CONCEPT_PC_LINK
TRM_CONCEPT_PROPERTY
TRM_VALUESET
TRM_VALUESET_CONCEPT
TRM_VALUESET_C_DESIGNATION
TYPE_INFO
USERS
VIEWS
Is the patient data stored in these tables?
Ryan Howells (Apr 20 2020 at 19:21):
Hey @Saul Kravitz - Any thoughts on @Stephen Whitney's question?
Saul Kravitz (Apr 21 2020 at 20:30):
Everything is on github:
- reference server: https://github.com/carin-alliance/cpcds-server-ri (customized HAPI FHIR server)
- auth-server: https://github.com/carin-alliance/cpcds-auth-server
@Benjamin Langley
Benjamin Langley (Apr 21 2020 at 20:58):
As Saul mentioned the the CPCDS server is based on HAPI FHIR. You can explore the server at http://localhost:8080/cpcds-server/fhir
As for the authorization server if it is up and running there is a debug endpoint (which I now realize is not in the readme so I shall add it) to view the contents of the tables:
Clients table: http://localhost:8180/debug/Clients
Users table: http://localhost:8180/debug/Users
The schema of the database for the auth server is also available in the git repo https://github.com/carin-alliance/cpcds-auth-server/blob/master/src/main/java/org/hl7/cpcdsauthserver/CreateDatabase.sql
I hope this helps and let me know if you have other questions!
Benjamin Langley (Apr 21 2020 at 21:04):
Stephen Whitney said:
Is the patient data stored in these tables?
No - you are inspecting the database for the authorization server. This contains registered clients and registered users. The patient data is all in the CPCDS server: https://github.com/carin-alliance/cpcds-server-ri
The sample data loaded into the docker image is all from the /data directory
Last updated: Apr 12 2022 at 19:14 UTC
