A
Anonymous
Guest
I'm looking for someone who can look at my table that i sketch before i creating the database on phpmyadmin based on the case. I not really good in creating database that involve too much table since i going mixed up and confuse with foreign key.. i attached with the screenshot of my case. when i searching around this things that i going to build is nearly same with moodle its like e-learning...
Code:
Users
-user_id(pk)
-user_name
-user_pass
-email
-forum_notification
courses
-course_id(pk)
-user_id(fk)
-course_name
-description
Messages
-msg_id(pk)
-user_id(fk)
-msg
-msg_date
Notes
-note_id(pk)
-user_id(fk)
-course_id
-note_name
-note_date
Assignments
-assg_id(pk)
-user_id(fk)
-course_id(fk)
-assg_name
-assg_date
announcements
-ann_id(pk)
-user_id(fk)
-course_id(fk)
-ann_name
-ann_description
-ann_date
categories
-category_id(pk)
-category_title
-category_description
-last_post_date
-last_user_posted
topics
-topic_id(pk)
-category_id(fk)
-topic_title
-topic_creator
-topic_last_user
-topic_date
-topic_replay_date
-topic_views
posts
-post_id(pk)
-category_id(fk)
-topic_id(fk)
-post_creator
-post_content
-post_date