The Entity Relationship Modell, which takes VDA 210-300 into account, could look as follows:
The JSON-Code, which takes VDA 210-300 into account, could look as follows:
"Generic.PropertyRequirement": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "PropertyRequirement","type": "string"},
"Property" : {"$ref": "#/$defs/Generic.RestrictedString"},
"Symbol" : {"$ref": "#/$defs/Generic.RestrictedString"},
"Unit" : {"$ref": "#/$defs/Generic.Unit"},
"Specification" : {"$ref": "#/$defs/Generic.Specification" },
"ValueType" : {"oneOf": [{"const": "NumberWithTolerance"},
{"const": "Range" },{"const": "Text"},
{"const": "Number"},{"const": "List"}]},
"Value" : {"$ref": "#/$defs/Generic.Value"},
"Rounding" : {"$ref": "#/$defs/Generic.RestrictedString"},
"RoundingAccuracy" : {"type": "number"},
"LocalizedText" : {"$ref": "#/$defs/Generic.ProperNameString"}
},
"required": ["Property","Value"],
"type": "object"},
"Generic.DeviatingProperties": {
“properties”: {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": " DeviatingProperty ","type": "string"},
"OriginalPropertyRequirement" : {"$ref”: “#defs/Generic.PropertyRequirement” }
"DeviatingPropertyRequirement": {"$ref”: “#defs/Generic.PropertyRequirement” }
} }
„Generic.TypPropertyRelateToSpec“: {
„properties“ : {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "TypPropertyRelateToSpec","type": "string"},
„TypPropertyRelation“ : {“const”: OneOf [„BasicPropertyOfSpecification“;
“OptionalPropertyOfSpecification”;
“CustomizedDeviationPropertyOfSpecification”;
“CustomizedFurtherProperty” ]; “type”: “string”}
} }
„Generic.SpecificationProperties“: {
„properties“ : {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "SpecOrCustomRequirement","type": "string"},
„Specification“ : {„$ref“: "#/defs/Generic.Specification"},
“TypRelateToSpec” : {“items”: {“$ref”: “#/$defs/Generic.TypPropertyRelateToSpec“ }, “type”:”array”},
"PropertyRequirement" : {"items": {OneOf [ {"$ref": "#/$defs/Generic.PropertyRequirement"},
{"$ref": "#/$defs/"Generic.DeviatingProperties„} ],
"minItems": 1, "type": "array", „description“: „List of properties of specification“},
„AlsoValidSpecification“ : {„items“: {„$ref“: "#/defs/Generic.Specification"}, „type“: „array“}
},
"required": ["_id","_type", „AnyOf“ : ["Specification";“PropertyRequirement“]],"type": "object"},
„Generic.ObjectSpecificationList“ : {
„properties“ : {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ObjectSpecificationList","type": "string"},
„RequirementList“:{„items“:{„$ref“:"#/defs/Generic.SpecOrCustomRequirement"},
„type“: „array“} },
"required": ["_id","_type","RequirementList"],"type": "array"},
„Generic.SpecificationObjectGroup“ : {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": „SpecificationObjectGroup", "type": "string"},
„GroupName“ : {"$ref": "#/$defs/Generic.LongString"},
„Partquantity“ : {"type": "number"},
„Partname“ : {„items“: {"$ref": "#/$defs/Generic.LongString"}, "type": "array";
„description“: „A list of names for each single part of the group“},
„SpecificationList“ : {„$ref“: „#/$defs/Generic.ObjectSpecificationList“,
"description": "A list of associated requirements
regarding this group of objects of a component."},
"PropertyRequirement" : {"items": {"$ref": "#/$defs/Generic.PropertyRequirement"}, "type": "array",
„description“: „List of further properties without specification“},
}
"required": ["_id","_type","GroupName",“Partquantity“,“RequirementList“],
"type": "object„ }
"Generic.SpecificationOneCategory": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": „SpecificationOneCategory","type": "string"},
„Category“ : {"$ref": "#/$defs/Generic.LongString"},
„Relating“ : {{"$ref": "#/$defs/Generic.RestrictedString"}, AnyOF : [ {„Body“, „Surface“} ],
„SpecificationCategory“ : { „items“ : {"$ref": "#/$defs/Generic.SpecificationObjectGroup"},“type“: „array“},
}
"required": ["_id","_type",“CategoryRequirements“}],"type": "object"
"Generic.ComponentSpecificationList": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ComponentSpecificationList","type": "string"},
„SpecificationList“ : { „items“ : {"$ref": "#/$defs/Generic.SpecificationOneCategory "},“type“: „array“},
}
"required": ["_id","_type",“SpecificationList“}],"type": "object"
"Generic.Color": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "Color","type": "string"},
"ColorName" : {"$ref": "#/$defs/Generic.RestrictedString"},
"ColorIdentifier" : {"$ref": "#/$defs/Generic.RestrictedString",
„description“: „Identifier or Code“ },
„Specification“ : {"$ref": "#/$defs/Generic.Specification",
„description“ : „Specification of RAL gGmbH, Pantone (PMS),
Natural Color System (NCS) or other supplier specification“ }
}
"required": ["_id","_type", “ColorName"],
“type”: “object” }
"Generic.ColorCode": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ColorCode","type": "string"},
“ColorList” : {"items": {"$ref": "#/$defs/Generic.Color"},"type": "array",
„description“: „List of Colors define the Color-Code“ }
}
"required": ["_id","_type", “ColorName"],
“type”: “object” }
"Generic.ComponentSpecification": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ComponentSpecification","type": "string"},
"Instances" : {"items": {"$ref": "#/$defs/Generic.ComponentInstance"},"type": "array", "description": "A list of instances of this component."},
„SubsupplierPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Part number of the subsupplier"},
"SupplierPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Tier-N part number"},
"Colors" : {"$ref": "#/$defs/Generic.ColorCode"},
"MaterialGroup" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-106"},
"MaterialClass" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-200"},
"MaterialName" : {"$ref": "#/$defs/Generic.RestrictedString"},
"MaterialIdentifiers" : {"items": {"$ref": "#/$defs/Generic.RestrictedString"},"type": "array", "description": "According to VDA 231-300"},
"SurfaceGroup" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-106"},
"SurfaceClass" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-200"},
"SurfaceName" : {"$ref": "#/$defs/Generic.RestrictedString"},
"SurfaceIdentifiers" : {"items": {"$ref": "#/$defs/Generic.RestrictedString"},"type": "array",
"description": "According to VDA 231-300"},
„Specification“ : {„$ref“: „#$defs/Generic.ComponentSpecificationList„ },
"Attachments" : {"items": {"$ref": "#/$defs/Generic.Attachment"},"type": "array"},
"Comment" : {"$ref": "#/$defs/Generic.RestrictedText",
"description": "Additional information about the component."}
},
"required": ["_id","_type","Instances"], "type": "object„ }
"Generic.GeneralComponentSpecification": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": „GeneralComponentSpecification","type": "string"},
"Instances" : {"items": {"$ref": "#/$defs/Generic.ComponentInstance"},"type": "array", "description": "A list of instances of this component."},
"CustomerPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Part number of the customer"},
"SupplierPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Tier-N part number"},
„Specification“ : {{"items": {„$ref“: „#$defs/Generic.ComponentSpecification"}, “type“: „array“},
"Attachments" : {"items": {"$ref": "#/$defs/Generic.Attachment"},"type": "array"},
"Comment" : {"$ref": "#/$defs/Generic.RestrictedText",
"description": "Additional information about the component."}
},
"required": ["_id","_type","Instances"], "type": "object„ }
The Entity Relationship Modell, which takes VDA 210-300 into account, could look as follows:
The JSON-Code, which takes VDA 210-300 into account, could look as follows:
"Generic.PropertyRequirement": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "PropertyRequirement","type": "string"},
"Property" : {"$ref": "#/$defs/Generic.RestrictedString"},
"Symbol" : {"$ref": "#/$defs/Generic.RestrictedString"},
"Unit" : {"$ref": "#/$defs/Generic.Unit"},
"Specification" : {"$ref": "#/$defs/Generic.Specification" },
"ValueType" : {"oneOf": [{"const": "NumberWithTolerance"},
{"const": "Range" },{"const": "Text"},
{"const": "Number"},{"const": "List"}]},
"Value" : {"$ref": "#/$defs/Generic.Value"},
"Rounding" : {"$ref": "#/$defs/Generic.RestrictedString"},
"RoundingAccuracy" : {"type": "number"},
"LocalizedText" : {"$ref": "#/$defs/Generic.ProperNameString"}
},
"required": ["Property","Value"],
"type": "object"},
"Generic.DeviatingProperties": {
“properties”: {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": " DeviatingProperty ","type": "string"},
"OriginalPropertyRequirement" : {"$ref”: “#defs/Generic.PropertyRequirement” }
"DeviatingPropertyRequirement": {"$ref”: “#defs/Generic.PropertyRequirement” }
} }
„Generic.TypPropertyRelateToSpec“: {
„properties“ : {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "TypPropertyRelateToSpec","type": "string"},
„TypPropertyRelation“ : {“const”: OneOf [„BasicPropertyOfSpecification“;
“OptionalPropertyOfSpecification”;
“CustomizedDeviationPropertyOfSpecification”;
“CustomizedFurtherProperty” ]; “type”: “string”}
} }
„Generic.SpecificationProperties“: {
„properties“ : {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "SpecOrCustomRequirement","type": "string"},
„Specification“ : {„$ref“: "#/defs/Generic.Specification"},
“TypRelateToSpec” : {“items”: {“$ref”: “#/$defs/Generic.TypPropertyRelateToSpec“ }, “type”:”array”},
"PropertyRequirement" : {"items": {OneOf [ {"$ref": "#/$defs/Generic.PropertyRequirement"},
{"$ref": "#/$defs/"Generic.DeviatingProperties„} ],
"minItems": 1, "type": "array", „description“: „List of properties of specification“},
„AlsoValidSpecification“ : {„items“: {„$ref“: "#/defs/Generic.Specification"}, „type“: „array“}
},
"required": ["_id","_type", „AnyOf“ : ["Specification";“PropertyRequirement“]],"type": "object"},
„Generic.ObjectSpecificationList“ : {
„properties“ : {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ObjectSpecificationList","type": "string"},
„RequirementList“:{„items“:{„$ref“:"#/defs/Generic.SpecOrCustomRequirement"},
„type“: „array“} },
"required": ["_id","_type","RequirementList"],"type": "array"},
„Generic.SpecificationObjectGroup“ : {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": „SpecificationObjectGroup", "type": "string"},
„GroupName“ : {"$ref": "#/$defs/Generic.LongString"},
„Partquantity“ : {"type": "number"},
„Partname“ : {„items“: {"$ref": "#/$defs/Generic.LongString"}, "type": "array";
„description“: „A list of names for each single part of the group“},
„SpecificationList“ : {„$ref“: „#/$defs/Generic.ObjectSpecificationList“,
"description": "A list of associated requirements
regarding this group of objects of a component."},
"PropertyRequirement" : {"items": {"$ref": "#/$defs/Generic.PropertyRequirement"}, "type": "array",
„description“: „List of further properties without specification“},
}
"required": ["_id","_type","GroupName",“Partquantity“,“RequirementList“],
"type": "object„ }
"Generic.SpecificationOneCategory": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": „SpecificationOneCategory","type": "string"},
„Category“ : {"$ref": "#/$defs/Generic.LongString"},
„Relating“ : {{"$ref": "#/$defs/Generic.RestrictedString"}, AnyOF : [ {„Body“, „Surface“} ],
„SpecificationCategory“ : { „items“ : {"$ref": "#/$defs/Generic.SpecificationObjectGroup"},“type“: „array“},
}
"required": ["_id","_type",“CategoryRequirements“}],"type": "object"
"Generic.ComponentSpecificationList": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ComponentSpecificationList","type": "string"},
„SpecificationList“ : { „items“ : {"$ref": "#/$defs/Generic.SpecificationOneCategory "},“type“: „array“},
}
"required": ["_id","_type",“SpecificationList“}],"type": "object"
"Generic.Color": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "Color","type": "string"},
"ColorName" : {"$ref": "#/$defs/Generic.RestrictedString"},
"ColorIdentifier" : {"$ref": "#/$defs/Generic.RestrictedString",
„description“: „Identifier or Code“ },
„Specification“ : {"$ref": "#/$defs/Generic.Specification",
„description“ : „Specification of RAL gGmbH, Pantone (PMS),
Natural Color System (NCS) or other supplier specification“ }
}
"required": ["_id","_type", “ColorName"],
“type”: “object” }
"Generic.ColorCode": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ColorCode","type": "string"},
“ColorList” : {"items": {"$ref": "#/$defs/Generic.Color"},"type": "array",
„description“: „List of Colors define the Color-Code“ }
}
"required": ["_id","_type", “ColorName"],
“type”: “object” }
"Generic.ComponentSpecification": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": "ComponentSpecification","type": "string"},
"Instances" : {"items": {"$ref": "#/$defs/Generic.ComponentInstance"},"type": "array", "description": "A list of instances of this component."},
„SubsupplierPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Part number of the subsupplier"},
"SupplierPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Tier-N part number"},
"Colors" : {"$ref": "#/$defs/Generic.ColorCode"},
"MaterialGroup" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-106"},
"MaterialClass" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-200"},
"MaterialName" : {"$ref": "#/$defs/Generic.RestrictedString"},
"MaterialIdentifiers" : {"items": {"$ref": "#/$defs/Generic.RestrictedString"},"type": "array", "description": "According to VDA 231-300"},
"SurfaceGroup" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-106"},
"SurfaceClass" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "According to VDA 231-200"},
"SurfaceName" : {"$ref": "#/$defs/Generic.RestrictedString"},
"SurfaceIdentifiers" : {"items": {"$ref": "#/$defs/Generic.RestrictedString"},"type": "array",
"description": "According to VDA 231-300"},
„Specification“ : {„$ref“: „#$defs/Generic.ComponentSpecificationList„ },
"Attachments" : {"items": {"$ref": "#/$defs/Generic.Attachment"},"type": "array"},
"Comment" : {"$ref": "#/$defs/Generic.RestrictedText",
"description": "Additional information about the component."}
},
"required": ["_id","_type","Instances"], "type": "object„ }
"Generic.GeneralComponentSpecification": {
"properties": {
"_id" : {"$ref": "#/$defs/Generic.Identifier"},
"_type" : {"const": „GeneralComponentSpecification","type": "string"},
"Instances" : {"items": {"$ref": "#/$defs/Generic.ComponentInstance"},"type": "array", "description": "A list of instances of this component."},
"CustomerPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Part number of the customer"},
"SupplierPartNumber" : {"$ref": "#/$defs/Generic.RestrictedString", "description": "Tier-N part number"},
„Specification“ : {{"items": {„$ref“: „#$defs/Generic.ComponentSpecification"}, “type“: „array“},
"Attachments" : {"items": {"$ref": "#/$defs/Generic.Attachment"},"type": "array"},
"Comment" : {"$ref": "#/$defs/Generic.RestrictedText",
"description": "Additional information about the component."}
},
"required": ["_id","_type","Instances"], "type": "object„ }