Hungry-in-Oxford

饥饿的牛津DB Schema这样Craig就不必再查看他的电子邮件了

CREATE TABLE Restaurant (

tName VARCHAR(50) NOT NULL,

tType VARCHAR(50),

tAddress VARCHAR(50),

tTelephone VARCHAR(50),

tDelievery BOOLEAN,

tPRIMARY KEY (Name)

);

CREATE TABLE FoodItems (

tName VARCHAR(50),

tFId INT NOT NULL,

tRName VARCHAR(50) NOT NULL,

tPrice DECIMAL(10,2),

tPRIMARY KEY (Fid),

tFOREIGN KEY (Rname) REFERENCES Restaurant (Name)

);