Resource Table Schema (resource)


Description

Each record is one resource and its config data

resource table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
enrol_lti_lti2_share_key.resourcelinkid Implied Constraint R
course BIGINT 19 0
name VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
tobemigrated SMALLINT 5 0
legacyfiles SMALLINT 5 0
legacyfileslast BIGINT 19 null
display SMALLINT 5 0
displayoptions LONGTEXT 2147483647 null
filterfiles SMALLINT 5 0
revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

timemodified BIGINT 19 0

Table contained -1 rows

resource table indexes

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

resource table relationships