20 lines
626 B
SQL
20 lines
626 B
SQL
CREATE TABLE IF NOT EXISTS GradeResults (
|
|
GradeObjectId INT NOT NULL,
|
|
OrgUnitId INT NOT NULL,
|
|
UserId INT NOT NULL,
|
|
PointsNumerator DECIMAL(19, 9),
|
|
PointsDenominator DECIMAL(19, 9),
|
|
WeightedNumerator DECIMAL(19, 9),
|
|
WeightedDenominator DECIMAL(19, 9),
|
|
IsReleased TINYINT(1),
|
|
IsDropped TINYINT(1),
|
|
LastModified DATETIME,
|
|
LastModifiedBy INT,
|
|
Comments VARCHAR(1000),
|
|
PrivateComments VARCHAR(1000),
|
|
GradeText VARCHAR(50),
|
|
GradeReleasedDate DATETIME,
|
|
Version BIGINT,
|
|
IsDeleted TINYINT(1),
|
|
PRIMARY KEY (GradeObjectId, OrgUnitId, UserId)
|
|
) CHARACTER SET utf8mb4; |