Table Definition


Restaurants

ID 
Name
Address
City
State
Zipcode
Countrycode
Latitude
Longitude
Capacity
Tables
Other
Occupancy --- how much is full ?

create table hotel (
ID NUMBER,
Name VARCHAR(30),
X NUMBER(7),
Y NUMBER(7),
Tables NUMBER,
Address VARCHAR(30),
City VARCHAR(30),
State VARCHAR(30),
Zipcode NUMBER(7),
Countrycode NUMBER(3),
Capacity NUMBER(4)
)
/


create table queryinfo (
id number(4),
string varchar(100),
qsize number(4),
freshness number(4),
currX number(7),
currY number(7)
)
/