FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
E-Learning-System-Java-GUI-Application/ELearningSystem.sql at main · kiran3454/E-Learning-System-Java-GUI-Application · GitHub
kiran3454
/
E-Learning-System-Java-GUI-Application
Public
forked from
SuwaidAslam/E-Learning-System-Java-GUI-Application
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
E-Learning-System-Java-GUI-Application
/
ELearningSystem.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
101 lines (84 loc) · 2.88 KB
Breadcrumbs
E-Learning-System-Java-GUI-Application
/
ELearningSystem.sql
Copy path
File metadata and controls
101 lines (84 loc) · 2.88 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
--
Database Name = 'ELearningSystem'
Create
Database
ELearningSystem
;
use ELearningSystem;
SET
GLOBAL max_allowed_packet
=
1024
*
1024
*
14
;
create
Table
Admin
(
Adminid
int
Not Null
AUTO_INCREMENT,
fname
varchar
(
150
)
Not Null
,
lname
varchar
(
150
),
Email_ID
varchar
(
250
),
username
varchar
(
20
)
Not Null
Unique,
password
varchar
(
20
),
Gender
varchar
(
10
),
picture MEDIUMBLOB,
Primary Key
(Adminid)
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
Insert Into
Admin (fname, lname, Email_ID, username, password, Gender)
Values
(
'
Suwaid
'
,
'
Aslam
'
,
'
Suwaid@admin.com
'
,
'
admin
'
,
'
admin
'
,
'
Male
'
);
create
Table
Student
(
stdID
int
Not Null
AUTO_INCREMENT,
fname
varchar
(
150
)
Not Null
,
lname
varchar
(
150
),
Email_ID
varchar
(
250
),
username
varchar
(
20
)
Not Null
Unique,
password
varchar
(
20
),
Gender
varchar
(
10
),
Registration_Date
Date
Not Null
,
Last_Login Datetime,
picture MEDIUMBLOB,
Primary Key
(stdID)
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
create
Table
Teacher
(
teacherID
int
Not Null
AUTO_INCREMENT,
fname
varchar
(
150
)
Not Null
,
lname
varchar
(
150
),
Email_ID
varchar
(
250
),
username
varchar
(
20
)
Not Null
Unique,
password
varchar
(
20
),
Gender
varchar
(
10
),
Registration_Date
Date
Not Null
,
Last_Login Datetime,
picture MEDIUMBLOB,
Primary Key
(teacherID)
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
create
Table
Subjects
(
Subject_ID
int
Not Null
AUTO_INCREMENT,
Name
varchar
(
150
)
Not Null
Unique,
Primary Key
(Subject_ID),
Adminid
int
Not Null
,
CONSTRAINT
Adminid_fk
Foreign Key
(Adminid)
References
Admin(Adminid)
ON DELETE CASCADE
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
create
Table
Courses
(
course_ID
int
Not Null
AUTO_INCREMENT,
Name
varchar
(
250
)
Not Null
Unique,
Description
varchar
(
1000
)
Not Null
,
Content
varchar
(
3000
)
Not Null
,
teacherID
int
Not Null
,
Subject_ID
int
Not Null
,
Primary Key
(course_ID),
CONSTRAINT
teacherID_fk
Foreign Key
(teacherID)
References
Teacher(teacherID)
ON DELETE CASCADE
,
CONSTRAINT
subjectID_fk
Foreign Key
(Subject_ID)
References
Subjects(Subject_ID)
ON DELETE CASCADE
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
create
Table
Enrollments
(
Enrollment_ID
int
Not Null
AUTO_INCREMENT,
Enrollment_Date
Date
Not Null
,
course_ID
int
Not Null
,
stdID
int
Not Null
,
CONSTRAINT
courseID_fk
Foreign Key
(course_ID)
References
Courses(course_ID)
ON DELETE CASCADE
,
CONSTRAINT
stdID_fk
Foreign Key
(stdID)
References
Student(stdID)
ON DELETE CASCADE
,
Primary Key
(Enrollment_ID),
UNIQUE KEY unique_Enrollment(course_ID, stdID)
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
create
Table
Messages
(
Message_ID
int
Not Null
AUTO_INCREMENT,
message
varchar
(
2000
)
Not Null
,
time_Stamp Datetime
Not Null
,
User_ID
int
Not Null
,
toUser_ID
int
Not Null
,
Primary Key
(Message_ID)
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
create
Table
MessageUsers
(
User_ID
int
Not Null
,
Message_ID
int
Not Null
,
CONSTRAINT
message_ID_fk
Foreign Key
(Message_ID)
References
Messages(Message_ID)
ON DELETE CASCADE
) ENGINE
=
InnoDB DEFAULT CHARSET
=
latin1;
Back
|
FazBrowse Home
|
New Git URL