Database model
calls_log
call_id: int PRIMARY KEY auto_increment
name: varchar(256)
request: text
response: text
note: varchar(256)
time: datetime
config
config_id: int PRIMARY KEY auto_increment
name: varchar(512)
value: longtext
oauth_access_tokens
access_token: varchar(80) PRIMARY KEY NOT NULL
client_id: varchar(80)
user_id: varchar(80)
expires: datetime
scope: varchar(4000)
oauth_authorization_codes
authorization_code: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
redirect_uri: varchar(2000)
expires: datetime NOT NULL
scope: varchar(4000)
id_token: varchar(1000)
oauth_clients
client_id: varchar(80) PRIMARY KEY NOT NULL
client_secret: varchar(80)
redirect_uri: varchar(2000)
grant_types: varchar(80)
scope: varchar(4000)
user_id: varchar(80)
oauth_jwt
client_id: varchar(80) NOT NULL
subject: varchar(80)
public_key: varchar(2000) NOT NULL
oauth_refresh_tokens
refresh_token: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
expires: datetime NOT NULL
scope: varchar(4000)
oauth_scopes
is_default: tinyint
scope: varchar(80)
oauth_users
user_id: int PRIMARY KEY AUTO_INCREMENT
username: varchar(40) NOT NULL
password: varchar(80) NOT NULL
email: varchar(4000)
email_verified: tinyint
scope: varchar(80)
activate_token: varchar(200)
reset_token: varchar(200)
perm_resources
resource_id: int PRIMARY KEY AUTO_INCREMENT
resource_name: varchar(256)
perm_roles_to_resource
role_id: int
resource_id: int
perm: int
perm_roles
role_id: int PRIMARY KEY AUTO_INCREMENT
role_name: varchar(256)
starting_page: varchar(256)
perm_user_to_role
role_id: int
user_id: int
tbl_Cert
CertID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CertName: varchar(256)
CertContent: text
CourseID: int NULL
tbl_TblChatMessage
ChatMessageID: int PRIMARY KEY auto_increment
RoomID: int NULL
ConferenceID: int NULL
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
DateTime: datetime NULL
Message: varchar(256) NULL
tbl_TblConference
ConferenceID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ConferenceName: varchar(256) NULL
ConferenceDesc: varchar(256) NULL
ImagePath: varchar(256) NULL
ConferenceStartDate: datetime NULL
ConferenceEndDate: datetime NULL
IsActive: int NULL
ApprovalRequired: int NULL
tbl_CourseCategory
CourseCategoryID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CourseCategoryName: varchar(256)
CourseCategoryActive: int
tbl_CourseForumMessage
CourseForumMessageID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
MessageContent: text
IsApproved: int
CourseForumThreadID: int
tbl_CourseForumThread
CourseForumThreadID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
ForumThreadTitle: varchar(256) NULL
ForumThreadDesc: varchar(512) NULL
CourseID: int
tbl_CourseMessage
CourseMessageID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
MessageDate: datetime NULL
MessageTitle: varchar(256)
MessageContent: text
CourseID: int
tbl_Courses
CourseID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
CourseName: varchar(256)
CourseShortDesc: longtext NULL
CourseLongDesc: longtext NULL
CourseActive: int
CoursePromo: int
CourseConfCertLevel: int
CourseConfPublicLevel: int
CourseConfEnrollLevel: int
CourseConfImagePath: varchar(512) NULL
CourseInviteToken: varchar(512) NULL
CourseCategoryID: int
CoursePromoText: varchar(32) NULL
tbl_CoursesAdmins
CourseID: int
UserID: int
CreateUpdateDate: datetime NULL
RoleName: varchar(256)
tbl_CoursesUsers
CourseID: int
UserID: int
CreateUpdateDate: datetime NULL
CompletionDate: datetime NULL
Completed: int
EnrolledState: int NULL
tbl_Faq
FaqID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
FaqName: varchar(256)
FaqContent: text
FaqActive: int NULL
tbl_LecturePage
LecturePageID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
LectureID: int
LectureEntryType: int
LectureEntryContent: longtext NULL
LectureEntryDescription: longtext NULL
CanDownload: int NULL
tbl_LectureSeen
LectureSeenID: int PRIMARY KEY auto_increment
LectureID: int NULL
UserID: int NULL
tbl_Lectures
LectureID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
LectureName: varchar(256)
LectureShortDesc: varchar(512) NULL
LectureLongDesc: longtext NULL
LectureActive: int NULL
LectureRequired: int NULL
CourseID: int NULL
LectureStartDate: datetime NULL
LectureOrder: int NULL
tbl_TblOpinionPool
RoomID: int
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
PoolName: varchar(256) NULL
tbl_Quiz
QuizID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
QuizName: varchar(256)
QuizDesc: varchar(512)
QuizActive: int
QuizStartDate: datetime
CourseID: int NULL
AutoRate: int NULL
PassRate: int NULL
RetryRate: int NULL
MaxQuestions: int NULL
TimeLimit: int NULL
tbl_QuizEntry
QuizEntryID: int PRIMARY KEY auto_increment
Question: text
Instructions: text
Type: int
Structure: text
QuizID: int
Position: int
tbl_QuizResult
QuizResultID: int PRIMARY KEY auto_increment
UpdatedByContactID: int NULL
RatedByID: int NULL
UserID: int
CreateUpdateDate: datetime NULL
StartTime: datetime
EndTime: datetime NULL
Score: varchar(512) NULL
ScoreNumber: float NULL
ScorePass: int
AutoRate: int NULL
State: int
QuizID: int
TryNum: int NULL
Answers: text NULL
tbl_TblRoom
RoomID: int PRIMARY KEY auto_increment
ConferenceID: int
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
RoomName: varchar(256) NULL
RoomDesc: varchar(256) NULL
EnableAudioParticipant: int NULL
EnableVideoParticipant: int NULL
tbl_RoomMessage
MessageRoomID: int PRIMARY KEY auto_increment
RoomID: int
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
Message: text NULL
UserID: int
tbl_TeacherInCourse
TeacherInCourseID: int PRIMARY KEY auto_increment
CourseID: int NULL
UserID: int NULL
tbl_TblUserToConference
UserToConferenceID: int PRIMARY KEY auto_increment
UserID: int NULL
ConferenceID: int NULL
RoleID: int NULL
ApprovalStatus: int NULL
AccessToken: varchar(256) NULL
AccessName: varchar(256) NULL
AccessEmail: varchar(4000) NULL
CanChat: int NULL
Attended: int NULL
UpdatedByContactID: int NULL
CreateUpdateDate: datetime NULL
user_info
user_info_id: int PRIMARY KEY auto_increment
user_id: int
user_created: datetime
user_modified: datetime
user_last_login: datetime
user_fname: varchar(32)
user_lname: varchar(32)
user_email: varchar(128)
user_phone: varchar(32)
user_city: varchar(64)
user_birth: datetime
user_zone: varchar(64) DEFAULT "UTC"
user_datetimeformat: varchar(64) DEFAULT "MM/DD/YYYY h:mm A"
archived_date: datetime
temp_access_token: varchar(512) NULL
type: int NULL