ГОСТ Р МЭК 61512-2—2016
CREATE TABLE BXT_MRecipeElement (
REID
REVersion
VersionDate
ApprovalDate
EffectiveDate
ExpirationDate
Author
ApprovedBy
ProcessCelllD
ProductlD
UsageConstraint
Description
Status
RE_Type
RE_Function
RE_Use
DerivedRE
DerivedVersion
CHAR (128)
CHAR (16)
DATETIME.
DATETIME.
DATETIME.
DATETIME.
CHAR (32).
CHAR (32).
CHAR (32).
CHAR (32).
CHAR (255).
CHAR (255).
INTEGER.
INTEGER.
CHAR (255).
INTEGER.
CHAR (128).
CHAR (16).
PRIMARY KEY (RE_ID. REVersion))
NOT NULL.
NOT NULL.
CREATE TABLE BXT_MRecipeStep (
ParentRE
ParentVersion
StepID
REJD
REVersion
VerticalStart
VerticalStop
HorizontalStart
HorizontaISlop
ScaleReference
ScateEngrtJnils
MaximumScale
MinimumScale
CHAR (128)
CHAR (16)
CHAR (128)
CHAR (128)
CHAR (16)
FLOAT.
FLOAT.
FLOAT.
FLOAT.
FLOAT.
CHAR (32).
FLOAT.
FLOAT.
NOT NULL.
NOT NULL.
NOT NULL.
NOT NULL.
NOT NULL.
PRIMARY KEY (ParentRE. ParentVersion. StepID).
FOREIGN KEY (REJD. REVersion)
REFERENCES BXT_MRecipeElement (REJD. REVersion))
CREATE TABLE BXT_MRecipeTransition (
NOT NULL.
NOT NULL.
NOT NULL.
REJD
REVersion
TransitionlD
Condition
VerticalStart
VerticalStop
HorizontalStart
HorizontalStop
CHAR (128)
CHAR (16)
CHAR (128)
CHAR (255).
FLOAT.
FLOAT.
FLOAT.
FLOAT.
PRIMARY KEY (REJD. REVersion. TransitionlD).
FOREIGN KEY (REJD. REVersion)
REFERENCES BXT_MRecipeElement (REJD. REVersion))
CREATE TABLE BXT_MRecipeLink {
REJD
REVersion
LinkID
FromType
FromElement
CHAR (128)
CHAR (16)
CHAR (32)
INTEGER.
CHAR (128).
NOT NULL.
NOT NULL.
NOT NULL.
78