28 lines
935 B
SQL
28 lines
935 B
SQL
CREATE TABLE IF NOT EXISTS ContentObjects (
|
|
ContentObjectId INT NOT NULL,
|
|
OrgUnitId INT NOT NULL,
|
|
Title VARCHAR(150),
|
|
ContentObjectType VARCHAR(6) COMMENT 'Topic or Module',
|
|
CompletionType VARCHAR(7),
|
|
ParentContentObjectId INT,
|
|
Location VARCHAR(1024),
|
|
StartDate DATETIME,
|
|
EndDate DATETIME,
|
|
DueDate DATETIME,
|
|
ObjectId1 INT COMMENT 'Quick link Object ID (Dropbox, Quiz, etc)',
|
|
ObjectId2 INT COMMENT 'Quick link Object ID (Discussion Topic)',
|
|
ObjectId3 INT COMMENT 'Quick link Object ID (Discussion Thread)',
|
|
LastModified DATETIME,
|
|
IsDeleted TINYINT(1),
|
|
SortOrder INT,
|
|
Depth INT,
|
|
ToolId INT,
|
|
IsHidden TINYINT(1),
|
|
ResultId INT,
|
|
DeletedDate DATETIME,
|
|
CreatedBy INT,
|
|
LastModifiedBy INT,
|
|
DeletedBy INT,
|
|
AIUtilization INT COMMENT '0=None, 1=Review, 2=Edited, 3=Assisted, 4=Generated',
|
|
PRIMARY KEY (ContentObjectId)
|
|
) CHARACTER SET utf8mb4; |