Recipe schema model structure

Recipe schema model structure organizes recipe data in database tables, including recipes, items, data items, and metadata. Each table includes specific fields to store relevant information.

Database Tables

Recipe schema model structure can be stored in the database, preserving the information if a variable stands alone or is part of an object. Recipe parameters are displayed in rows organized as follows:
  • Recipes:
    • Id (Primary key) [UInt32]
    • Name [String]
    • Version [String]
    • RecipeSchemaName [String]
    • RecipeSchemaNamespaceUri [String]
    • RecipeSchemaTimestamp [DateTime]
    • CreatedAt [DateTime]
    • ModifiedAt [DateTime]
  • RecipeItems:
    • Id (Primary key) [UInt32]
    • RecipeId [UInt32]
    • RelativeBrowsePath [String]
    • TypeId [String]
  • RecipeDataItems:
    • Id (Primary key) [UInt32]
    • RecipeItemId [UInt32]
    • RelativeBrowsePath [String]
    • ElementAccess [String]
    • DataTypeId [String]
    • Value [String]
  • RecipeMetadata:
    • Metadata1 [UserDefined]
    • Metadata2 [UserDefined]
    • …
    • Metadata_n [UserDefined]
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal