ERD

Reference:
ERD

ERD

updateupdatesoftware_id[{abc..123}]name[text]deploymentdeploymentdeployment_id[{def...456}]name[My Deployment]collection[T1234]update--deployment0..N0..Ncollectioncollectioncollection_id[T1234]collection_name[Some Computers]deployment--collection11computercomputerresource_id[123456]hostname[38-ITC123]serialnumber[8910A1B2]collection_id[T1234]collection--computer0..N1
```kroki {_type=erd}
[update] {bgcolor: "#ececfc", size: "40"}
  software_id {label: "{abc..123}" }
  name {label: "text" }
  
[deployment]
  deployment_id {label: "{def...456}" }
  name {label: "My Deployment" }
  collection {label: "T1234" }
  
[collection]
  collection_id {label: "T1234" }
  collection_name {label: "Some Computers"}
  
[computer]
  resource_id {label: "123456"}
  hostname  {label: "38-ITC123" }
  serialnumber  {label: "8910A1B2" }
  collection_id {label: "T1234" }
  
  
  collection 1--* computer
  deployment 1--1 collection
  update *--* deployment
```