create table maman 11

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


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


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

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) PRIMARY KEY,
     rno    numeric(5,0),
     iname  varchar(30),
     amount int,
     PRIMARY KEY (cid,rno,iname),
     FOREIGN KEY (cid,rno)  REFERENCES Client,
     FOREIGN KEY (iname)    REFERENCES item);