   `project_attribute_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `project_attribute_name` VARCHAR(50) NULL,
   `project_attribute_value` VARCHAR(50) NULL,
-  `project_id` INT UNSIGNED NULL,
+  `project_id` INT UNSIGNED NOT NULL,
   PRIMARY KEY (`project_attribute_id`),
   UNIQUE INDEX `project_attribute_name_UNIQUE` (`project_attribute_name` ASC),
   INDEX `fk_project_attribute_1_idx` (`project_id` ASC),

  CONSTRAINT `fk_collection_attribute_1`
    FOREIGN KEY (`collection_id`)
    REFERENCES `igfdb`.`collection` (`collection_id`)
    ON DELETE SET NULL
    ON UPDATE CASCADE)
ENGINE = InnoDB CHARSET=UTF8;


CREATE TABLE IF NOT EXISTS `igfdb`.`project` (
  `project_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `igf_id` VARCHAR(20) NOT NULL,
  `project_name` VARCHAR(100) NULL,
  `start_date` DATE NOT NULL,
  `project_requirement` ENUM('FASTQ', 'ALIGNMENT', 'ANALYSIS') NULL DEFAULT 'FASTQ',
  `description` TEXT NULL,
