phdi
phdi copied to clipboard
add extended metadata schema
PULL REQUEST
Summary
- Create new
extended_metadata_db.sqlfile - Written for SQL Server
- UUID type is supported in Postgres and SQL Server, but not MySQL or Oracle.
- DATETIME is supported in SQL Server and MySQL but not in Oracle or postgres.
- UUID would be pretty easy and seamless to change to varchar, but if we convert DATETIME to varchar we would probably lose out a lot.
Related Issue
Fixes #2349
Additional Information
- Acceptance calls out to be stored in
src/app, but I believe it makes more sense to store the schema outside of thesrcfolder to keep it totally separate from the typescript folder structure we have now - An additional table was created to handle
ecr_rr_conditions.rule_summarysince it is an array of data and SQL server does not support array types.