...
- 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)
Refined schema (step 7)
Experiment database
- table replace was renamed to entry_replacement - by accident, we have used reserved word
Refined schema (step 8)
Anchor | ||||
---|---|---|---|---|
|
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 atvariable_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 atrequest_status.id
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
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)
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