Migrate DB to more flexibly handle files - Githubissues

mycorrhiza-inc / kessler

1 stars 0 forks source link

Migrate DB to more flexibly handle files #185

Closed mirrir0 closed 2 weeks ago

mirrir0 commented 2 weeks ago

Files Schema

Fields

Name
Date Published
File Extension
isPrivate
hash
lang
Document Text Source

task under #186

Metadata Mapping

Object ID (foreign key to files)
Metadata Field
Metadata Value (Jsonified, or compressed in some way to store things like lists, or dates, or numbers)

task under #187

Source Table

Object ID (foreign key to files)
Source Type (type of source, url, doi)
URL (Optional)
Other stuff as needed to decide later
Juristiction Table (For filtering on juristiction, delay until later.)

Stage Table

Stage Table with the following fields
Object ID (foreign key to files) stage (string enum with same values as in python) error (optional string)