Database - helps

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

aquilina
New php-forum User
New php-forum User
Posts: 7
Joined: Tue Sep 20, 2011 9:01 pm

Database - helps

Postby aquilina » Thu May 22, 2014 8:30 am

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
Screenshot_1.png (50.57 KiB) Viewed 258 times
Screenshot_2.png
Screenshot_2.png (43.82 KiB) Viewed 258 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

Return to “phpMyAdmin”

Who is online

Users browsing this forum: No registered users and 0 guests