CREATE TABLE IF NOT EXISTS  `year_discount_level_specialty_payment_concept` (
  `serial_ydp` INT NOT NULL AUTO_INCREMENT,
  `serial_ypc` INT NULL,
  `serial_ydc` INT NULL,
  `value_ydp` DOUBLE NULL,
  `discount_type_ydp` ENUM('ALL', 'ONE_SIBLIN', 'TWO_SIBLINS', 'THREE_SIBLINS', 'FOUR_SIBLINS', 'FIVE_SIBLINS') NULL,
  `status_ydp` ENUM('ACTIVE', 'INACTIVE') NULL,
  PRIMARY KEY (`serial_ydp`),
  INDEX `fk_ydp_ydc_idx` (`serial_ypc` ASC),
  INDEX `fk_ydp_dsc_idx` (`serial_ydc` ASC),
  CONSTRAINT `fk_ydp_ydc`
    FOREIGN KEY (`serial_ypc`)
    REFERENCES `year_level_specialty_payment_concept` (`serial_ypc`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_ydp_dsc`
    FOREIGN KEY (`serial_ydc`)
    REFERENCES `year_discount` (`serial_ydc`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)

	ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;