Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • There is a new table: filter - it allows to store custom user filters
  • There is a new table: user_filter - it allows to link filter with user; it is possible to share filter between different user - this is why filters require linking table between user and filter

Refined schema (step 10)

user_filter

  • There are fixes inside user_filter table
  • There is a new explicit ID column
  • relations are non-identifying (user - user_filter - filter)

Image Added

Refined schema (step 11)

experiment_description

VARCHAR to TEXT

  • all text fields are now represented by TEXT fields

Image Added