Java Reference
In-Depth Information
<< table >>
COUPON
COUPON _ID << pk >>
TYPE
CODE << unique >>
MINIMUM
PER _ DISCOUNT
<< table >>
PENDING _ ORDER
<< table >>
PLACED _ORDER
PENDING _ ORDER _ID << pk >>
RESTAURANT_ID << fk>>
COUPON _ ID << fk>>
DELIVERY _TIME
DELIVERY _ ADDRESS _ STREET 1
DELIVERY _ ADDRESS _ CITY
...
ORDER _ID << pk >>
RESTAURANT _ID << fk>>
COUPON _ID << fk>>
DELIVERY _TIME
DELIVERY _ADDRESS _STREET
DELIVERY _ ADDRESS _CITY
...
1
<< table >>
MENU _ ITEM
MENU _ ITEM _ ID << pk >>
RESTAURANT _ ID << fk>>
NAME
PRICE
<< table >>
PENDING _ORDER _ LINE _ITEM
<< table >>
ORDER _LINE _ITEM
PENDING _ORDER _LINE _ITEM _ID << pk>>
PENDING _ORDER _ID << fk>>
MENU_ITEM_ID << fk>>
LINE _ITEM_INDEX
QUANTITY
...
ORDER _LINE _ITEM_ID << pk >>
ORDER _ID << fk>>
MENU_ITEM_ID << fk>>
LINE _ITEM_INDEX
QUANTITY
PRICE
EXTENDED _PRICE
...
<< table >>
RESTAURANT
RESTAURANT_ID << pk >>
NAME
...
<< table >>
RESTAURANT _TIME _RANGE
<< table >>
RESTAURANT _ZIPCODE
<< table >>
ZIP_CODE
RESTAURANT _ID << fk>>
DAY_OF_WEEK
OPEN _HOUR
OPEN _MINUTE
CLOSE _HOUR
CLOSE _MINUTE
ZIP_CODE <<pk>>
RESTAURANT _ID << fk>>
ZIP_CODE<< fk>>
Figure 4.5
The Food to Go database schema
 
Search WWH ::




Custom Search