CREATE TABLE item
    (iname  varchar(30),
     itype  varchar(30),
     PRIMARY KEY (iname));

CREATE TABLE Cafe
    (license numeric(5,0),
     cname   varchar(30),
     address varchar(30),
     PRIMARY KEY (license));

CREATE TABLE Client
    (cid    numeric(5,0),
     name   varchar(30),
     phone  numeric(9,0),
     PRIMARY KEY (cid));

CREATE TABLE Likes
    (cid    numeric(5,0),
     iname  varchar(30),
     PRIMARY KEY (cid,iname),
     FOREIGN KEY (cid) REFERENCES Client,
     FOREIGN KEY (iname) REFERENCES item);

CREATE TABLE Sells
    (license numeric(5,0),
     iname   varchar(30),
     price   float,
     PRIMARY KEY (license,iname),
     FOREIGN KEY (license) REFERENCES Cafe,
     FOREIGN KEY (iname) REFERENCES item);

CREATE TABLE Receipt
    (cid     numeric(5,0),
     rno     numeric(5,0),
     license numeric(5,0),
     rdate   date,
     PRIMARY KEY (cid,rno),
     FOREIGN KEY (cid) REFERENCES Client,
     FOREIGN KEY (license) REFERENCES Cafe);

CREATE TABLE Buys
    (cid     numeric(5,0),
     rno     numeric(5,0),
     iname   varchar(30),
     amount  int,
     PRIMARY KEY (cid,rno,iname),
     FOREIGN KEY (cid,rno) REFERENCES Receipt,
     FOREIGN KEY (iname) REFERENCES item);