gmc1103 Posted February 12, 2016 Share Posted February 12, 2016 Hi I have followed the user "Barand" implementation and i have another tables to uses Now i must uses another tables to make this database even more reliable I must add to an user the subject class, i mean, user A can teach Mats A and Maths B, user B can teach English and French So i create a table "users_disc" where i use foreign keys from table user and table "esmaior_disc" And the "esmaior_disc" where i have the subjects class must have a year where they belongnew All the new schema are in red Any suggestions? Quote Link to comment https://forums.phpfreaks.com/topic/300798-database-new-tables/ Share on other sites More sharing options...
Solution Barand Posted February 12, 2016 Solution Share Posted February 12, 2016 Would this meet your requirements? 1 Quote Link to comment https://forums.phpfreaks.com/topic/300798-database-new-tables/#findComment-1531053 Share on other sites More sharing options...
gmc1103 Posted February 12, 2016 Author Share Posted February 12, 2016 Hi Barand Yes it does, i made from the related tables but your examples seems to be better. I think it covers all needs regarding having a database to store all fields. Thank you again and have a nice week-end. Quote Link to comment https://forums.phpfreaks.com/topic/300798-database-new-tables/#findComment-1531054 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.