Schéma type pour Oracle
create table CLASSIFICATION (
noclassification INTEGER not null,
nomclassification CHAR(40) ,
datecreation DATE ,
createur CHAR(80) ,
nonoeudracine INTEGER not null,
constraint C_noclassification primary key (noclassification)
);
create table NOEUD (
nonoeud INTEGER not null,
libelle CHAR(80) ,
niveau CHAR(20) not null,
noclassification INTEGER not null,
nonoeudpere INTEGER not null,
constraint NOEUD_nonoeud primary key (nonoeud)
);
create table RESSOURCE (
URL_url CHAR(128) not null,
descriptif CHAR(156) ,
proprietaire CHAR(80) ,
constraint RESSOURCE_url primary key (URL_url)
);
create table indexn (
URL_url CHAR(128) not null,
nonoeud INTEGER not null,
constraint indexn_url primary key (URL_url,nonoeud)
);
alter table indexn add constraint indexn_NOEUD
foreign key (nonoeud)
references NOEUD (nonoeud);
alter table indexn add constraint indexn_RESSOURCE
foreign key (URL_url)
references RESSOURCE (URL_url);
alter table NOEUD add constraint NOEUD_CLASSIFICATION
foreign key (noclassification)
references CLASSIFICATION (noclassification);
alter table NOEUD add constraint NOEUD_NOEUD
foreign key (nonoeudpere)
references NOEUD (nonoeud);