1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| CREATE TYPE "T_CENTRE" AS OBJECT
( numC NUMBER(6),
ville VARCHAR2(30));
CREATE TABLE "CENTRE" OF "T_CENTRE"
( PRIMARY KEY ("NUMC") ENABLE
) ;
CREATE TABLE "CENTRE" OF "T_CENTRE"
( PRIMARY KEY ("NUMC") ENABLE
) ;
CREATE TYPE "T_MODULE" AS OBJECT(
numM decimal(3),
nomM varchar2(40),
numC decimal(3));
CREATE TABLE "MODULE" OF "T_MODULE"
( PRIMARY KEY ("NUMM") ENABLE,
FOREIGN KEY ("NUMC") REFERENCES "CENTRE" ("NUMC") ENABLE);
CREATE TYPE "T_ETUDIANT" AS OBJECT(
numE decimal(3),
nomE varchar2(20),
prenomE varchar2(20));
CREATE TABLE "ETUDIANT" OF "T_ETUDIANT"
( PRIMARY KEY ("NUME") ENABLE
) ;
CREATE TYPE "T_INSCRIPTION" AS OBJECT (
numE decimal(6),
numM decimal(3),
semestre decimal(6),
resultat ENUM ('validé','encours','non validé'));
CREATE TABLE "INSCRIPTION" OF "T_INSCRIPTION" (
PRIMARY KEY ("NUME","NUMM","semestre") ENABLE,
FOREIGN KEY ("NUME") REFERENCES ETUDIANT ("NUME")ENABLE,
FOREIGN KEY ("NUMM") REFERENCES MODULE("NUMM")ENABLE);
------------------------------------------------------
ERREUR : ORA-00902: invalid datatype
------------------------------------------------------- |
Partager