Re: How to find values without a FK?

> The easiest way I can think of is a many-to-many table.
>
> CREATE TABLE user_subject (
> id_user .... ,
> id_subject .... ,
> status ENUM ('complete', 'future'),
> FOREIGN KEY id_user REFERENCES users(id_user),
> FOREIGN KEY id_subject REFERENCES subjects(id_subject),
> PRIMARY KEY (id_user, id_subject)
> )

It's a good idea to use ENUM field, I didn't thought it!

Thanks!
^Bart Received on Wed Apr 03 2019 - 21:15:27 CEST