ГОСТ Р МЭК 61512-2—2016
PropertylD
DefauItVaJue
Datalnterpretation
EvaluationRule
EngrUnits
Description
CHAR (32)NOT NULL.
CHAR (128).
INTEGER.
INTEGER.
CHAR (32).
CHAR (255).
PRIMARY KEY (RE_ID. REVersion. PropertylD).
FOREIGN KEY (REJD. REVersion)
REFERENCES BXT_MRecipeElement)
CREATE TABLE BXT_MRecipeStepEquip (
NOT NULL.
NOT NULL.
NOT NULL.
NOT NULL.
ParentRE
ParenlVersion
StepID
PropertylD
PropertyVbJue
CHAR (128)
CHAR (16)
CHAR (128)
CHAR (32)
CHAR (128).
PRIMARY KEY (ParentRE. ParentVersion.StepID. PropertylD).
FOREIGN KEY (ParentRE. ParentVersion.StepID)
REFERENCES BXT_MRectpeStep (ParentRE. ParentVersion. StepID))
CREATE TABLE BXT_EquipElement (
EquipmentlD
EE_Type
EE_Level
Containedln
Description
PRIMARY KEY (EquipmentlD))
CHAR (32)NOT NULL.
INTEGER.
INTEGER.
CHAR (32),
CHAR (255).
NOT NULL.
NOT NULL.
CREATE TABLE BXT_EquipLink (
EquipmentlD
ToEquipmentID
Description
CHAR (32)
CHAR (32)
CHAR (255).
PRIMARY KEY (EquipmentlD . ToEquipmentID).
FOREIGN KEY (EquipmentlD)
REFERENCES BXT_EquipElement.
FOREIGN KEY (ToEquipmentID)
REFERENCES BXT_EquipElement)
NOT NULL.
NOT NULL.
CREATE TABLE BXT_Equiplnclude (
EquipmentlD
ClassEquipmentID
Description
CHAR (32)
CHAR (32)
CHAR (255).
PRIMARY KEY (EquipmentlD. ClassEquipmentID).
FOREIGN KEY (EquipmentlD)
REFERENCES BXT_EquipElement.
FOREIGN KEY (ClassEquipmentID)
REFERENCES BXT_EquipElement)
CREATE TABLE BXT_EquipProperty (
NOT NULL.
NOT NULL.
EquipmentlD
PropertylD
PropertyVaJue
EngrUnits
Description
CHAR (32)
CHAR (32)
CHAR (255).
CHAR (32).
CHAR (255).
PRIMARY KEY (EquipmentlD. PropertylD).
FOREIGN KEY (EquipmentlD)
REFERENCES BXT_EquipElement)
CREATE TABLE BXT_Equiplnterface (
EquipmentlDCHAR (32)NOT NULL.
80