[imaging/database] cleanup mri_protocol tables - Githubissues

aces / Loris-MRI

The set of scripts that preprocess and insert MRI data into the database.

10 stars 50 forks source link

[imaging/database] cleanup mri_protocol tables #1128

Closed MaximeMulder closed 1 month ago

MaximeMulder commented 1 month ago

After discussing imaging with @nicolasbrossard and @ridz1208 this morning, we agreed the mri_protocol tables could use some clean-up :

In the mri_protocol_group_target table, the fields ProjectID, CohortID and Visit_label should have a UNIQUE constraint.
In the mri_protocol table, the field Scan_type should have a foreign key to the mri_scan_type.ID field.

Eventually, we could rename some fields to respect more accurately LORIS' naming conventions.

MaximeMulder commented 1 month ago

Whoops, wrong repo 😅.