forked from aktyis/WebTech
-
Notifications
You must be signed in to change notification settings - Fork 0
/
database design.txt
22 lines (12 loc) · 730 Bytes
/
database design.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
**the primary keys are _(dash)ed in the front like _id. But user_name is not a primary key
users(_user_id,password,status,validity)
students(user_id,first_name,last_name,contact_number,email,blood_group,current_address,gender,guardians_name,guardians_contact)
courses(_course_id,class_id,discipline_name,course_name,is_open,total_capacity,filled_number,duration,start_time,end_time,day,room,sec)
taken_courses(user_id,_course_id,completion_status,availablity_status,semester,date,cpga)
faculties(user_id,name,qulification,contact_no,email,specility)
library(book_id,book_name,author,arrival_date,issue_status)
issue_list(issue_id,user_id,book_id,borrow_date,return_date)
laterwork
.........
faculty wise section
payment