`Rendez_vous`

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_rendezvous`	int(11)	Bdd.no	Bdd.primary_key	Bdd.null_default	-
`date`	date	Bdd.yes	-	Bdd.null_default	-
`heure`	time	Bdd.yes	-	Bdd.null_default	-
`duree`	int(11)	Bdd.yes	-	Bdd.null_default	-
`id_patients`	int(11)	Bdd.yes	Bdd.index_key	Bdd.null_default	-
`id_medecins`	int(11)	Bdd.yes	Bdd.index_key	Bdd.null_default	-
`motif`	text	Bdd.yes	-	Bdd.null_default	-
`notes`	text	Bdd.yes	-	Bdd.null_default	-

Bdd.total_columns

Bdd.create_table_query

CREATE TABLE `Rendez_vous` (
  `id_rendezvous` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `heure` time DEFAULT NULL,
  `duree` int(11) DEFAULT NULL,
  `id_patients` int(11) DEFAULT NULL,
  `id_medecins` int(11) DEFAULT NULL,
  `motif` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  PRIMARY KEY (`id_rendezvous`),
  KEY `id_patient` (`id_patients`),
  KEY `id_medecin` (`id_medecins`),
  CONSTRAINT `Rendez_vous_ibfk_1` FOREIGN KEY (`id_patients`) REFERENCES `Patients` (`id_patients`),
  CONSTRAINT `Rendez_vous_ibfk_2` FOREIGN KEY (`id_medecins`) REFERENCES `Medecins` (`id_medecins`)
) ENGINE=InnoDB 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 Rendez_vous LIMIT 10;

SELECT COUNT(*) FROM Rendez_vous;

DESCRIBE Rendez_vous;

Bdd.ready_to_test

Bdd.open_sql_editor