Open topic with navigation

TERM (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers

Terms for a Session

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
SESSIONID	uniqueidentifier	true	SESSION.ID	The session that the term is related to.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
TIMETABLEDAYID	uniqueidentifier	false	TIMETABLEDAY.ID	The timetable day the term starts with.
TERMNAMECODEID	uniqueidentifier	false	TERMNAMECODE.ID	Name of the term.

Fields
Field	Field Type	Null	Notes	Description
STARTDATE	date	false		Start date of the term.
ENDDATE	date	false		End date of the term.
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.
WITHDRAWALDATE	date	false		Withdrawal date of the term.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_TERM_DATEADDED	DATEADDED	False	False	True
IX_TERM_DATECHANGED	DATECHANGED	False	False	False
PK_TERM	ID	True	True	False
UIX_TERM_TERMNAMECODEID_SESSIONID	TERMNAMECODEID SESSIONID	True	False	False

Triggers
Trigger Name	Description
TR_TERM_AUDIT_UPDATE
TR_TERM_AUDIT_DELETE
TR_TERM_DELETE