...
- request table no longer holds URI for the data entry
- there is a new table: experiment. This table contains location of data we are working with. As we may have multiple requests for a single experiment (e.g. update of the data) I want to keep URI in separate table.
- entry table is now linked with request - this way it points to the experiment (via request)
- There is a new table: replace - this table will contain information for tracking additional info (as described in Proposal on Metadata Schema Standardisation and Mapping Existing Schemas)
- There is a new table: reference - this table will allow to store multiple DOI (maybe something else) related to a particular entry
- There is a new table: tag - this table will contain all the tags defined by users
- There is a new table: tag_entry - this table will contain all the links between: user, tag and entry; this way it will be possible to track who has tagged entry with given tag
- Removed: machine table is no longer here. Do we really need it?
Refined schema (step 5)
Experiment database
- auto increment for all ID fields in database
- further unification of fields (all primary keys and foreign keys are represented solely by INT)
- further cleaning of indexes