Data Table Schema (data)


Description

all database activities

data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
data_fields.dataid datafiel_dat2_fk R
data_records.dataid datareco_dat2_fk R
course bigint 10 0
name varchar 255
intro longtext 2147483647 null
introformat smallint 4 0
comments smallint 4 0
timeavailablefrom bigint 10 0
timeavailableto bigint 10 0
timeviewfrom bigint 10 0
timeviewto bigint 10 0
requiredentries int 8 0
requiredentriestoview int 8 0
maxentries int 8 0
rssarticles smallint 4 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 4 0
manageapproved smallint 4 1
scale bigint 10 0
assessed bigint 10 0
assesstimestart bigint 10 0
assesstimefinish bigint 10 0
defaultsort bigint 10 0
defaultsortdir smallint 4 0
editany smallint 4 0
notification bigint 10 0

Notify people when things change

timemodified bigint 10 0

The time the settings for this database module instance were last modified.

config longtext 2147483647 null
completionentries bigint 10 0

Number of entries required for completion

Table contained -1 rows

data table indexes

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

data table relationships