ГОСТ Р МЭК 61512-2—2016
ToType
ToElement
LinkType
VerticalStart
VerticalStop
HorizontalStart
HorizontalStop
Depiction
EvaluationOrder
INTEGER.
CHAR (128),
INTEGER.
FLOAT.
FLOAT.
FLOAT.
FLOAT.
INTEGER.
INTEGER.
PRIMARY KEY (REJD. REVersion. LinkID),
FOREIGN KEY (REJD. REVersion)
REFERENCES BXT_MRecipeElement (REJD. REVerson))
CREATE TABLE BXTMRecipeElementParameter (
NOT NULL.
NOT NULL.
NOT NULL.
REJD
REVersion
ParameterlD
ParentParamlD
Datalnterpretation
DataDirection
DefaullValue
Description
EngrUnits
EnumSet
DefaultScaling
ParamType
ParamSubType
CHAR (128)
CHAR (16)
CHAR(32)
CHAR(32),
INTEGER.
INTEGER.
CHAR(128).
CHAR(255).
CHAR(32).
CHAR (32).
INTEGER.
INTEGER.
INTEGER.
PRIMARY KEY (RE..ID. REVersion. ParameterlD).
FOREIGN KEY (REJD. REVersion)
REFERENCES BXT_MRecipeElement (REJD. REVersion))
CREATE TABLE BXT_MReapeStepParameter {
ParentRE
ParentVersion
StepID
ParameterlD
ParentParamlD
ParameterValue
Datalnterpretation
Scaled
CHAR (128)
CHAR (16)
CHAR (128)
CHAR (32)
CHAR (32).
CHAR (128),
INTEGER.
INTEGER.
NOT NULL.
NOT NULL.
NOT NULL.
NOT NULL.
PRIMARY KEY (ParentRE. ParentVersion. StepID. ParameterlD),
FOREIGN KEY (ParentRE. ParentVersion. StepID)
REFERENCES BXT_MRecipeStep (ParentRE. ParentVersion. StepID))
CREATE TABLE BXT_MRecipeOtherlnformation (
REJD
REVersion
StepID
DatalD
DataType
DataValue
Description
CHAR (128)
CHAR (16)
CHAR (128)
CHAR (32)
CHAR (32).
CHAR (255).
CHAR (255).
NOT NULL.
NOT NULL.
NOT NULL.
NOT NULL.
PRIMARY KEY (REJD. REVersion. DatalD).
FOREIGN KEY (REJD. REVersion)
REFERENCES BXT_MRecipeElement (REJD. REVersion))
CREATE TABLE BXTJHRecipeElementEquip (
REJD
REVersion
CHAR (128)
CHAR (16)
NOT NULL.
NOT NULL.
79