data

0 rows


Description

all database activities

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
data_fields.dataid datafiel_dat2_fkR
data_records.dataid datareco_dat2_fkR
course BIGINT 19 0
name VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
comments SMALLINT 5 0
timeavailablefrom BIGINT 19 0
timeavailableto BIGINT 19 0
timeviewfrom BIGINT 19 0
timeviewto BIGINT 19 0
requiredentries INT 10 0
requiredentriestoview INT 10 0
maxentries INT 10 0
rssarticles SMALLINT 5 0
singletemplate LONGTEXT 2147483647 null
listtemplate LONGTEXT 2147483647 null
listtemplateheader LONGTEXT 2147483647 null
listtemplatefooter LONGTEXT 2147483647 null
addtemplate LONGTEXT 2147483647 null
rsstemplate LONGTEXT 2147483647 null
rsstitletemplate LONGTEXT 2147483647 null
csstemplate LONGTEXT 2147483647 null
jstemplate LONGTEXT 2147483647 null
asearchtemplate LONGTEXT 2147483647 null
approval SMALLINT 5 0
manageapproved SMALLINT 5 1
scale BIGINT 19 0
assessed BIGINT 19 0
assesstimestart BIGINT 19 0
assesstimefinish BIGINT 19 0
defaultsort BIGINT 19 0
defaultsortdir SMALLINT 5 0
editany SMALLINT 5 0
notification BIGINT 19 0
timemodified BIGINT 19 0
config LONGTEXT 2147483647 null
completionentries BIGINT 19 0

Indexes

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

Relationships