CREATE TABLE tx_reduction (
id INT AUTO_INCREMENT NOT NULL,
tx_vhc_cat_id INT DEFAULT NULL,
rdc_description VARCHAR(255) DEFAULT NULL,
rdc_taux DOUBLE PRECISION DEFAULT NULL,
rdc_date_debut DATETIME DEFAULT NULL,
rdc_date_fin DATETIME DEFAULT NULL,
rdc_nbr_passager INT DEFAULT NULL,
INDEX IDX_78952517C436EFD (tx_vhc_cat_id), PRIMARY KEY(id))
DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;

ALTER TABLE tx_reduction
ADD CONSTRAINT FK_78952517C436EFD FOREIGN KEY (tx_vhc_cat_id) REFERENCES tx_reduction_type (id) ON DELETE CASCADE;
