CREATE TABLE `user_profile_distribution` ( `upd_id` INT AUTO_INCREMENT PRIMARY KEY, `upd_upr_id` INT NOT NULL, `upd_distribution_per_id` INT, `upd_distribution_email` VARCHAR(255), `upd_created_date` DATETIME NOT NULL, `upd_created_by_per_id` INT NOT NULL, `upd_modified_date` DATETIME, `upd_modified_by_per_id` INT, `upd_enable` BOOLEAN DEFAULT TRUE, `upd_enote` VARCHAR(255), FOREIGN KEY (`upd_upr_id`) REFERENCES `user_profile` (`id`) ON DELETE NO ACTION, FOREIGN KEY (`upd_distribution_per_id`) REFERENCES `person` (`id`) ON DELETE NO ACTION, FOREIGN KEY (`upd_created_by_per_id`) REFERENCES `person` (`id`) ON DELETE NO ACTION, FOREIGN KEY (`upd_modified_by_per_id`) REFERENCES `person` (`id`) ON DELETE NO ACTION );