Database Table Standard

[This is preliminary documentation and is subject to change.]

This table holds standard objects. A standard does not hold much information by itself - its main purposes is being container for standard editions.

Most of the data about a standard is stored per edition (table StandardVersion>.

Fields

Field name	Type	Note	Description
StandardCode	VARCHAR(20)	Primary Key	Standard code
StandardName	VARCHAR(255)	Editable	Standard name
StdGroupCode	VARCHAR(20)	Reference to Database Table StdGroup	Specifies where in the hierarchy the standard is placed. The application implements rules for code numbering of groups and standards. These rules may be overridden by user, and the values of the code does NOT determine the standard's position in the hierarchy. It is this field (StdGroupCode) only that determines the position in the hierarchy.
CreatedDateTime	DATETIME		Date and time for creation of standard
CreatedBy	INT		Reference to Employee: id of user who created the standard
UpdatedDateTime	DATETIME		Date and time for latest update of standard
UpdatedBy	INT		Reference to Employee: id of user who latest updated the standard
DeletedDateTime	DATETIME		Date and time for (logical) deletion of standard. NB: NOT USED - standards are physically deleted!
DeletedBy	INT		Reference to Employee: id of user who (logically) deleted the standard. NB: NOT USED - standards are physically deleted!
FrameworkStandard	BIT		Whether or not standard is a framework standard

Relations

Table	Relation
StdGroup	The group where this standard is placed (defines the standard's position) in the grouping hierarchy). See field StdGroupCode above.
StandardVersion.	1:N relation - the eiditons in this standard (remember that anything that is called "standard version" in the database is called "standard edition" in the user interface).
OrgUnitFunction	N:M relation - a version may be related to several OrgUnitFunction objects The N:M relation is implemented by the table StandardFunction

Table

Relation

StdGroup

The group where this standard is placed (defines the standard's position) in the grouping hierarchy).

See field StdGroupCode above.

StandardVersion.

1:N relation - the eiditons in this standard (remember that anything that is called "standard version" in the database is called "standard edition" in the user interface).

OrgUnitFunction

N:M relation - a version may be related to several OrgUnitFunction objects

The N:M relation is implemented by the table StandardFunction