CREATE TABLE tx_rendezvous (
id INT AUTO_INCREMENT NOT NULL,
tx_plc_id INT DEFAULT NULL,
tx_hr_id INT DEFAULT NULL,
rdv_date DATETIME DEFAULT NULL,
rdv_description VARCHAR(255) DEFAULT NULL,
INDEX IDX_9F297DA661D464E (tx_plc_id),
INDEX IDX_9F297DA69E132CD4 (tx_hr_id),
PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;

ALTER TABLE tx_rendezvous
ADD CONSTRAINT FK_9F297DA661D464E FOREIGN KEY (tx_plc_id) REFERENCES tx_place (id) ON DELETE CASCADE;

ALTER TABLE tx_rendezvous
ADD CONSTRAINT FK_9F297DA69E132CD4 FOREIGN KEY (tx_hr_id) REFERENCES tx_horaire (id) ON DELETE CASCADE;
