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