Open Know Where Standard Entity Relationship Diagram

U OKW_Schema The Internet of Production Alliance Read the schema comments as mouse-over tooltips. Zoom using CTRL + mouse wheel, pan by dragging with the right-mouse button. Fk fk_facility_location 4. Manufacturing Facility Properties ref 6. Location Properties ( - -> 6.1. Address ) Fk fk_facility_location 4. Manufacturing Facility Properties ref 6. Location Properties ( - -> 6.1. Address ) - Fk fk_4.27. circular economy sub-properties 4.27. Circular Economy sub-properties ref 4. Manufacturing Facility Properties ( ) Fk fk_4.27. circular economy sub-properties 4.27. Circular Economy sub-properties ref 4. Manufacturing Facility Properties ( ) Fk fk_4.28. human capacity sub-properties 4.28. Human Capacity sub-properties ref 4. Manufacturing Facility Properties ( ) Fk fk_4.28. human capacity sub-properties 4.28. Human Capacity sub-properties ref 4. Manufacturing Facility Properties ( ) Fk fk_4.29. innovation space sub-properties 4.29. Innovation Space sub-properties ref 4. Manufacturing Facility Properties ( ) Fk fk_4.29. innovation space sub-properties 4.29. Innovation Space sub-properties ref 4. Manufacturing Facility Properties ( ) Fk JSon 5.10 social_media_subproperties ref 5. Agent Properties ( ) Fk JSon 5.10 social_media_subproperties ref 5. Agent Properties ( ) Obj Fk JSon 5.9 contact_subproperties ref 5. Agent Properties ( ) Fk JSon 5.9 contact_subproperties ref 5. Agent Properties ( ) Obj Fk JSon 6.1. Address ref 6. Location Properties ( ) Fk JSon 6.1. Address ref 6. Location Properties ( ) Obj Fk JSon 6.3. GPS Coordinates ref 6. Location Properties ( ) Fk JSon 6.3. GPS Coordinates ref 6. Location Properties ( ) Obj Fk JSon 6.5. What 3 Words sub-properties ref 6. Location Properties ( ) Fk JSon 6.5. What 3 Words sub-properties ref 6. Location Properties ( ) Obj Fk fk_equipment_location 7. Equipment Properties ref 6. Location Properties ( - -> 6.1. Address ) Fk fk_equipment_location 7. Equipment Properties ref 6. Location Properties ( - -> 6.1. Address ) - Fk fk_7.20. defined sub-properties  7.20. Defined sub-properties  ref 7. Equipment Properties ( ) Fk fk_7.20. defined sub-properties  7.20. Defined sub-properties  ref 7. Equipment Properties ( ) Fk fk_8. materials properties 8. Materials Properties ref 7. Equipment Properties ( ) Fk fk_8. materials properties 8. Materials Properties ref 7. Equipment Properties ( ) Fk fk_8.5.1. plastics 8.5.1. Plastics ref 8. Materials Properties ( ) Fk fk_8.5.1. plastics 8.5.1. Plastics ref 8. Materials Properties ( ) Fk fk_8.5.2. metals 8.5.2. Metals ref 8. Materials Properties ( ) Fk fk_8.5.2. metals 8.5.2. Metals ref 8. Materials Properties ( ) Fk fk_8.5.3. wood products 8.5.3. Wood Products ref 8. Materials Properties ( ) Fk fk_8.5.3. wood products 8.5.3. Wood Products ref 8. Materials Properties ( ) Fk fk_8.5.4. elastomers 8.5.4. Elastomers ref 8. Materials Properties ( ) Fk fk_8.5.4. elastomers 8.5.4. Elastomers ref 8. Materials Properties ( ) Fk fk_8.5.5. ceramics 8.5.5. Ceramics ref 8. Materials Properties ( ) Fk fk_8.5.5. ceramics 8.5.5. Ceramics ref 8. Materials Properties ( ) Fk fk_8.5.6. electronics 8.5.6. Electronics ref 8. Materials Properties ( ) Fk fk_8.5.6. electronics 8.5.6. Electronics ref 8. Materials Properties ( ) Fk fk_8.5.7. others 8.5.7. Others ref 8. Materials Properties ( ) Fk fk_8.5.7. others 8.5.7. Others ref 8. Materials Properties ( ) 4. Manufacturing Facility PropertiesEntity INSTANCE.4. Manufacturing Facility Properties 4.1. name4.1. name varchar(30) t 4.2 location4.2 location varchar(30) t 4.3 owner4.3 owner varchar(20) t 4.4 contact4.4 contact varchar(20) t 4.5 affiliation4.5 affiliation varchar(20) t 4.6 facility_status4.6 facility_status varchar(20) t 4.7 opening_hours4.7 opening_hours datetime d 4.8 description4.8 description text t 4.9 data_founded4.9 data_founded date d 4.10 access_type4.10 access_type text t 4.11 wheelchair_accessibility4.11 wheelchair_accessibility text t 4.12 equipment4.12 equipment text t 4.13 manufacturing_process4.13 manufacturing_process text t 4.14 typical_batch_size4.14 typical_batch_size text t 4.15 size_floor_size4.15 size_floor_size text t 4.16 storage_capacity4.16 storage_capacity text t 4.17 typical_materials4.17 typical_materials text t 4.18 certifications4.18 certifications text t 4.19 backup_generator4.19 backup_generator boolean b 4.20 uninterrupted_power_supply4.20 uninterrupted_power_supply boolean b 4.21 road_access4.21 road_access boolean b 4.22 loading_dock4.22 loading_dock boolean b 4.23 maintenance_schedule4.23 maintenance_schedule text t 4.24 typical_products4.24 typical_products text t 4.25 partner_funder4.25 partner_funder varchar(20) t 4.26 customer_reviews4.26 customer_reviews text t 4.27. Circular Economy sub-propertiesEntity INSTANCE.4.27. Circular Economy sub-properties 4.27.1. Circular Economy4.27.1. Circular Economy boolean b 4.27.2. Description4.27.2. Description text t 4.27.3. By-products4.27.3. By-products relationship 4.28. Human Capacity sub-propertiesEntity INSTANCE.4.28. Human Capacity sub-properties 4.28.1. Headcount4.28.1. Headcount int # 4.28.2. Maker (WIP)4.28.2. Maker (WIP) text t 4.29. Innovation Space sub-propertiesEntity INSTANCE.4.29. Innovation Space sub-properties 4.29.1. Staff4.29.1. Staff int # 4.29.2. Learning Resources4.29.2. Learning Resources text t 4.29.3. Services4.29.3. Services text t 4.29.4. Footfall4.29.4. Footfall text t 4.29.5. Residencies4.29.5. Residencies boolean b 5. Agent PropertiesEntity INSTANCE.5. Agent Properties 5.1 name5.1 name varchar(30) The name of the Agent. Note: This could be a name of a person or an organisation. t 5.2 location5.2 location varchar(30) A Location. Uses the Location class. t 5.3 contact_person5.3 contact_person varchar(30) An Agent who is the key point of contact for a manufacturing facility or organisation. Provide the name of the Agent. t 5.4 bio5.4 bio text A description of a person or an organisation. Free text. t 5.5 website5.5 website text Website address. Provide the relevant URL. t 5.6 languages5.6 languages text Languages used by a person or an organisation. Format: ISO 639-2 or ISO 639-3, for example “en-gb”. Often manufacturing facilities may be able to provide services dealing in more than one language. t 5.7 mailing_list5.7 mailing_list text Images / Media of a person, an organisation, or relating to the manufacturing facility. t 5.8 images_media5.8 images_media text Mailing list for an organisation. t 5.9 contact_subproperties5.9 contact_subproperties subtype Defined contact information. 5.10 social_media_subproperties5.10 social_media_subproperties subtype 5.10 social_media_subpropertiesSub-document 5.10 social_media_subproperties 5.10.1 facebook5.10.1 facebook varchar(20) ... t 5.10.2 twitter5.10.2 twitter varchar(20) ... t 5.10.3 instagram5.10.3 instagram varchar(20) ... t 5.10.4 other_urls5.10.4 other_urls varchar(20) ... t 5.9 contact_subpropertiesSub-document 5.9 contact_subproperties Defined contact information. 5.9.1 landline5.9.1 landline numeric(20) A landline telephone number to contact the facility, person or organisation. Provide the telephone number. # 5.9.2 mobile5.9.2 mobile numeric(20) A mobile telephone number to contact the facility, person or organisation. Provide the telephone number. # 5.9.3 fax5.9.3 fax numeric(20) A fax number to contact the facility, person or organisation. Provide the fax number. # 5.9.4 email5.9.4 email varchar(20) ... t 5.9.5 whatsapp5.9.5 whatsapp numeric(20) ... # 6. Location PropertiesEntity INSTANCE.6. Location Properties 6.1. Address6.1. Address subtype 6.3. GPS Coordinates6.3. GPS Coordinates subtype 6.4. Directions6.4. Directions subtype 6.5. What 3 Words sub-properties6.5. What 3 Words sub-properties subtype 6.1. AddressSub-document 6.1. Address numbernumber decimal # streetstreet varchar(40) t districtdistrict subtype citycity subtype regionregion subtype countrycountry char(2) c postcodepostcode varchar(10) t 6.3. GPS CoordinatesSub-document 6.3. GPS Coordinates latitudelatitude decimal # longitudelongitude decimal # altitudealtitude decimal # precisionprecision decimal # 6.5. What 3 Words sub-propertiesSub-document 6.5. What 3 Words sub-properties 6.4.1. What 3 Words6.4.1. What 3 Words varchar(20) t 6.4.2. Language6.4.2. Language varchar(6) t 7. Equipment PropertiesEntity INSTANCE.7. Equipment Properties 7.1 equipment_type7.1 equipment_type text Provide the Wikipedia URL for the relevant Equipment Type. t 7.2 manufacturing_process7.2 manufacturing_process text Manufacturing process the Equipment is capable of. t 7.3 make7.3 make text Make of the piece of equipment. Provide the make of the model. Provides detailed information about a piece of equipment/tool. For example, you can design generically for a 3D printer, or you can design for a specific make or model of 3D printer. t 7.4 model7.4 model text Provide the name of the model. t 7.5 serial_number7.5 serial_number text Serial number of the piece of Equipment. t 7.6 location7.6 location varchar(30) t 7.7 skills_required7.7 skills_required text t 7.8 condition7.8 condition text This provides a user with information surrounding the quality of a piece of equipment/tool, and whether it can complete the task they need it for. t 7.9 notes7.9 notes text t 7.10 owner7.10 owner text The owner of a piece of equipment. t 7.11 quantity7.11 quantity int Quantity of specific piece of equipment. This provides information surrounding the size and scale of a manufacturing facility and implicates batch size. # 7.12 throughput7.12 throughput text  The throughput of the piece of equipment. t 7.13 power_rating7.13 power_rating int  The power rating of the piece of equipment. Unit: "W" (Watts?) # 7.14 materials_worked7.14 materials_worked subtype 7.15 maintenance_schedule7.15 maintenance_schedule text When the equipment was last maintained. t 7.16 usage_levels7.16 usage_levels text t 7.17 tolerance class7.17 tolerance class subtype 7.18. Current Firmware7.18. Current Firmware text t 7.19. Uninterrupted Power Supply7.19. Uninterrupted Power Supply boolean b 7.20. Defined sub-properties Entity INSTANCE.7.20. Defined sub-properties  7.20.1. Axes7.20.1. Axes int # 7.20.2. Bed Size7.20.2. Bed Size decimal # 7.20.3. Bending Length7.20.3. Bending Length decimal # 7.20.4.Build Volume7.20.4.Build Volume decimal # 7.20.5. Chuck Jaw Diameter7.20.5. Chuck Jaw Diameter decimal # 7.20.6. Collet Size7.20.6. Collet Size decimal # 7.20.7. Computer Controlled7.20.7. Computer Controlled decimal # 7.20.8. Cross Slide Travel7.20.8. Cross Slide Travel decimal # 7.20.9. Daylight / Opening7.20.9. Daylight / Opening text t 7.20.10. Distance Between Centres7.20.10. Distance Between Centres decimal # 7.20.11. Ejector Threads7.20.11. Ejector Threads decimal # 7.20.12. Extraction System7.20.12. Extraction System boolean b 7.20.13. Gantry Material7.20.13. Gantry Material relationship 7.20.14. Hot Runner Compatible7.20.14. Hot Runner Compatible boolean b 7.20.15. Laser Power7.20.15. Laser Power decimal # 7.20.16. Layer Resolution7.20.16. Layer Resolution decimal # 7.20.17. Locating Ring Diameter7.20.17. Locating Ring Diameter decimal # 7.20.18. Material Worked ??7.20.18. Material Worked ?? relationship Material Type 7.20.19. Maximum Clamping Force7.20.19. Maximum Clamping Force decimal # 7.20.20. Maximum Shot Volume7.20.20. Maximum Shot Volume decimal # 7.20.21. Maximum Spindle Speed7.20.21. Maximum Spindle Speed decimal # 7.20.22. Maximum Tie Bar Distance7.20.22. Maximum Tie Bar Distance decimal # 7.20.23. Nozzle Size7.20.23. Nozzle Size decimal # 7.20.24. Nozzle Radius7.20.24. Nozzle Radius decimal # 7.20.25. Optimal Material7.20.25. Optimal Material relationship 7.20.26. Pieceholding Type7.20.26. Pieceholding Type text t 7.20.27. Press Force7.20.27. Press Force decimal # 7.20.28. Punch Force7.20.28. Punch Force decimal # 7.20.29. Spindle Rotation ??7.20.29. Spindle Rotation ?? decimal # 7.20.30. Stations7.20.30. Stations boolean b 7.20.31. Station size7.20.31. Station size decimal # 7.20.32. Tailstock Sleeve Travel7.20.32. Tailstock Sleeve Travel decimal # 7.20.33. Tooling Type7.20.33. Tooling Type text t 7.20.34. Turning Capacity / Swing7.20.34. Turning Capacity / Swing decimal # 7.20.35. Working Surface7.20.35. Working Surface decimal # 7.20.36. X Travel7.20.36. X Travel decimal # 7.20.37. Y Travel7.20.37. Y Travel decimal # 7.20.38. Z Travel7.20.38. Z Travel decimal # 8. Materials PropertiesEntity INSTANCE.8. Materials Properties 8.1. Manufacturer8.1. Manufacturer text t 8.2. Brand8.2. Brand text t 8.3. Supplier Location8.3. Supplier Location relationship 8.4. Material Type8.4. Material Type text t 8.5.1. PlasticsEntity INSTANCE.8.5.1. Plastics HDPEHDPE boolean b PLAPLA boolean b ABSABS boolean b PETPET boolean b AcetateAcetate boolean b PVCPVC boolean b NylonNylon boolean b PolycarbonatePolycarbonate boolean b PolypropylenePolypropylene boolean b AcrylicAcrylic boolean b 8.5.2. MetalsEntity INSTANCE.8.5.2. Metals IronIron boolean b SteelSteel boolean b Stainless SteelStainless Steel boolean b Mild SteelMild Steel boolean b Galvanised SteelGalvanised Steel boolean b AluminiumAluminium boolean b CopperCopper boolean b ZincZinc boolean b 8.5.3. Wood ProductsEntity INSTANCE.8.5.3. Wood Products SoftwoodSoftwood boolean b HardwoodHardwood boolean b MDFMDF boolean b 8.5.4. ElastomersEntity INSTANCE.8.5.4. Elastomers Natural RubberNatural Rubber boolean b TPUTPU boolean b SiliconeSilicone boolean b 8.5.5. CeramicsEntity INSTANCE.8.5.5. Ceramics GeopolymersGeopolymers boolean b CeramicsCeramics boolean b ClayClay boolean b 8.5.6. ElectronicsEntity INSTANCE.8.5.6. Electronics PCBsPCBs boolean b Electronic ComponentsElectronic Components boolean b 8.5.7. OthersEntity INSTANCE.8.5.7. Others TextilesTextiles boolean b LeatherLeather boolean b ConcreteConcrete boolean b RockRock boolean b SoilSoil boolean b Composite MaterialsComposite Materials boolean b FoodFood boolean b CompostCompost boolean b ResinResin boolean b GlassGlass boolean b Carbon FiberCarbon Fiber boolean b CardboardCardboard boolean b PaperPaper boolean b 9. Record Data PropertiesEntity INSTANCE.9. Record Data Properties 9.1. Date Created9.1. Date Created date d 9.2. Created By9.2. Created By relationship 9.3. Last Updated9.3. Last Updated date d 9.4. Updated By9.4. Updated By relationship 9.5. Date Verified9.5. Date Verified date d 9.6. Verified By9.6. Verified By relationship 9.7. Data Collection Method9.7. Data Collection Method text t


Schema OKW_Schema.INSTANCE
Entity 4. Manufacturing Facility Properties
IdxField NameData Type
  4.1. name VARCHAR(30)
  4.2 location VARCHAR(30)
  4.3 owner VARCHAR(20)
  4.4 contact VARCHAR(20)
  4.5 affiliation VARCHAR(20)
  4.6 facility_status VARCHAR(20)
  4.7 opening_hours DATETIME
  4.8 description TEXT
  4.9 data_founded DATE
  4.10 access_type TEXT
  4.11 wheelchair_accessibility TEXT
  4.12 equipment TEXT
  4.13 manufacturing_process TEXT
  4.14 typical_batch_size TEXT
  4.15 size_floor_size TEXT
  4.16 storage_capacity TEXT
  4.17 typical_materials TEXT
  4.18 certifications TEXT
  4.19 backup_generator BOOLEAN
  4.20 uninterrupted_power_supply BOOLEAN
  4.21 road_access BOOLEAN
  4.22 loading_dock BOOLEAN
  4.23 maintenance_schedule TEXT
  4.24 typical_products TEXT
  4.25 partner_funder VARCHAR(20)
  4.26 customer_reviews TEXT
Relationships
fk_facility_location (null) → 6. Location Properties(6.1. Address)
Referring Relationships
fk_4.27. circular economy sub-properties () ← 4.27. Circular Economy sub-properties
fk_4.28. human capacity sub-properties () ← 4.28. Human Capacity sub-properties
fk_4.29. innovation space sub-properties () ← 4.29. Innovation Space sub-properties


Entity 4.27. Circular Economy sub-properties
IdxField NameData Type
  4.27.1. Circular Economy BOOLEAN
  4.27.2. Description TEXT
  4.27.3. By-products RELATIONSHIP
Relationships
fk_4.27. circular economy sub-properties () → 4. Manufacturing Facility Properties


Entity 4.28. Human Capacity sub-properties
IdxField NameData Type
  4.28.1. Headcount INT
  4.28.2. Maker (WIP) TEXT
Relationships
fk_4.28. human capacity sub-properties () → 4. Manufacturing Facility Properties


Entity 4.29. Innovation Space sub-properties
IdxField NameData Type
  4.29.1. Staff INT
  4.29.2. Learning Resources TEXT
  4.29.3. Services TEXT
  4.29.4. Footfall TEXT
  4.29.5. Residencies BOOLEAN
Relationships
fk_4.29. innovation space sub-properties () → 4. Manufacturing Facility Properties


Entity 5. Agent Properties
IdxField NameData TypeDescription
  5.1 name VARCHAR(30) The name of the Agent. Note: This could be a name of a person or an organisation.
  5.2 location VARCHAR(30) A Location. Uses the Location class.
  5.3 contact_person VARCHAR(30) An Agent who is the key point of contact for a manufacturing facility or organisation. Provide the name of the Agent.
  5.4 bio TEXT A description of a person or an organisation. Free text.
  5.5 website TEXT Website address. Provide the relevant URL.
  5.6 languages TEXT Languages used by a person or an organisation. Format: ISO 639-2 or ISO 639-3, for example “en-gb”. Often manufacturing facilities may be able to provide services dealing in more than one language.
  5.7 mailing_list TEXT Images / Media of a person, an organisation, or relating to the manufacturing facility.
  5.8 images_media TEXT Mailing list for an organisation.
  5.9 contact_subproperties SUBTYPE Defined contact information.
  5.9 contact_subproperties.5.9.1 landline NUMERIC(20) A landline telephone number to contact the facility, person or organisation. Provide the telephone number.
  5.9 contact_subproperties.5.9.2 mobile NUMERIC(20) A mobile telephone number to contact the facility, person or organisation. Provide the telephone number.
  5.9 contact_subproperties.5.9.3 fax NUMERIC(20) A fax number to contact the facility, person or organisation. Provide the fax number.
  5.9 contact_subproperties.5.9.4 email VARCHAR(20) ...
  5.9 contact_subproperties.5.9.5 whatsapp NUMERIC(20) ...
  5.10 social_media_subproperties SUBTYPE
  5.10 social_media_subproperties.5.10.1 facebook VARCHAR(20) ...
  5.10 social_media_subproperties.5.10.2 twitter VARCHAR(20) ...
  5.10 social_media_subproperties.5.10.3 instagram VARCHAR(20) ...
  5.10 social_media_subproperties.5.10.4 other_urls VARCHAR(20) ...
Referring Relationships
JSon (5.9 contact_subproperties) ← 5.9 contact_subproperties()
JSon (5.10 social_media_subproperties) ← 5.10 social_media_subproperties()


Entity 6. Location Properties
IdxField NameData Type
  6.1. Address SUBTYPE
  6.1. Address.number DECIMAL
  6.1. Address.street VARCHAR(40)
  6.1. Address.district SUBTYPE
  6.1. Address.city SUBTYPE
  6.1. Address.region SUBTYPE
  6.1. Address.country CHAR(2)
  6.1. Address.postcode VARCHAR(10)
  6.3. GPS Coordinates SUBTYPE
  6.3. GPS Coordinates.latitude DECIMAL
  6.3. GPS Coordinates.longitude DECIMAL
  6.3. GPS Coordinates.altitude DECIMAL
  6.3. GPS Coordinates.precision DECIMAL
  6.4. Directions SUBTYPE
  6.5. What 3 Words sub-properties SUBTYPE
  6.5. What 3 Words sub-properties.6.4.1. What 3 Words VARCHAR(20)
  6.5. What 3 Words sub-properties.6.4.2. Language VARCHAR(6)
Referring Relationships
JSon (6.1. Address) ← 6.1. Address()
JSon (6.3. GPS Coordinates) ← 6.3. GPS Coordinates()
JSon (6.5. What 3 Words sub-properties) ← 6.5. What 3 Words sub-properties()
fk_equipment_location (6.1. Address) ← 7. Equipment Properties(null)
fk_facility_location (6.1. Address) ← 4. Manufacturing Facility Properties(null)
JSon (6.4. Directions) ← 6.4. Directions()
JSon (6.5. What 3 Words sub-properties) ← 6.5. What 3 Words sub-properties()
JSon (6.5. What 3 Words sub-properties) ← 6.5. What 3 Words sub-properties()
JSon (6.3. GPS Coordinates) ← 6.3. GPS Coordinates()
JSon (6.1. Address) ← 6.1. Address()


Entity 7. Equipment Properties
IdxField NameData TypeDescription
  7.1 equipment_type TEXT Provide the Wikipedia URL for the relevant Equipment Type.
  7.2 manufacturing_process TEXT Manufacturing process the Equipment is capable of.
  7.3 make TEXT Make of the piece of equipment. Provide the make of the model. Provides detailed information about a piece of equipment/tool. For example, you can design generically for a 3D printer, or you can design for a specific make or model of 3D printer.
  7.4 model TEXT Provide the name of the model.
  7.5 serial_number TEXT Serial number of the piece of Equipment.
  7.6 location VARCHAR(30)
  7.7 skills_required TEXT
  7.8 condition TEXT This provides a user with information surrounding the quality of a piece of equipment/tool, and whether it can complete the task they need it for.
  7.9 notes TEXT
  7.10 owner TEXT The owner of a piece of equipment.
  7.11 quantity INT Quantity of specific piece of equipment. This provides information surrounding the size and scale of a manufacturing facility and implicates batch size.
  7.12 throughput TEXT  The throughput of the piece of equipment.
  7.13 power_rating INT  The power rating of the piece of equipment. Unit: "W" (Watts?)
  7.14 materials_worked SUBTYPE
  7.15 maintenance_schedule TEXT When the equipment was last maintained.
  7.16 usage_levels TEXT
  7.17 tolerance class SUBTYPE
  7.18. Current Firmware TEXT
  7.19. Uninterrupted Power Supply BOOLEAN
Relationships
fk_equipment_location (null) → 6. Location Properties(6.1. Address)
Referring Relationships
fk_8. materials properties () ← 8. Materials Properties
fk_7.20. defined sub-properties  () ← 7.20. Defined sub-properties 


Entity 7.20. Defined sub-properties 
IdxField NameData TypeDescription
  7.20.1. Axes INT
  7.20.2. Bed Size DECIMAL
  7.20.3. Bending Length DECIMAL
  7.20.4.Build Volume DECIMAL
  7.20.5. Chuck Jaw Diameter DECIMAL
  7.20.6. Collet Size DECIMAL
  7.20.7. Computer Controlled DECIMAL
  7.20.8. Cross Slide Travel DECIMAL
  7.20.9. Daylight / Opening TEXT
  7.20.10. Distance Between Centres DECIMAL
  7.20.11. Ejector Threads DECIMAL
  7.20.12. Extraction System BOOLEAN
  7.20.13. Gantry Material RELATIONSHIP
  7.20.14. Hot Runner Compatible BOOLEAN
  7.20.15. Laser Power DECIMAL
  7.20.16. Layer Resolution DECIMAL
  7.20.17. Locating Ring Diameter DECIMAL
  7.20.18. Material Worked ?? RELATIONSHIP Material Type
  7.20.19. Maximum Clamping Force DECIMAL
  7.20.20. Maximum Shot Volume DECIMAL
  7.20.21. Maximum Spindle Speed DECIMAL
  7.20.22. Maximum Tie Bar Distance DECIMAL
  7.20.23. Nozzle Size DECIMAL
  7.20.24. Nozzle Radius DECIMAL
  7.20.25. Optimal Material RELATIONSHIP
  7.20.26. Pieceholding Type TEXT
  7.20.27. Press Force DECIMAL
  7.20.28. Punch Force DECIMAL
  7.20.29. Spindle Rotation ?? DECIMAL
  7.20.30. Stations BOOLEAN
  7.20.31. Station size DECIMAL
  7.20.32. Tailstock Sleeve Travel DECIMAL
  7.20.33. Tooling Type TEXT
  7.20.34. Turning Capacity / Swing DECIMAL
  7.20.35. Working Surface DECIMAL
  7.20.36. X Travel DECIMAL
  7.20.37. Y Travel DECIMAL
  7.20.38. Z Travel DECIMAL
Relationships
fk_7.20. defined sub-properties  () → 7. Equipment Properties


Entity 8. Materials Properties
IdxField NameData Type
  8.1. Manufacturer TEXT
  8.2. Brand TEXT
  8.3. Supplier Location RELATIONSHIP
  8.4. Material Type TEXT
Relationships
fk_8. materials properties () → 7. Equipment Properties
Referring Relationships
fk_8.5.1. plastics () ← 8.5.1. Plastics
fk_8.5.2. metals () ← 8.5.2. Metals
fk_8.5.5. ceramics () ← 8.5.5. Ceramics
fk_8.5.4. elastomers () ← 8.5.4. Elastomers
fk_8.5.3. wood products () ← 8.5.3. Wood Products
fk_8.5.6. electronics () ← 8.5.6. Electronics
fk_8.5.7. others () ← 8.5.7. Others


Entity 8.5.1. Plastics
IdxField NameData Type
  HDPE BOOLEAN
  PLA BOOLEAN
  ABS BOOLEAN
  PET BOOLEAN
  Acetate BOOLEAN
  PVC BOOLEAN
  Nylon BOOLEAN
  Polycarbonate BOOLEAN
  Polypropylene BOOLEAN
  Acrylic BOOLEAN
Relationships
fk_8.5.1. plastics () → 8. Materials Properties


Entity 8.5.2. Metals
IdxField NameData Type
  Iron BOOLEAN
  Steel BOOLEAN
  Stainless Steel BOOLEAN
  Mild Steel BOOLEAN
  Galvanised Steel BOOLEAN
  Aluminium BOOLEAN
  Copper BOOLEAN
  Zinc BOOLEAN
Relationships
fk_8.5.2. metals () → 8. Materials Properties


Entity 8.5.3. Wood Products
IdxField NameData Type
  Softwood BOOLEAN
  Hardwood BOOLEAN
  MDF BOOLEAN
Relationships
fk_8.5.3. wood products () → 8. Materials Properties


Entity 8.5.4. Elastomers
IdxField NameData Type
  Natural Rubber BOOLEAN
  TPU BOOLEAN
  Silicone BOOLEAN
Relationships
fk_8.5.4. elastomers () → 8. Materials Properties


Entity 8.5.5. Ceramics
IdxField NameData Type
  Geopolymers BOOLEAN
  Ceramics BOOLEAN
  Clay BOOLEAN
Relationships
fk_8.5.5. ceramics () → 8. Materials Properties


Entity 8.5.6. Electronics
IdxField NameData Type
  PCBs BOOLEAN
  Electronic Components BOOLEAN
Relationships
fk_8.5.6. electronics () → 8. Materials Properties


Entity 8.5.7. Others
IdxField NameData Type
  Textiles BOOLEAN
  Leather BOOLEAN
  Concrete BOOLEAN
  Rock BOOLEAN
  Soil BOOLEAN
  Composite Materials BOOLEAN
  Food BOOLEAN
  Compost BOOLEAN
  Resin BOOLEAN
  Glass BOOLEAN
  Carbon Fiber BOOLEAN
  Cardboard BOOLEAN
  Paper BOOLEAN
Relationships
fk_8.5.7. others () → 8. Materials Properties


Entity 9. Record Data Properties
IdxField NameData Type
  9.1. Date Created DATE
  9.2. Created By RELATIONSHIP
  9.3. Last Updated DATE
  9.4. Updated By RELATIONSHIP
  9.5. Date Verified DATE
  9.6. Verified By RELATIONSHIP
  9.7. Data Collection Method TEXT