`Medias`

Bdd.database_name • Bdd.columns_count

Bdd.column_name	Bdd.column_type	Bdd.column_null	Bdd.column_key	Bdd.column_default	Bdd.column_extra
`MediaID`	int(11)	Bdd.no	Bdd.primary_key	Bdd.null_default	auto_increment
`TicketID`	int(11)	Bdd.no	Bdd.index_key	Bdd.null_default	-
`CheminFichier`	varchar(255)	Bdd.no	-	Bdd.null_default	-
`TypeMedia`	varchar(50)	Bdd.no	-	Bdd.null_default	-

Bdd.total_columns

Bdd.create_table_query

CREATE TABLE `Medias` (
  `MediaID` int(11) NOT NULL AUTO_INCREMENT,
  `TicketID` int(11) NOT NULL,
  `CheminFichier` varchar(255) NOT NULL,
  `TypeMedia` varchar(50) NOT NULL,
  PRIMARY KEY (`MediaID`),
  KEY `TicketID` (`TicketID`),
  CONSTRAINT `Medias_ibfk_1` FOREIGN KEY (`TicketID`) REFERENCES `Tickets` (`TicketID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci

Bdd.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 Medias LIMIT 10;

SELECT COUNT(*) FROM Medias;

DESCRIBE Medias;

Bdd.ready_to_test

Bdd.open_sql_editor