Inscription
Bdd.database_name • Bdd.columns_count
| Bdd.column_name | Bdd.column_type | Bdd.column_null | Bdd.column_key | Bdd.column_default | Bdd.column_extra |
|---|---|---|---|---|---|
ID_inscription |
int(11) | Bdd.no | Bdd.primary_key | Bdd.null_default | - |
ID_etudiant |
int(11) | Bdd.yes | Bdd.index_key | Bdd.null_default | - |
ID_formation |
int(11) | Bdd.yes | Bdd.index_key | Bdd.null_default | - |
Date_dinscription |
date | Bdd.yes | - | Bdd.null_default | - |
Etat_de_la_formation |
enum('terminé','en cours','annulé') | Bdd.yes | - | Bdd.null_default | - |
Note_finale |
decimal(3,2) | Bdd.yes | - | Bdd.null_default | - |
Bdd.create_table_query
CREATE TABLE `Inscription` (
`ID_inscription` int(11) NOT NULL,
`ID_etudiant` int(11) DEFAULT NULL,
`ID_formation` int(11) DEFAULT NULL,
`Date_dinscription` date DEFAULT NULL,
`Etat_de_la_formation` enum('terminé','en cours','annulé') DEFAULT NULL,
`Note_finale` decimal(3,2) DEFAULT NULL,
PRIMARY KEY (`ID_inscription`),
KEY `ID_etudiant` (`ID_etudiant`),
KEY `ID_formation` (`ID_formation`),
CONSTRAINT `Inscription_ibfk_1` FOREIGN KEY (`ID_etudiant`) REFERENCES `Etudiant` (`ID_etudiant`),
CONSTRAINT `Inscription_ibfk_2` FOREIGN KEY (`ID_formation`) REFERENCES `Formation` (`ID_formation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ciBdd.key_types
- Bdd.primary_key Bdd.primary_key_desc
- Bdd.unique_key Bdd.unique_key_desc
- Bdd.index_key Bdd.index_key_desc
Bdd.query_examples
SELECT * FROM Inscription LIMIT 10;
SELECT COUNT(*) FROM Inscription;
DESCRIBE Inscription;