tables: how should I plan them ?

Basic scenario: seminar, students, attendance

Tables: seminars (name, description, room_number) students (first_name, last_name, etc ...) seminars_students (seminar_id, student_id)

My problem is trying to figure out how to setup the attendance table.

I thought of: seminairs_students (seminar_id, student_id, attended)

but I'm thinking that detach, sync is going to mess up.

What is suggested? OR am I just over thinking this?

Thanks!

Level 56

but I'm thinking that detach, sync is going to mess up.

Level 8

Ugh, sorry, I meant that if I used the attended column in seminars-students that detach or sync will erases the attended column's value

Please or to participate in this conversation.