Versions Compared

Key

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

...

  • 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

Refined schema (step 6)

Experiment database

  • all text fields are now represented by VARCHAR (it's still a subject to change)
  • using TEXT as type of column lead to strange issues in some of the SQL engines (e.g. H2)

Image Added