store_ERP

Tables (5)

Item (Untitled)

  • item_id (Key) — Primary key — NOT NULL
  • Price (Field)
  • Category (Field2)
  • Status (Field3)
  • store (Field4)
  • name (Field5)
  • order_units (Field6)
  • Field7

Locations (Untitled2)

    Logis (Untitled3)

      Store (Untitled4)

      • store_id (Key) — Primary key — NOT NULL
      • item_id (Key2) — Foreign key → Item.item_id — NOT NULL

      Truck (Untitled5)