The western_customers
cache group contains the following cache tables: active_customer
(root table), ordertab
, cust_interests
, orderdetails
.
The active_customer
cache table contains the following columns: custid
, name
, addr
, zip
, region
.
The ordertab
cache table contains the following columns: orderid
, custid
.
The cust_interests
cache table contains the following columns: custid
, interest
.
The orderdetails
cache table contains the following columns: orderid
, itemid
, quantity
.
End of description.