salut...jé crée 1 base de donnée sous oracle 10g et je sé ps est ce kilé correcte ou pas?vous pouvez médé?
voici mon base de donnée:
create table materiel(num_serie number constraint pk_materiel primary key,
designation varchar2(20),
prix number,date_aquisition date,date_mise_service date,
j_m_a date constraint fk_materiel1 references date_1(j_m_a),
num_commande constraint fk_materiel references commande(num_commande));
***********************************************************************************************************
create table accessoire( ref varchar2(12) constraint pk_accessoire primary key ,
type varchar2(10),
num_serie number constraint fk_accessoire references materiel(num_serie));
************************************************************************************************************
create table machine(num_machine number constraint pk_machine primary key,
num_serie number constraint fk_machine references materiel(num_serie));
******************************************************************************************************
create table depot(num_depot number constraint pk_depot primary key,num_article number contraint pk_depot primary key);
*************************************************************************************************
A create table date_1(j_m_a date constraint pk_date1 primary key);
***************************************************************************************************
create table est_stocker(quantité number contraint pk_est_stocker primary key,
ref varchar2(12) constraint fk_est_stocker references accessoire(ref),
num_depot number constraint fk_est_stocker references depot(num_depot),
num_article number constraint fk_est_stocker references depot(num_article));
****************************************************************************************************
create table composant(num_machine number constraint fk_composant references machine(num_machine),
ref varchar2(12) constraint fk_composant references accessoire(ref));
************************************************************************************************
create table contenir(num_machine number constraint fk_contenir references machine(num_machine),
nom_station varchar2(20) constraint fk_contenir references station(nom_station),
type_tratement varchar2(20) constraint fk_contenir references station(type_traitement));
**************************************************************************************
create table station(nom_station varchar2(20) constraint pk_station primary key ,
type_traitement varchar2(20) constraint pk_station primary key ,
adresse_station varchar2(20),
nom_centre varchar2(20));
*************************************************************************************
create table service(num_service number constraint pk_service primary key,
nom_service varchar2(20));
******************************************************************************************************
create table appartenir(num_service number constraint fk_appartenir reference service(num_service),
nom_centre varchar2(20) constraint fk_appartenir reference centre(nom_centre));
********************************************************************************************************
create table centre(nom_centre varchar2(20) constraint pk_centre primary key,
adresse_centre varchar2(20) );
******************************************************************************************************
create table employe (matricule number constraint pk_employe primary key,
nom varchar2(20),
prenom varchar2(20),
grade varchar2(20),
num_service number constraint fk_employe references service(num_service),
num_chef numer constraint fk_employe references employe(num_chef));
***********************************************************************************************
create table tache(num_tache number constraint pk_tache primary key,
desig_tache varchar2(20),
date_tache date);
**************************************************************************************************
create table effectuer (matricule number constraint fk_effectuer references employe(matricule),
num_tache number constraint fk_effecuer reference tache(num_tache));
**************************************************************************************************
create table commande(num_commande number constraint pk_commande primary key);
******************************************************************************************************
create tale ligne_commande(quantite number constraint pk_ligne_commande primary key,
num_commande number constraint fk_ligne_commande references commande(num_commande),
num_serie number constraint fk_ligne_commande reference materiel(num_serie));
*****************************************************************************************************
create table fournisseur(num_fournisseur number constraint pk_fournisseur primary key,
email varchar2(20),
code number constraint pk_fournisseur primary key,
ordre number);
**********************************************************************************************************************************
create table facture (num_facture varchar2(20) constraint pk_facture primary key,
num_arrive varchar2(20),
date_arrive date,
date_debut varchar2(20),
date_fin varchar2(20),
num_fournisseur number constraint fk_facture references fournisseur(num_fournisseur),
code number constraint fk_facture references fournisseur(code),
j_m_a date constraint fk_facture reference date1(j_m_a));
********************************************************************************************************************
create table facture_one(num_facture varchar2(20) constraint fk_facture references facture(num_facture),
lieu_consomation varchar2(12),
num_client varchar2(12),
num_contrat number,
tarif varchar2(12),
montant number,
cosfi number,
E_reactive number,
H_creuse number,
H_pointe number,
H_pleine number,
H_creuse_qte number,
H_pointe_qte number,
H_pleine_qte number,
penabilite number,
);
***************************************************************************************************************************************
create table factue_maroc_telecom_telephone(num_facture varchar2(20) constraint fk_facture references facture(num_facture),
lieu_instalation varchar2(12),
num_client varchar2(12),
num_abonnement number,
infinifix number,
restition_nationalle number,
montant number);
***************************************************************************************************************************
create table facture_arnt(num_arrive varchar2(12) constraint fk_facture_one references facture(num_arrive),
num_facture varchar2(20) constraint fk_facture references facture(num_facture),
date_arrive date constraint fk_facture_one references facture(date_arrive),
date_debut date constraint fk_facture_one references facture(date_debut),
date_fin date constraint fk_facture_one references facture(date_fin),
num_fournisseur number constraint fk_facture_one references founisseur(num_fournisseur),
code number constraint fk_facture references fournisseur(code),
j_m_a date constraint fk_facture reference date1(j_m_a),
num_aotorisation varchar2(20),
montant number ,
indicatif varchar2(20),
lieu_consomation varchar2(20));
***************************************************************************************************************
create table facture_louement(num_facture varchar2(20) constraint fk_facture references facture(num_facture),
montant number,
num_contrat number,
adresse varchar2(20),
benificiaire varchar2(20),
nom_parc varchar2(20));
*************************************************************************************************************************************************************************************
create table factue_maroc_telecom_internet(num_facture varchar2(20) constraint fk_facture references facture(num_facture),
num_client varchar2(20),
service_et_option varchar2(20),
abonnement varchar2(20)
);
*********************************************************************************************************************************************************
create table facture_oncf(
num_facture varchar2(20) constraint fk_facture references facture(num_facture),
adresse varchar2(20),
montant number);
********************************************************************************************************************************************************