10 lines
260 B
SQL
10 lines
260 B
SQL
CREATE TABLE Courses
|
|
(
|
|
courseID INT AUTO_INCREMENT,
|
|
courseNum VARCHAR(10),
|
|
courseName VARCHAR(40),
|
|
courseDescription VARCHAR(80),
|
|
creditHours FLOAT DEFAULT 3.0,
|
|
CHECK (creditHours BETWEEN 0.0 AND 6.0),
|
|
PRIMARY KEY(courseID)
|
|
); |