Database - helps

[aquilina]

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...

Screenshot_1.png (50.57 KiB) Viewed 5888 times

Screenshot_2.png (43.82 KiB) Viewed 5888 times

Code: Select all

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