phdi icon indicating copy to clipboard operation
phdi copied to clipboard

add extended metadata schema

Open BobanL opened this issue 1 year ago • 0 comments

PULL REQUEST

Summary

  • Create new extended_metadata_db.sql file
  • 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 the src folder to keep it totally separate from the typescript folder structure we have now
  • An additional table was created to handle ecr_rr_conditions.rule_summary since it is an array of data and SQL server does not support array types.

Checklist

BobanL avatar Aug 14 '24 19:08 BobanL