CD2: submissions vs quiz_submissions

[IanGoh]

Another n00b question.  I'm trying to find our the last quiz or test submission for a student.

From Assignments, I know about the submissions table.  But there's also a quiz_submissions table.

If I'm just looking for the last quiz submitted, can I get that information purely from the submissions table (because that has the submissions.submitted_at).  Or do I really need to go to quiz_submissions and quizzes?

Also, then it just occurred to me, where's New Quizzes in all this?

[IanGoh]

Perhaps this craziness is because an assignment can be a quiz_type.  Whatever that means.

[r_layden]

I'm similarly bamboozled by this....

Apologies for tagging onto the end of your query @IanGoh  but can anyone help?

I've synced our CD2 tables to a local MySQL database.

I'm trying to get the results of a particular quiz (students need to get a pass mark on this quiz to proceed)

Some students have an entry for this quiz in the submissions table,
Whilst other students have no entry in the submissions table but they do have an entry in the quiz_submissions table instead... for the same quiz...

I'm scratching my head - there is a simple explanation as to the difference but I'm yet to see it

In general is it better to query the quiz_submissions table to get the scores of all students taking this quiz? (or is there more to it than that - suspect so...)

Cheers

Rich