CREATE TABLE "COMPOSE" ("NUM_CONTIENT" NUMBER(10) NOT NULL, 
    "NUM_CONTENU" NUMBER(10) NOT NULL, 
    CONSTRAINT "FK_RECETTE_2" FOREIGN KEY("NUM_CONTIENT") 
    REFERENCES "RECETTE"("NUM"), 
    CONSTRAINT "FK_RECETTE_3" FOREIGN KEY("NUM_CONTENU") 
    REFERENCES "RECETTE"("NUM"), 
    CONSTRAINT "PK_7" PRIMARY KEY("NUM_CONTIENT", "NUM_CONTENU"))     
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/

    
CREATE TABLE "ALIMENTS" ("NOM" VARCHAR2(255 byte) NOT NULL, 
    "UNITE" VARCHAR2(30 byte), "PRIX_MAX" NUMBER(10, 2), 
    "PRIX_MIN" NUMBER(10, 2), "STOCK_MAX" NUMBER(10, 2), 
    "STOCK_MIN" NUMBER(10, 2), "STOCK_ACTUEL" NUMBER(10, 2), 
    "SAISON" VARCHAR2(30 byte), 
    CONSTRAINT "ANTI_SUR_APRO" CHECK(STOCK_ACTUEL < STOCK_MAX), 
    CONSTRAINT "BONNE_SAISON" FOREIGN KEY("SAISON") 
    REFERENCES "SAISONS"("SAISON"), 
    CONSTRAINT "PK_ALIM" PRIMARY KEY("NOM") 
    USING INDEX  
    TABLESPACE "USERS" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/


CREATE TABLE "CONTIENT" ("NUM" NUMBER(10) NOT NULL, "ID" 
    NUMBER(10) NOT NULL, 
    CONSTRAINT "FK_MENU" FOREIGN KEY("ID") 
    REFERENCES "MENU"("ID"), 
    CONSTRAINT "FK_RECETTE_1" FOREIGN KEY("NUM") 
    REFERENCES "RECETTE"("NUM"), 
    CONSTRAINT "PK_6" PRIMARY KEY("NUM", "ID"))  
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/


CREATE TABLE "MENU" ("ID" NUMBER(10) NOT NULL, "NOM" 
    VARCHAR2(2000 byte), "PV_ENFANT" NUMBER(10, 2), "PV_ADULTE" 
    NUMBER(10, 2), "DUREE_ATTENTE" DATE, 
    CONSTRAINT "PK" PRIMARY KEY("ID") 
    USING INDEX  
    TABLESPACE "USERS" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255,
    CONSTRAINT "PRIX DE VENTE VALIDE" CHECK(PV_ENFANT <  
    PV_ADULTE))  
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/

CREATE TABLE "RECETTE" ("NUM" NUMBER(10) NOT NULL, "NOM" 
    VARCHAR2(200 byte), "TEXTE" LONG, "DUREE" DATE, "CODE_TYPE" 
    VARCHAR2(30 byte), 
    CONSTRAINT "PK_4" PRIMARY KEY("NUM") 
    USING INDEX  
    TABLESPACE "USERS" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255,
    CONSTRAINT "TYPE" FOREIGN KEY("CODE_TYPE") 
    REFERENCES "TYPES_RECETTE"("CODE_TYPE"))  
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/


CREATE TABLE "SAISONS" ("SAISON" VARCHAR2(30 byte) NOT NULL,
    "DATE_DEB" DATE, "DATE_FIN" DATE, 
    CONSTRAINT "PK_1" PRIMARY KEY("SAISON") 
    USING INDEX  
    TABLESPACE "USERS" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/

    
CREATE TABLE "TYPES_RECETTE" ("CODE_TYPE" VARCHAR2(30 byte) 
    NOT NULL, "TYPE" VARCHAR2(200 byte), 
    CONSTRAINT "PK_2" PRIMARY KEY("CODE_TYPE") 
    USING INDEX  
    TABLESPACE "USERS" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/    
    
CREATE TABLE "UTILISE" ("NUM" NUMBER(10) NOT NULL, "NOM" 
    VARCHAR2(255 byte) NOT NULL, "QUANTITE" NUMBER(10), 
    CONSTRAINT "FK_ALIMENT" FOREIGN KEY("NOM") 
    REFERENCES "ALIMENTS"("NOM"), 
    CONSTRAINT "FK_RECETTE" FOREIGN KEY("NUM") 
    REFERENCES "RECETTE"("NUM"), 
    CONSTRAINT "PK_5" PRIMARY KEY("NUM", "NOM") 
    USING INDEX  
    TABLESPACE "USERS" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
    TABLESPACE "USERS" PCTFREE 5 PCTUSED 0 INITRANS 2 MAXTRANS 
    255 
    STORAGE ( INITIAL 48K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
/