id | int(3) |
|
|
|
name | varchar(256) |
|
|
|
credits | int(2) |
|
|
|
course_code | varchar(10) |
|
|
|
program_id | int(3) |
|
|
|
semester | int(1) |
|
|
|
session | int(2) |
|
|
0
|
core | char(1) |
|
|
|
type | varchar(10) |
|
|
|
mark_pattern | tinyint(4) |
|
|
1
|
internal | int(3) |
|
|
40
|
external | int(3) |
|
|
60
|
syllabus | int(4) |
|
|
|
created | datetime |
|
|
CURRENT_TIMESTAMP
|
weight | int(4) |
|
|
|
locked | tinyint(1) |
|
|
0
|
date_modified | timestamp |
|
|
CURRENT_TIMESTAMP
|