1 2 3 4 5
| create table piece (id_piece number primary key, libelle_piece varchar2(20),id_modele number references modele (id_modele), prix_piece number,id_lot number references lot (id_lot))
create table appareil (id_appareil number primary key, description_appareil varchar2(30), num_serie varchar2(30),id_modele number references modele (id_modele), prix_achat number, id_lot number references lot (id_lot),id_etat references etat (id_etat))
create table rechange (id_rechange number primary key, id_piece number references piece (id_piece),id_appareil number references appareil (id_appareil), date_envoie_rechange date,date_retour_rechange date, montant_rechange number,description_rechange varchar2(20)) |
Partager