folder

0 rows


Description

each record is one folder resource

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
course BIGINT 19 0
course.id folder_erd_courseidR
name VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

timemodified BIGINT 19 0
display SMALLINT 5 0

Display type of folder contents - on a separate page or inline

showexpanded BIT 1 1

1 = expanded, 0 = collapsed for sub-folders

showdownloadfolder BIT 1 1

1 = show download folder button

forcedownload BIT 1 1

1 = force download of individual files

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fold_cou_ix Performance Asc course

Relationships