table ITEM_TYPE (
        ITEM_TYPE_ID   numeric  --  Primary key.
        ITEM_TYPE_DESC char     --  Description (weapon, armour, ...)
    )
        
    table ITEM (
        ITEM_ID        numeric  --  Primary key.
        ITEM_TYPE_ID   numeric  --  Foreign key into ITEM_TYPE
        DESC           char     --  Description.
        -- More common attributes like weight, value, etc.
    )
        
    table WEAPON_DETAILS (
        ITEM_ID        numeric  --  Primary/Foreign key.
        WEAPON_CLASS   numeric  --  Strength of weapon
        -- More weapon attributes.
    )
        
    table ARMOUR_DETAILS (
        ITEM_ID        numeric  --  Primary/Foreign key.
        ARMOUR_CLASS   numeric  --  Strength of armour
        -- More armour attributes.
    )
     
    table STORE (
        STORE_ID       numeric  --  Primary key
        -- Store attributes.
    )
      
    table STORE_INVENTORY (
        STORE_ID       numeric  --  Primary/foreign key *not unique* 
        ITEM_ID        numeric  --  Foreign key into ITEM.
    );