ГОСТ Р МЭК 61512-2—2016
Приложение В
(обязательное)
Листинг определений Языка структурированных запросов SQL
Данное приложение содержит примеры составления текстов программ для формирования таблиц (в соот
ветствии с ИСО/МЭК 9075:1992). приведенных в разделе 5.
CHAR (32)
CHAR (128)
NOT NULL
NOT NULL.
CREATE TABLE BXT_Exchange (
ExchangelD
ExchangeValue
PRIMARY KEY (ExchangelD))
INSERT INTO BXT_Exchange (ExchangelD. ExchangeValue)
VALUES (’Schema-. ’IEC 61512-2 2001’)
VALUES ("Delimiter’. Г)
VALUES ("ToollD’. ToolName")
VALUES (ToolVersion’, ’4.0")
VALUES (ToolSchema". "1.2")
NOT NULL.
CREATE TABLE BXT_EnumerationSet (
EnumSet
Description
PRIMARY KEY (EnumSet))
CHAR (32)
CHAR (255).
NOT NULL.
NOT NULL.
CREATE TABLE BXT Enumeration (
EnumSet
EnumValue
EnumString
Description
PRIMARY KEY (EnumSet. EnumValue»
CHAR (32)
INTEGER
CHAR (32).
CHAR (255).
INSERT INTO BXT_EnumerationSet (EnumSet. Description)
VALUES (Boolean". "Defines a set of Boolean values")
VALUES ("DirectionType".
"Defines how a parameter is intended to be handled")
VALUES ("EquipmentLevel".
"Defines the equipment hierarchical level for equipment elements’)
VALUES ("EquipmentType",
"Defines the type of equipment record for equipment elements’)
VALUES ("EvaluatkxiRule".
"Defines the evaluation rules for equipment properties’)
VALUES ("FormulaSubType’. ’Defines the recipe formula types’)
VALUES ("FormulaType". "User supplied formula sub type definitions’)
VALUES CLinkDepiction’.
’Defines how links between recipe elements are to be depicted’)
VALUES CLinkToType". ’Defines if a link references a step or a transition’)
VALUES ("LinkType’. "Defines the type of link")
VALUES ("RE.Type’.
’Defines the recipe element, either recipe procedure level or allocation entity")
VALUES (’RE_Use\ ’Defines ho*// a recipe element is used in a recipe")
VALUES ("RecipeStatus". ’Defines the possible status of a recipe"
VALUES ("RecordSet".
"Definesthe enumeration setused toclassifya record intoa categoryofbatch historyinformation.’)
VALUES ("RecordSetControlRecipe’,
’Provides further history record classification under the category of ControlRecipe. ’)
VALUES ("RecordSetMasterRecipe’.
’Provides further history record classification under the category of MasterRecipe.’)
VALUES ("RecordSetExecutionlnfo’.
73