Scribd
Upload
2 views2 pages

Untitled

The document outlines a database schema with various tables and their respective fields, including user information, course sections, and classroom details. Key attributes include user IDs, section IDs, and various ENUM types for categorization. It emphasizes relationships between users, sections, and colleges, indicating a structured approach to managing educational data.

Uploaded by

stuchfun
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Untitled

The document outlines a database schema with various tables and their respective fields, including user information, course sections, and classroom details. Key attributes include user IDs, section IDs, and various ENUM types for categorization. It emphasizes relationships between users, sections, and colleges, indicating a structured approach to managing educational data.

Uploaded by

stuchfun
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

id INT

id INT 1 1 id 1 title VARCHAR(200)


INT

user_id INT * content TEXT


username VARCHAR(100)

section_id INT * * author_id INT


hashed_password VARCHAR(255)

tele INT

question VARCHAR(255)

hashed_answer VARCHAR(255)

college_id INT * 1 id INT

is_admin BOOLEAN name VARCHAR(100)


id INT

section_id INT *

week_start INT 1 id INT 1

week_end INT * lesson_id INT id INT

weekday ENUM(1,2,3,4,5,6,7) sn INT * user_id INT

odd_or_even ENUM(odd,even,both) capacity INT * section_id INT

period_start INT info VARCHAR(255)


1 id INT
period_end INT classroom_id INT *
building VARCHAR(100)

room VARCHAR(50)

id INT 1
id INT 1
name VARCHAR(100)
name VARCHAR(200)
college_id VARCHAR(50) * id INT
college_id INT *
* section_id INT
credit INT * teacher_id INT
study_time INT

importance ENUM(,)

exam_type ENUM(,)
id INT

id INT 1 1 id 1 title VARCHAR(200)


INT

user_id INT * content TEXT


username VARCHAR(100)

section_id INT * * author_id INT


hashed_password VARCHAR(255)

tele INT

question VARCHAR(255)

hashed_answer VARCHAR(255)

college_id INT * 1 id INT

is_admin BOOLEAN name VARCHAR(100)


id INT

section_id INT *

week_start INT 1 id INT 1

week_end INT * lesson_id INT id INT

weekday ENUM(1,2,3,4,5,6,7) sn INT * user_id INT

odd_or_even ENUM(odd,even,both) capacity INT * section_id INT

period_start INT info VARCHAR(255)


1 id INT
period_end INT classroom_id INT *
building VARCHAR(100)

room VARCHAR(50)

id INT 1
id INT 1
name VARCHAR(100)
name VARCHAR(200)
college_id VARCHAR(50) * id INT
college_id INT *
* section_id INT
credit INT * teacher_id INT
study_time INT

importance ENUM(,)

exam_type ENUM(,)

You might also like