This is a description of cachegroupover.gif. The image shows the customer
(root table), orders
and order_item
cache tables in the customer_orders
cache group with the following rows:
customer
(root table):
cust_num region name address 122 West Jim Johnston 231 Main, Needles CA 92363 342 West Jane Stone 4223 Cowper,Palo Alto CA 94302 663 Midwest Mary J. Warren 673 State, Madison WI 53787
orders
:
ord_num cust_num when_placed when_shipped 44325 122 10/7/07 10/7/07 65432 122 8/24/08 8/27/08 76543 663 4/2/09 4/8/09
order_item
:
ord_num prod_num quantity 44325 SD07 1 44325 TR3A 5 65432 FT094 1 76543 SD07 2
End of description.