27 lines
805 B
SQL
27 lines
805 B
SQL
CREATE TABLE IF NOT EXISTS AssignmentSummary (
|
|
DropboxId BIGINT NOT NULL,
|
|
OrgUnitId INT NOT NULL,
|
|
Name VARCHAR(128),
|
|
Category VARCHAR(128),
|
|
Type VARCHAR(10),
|
|
GradeItemId BIGINT,
|
|
PossibleScore DECIMAL(19, 9),
|
|
StartDate DATETIME,
|
|
EndDate DATETIME,
|
|
DueDate DATETIME,
|
|
IsRestricted TINYINT(1),
|
|
IsDeleted TINYINT(1),
|
|
TurnItInEnabled TINYINT(1),
|
|
IsHidden TINYINT(1),
|
|
SortOrder INT,
|
|
SubmissionType VARCHAR(18),
|
|
CompletionType VARCHAR(27),
|
|
ResultId INT,
|
|
CategoryId BIGINT,
|
|
Version BIGINT,
|
|
StartDateAvailabilityType SMALLINT,
|
|
EndDateAvailabilityType SMALLINT,
|
|
AIUtilization INT COMMENT '0=None, 1=AI+Review, 2=AI+Edit, 3=Assisted, 4=AI No Review',
|
|
Instructions TEXT,
|
|
PRIMARY KEY (DropboxId)
|
|
) CHARACTER SET utf8mb4; |