...

• 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

Refined schema (step 7)

Experiment database

• table replace was renamed to entry_replacement - by accident, we have used reserved word

Image Added

Refined schema (step 8)

Anchor
DB-schema-latest DB-schema-latest

Experiment database

• There is a new table: variable_type - it describes possible types of the variables
• Inside variable table, there is no longer variable_type column. Instead there is a foreign key (variable_type_id) that points at variable_type.id
• There is a new table: request_status - it describes possible statues of the request
• Inside request table there is no longer status column - instead there is a foreign key (request_status_id) that points at request_status.id

Image Added

Refined schema (step 9)

Filter table

• 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

Image Added

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

• experiment_description is a table that allows to uniquely identify experiments based on dataset_description IDS
• https://trello.com/c/8lZbmTBg

VARCHAR to TEXT

• all text fields are now represented by TEXT fields

Image Added