|
id
|
bigint(10)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
description
|
longtext
|
|
|
|
|
timecreated
|
bigint(10)
|
|
|
0
|
|
timemodified
|
bigint(10)
|
|
|
0
|
|
usercreated
|
bigint(10)
|
|
|
|
|
usermodified
|
bigint(10)
|
|
|
|
|
issuername
|
varchar(255)
|
|
|
|
|
issuerurl
|
varchar(255)
|
|
|
|
|
issuercontact
|
varchar(255)
|
|
|
|
|
expiredate
|
bigint(10)
|
|
|
|
|
expireperiod
|
bigint(10)
|
|
|
|
|
type
|
tinyint(1)
|
|
|
1
|
|
courseid
|
bigint(10)
|
|
|
|
|
message
|
longtext
|
|
|
|
|
messagesubject
|
longtext
|
|
|
|
|
attachment
|
tinyint(1)
|
|
|
1
|
|
notification
|
tinyint(1)
|
|
|
1
|
|
status
|
tinyint(1)
|
|
|
0
|
|
nextcron
|
bigint(10)
|
|
|
|
|
version
|
varchar(255)
|
|
|
|
|
language
|
varchar(255)
|
|
|
|
|
imageauthorname
|
varchar(255)
|
|
|
|
|
imageauthoremail
|
varchar(255)
|
|
|
|
|
imageauthorurl
|
varchar(255)
|
|
|
|
|
imagecaption
|
longtext
|
|
|
|