php mysql question. if I have a table CONTENT with a primary key of contentID....

  • Thread starter Thread starter eliyahu_s
  • Start date Start date
E

eliyahu_s

Guest
...Then I have 6 other tables with? if I have a table CONTENT with a primary key of contentID. Then I have 6 other tables with a foreign key to contentID - SUBJECTS, BOOKS, DIVIDES, CHAPTERS, QUESTIONS, NOTES. Should I 1) make a field in CONTENT called contentType with keys Su, Bo, Di, Ch, Qu, No. Or 2) find out what the contentType is in the php script? What do you recommend? If I should do 2), what is the best way to do it?
 
Back
Top