My table structrure:
我的桌子结构:
CREATE TABLE `goal_review` (
`id` BIGINT(25) NOT NULL AUTO_INCREMENT,
`user_review_info` BIGINT(25) UNSIGNED NOT NULL DEFAULT '0',
`SKILL_COMPETENCY_MID_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`SKILL_COMPETENCY_MID_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`SKILL_COMPETENCY_ANNUAL_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`SKILL_COMPETENCY_ANNUAL_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`SKILL_COMPETENCY_OBJECTIVE` LONGTEXT NULL,
`SKILL_COMPETENCY_CONDITION` LONGTEXT NULL,
`SKILL_COMPETENCY_MEASURE` LONGTEXT NULL,
`SKILL_COMPETENCY_TIMING` LONGTEXT NULL,
`SKILL_COMPETENCY_TYPE` LONGTEXT NULL,
`SKILL_COMPETENCY_WEIGHTAGE` LONGTEXT NULL,
`SKILL_COMPETENCY_ANNUAL_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`SKILL_COMPETENCY_MID_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`SKILL_COMPETENCY_ANNUAL_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`SKILL_COMPETENCY_MID_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`PROJECT_DELIVERY_MID_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`PROJECT_DELIVERY_MID_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`PROJECT_DELIVERY_ANNUAL_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`PROJECT_DELIVERY_ANNUAL_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`PROJECT_DELIVERY_OBJECTIVE` LONGTEXT NULL,
`PROJECT_DELIVERY_CONDITION` LONGTEXT NULL,
`PROJECT_DELIVERY_MEASURE` LONGTEXT NULL,
`PROJECT_DELIVERY_TIMING` LONGTEXT NULL,
`PROJECT_DELIVERY_TYPE` LONGTEXT NULL,
`PROJECT_DELIVERY_WEIGHTAGE` LONGTEXT NULL,
`PROJECT_DELIVERY_ANNUAL_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`PROJECT_DELIVERY_MID_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`PROJECT_DELIVERY_ANNUAL_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`PROJECT_DELIVERY_MID_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`BUSINESS_MID_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`BUSINESS_MID_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`BUSINESS_ANNUAL_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`BUSINESS_ANNUAL_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`BUSINESS_OBJECTIVE` LONGTEXT NULL,
`BUSINESS_CONDITION` LONGTEXT NULL,
`BUSINESS_MEASURE` LONGTEXT NULL,
`BUSINESS_TIMING` LONGTEXT NULL,
`BUSINESS_TYPE` LONGTEXT NULL,
`BUSINESS_WEIGHTAGE` LONGTEXT NULL,
`BUSINESS_ANNUAL_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`BUSINESS_MID_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`BUSINESS_ANNUAL_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`BUSINESS_MID_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`COMPLIANCE_MID_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`COMPLIANCE_MID_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`COMPLIANCE_ANNUAL_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`COMPLIANCE_ANNUAL_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`COMPLIANCE_OBJECTIVE` LONGTEXT NULL,
`COMPLIANCE_CONDITION` LONGTEXT NULL,
`COMPLIANCE_MEASURE` LONGTEXT NULL,
`COMPLIANCE_TIMING` LONGTEXT NULL,
`COMPLIANCE_TYPE` LONGTEXT NULL,
`COMPLIANCE_WEIGHTAGE` LONGTEXT NULL,
`COMPLIANCE_ANNUAL_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`COMPLIANCE_MID_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`COMPLIANCE_ANNUAL_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`COMPLIANCE_MID_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`LONG_TERM_MID_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`LONG_TERM_MID_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`LONG_TERM_ANNUAL_REVIEW_SELF_COMMENTS` LONGTEXT NULL,
`LONG_TERM_ANNUAL_REVIEW_MANAGER_COMMENTS` LONGTEXT NULL,
`LONG_TERM_OBJECTIVE` LONGTEXT NULL,
`LONG_TERM_CONDITION` LONGTEXT NULL,
`LONG_TERM_MEASURE` LONGTEXT NULL,
`LONG_TERM_TIMING` LONGTEXT NULL,
`LONG_TERM_TYPE` LONGTEXT NULL,
`LONG_TERM_WEIGHTAGE` LONGTEXT NULL,
`LONG_TERM_ANNUAL_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`LONG_TERM_MID_REVIEW_SELF_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`LONG_TERM_ANNUAL_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
`LONG_TERM_MID_REVIEW_MANAGER_RATING` INT(10) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `FK_goal_review_user_review_info` (`user_review_info`),
INDEX `FK_GRSKILL_COMPETENCY_ANNUAL_REVIEW_MANAGER_RATING` (`SKILL_COMPETENCY_ANNUAL_REVIEW_MANAGER_RATING`),
INDEX `FK_GRSKILL_COMPETENCY_MID_REVIEW_MANAGER_RATING` (`SKILL_COMPETENCY_MID_REVIEW_MANAGER_RATING`),
INDEX `FK_GRSKILL_COMPETENCY_ANNUAL_REVIEW_SELF_RATING` (`SKILL_COMPETENCY_ANNUAL_REVIEW_SELF_RATING`),
INDEX `FK_GRSKILL_COMPETENCY_MID_REVIEW_SELF_RATING` (`SKILL_COMPETENCY_MID_REVIEW_SELF_RATING`),
INDEX `FK_GRPROJECT_DELIVERY_ANNUAL_REVIEW_MANAGER_RATING` (`PROJECT_DELIVERY_ANNUAL_REVIEW_MANAGER_RATING`),
INDEX `FK_GRPROJECT_DELIVERY_MID_REVIEW_MANAGER_RATING` (`PROJECT_DELIVERY_MID_REVIEW_MANAGER_RATING`),
INDEX `FK_GRPROJECT_DELIVERY_ANNUAL_REVIEW_SELF_RATING` (`PROJECT_DELIVERY_ANNUAL_REVIEW_SELF_RATING`),
INDEX `FK_GRPROJECT_DELIVERY_MID_REVIEW_SELF_RATING` (`PROJECT_DELIVERY_MID_REVIEW_SELF_RATING`),
INDEX `FK_GRBUSINESS_ANNUAL_REVIEW_MANAGER_RATING` (`BUSINESS_ANNUAL_REVIEW_MANAGER_RATING`),
INDEX `FK_GRBUSINESS_MID_REVIEW_MANAGER_RATING` (`BUSINESS_MID_REVIEW_MANAGER_RATING`),
INDEX `FK_GRBUSINESS_ANNUAL_REVIEW_SELF_RATING` (`BUSINESS_ANNUAL_REVIEW_SELF_RATING`),
INDEX `FK_GRBUSINESS_MID_REVIEW_SELF_RATING` (`BUSINESS_MID_REVIEW_SELF_RATING`),
INDEX `FK_GRCOMPLIANCE_ANNUAL_REVIEW_MANAGER_RATING` (`COMPLIANCE_ANNUAL_REVIEW_MANAGER_RATING`),
INDEX `FK_GRCOMPLIANCE_MID_REVIEW_MANAGER_RATING` (`COMPLIANCE_MID_REVIEW_MANAGER_RATING`),
INDEX `FK_GRCOMPLIANCE_ANNUAL_REVIEW_SELF_RATING` (`COMPLIANCE_ANNUAL_REVIEW_SELF_RATING`),
INDEX `FK_GRCOMPLIANCE_MID_REVIEW_SELF_RATING` (`COMPLIANCE_MID_REVIEW_SELF_RATING`),
INDEX `FK_GRLONG_TERM_ANNUAL_REVIEW_MANAGER_RATING` (`LONG_TERM_ANNUAL_REVIEW_MANAGER_RATING`),
INDEX `FK_GRLONG_TERM_MID_REVIEW_MANAGER_RATING` (`LONG_TERM_MID_REVIEW_MANAGER_RATING`),
INDEX `FK_GRLONG_TERM_ANNUAL_REVIEW_SELF_RATING` (`LONG_TERM_ANNUAL_REVIEW_SELF_RATING`),
INDEX `FK_GRLONG_TERM_MID_REVIEW_SELF_RATING` (`LONG_TERM_MID_REVIEW_SELF_RATING`),
CONSTRAINT `FK_GRLONG_TERM_ANNUAL_REVIEW_MANAGER_RATING` FOREIGN KEY (`LONG_TERM_ANNUAL_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRLONG_TERM_MID_REVIEW_MANAGER_RATING` FOREIGN KEY (`LONG_TERM_MID_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRLONG_TERM_ANNUAL_REVIEW_SELF_RATING` FOREIGN KEY (`LONG_TERM_ANNUAL_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRLONG_TERM_MID_REVIEW_SELF_RATING` FOREIGN KEY (`LONG_TERM_MID_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_goal_review_user_review_info` FOREIGN KEY (`user_review_info`) REFERENCES `user_review_info` (`ID`),
CONSTRAINT `FK_GRBUSINESS_ANNUAL_REVIEW_MANAGER_RATING` FOREIGN KEY (`BUSINESS_ANNUAL_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRBUSINESS_ANNUAL_REVIEW_SELF_RATING` FOREIGN KEY (`BUSINESS_ANNUAL_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRBUSINESS_MID_REVIEW_MANAGER_RATING` FOREIGN KEY (`BUSINESS_MID_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRBUSINESS_MID_REVIEW_SELF_RATING` FOREIGN KEY (`BUSINESS_MID_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRCOMPLIANCE_ANNUAL_REVIEW_MANAGER_RATING` FOREIGN KEY (`COMPLIANCE_ANNUAL_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRCOMPLIANCE_ANNUAL_REVIEW_SELF_RATING` FOREIGN KEY (`COMPLIANCE_ANNUAL_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRCOMPLIANCE_MID_REVIEW_MANAGER_RATING` FOREIGN KEY (`COMPLIANCE_MID_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRCOMPLIANCE_MID_REVIEW_SELF_RATING` FOREIGN KEY (`COMPLIANCE_MID_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRPROJECT_DELIVERY_ANNUAL_REVIEW_MANAGER_RATING` FOREIGN KEY (`PROJECT_DELIVERY_ANNUAL_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRPROJECT_DELIVERY_ANNUAL_REVIEW_SELF_RATING` FOREIGN KEY (`PROJECT_DELIVERY_ANNUAL_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRPROJECT_DELIVERY_MID_REVIEW_MANAGER_RATING` FOREIGN KEY (`PROJECT_DELIVERY_MID_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRPROJECT_DELIVERY_MID_REVIEW_SELF_RATING` FOREIGN KEY (`PROJECT_DELIVERY_MID_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRSKILL_COMPETENCY_ANNUAL_REVIEW_MANAGER_RATING` FOREIGN KEY (`SKILL_COMPETENCY_ANNUAL_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRSKILL_COMPETENCY_ANNUAL_REVIEW_SELF_RATING` FOREIGN KEY (`SKILL_COMPETENCY_ANNUAL_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRSKILL_COMPETENCY_MID_REVIEW_MANAGER_RATING` FOREIGN KEY (`SKILL_COMPETENCY_MID_REVIEW_MANAGER_RATING`) REFERENCES `appraisal_rating` (`ID`),
CONSTRAINT `FK_GRSKILL_COMPETENCY_MID_REVIEW_SELF_RATING` FOREIGN KEY (`SKILL_COMPETENCY_MID_REVIEW_SELF_RATING`) REFERENCES `appraisal_rating` (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;
CREATE TABLE `
