Skip to content

Multipack Constituents

The multipack constituents relationship list identifies the complete packaging items and components that are combined to create multipacks. This is only used in multipack.

Data

Column
Status
 Format Notes
multipackConstituentsIdentifier mandatory UUID A globally unique identifier. See identifiers section for information on how to construct this identifier
multipackCombinationIdentifier mandatory UUID The unique identifier of components and/or complete packaging that this multipack is made of. There must be an equivalent record in the Components OR Complete Packaging data.
identicalQuantity mandatory Integer Number of identical units of the component and/or complete package that this multipack is made of.

Diagram

erDiagram

  MULTIPACK }o..o{ MULTIPACK_CONSTITUENTS : within
  MULTIPACK_CONSTITUENTS {
    multipackConstituentsIdentifier UUID "*"
    multipackCombinationIdentifier UUID "*"
    identicalQuantity integer "*"
  }
  MULTIPACK_CONSTITUENTS }o--o{ COMPLETE_PACKAGING : attributes
  MULTIPACK_CONSTITUENTS }o--o{ COMPONENTS : attributes

Example

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
[
  {
    "multipackConstituentsIdentifier": "346C5546-282B-C040-CE74-DD0DD4688C0B",
    "multipackCombinationIdentifier": "516ac728-65e3-48c6-9756-37c29c177a7c",
    "identicalQuantity": 1,
  },
  {
    "multipackConstituentsIdentifier": "346C5546-282B-C040-CE74-DD0DD4688C0B",
    "multipackCombinationIdentifier": "123f1eab-f674-4009-862a-7168cd5cf53f",
    "identicalQuantity": 12,
  } 
]

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
<?xml version="1.0" encoding="UTF-8" ?>
<root>
  <row>
    <multipackConstituentsIdentifier>346C5546-282B-C040-CE74-DD0DD4688C0B</multipackConstituentsIdentifier>
    <multipackCombinationIdentifier>516ac728-65e3-48c6-9756-37c29c177a7c</multipackCombinationIdentifier>
    <identicalQuantity>1</identicalQuantity>
  </row>
  <row>
    <multipackConstituentsIdentifier>346C5546-282B-C040-CE74-DD0DD4688C0B</multipackConstituentsIdentifier>
    <multipackCombinationIdentifier>123f1eab-f674-4009-862a-7168cd5cf53f</multipackCombinationIdentifier>
    <identicalQuantity>12</identicalQuantity>
  </row>
</root>

Data flow

flowchart LR
    subgraph completePackages[Complete Packages]
        cp_wineBox["Wine Box
        -
        516ac728-65e3-48c6-9756-37c29c177a7c"]
        cp_wineBottle["Wine Bottle
        -
        123f1eab-f674-4009-862a-7168cd5cf53f"]
    end
    subgraph multipackConstituents["`**-**`"]
      subgraph mpcs_wineBox ["`**Wine Multipack Constituents**`"]
        mpc_wineBox["`**346C5546-282B-C040-CE74-DD0DD4688C0B
        -
        identicalQuantity: 1**`"]
        mpc_wineBottle["`**346C5546-282B-C040-CE74-DD0DD4688C0B
        -
        identicalQuantity: 12**`"]
      end
    end
    subgraph multipacks["Multipacks"]
        mp_wineBox["12 pack of wine
        -
        111525c0-9a41-4eea-a9b7-a8c23ffcf94d"]
    end
    cp_wineBox --> mpc_wineBox
    cp_wineBottle --> mpc_wineBottle
    mpcs_wineBox --> mp_wineBox