`Facturation`

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_facturation`	int(11)	Bdd.no	Bdd.primary_key	Bdd.null_default	auto_increment
`montant`	float	Bdd.no	-	Bdd.null_default	-
`date_facture`	date	Bdd.no	-	Bdd.null_default	-
`id_rendezvous`	int(11)	Bdd.no	Bdd.index_key	Bdd.null_default	-

Bdd.total_columns

Bdd.create_table_query

CREATE TABLE `Facturation` (
  `id_facturation` int(11) NOT NULL AUTO_INCREMENT,
  `montant` float NOT NULL,
  `date_facture` date NOT NULL,
  `id_rendezvous` int(11) NOT NULL,
  PRIMARY KEY (`id_facturation`),
  KEY `id_rendezvous` (`id_rendezvous`),
  CONSTRAINT `Facturation_ibfk_1` FOREIGN KEY (`id_rendezvous`) REFERENCES `Rendez_vous` (`id_rendezvous`)
) ENGINE=InnoDB AUTO_INCREMENT=11 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 Facturation LIMIT 10;

SELECT COUNT(*) FROM Facturation;

DESCRIBE Facturation;

Bdd.ready_to_test

Bdd.open_sql_editor