Class Portal.ProductStats Extends %Persistent
{

Property Item As %String [ Required ];

Property dateImported As %String [ Required ];

Index pcacheUpds On Item;
}
Class Portal.ProductCacheUpdates Extends %Persistent
{

Property Product As %String [ Required ];

Property Item As %String [ Calculated, SqlComputeCode = { s {*}=$e({Product},1,5)}, SqlComputed ];

Property dateEdited As %String [ Required ];

Index pcacheUpdsUniq On (Product, Item) [ Unique ];

Index pcacheUpdsProd On Item;

}

Cache for Windows (x86-64) 2017.2 (Build 744U) Fri Sep 29 2017 10:58:27 EDT