Faculty of Engineering and Mathematical Sciences 
Not logged in (login)


This forum is provided to promote discussion amongst students enrolled in Agile Web Development (CITS3403).
RSS cloud
Jump to:

Database Schema

1 of 419 articles shown, currently no other people reading this forum.
From: Takoyaki N.
Date: Wed 13th May 2020, 12:37pm


I'm not 100% sure but your schema does look a little strange.

What is the point of the set_id field in the Questions model.  If you want one question to 
have multiple options listed in the options set just query the Options table where 
question_id is equal to the id of the question.  Not sure why you would then bother to have a 
separate table (set).  

TLDR: Try comment out the line     set_id = db.Column(db.Integer, db.ForeignKey('set.id'))
 and see if you get the same issue.

Related articles

Database Schema (all 6) RSS
├─ original   Tue 5th May 2020, 3:35pm, ANONYMOUS
├─ reply 1   Wed 6th May 2020, 10:59am, Takoyaki N.
├─ reply 2   Wed 6th May 2020, 12:13pm, Timothy F.
├─ reply 3   Mon 11th May 2020, 10:02am, ANONYMOUS
├─ THIS   Wed 13th May 2020, 12:37pm, Takoyaki N.
└─ reply 5   Wed 13th May 2020, 1:16pm, Timothy F.
This Page

Program written by: [email protected]
Feedback welcome
Last modified: 11:27am Sep 21 2020