Resource component and object

Resource components and objects

Item - Location - Resource Object model.

erDiagram
  Items ||--o{ ILR : "can be planned at"
  Locations ||--o{ Resources : "has"
  Locations ||--o{ ILR : "hosts"
  Resources ||--o{ ILR : "enables"

  Items {
    string item_id PK
    string item_name
    string item_type
    string uom
    int    shelf_life_days
    float  cost_base
  }

  Locations {
    string location_id PK
    string latitude
    string longitude
    string location_name
    string location_type
    string timezone
  }

  Resources {
    string resource_id PK
    string resource_name
    string location_id FK
    float  capacity_units
    string capacity_uom
    string calendar_id
  }

  ILR {
    string ilr_id PK
    string item_id FK
    string location_id FK
    string resource_id FK "nullable for stocking"
    float  throughput_rate
    int    lead_time_days
    float  unit_cost
    float  safety_stock
  }

Test - can 2 mermaid charts be posted?

No, 2 Mermaid charts area can’t be posted together, no errors get displayed but it doesn’t get rendered.