This Social Networking Site For College students. In this document we shared Database Design of College Social Networking. The purpose of preparing this document is to explain complete database design details of our College Social Networking project. This document covers Table design and ER diagram of the project. Table schema diagram and other documents you can download in download link.


Database Design of College Social Networking is organized with 16 tables: 

  • course
  • subject
  • user
  • student
  • notice
  • chat
  • group_chat
  • chat_message
  • timeline
  • timeline_comments
  • quiz
  • question
  • quiz_result
  • study_material
  • discussion
  • discussion_reply

Table Design of College Social Networking

Table name: student

The student table stores student records.

          ColumnTypeIndexDescription
student_idint(10)Primary keyStudent ID
student_namevarchar(25)NullStudent name
roll_novarchar(20)UniqueStudent Roll Number
Passwordvarchar(100)NullStudent password
student_imgvarchar(100)NullStudent profile image
course_idint(10)Foreign keyCourse ID
semestervarchar(20)NullSemester
about_studentTextNullAbout student
email_idvarchar(25)NullEmail ID
mob_novarchar(15)NullMobile Number
statusvarchar(10)NullStudent status

Table name: subject

The subject is the master table  which stores subject details

ColumnTypeIndexDescription
subject_idint(10)Primary keySubject ID
subjectvarchar(40)NullSubject name
course_idint(10)Foreign keyCourse ID
noteTextNullSubject note
statusvarchar(10)NullSubject status

Table name: user

The user table stores administrator and staff information

ColumnTypeIndexDescription
user_idint(10)Primary keyUser ID
user_typevarchar(25)NullUser type
namevarchar(25)NullName
user_imgTextNullUser Image
login_idvarchar(25)UniqueLogin ID
passwordvarchar(100)NullPassword
statusvarchar(10)NullStatus

Table name: course

The course table is the master table which stores course records

ColumnTypeIndexDescription
course_idint(10)Primary keyCourse ID
coursevarchar(25)NullCourse title
course_descriptiontextNullCourse description
statusvarchar(10)NullCourse status – Active or Inactive

 Table name: timeline

The timeline table stores published wallpost contents.

ColumnTypeIndexDescription
timeline_idint(10)Primary keyTimeline ID
student_idint(10)Foreign keyStudent ID
post_typevarchar(20)NullPost type – Photo, video or Text
text_messageTextNullText message
image_pathTextNullImage page
video_pathTextNullVideo path
date_timeDatetimeNullPublished date and time

Table name: timeline_comments

The timeline comments table stores comment which is published for wallpost.

ColumnTypeIndexDescription
timeline_comment_idint(10)Primary keyTimeline comment ID
comment_typevarchar(15)NullTimeline comment type
student_idint(10)Foreign keyStudent ID
timeline_idint(10)Foreign keyTimeline ID
messageTextNullComment message
date_timeDatetimeNullComment date and time

Table name: chat

The chat table stores chat records

ColumnTypeIndexDescription
chat_idint(10)Primary keyChat ID
student_id1int(10)Foreign keyChat message sender ID
student_id2int(10)Foreign keyChat message receiver ID

Table name: chat_message

The chat message table stores chat messages.

ColumnTypeIndexDescription
chat_message_idint(10)Primary keyChat message ID
chat_idint(10)Foreign keyChat ID
group_chat_idint(10)Foreign keyGroup chat ID
student_idint(10)Foreign keyStudent ID
date_timeDatetimeNullMessage received date and time
messageTextNulltext message
message_statusvarchar(10)NullChat message status

Table name: group_chat

The group_chat is the table which contains group chat messages.

ColumnTypeIndexDescription
group_chat_idint(10)Primary keyGroup chat ID
course_idint(10)Foreign keyCourse ID
    
Semestervarchar(20)NullSemester

Table name: discussion

The discussion table stores discussion details.

ColumnTypeIndexDescription
discussion_idint(10)Primary keyDiscussion ID
course_idint(10)Foreign keyCourse ID
semestervarchar(20)NullSemester
subject_idint(10)Foreign keySubject ID
discussion_titlevarchar(100)NullDiscussion title
discussion_descriptionTextNullDiscussion description
date_timeDatetimeNullDate time
student_idint(10)Foreign keyStudent ID
statusvarchar(10)NullDiscussion status

Table name: discussion_reply

The discussion reply stores discussion reply records

ColumnTypeIndexDescription
discussion_reply_idint(10)Primary keyDiscussion reply ID
discussion_idint(10)Foreign keyDiscussion ID
student_idint(10)Foreign keyStudent ID
user_idint(10)Foreign keyUser ID
messageTextNullDiscussion reply Message
uploadsvarchar(100)NullUploaded documents
date_timeDatetimeNullDiscussion reply date and time

Table name: notice

The notice table stores published events, news and meeting records.

ColumnTypeIndexDescription
notice_idint(10)Primary keyNotice ID
notice_typevarchar(25)NullNotice type
user_idint(10)Foreign keyUser ID
titlevarchar(100)NullNotice title or heading
descriptionTextNullNotice content
uploadsTextNullNotice uploading files.
date_timeDatetimeNullNotice date and time
statusvarchar(10)NullNotice status

Table name: quiz

The quiz table stores the detailed information of quiz

ColumnTypeIndexDescription
quiz_idint(10)Primary keyQuiz ID
user_idint(10)Foreign keyUser ID
course_idint(10)Foreign keyCourse ID
subject_idint(10)Foreign keySubject ID
titlevarchar(100)NullQuiz title
descriptionTextNullQuiz detailed information

Table name: question

The question table stores quiz question, options and answers

ColumnTypeIndexDescription
quiz_question_idint(10)Primary keyQuiz question ID
quiz_idint(10)Foreign keyQuiz ID
questionTextNullQuiz question
option1TextNullOption 1
option2TextNullOption 2
option3TextNullOption 3
option4TextNullOption 4
correct_ansvarchar(10)NullCorrect answer
statusvarchar(10)NullQuestion status

Table name: quiz_result

The quiz result stores published quiz result.

ColumnTypeIndexDescription
quiz_result_idint(10)Primary keyQuiz result ID
quiz_idint(10)Foreign keyQuiz ID
student_idint(10)Foreign keyStudent ID
quiz_question_idint(10)Foreign keyQuiz question ID
selected_optionvarchar(10)Foreign keyAnswer ID
correct_ansvarchar(10)NullCorrect answer
date_timeDatetimeNullAttended Date time

Table name: study_material

The study_material table stores uploaded study materials.

ColumnTypeIndexDescription
study_material_idint(10)Primary keyStudy material ID
course_idint(10)Foreign keyCourse ID
semestervarchar(20)NullSemester
subject_idint(10)Foreign keySubject ID
titlevarchar(100)NullStudy material title
user_idint(10)Foreign keyUploaded faculty id
descriptionTextNullStudy material descripton
uploadsTextNullDocuments uploaded
date_timeDatetimeNullPublished date and time

ER diagram of College Social Networking

Database Design of College Social Networking
Database Design of College Social Networking

Video Demonstration:

Download Virtual Classroom Network

Do you have any queries? Contact us.. Our Whatsapp Number is: 9972853368

StudentProjects.Live

A collection of source codes that I wrote in VB 6.0, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.