SchemaSpy Analysis of survey - Constraints Generated by
SchemaSpy
11 Foreign Key Constraints:

Constraint Name Child Column Parent Column
FK_comparisons_res1 comparisons.res1
comparisons.did
results.id
results.did
FK_comparisons_res2 comparisons.res2
comparisons.did
results.id
results.did
FK_comparisons_sid comparisons.sid sessions.id
FK_datasets_imid datasets.imid images.id
FK_experiments_judges_did experiments_judges.did datasets.id
FK_image_attributes_aid image_attributes.aid attributes.id
FK_image_attributes_imid image_attributes.imid images.id
FK_options_cid options.sid
options.cid
comparisons.sid
comparisons.cid
FK_options_qid options.qid questions.id
FK_questions_aid questions.aid attributes.id
FK_results_did results.did datasets.id

Check Constraints:

Table Constraint Name Constraint
None detected