Column Name

Primary key

Data type

NOT NULL

AUTO INC

ID

Course code

Course title

Units

Lecturer

Topic

Lesson

File

Yes

INTEGER

VARCHAR (45)

VARCHAR (4500)

INTEGER

VARCHAR (450)

TEXT

TEXT

BLOB

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes