Commentaires
Bdd.database_name • Bdd.columns_count
| Bdd.column_name | Bdd.column_type | Bdd.column_null | Bdd.column_key | Bdd.column_default | Bdd.column_extra |
|---|---|---|---|---|---|
CommentaireID |
int(11) | Bdd.no | Bdd.primary_key | Bdd.null_default | auto_increment |
TicketID |
int(11) | Bdd.no | Bdd.index_key | Bdd.null_default | - |
UtilisateurID |
int(11) | Bdd.no | Bdd.index_key | Bdd.null_default | - |
Commentaire |
text | Bdd.no | - | Bdd.null_default | - |
DateCreation |
timestamp | Bdd.no | - |
current_timestamp()
|
- |
DateMiseAJour |
timestamp | Bdd.no | - |
current_timestamp()
|
on update current_timestamp() |
Bdd.create_table_query
CREATE TABLE `Commentaires` (
`CommentaireID` int(11) NOT NULL AUTO_INCREMENT,
`TicketID` int(11) NOT NULL,
`UtilisateurID` int(11) NOT NULL,
`Commentaire` text NOT NULL,
`DateCreation` timestamp NOT NULL DEFAULT current_timestamp(),
`DateMiseAJour` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`CommentaireID`),
KEY `TicketID` (`TicketID`),
KEY `UtilisateurID` (`UtilisateurID`),
CONSTRAINT `Commentaires_ibfk_1` FOREIGN KEY (`TicketID`) REFERENCES `Tickets` (`TicketID`),
CONSTRAINT `Commentaires_ibfk_2` FOREIGN KEY (`UtilisateurID`) REFERENCES `Utilisateurs` (`UtilisateurID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 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 Commentaires LIMIT 10;
SELECT COUNT(*) FROM Commentaires;
DESCRIBE Commentaires;