Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #------------------------------------------------------------
- # Script MySQL.
- #------------------------------------------------------------
- #------------------------------------------------------------
- # Table: eleves
- #------------------------------------------------------------
- CREATE TABLE eleves(
- elevesid Int NOT NULL ,
- nom Varchar (2550) NOT NULL ,
- prenom Varchar (50) NOT NULL ,
- adresse Varchar (250) NOT NULL ,
- matricule Varchar (25) NOT NULL ,
- PRIMARY KEY (elevesid )
- )ENGINE=InnoDB;
- #------------------------------------------------------------
- # Table: annee_scolaire
- #------------------------------------------------------------
- CREATE TABLE annee_scolaire(
- anneeid Int NOT NULL ,
- annee Int NOT NULL ,
- commentaire Varchar (200) ,
- PRIMARY KEY (anneeid )
- )ENGINE=InnoDB;
- #------------------------------------------------------------
- # Table: niveau
- #------------------------------------------------------------
- CREATE TABLE niveau(
- niveauid Int NOT NULL ,
- nomNiveau Varchar (30) NOT NULL ,
- commentaire_niveau Varchar (100) NOT NULL ,
- PRIMARY KEY (niveauid )
- )ENGINE=InnoDB;
- #------------------------------------------------------------
- # Table: statut
- #------------------------------------------------------------
- CREATE TABLE statut(
- statutid Int NOT NULL ,
- status_nom Varchar (30) NOT NULL ,
- PRIMARY KEY (statutid )
- )ENGINE=InnoDB;
- #------------------------------------------------------------
- # Table: payement_scolarite
- #------------------------------------------------------------
- CREATE TABLE payement_scolarite(
- payement_scolarite_id Int NOT NULL ,
- montant_verse Decimal (25,2) NOT NULL ,
- reste_a_verser Decimal (25,2) NOT NULL ,
- elevesid Int NOT NULL ,
- frais_scolarite_id Int NOT NULL ,
- PRIMARY KEY (payement_scolarite_id )
- )ENGINE=InnoDB;
- #------------------------------------------------------------
- # Table: classe
- #------------------------------------------------------------
- CREATE TABLE classe(
- classId Int NOT NULL ,
- classname Varchar (25) NOT NULL ,
- PRIMARY KEY (classId )
- )ENGINE=InnoDB;
- #------------------------------------------------------------
- # Table: frais_scolarite
- #------------------------------------------------------------
- CREATE TABLE frais_scolarite(
- frais_scolarite_id Int NOT NULL ,
- anneeid Int NOT NULL ,
- niveauid Int NOT NULL ,
- classId Int NOT NULL ,
- statutid Int NOT NULL ,
- PRIMARY KEY (frais_scolarite_id )
- )ENGINE=InnoDB;
- #------------------------------------------------------------
- # Table: scolarite_eleve
- #------------------------------------------------------------
- CREATE TABLE scolarite_eleve(
- elevesid Int NOT NULL ,
- statutid Int NOT NULL ,
- niveauid Int NOT NULL ,
- anneeid Int NOT NULL ,
- classId Int NOT NULL ,
- PRIMARY KEY (elevesid ,statutid ,niveauid ,anneeid ,classId )
- )ENGINE=InnoDB;
- ALTER TABLE payement_scolarite ADD CONSTRAINT FK_payement_scolarite_elevesid FOREIGN KEY (elevesid) REFERENCES eleves(elevesid);
- ALTER TABLE payement_scolarite ADD CONSTRAINT FK_payement_scolarite_frais_scolarite_id FOREIGN KEY (frais_scolarite_id) REFERENCES frais_scolarite(frais_scolarite_id);
- ALTER TABLE frais_scolarite ADD CONSTRAINT FK_frais_scolarite_anneeid FOREIGN KEY (anneeid) REFERENCES annee_scolaire(anneeid);
- ALTER TABLE frais_scolarite ADD CONSTRAINT FK_frais_scolarite_niveauid FOREIGN KEY (niveauid) REFERENCES niveau(niveauid);
- ALTER TABLE frais_scolarite ADD CONSTRAINT FK_frais_scolarite_classId FOREIGN KEY (classId) REFERENCES classe(classId);
- ALTER TABLE frais_scolarite ADD CONSTRAINT FK_frais_scolarite_statutid FOREIGN KEY (statutid) REFERENCES statut(statutid);
- ALTER TABLE scolarite_eleve ADD CONSTRAINT FK_scolarite_eleve_elevesid FOREIGN KEY (elevesid) REFERENCES eleves(elevesid);
- ALTER TABLE scolarite_eleve ADD CONSTRAINT FK_scolarite_eleve_statutid FOREIGN KEY (statutid) REFERENCES statut(statutid);
- ALTER TABLE scolarite_eleve ADD CONSTRAINT FK_scolarite_eleve_niveauid FOREIGN KEY (niveauid) REFERENCES niveau(niveauid);
- ALTER TABLE scolarite_eleve ADD CONSTRAINT FK_scolarite_eleve_anneeid FOREIGN KEY (anneeid) REFERENCES annee_scolaire(anneeid);
- ALTER TABLE scolarite_eleve ADD CONSTRAINT FK_scolarite_eleve_classId FOREIGN KEY (classId) REFERENCES classe(classId);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement