Open topic with navigation

MARKINGCOLUMN (4.0SP20)

no changes

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

This table contains information about a marking column.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
MARKINGCOLUMNSETID	uniqueidentifier	false	MARKINGCOLUMNSET.ID	The marking column set to which this marking column belongs.
MARKINGCOLUMNDESCRIPTIONCODEID	uniqueidentifier	false	MARKINGCOLUMNDESCRIPTIONCODE.ID	Description of the marking column.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.

Fields
Field	Field Type	Null	Notes	Description
DISPLAYNAME	nvarchar(10)	false	''	The short display name of the marking column.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
ALLTERMS	bit	false	1	Marking column is associated with all terms.
SEQUENCE	int	false	0	Allows the user to sequence the marking column set.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_MARKINGCOLUMN_DATEADDED	DATEADDED	False	False	True
IX_MARKINGCOLUMN_DATECHANGED	DATECHANGED	False	False	False
PK_MARKINGCOLUMN	ID	True	True	False
UIX_MARKINGCOLUMN_MARKINGCOLUMNSETID_DISPLAYNAME	MARKINGCOLUMNSETID DISPLAYNAME	True	False	False
UIX_MARKINGCOLUMN_MARKINGCOLUMNSETID_MARKINGCOLUMNDESCRIPTIONCODEID	MARKINGCOLUMNSETID MARKINGCOLUMNDESCRIPTIONCODEID	True	False	False
UIX_MARKINGCOLUMN_MARKINGCOLUMNSETID_SEQUENCE	MARKINGCOLUMNSETID SEQUENCE	True	False	False

Triggers
Trigger Name	Description
TR_MARKINGCOLUMN_AUDIT_UPDATE
TR_MARKINGCOLUMN_AUDIT_DELETE

Referenced by
Referenced by	Field
COURSEGRADINGMARKINGCOLUMN	MARKINGCOLUMNID
MARKINGCOLUMNTERM	MARKINGCOLUMNID