Viewing file:  real_alter_InnoDB_mo_reg.sql (24.84 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
--
-- script ADD CONSTRAINT 000 foreign key
--
ALTER TABLE `regist`.`rg_AcadConfig`
ADD CONSTRAINT `acPrsIdTSRegistrar` FOREIGN KEY (`acPrsIdTSRegistrar`) REFERENCES `rg_Person` (`prsId`),
ADD CONSTRAINT `acPrsIdDirector` FOREIGN KEY (`acPrsIdDirector`) REFERENCES `rg_Person` (`prsId`);
ALTER TABLE `regist`.`rg_Adviser`
ADD CONSTRAINT `advAcY` FOREIGN KEY ( `advAcY` ) REFERENCES `rg_TermConfig` (`tmcAcY`),
ADD CONSTRAINT `advStdId` FOREIGN KEY ( `advStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `advSyId` FOREIGN KEY ( `advSyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `advPrsId` FOREIGN KEY ( `advPrsId` ) REFERENCES `rg_Person` (`prsId`);
ALTER TABLE `regist`.`rg_AllowSendGrade`
ADD CONSTRAINT `asgStdId` FOREIGN KEY ( `asgStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `asgTmId` FOREIGN KEY ( `asgTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `asgAcY` FOREIGN KEY ( `asgAcY` ) REFERENCES `rg_TermConfig` (`tmcAcY`);
ALTER TABLE `regist`.`rg_ClassTeacher`
ADD CONSTRAINT `ctcSyId` FOREIGN KEY ( `ctcSyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `ctcCurId` FOREIGN KEY ( `ctcCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `ctcPrsId` FOREIGN KEY ( `ctcPrsId` ) REFERENCES `rg_Person` (`prsId`),
ADD CONSTRAINT `ctcAcY` FOREIGN KEY ( `ctcAcY` ) REFERENCES `rg_TermConfig` (`tmcAcY`);
ALTER TABLE `regist`.`rg_CommonFee`
ADD CONSTRAINT `cmfStdId` FOREIGN KEY ( `cmfStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `cmfFeeId` FOREIGN KEY ( `cmfFeeId` ) REFERENCES `rg_Fee` (`feeId`),
ADD CONSTRAINT `cmfTmId` FOREIGN KEY ( `cmfTmId` ) REFERENCES `rg_Term` (`tmId`);
ALTER TABLE `regist`.`rg_CommonFeeTp`
ADD CONSTRAINT `cmftTmId` FOREIGN KEY ( `cmftTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `cmftFeeId` FOREIGN KEY ( `cmftFeeId` ) REFERENCES `rg_Fee` (`feeId`);
ALTER TABLE `regist`.`rg_CourseOpen`
ADD CONSTRAINT `coCurId` FOREIGN KEY ( `coCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `coSyId` FOREIGN KEY ( `coSyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `coTmId` FOREIGN KEY ( `coTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `coCrsId` FOREIGN KEY ( `coCrsId` ) REFERENCES `rg_Course` (`crsId`),
ADD CONSTRAINT `coRspId` FOREIGN KEY ( `coRspId` ) REFERENCES `rg_RealStudyPlan` (`rspId`),
ADD CONSTRAINT `coCdId1` FOREIGN KEY ( `coCdId1` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `coCdId2` FOREIGN KEY ( `coCdId2` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `coPrsId` FOREIGN KEY ( `coPrsId` ) REFERENCES `rg_Person` (`prsId`);
ALTER TABLE `regist`.`rg_CourseOpenFor`
ADD CONSTRAINT `cofCoId` FOREIGN KEY ( `cofCoId` ) REFERENCES `rg_CourseOpen` (`coId`),
ADD CONSTRAINT `cofCurId` FOREIGN KEY ( `cofCurId` ) REFERENCES `rg_Curriculum` (`curId`);
ALTER TABLE `regist`.`rg_Course`
ADD CONSTRAINT `crsCdId` FOREIGN KEY ( `crsCdId` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `crsGtpId` FOREIGN KEY ( `crsGtpId` ) REFERENCES `rg_GradeTp` (`gtpId`);
ALTER TABLE `regist`.`rg_CourseFee`
ADD CONSTRAINT `crfStdId` FOREIGN KEY ( `crfStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `crfTmId` FOREIGN KEY ( `crfTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `crfRfId` FOREIGN KEY ( `crfRfId` ) REFERENCES `rg_RegistFee` (`rfId`);
ALTER TABLE `regist`.`rg_CourseFeeTp`
ADD CONSTRAINT `crftCurId` FOREIGN KEY ( `crftCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `crftTmId` FOREIGN KEY ( `crftTmId` ) REFERENCES `rg_Term` (`tmId`);
ALTER TABLE `regist`.`rg_CourseOpenStudent`
ADD CONSTRAINT `cosStdId` FOREIGN KEY ( `cosStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `cosCoId` FOREIGN KEY ( `cosCoId` ) REFERENCES `rg_CourseOpen` (`coId`);
ALTER TABLE `regist`.`rg_Curriculum`
ADD CONSTRAINT `curCcId` FOREIGN KEY ( `curCcId` ) REFERENCES `rg_CurriculumConfig` (`ccId`),
ADD CONSTRAINT `curEdgId` FOREIGN KEY ( `curEdgId` ) REFERENCES `rg_EduDegree` (`edgId`),
ADD CONSTRAINT `curGtpId` FOREIGN KEY ( `curGtpId` ) REFERENCES `rg_GradeTp` (`gtpId`),
ADD CONSTRAINT `curElvId` FOREIGN KEY ( `curElvId` ) REFERENCES peoplecenter.`Level` (levelId);
ALTER TABLE `regist`.`rg_CurriculumFee`
ADD CONSTRAINT `cfStdId` FOREIGN KEY ( `cfStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `cfTmId` FOREIGN KEY ( `cfTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `cfFeeId` FOREIGN KEY ( `cfFeeId` ) REFERENCES `rg_Fee` (`feeId`);
ALTER TABLE `regist`.`rg_CurriculumFeeTp`
ADD CONSTRAINT `cftCurId` FOREIGN KEY ( `cftCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `cftTmId` FOREIGN KEY ( `cftTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `cftFeeId` FOREIGN KEY ( `cftFeeId` ) REFERENCES `rg_Fee` (`feeId`);
ALTER TABLE `regist`.`rg_CurriculumStructure`
ADD CONSTRAINT `csCurId` FOREIGN KEY ( `csCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `csCdId1` FOREIGN KEY ( `csCdId1` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `csCdId2` FOREIGN KEY ( `csCdId2` ) REFERENCES `rg_Condition` (`cdId`);
ALTER TABLE `regist`.`rg_Debt`
ADD CONSTRAINT `dbtStdId` FOREIGN KEY ( `dbtStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `dbtTmId` FOREIGN KEY ( `dbtTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `dbtOrgId` FOREIGN KEY ( `dbtOrgId` ) REFERENCES `rg_Organization` (`orgId`);
-- ALTER TABLE `regist`.`rg_District`
-- ADD CONSTRAINT `dtApId` FOREIGN KEY ( `dtApId` ) REFERENCES `rg_Amphur` (`apId`),
-- ADD CONSTRAINT `dtPrvId` FOREIGN KEY ( `dtPrvId` ) REFERENCES `rg_Province` (`prvId`);
ALTER TABLE `regist`.`rg_DomitoryFeeTp`
ADD CONSTRAINT `dftTmId` FOREIGN KEY ( `dftTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `dftDmId` FOREIGN KEY ( `dftDmId` ) REFERENCES peoplecenter.`spc_Place` (`plHwId`);
ALTER TABLE `regist`.`rg_ExamSchedule`
ADD CONSTRAINT `esCoId` FOREIGN KEY ( `esCoId` ) REFERENCES `rg_CourseOpen` (`coId`),
ADD CONSTRAINT `esRmId` FOREIGN KEY ( `esRmId` ) REFERENCES peoplecenter.`spc_Place` (`plHwId`),
ADD CONSTRAINT `esPrdFrTime` FOREIGN KEY ( `esPrdFrTime` ) REFERENCES `rg_Period` (`prdId`),
ADD CONSTRAINT `esPrsId` FOREIGN KEY ( `esPrsId` ) REFERENCES `rg_Person` (`prsId`),
ADD CONSTRAINT `esPrdToTime` FOREIGN KEY ( `esPrdToTime` ) REFERENCES `rg_Period` (`prdId`),
ADD CONSTRAINT `esStId` FOREIGN KEY ( `esStId` ) REFERENCES `rg_StudyType` (`stId`);
ALTER TABLE `regist`.`rg_ExternalPlace`
ADD CONSTRAINT `etpMepId` FOREIGN KEY ( `etpMepId` ) REFERENCES `rg_MainExternalPlace` (`mepId`),
ADD CONSTRAINT `etpSepId` FOREIGN KEY ( `etpSepId` ) REFERENCES `rg_SubExternalPlace` (`sepId`);
ALTER TABLE `regist`.`rg_Fee`
ADD CONSTRAINT `feeFgId` FOREIGN KEY ( `feeFgId` ) REFERENCES `rg_FeeGroup` (`fgId`),
ADD CONSTRAINT `feePytId` FOREIGN KEY ( `feePytId` ) REFERENCES `rg_PayType` (`pytId`),
ADD CONSTRAINT `feeElvId` FOREIGN KEY ( `feeElvId` ) REFERENCES peoplecenter.`Level` (`levelId`);
ALTER TABLE `regist`.`rg_FStatusInPs`
ADD CONSTRAINT `fipPsId` FOREIGN KEY ( `fipPsId` ) REFERENCES `rg_PersonStatus` (`psId`);
ALTER TABLE `regist`.`rg_Generation`
ADD CONSTRAINT `genCurId` FOREIGN KEY ( `genCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `genTmId` FOREIGN KEY ( `genTmId` ) REFERENCES `rg_Term` (`tmId`);
ALTER TABLE `regist`.`rg_Grade`
ADD CONSTRAINT `grdGtpId` FOREIGN KEY ( `grdGtpId` ) REFERENCES `rg_GradeTp` (`gtpId`);
ALTER TABLE `regist`.`rg_LoadType`
ADD CONSTRAINT `ltStId` FOREIGN KEY ( `ltStId` ) REFERENCES `rg_StudyType` (`stId`);
ALTER TABLE `regist`.`rg_MainExternalPlace`
ADD CONSTRAINT `mepPrvId` FOREIGN KEY ( `mepPrvId` ) REFERENCES peoplecenter.`Province` (`provinceId`);
ALTER TABLE `regist`.`rg_NoStudyDate`
ADD CONSTRAINT `nsdNsdIdParent` FOREIGN KEY ( `nsdNsdIdParent` ) REFERENCES `rg_NoStudyDate` (`nsdId`);
ALTER TABLE `regist`.`rg_Payment`
ADD CONSTRAINT `pmRfId` FOREIGN KEY ( `pmRfId` ) REFERENCES `rg_RegistFee` (`rfId`);
ALTER TABLE `regist`.`rg_Person`
ADD CONSTRAINT `prsPtId` FOREIGN KEY ( `prsPtId` ) REFERENCES `rg_PersonType` (`ptId`),
ADD CONSTRAINT `prsOrgId` FOREIGN KEY ( `prsOrgId` ) REFERENCES `rg_Organization` (`orgId`),
ADD CONSTRAINT `prsItId` FOREIGN KEY ( `prsItId` ) REFERENCES `rg_InstructorType` (`itId`),
ADD CONSTRAINT `prsPsId` FOREIGN KEY ( `prsPsId` ) REFERENCES `rg_PersonStatus` (`psId`);
ALTER TABLE `regist`.`rg_PersonDepartment`
ADD CONSTRAINT `pdPrsId` FOREIGN KEY ( `pdPrsId` ) REFERENCES `rg_Person` (`prsId`),
ADD CONSTRAINT `pdDptId` FOREIGN KEY ( `pdDptId` ) REFERENCES `rg_Department` (`dptId`);
ALTER TABLE `regist`.`rg_PersonPermission`
ADD CONSTRAINT `ppPrsId` FOREIGN KEY ( `ppPrsId` ) REFERENCES `rg_Person` (`prsId`),
ADD CONSTRAINT `ppTmId` FOREIGN KEY ( `ppTmId` ) REFERENCES `rg_Term` (`tmId`);
-- ADD CONSTRAINT `ppCurId` FOREIGN KEY ( `ppCurId` ) REFERENCES `rg_Curriculum` (`curId`);
ALTER TABLE `regist`.`rg_PracticeHours`
ADD CONSTRAINT `phCurId` FOREIGN KEY ( `phCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `phCpId` FOREIGN KEY ( `phCpId` ) REFERENCES `rg_ClinicalPractice` (`cpId`);
ALTER TABLE `regist`.`rg_PreCourse`
ADD CONSTRAINT `prcCrsId` FOREIGN KEY ( `prcCrsId` ) REFERENCES `rg_Course` (`crsId`),
ADD CONSTRAINT `prcPrCrsId` FOREIGN KEY ( `prcPrCrsId` ) REFERENCES `rg_Course` (`crsId`);
ALTER TABLE `regist`.`rg_ProgramCourses`
ADD CONSTRAINT `rg_ProgramCourses_ibfk_1` FOREIGN KEY (`pcrCsCurId`, `pcrCsCdId1`, `pcrCsCdId2`) REFERENCES `rg_CurriculumStructure` (`csCurId` ,`csCdId1`, `csCdId2`),
ADD CONSTRAINT `pcrCsCurId` FOREIGN KEY ( `pcrCsCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `pcrCsCdId1` FOREIGN KEY ( `pcrCsCdId1` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `pcrCsCdId2` FOREIGN KEY ( `pcrCsCdId2` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `pcrCrsId` FOREIGN KEY ( `pcrCrsId` ) REFERENCES `rg_Course` (`crsId`);
ALTER TABLE `regist`.`rg_RealStudyPlan`
ADD CONSTRAINT `rspCurId` FOREIGN KEY ( `rspCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `rspSyId` FOREIGN KEY ( `rspSyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `rspTmId` FOREIGN KEY ( `rspTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `rspCrsId` FOREIGN KEY ( `rspCrsId` ) REFERENCES `rg_Course` (`crsId`),
ADD CONSTRAINT `rspCoId` FOREIGN KEY ( `rspCoId` ) REFERENCES `rg_CourseOpen` (`coId`),
ADD CONSTRAINT `rspCdId1` FOREIGN KEY ( `rspCdId1` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `rspCdId2` FOREIGN KEY ( `rspCdId2` ) REFERENCES `rg_Condition` (`cdId`);
ALTER TABLE `regist`.`rg_ReceiptItemsInCurriculum`
ADD CONSTRAINT `ricCurId` FOREIGN KEY ( `ricCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `ricRitId` FOREIGN KEY ( `ricRitId` ) REFERENCES `rg_ReceiptItems` (`ritId`);
ALTER TABLE `regist`.`rg_Regist`
ADD CONSTRAINT `rgStdId` FOREIGN KEY ( `rgStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `rgTmId` FOREIGN KEY ( `rgTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `rgCurId` FOREIGN KEY ( `rgCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `rgSyId` FOREIGN KEY ( `rgSyId` ) REFERENCES `rg_StudyYear` (`syId`);
ALTER TABLE `regist`.`rg_RegistDetails`
ADD CONSTRAINT `rg_RegistDetails_ibfk_1` FOREIGN KEY (`rdStdId`, `rdAcY`, `rdTmId`, `rdSeq`) REFERENCES `rg_Regist` (`rgStdId`, `rgAcY`, `rgTmId`, `rgSeq`),
ADD CONSTRAINT `rdStdId` FOREIGN KEY ( `rdStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `rdTmId` FOREIGN KEY ( `rdTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `rdCoId` FOREIGN KEY ( `rdCoId` ) REFERENCES `rg_CourseOpen` (`coId`),
ADD CONSTRAINT `rdCdId1` FOREIGN KEY ( `rdCdId1` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `rdCdId2` FOREIGN KEY ( `rdCdId2` ) REFERENCES `rg_Condition` (`cdId`);
ALTER TABLE `regist`.`rg_RegistFee`
ADD CONSTRAINT `rfStdId` FOREIGN KEY ( `rfStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `rfSyId` FOREIGN KEY ( `rfSyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `rfTmId` FOREIGN KEY ( `rfTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `rfCurId` FOREIGN KEY ( `rfCurId` ) REFERENCES `rg_Curriculum` (`curId`);
ALTER TABLE `regist`.`rg_RegistWithdraw`
ADD CONSTRAINT `rg_RegistWithdraw_ibfk_1` FOREIGN KEY ( `rwStdId`, `rwAcY`, `rwTmId`, `rwSeq`) REFERENCES `rg_Regist` (`rgStdId`, `rgAcY`, `rgTmId` ,`rgSeq`),
ADD CONSTRAINT `rwStdId` FOREIGN KEY ( `rwStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `rwTmId` FOREIGN KEY ( `rwTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `rwCoId` FOREIGN KEY ( `rwCoId` ) REFERENCES `rg_CourseOpen` (`coId`),
ADD CONSTRAINT `rwCdId1` FOREIGN KEY ( `rwCdId1` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `rwCdId2` FOREIGN KEY ( `rwCdId2` ) REFERENCES `rg_Condition` (`cdId`);
-- ALTER TABLE `regist`.`rg_Room`
-- ADD CONSTRAINT `rmBdId` FOREIGN KEY ( `rmBdId` ) REFERENCES `rg_Building` (`bdId`);
ALTER TABLE `regist`.`rg_Schedule`
ADD CONSTRAINT `sdTmId` FOREIGN KEY ( `sdTmId` ) REFERENCES `rg_Term` (`tmId`);
ALTER TABLE `regist`.`rg_ScholarOwner`
ADD CONSTRAINT `soPrvId` FOREIGN KEY ( `soPrvId` ) REFERENCES peoplecenter.`Province` (`provinceId`);
ALTER TABLE `regist`.`rg_Student`
ADD CONSTRAINT `stdPfId` FOREIGN KEY (`stdPfId`) REFERENCES peoplecenter.`Prefix` (`prefixId`),
ADD CONSTRAINT `stdCurId` FOREIGN KEY (`stdCurId`) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `stdTmIdAdmit` FOREIGN KEY (`stdTmIdAdmit`) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `stdSyId` FOREIGN KEY (`stdSyId`) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `stdSstId` FOREIGN KEY (`stdSstId`) REFERENCES `rg_StudentStatus` (`sstId`),
ADD CONSTRAINT `stdGenId` FOREIGN KEY (`stdGenId`) REFERENCES `rg_Generation` (`genId`),
ADD CONSTRAINT `stdEtId` FOREIGN KEY (`stdEtId`) REFERENCES `rg_EntryType` (`etId`),
ADD CONSTRAINT `stdEt2Id` FOREIGN KEY ( `stdEt2Id` ) REFERENCES `rg_EntryType2` (`et2Id`),
ADD CONSTRAINT `stdPaId` FOREIGN KEY (`stdPaId`) REFERENCES `rg_PreAdmit` (`paId`),
ADD CONSTRAINT `stdSoId` FOREIGN KEY (`stdSoId`) REFERENCES `rg_ScholarOwner` (`soId`),
ADD CONSTRAINT `stdFsId` FOREIGN KEY ( `stdFsId` ) REFERENCES `rg_FinanceStatus` (`fsId`),
ADD CONSTRAINT `stdSstIdTmp` FOREIGN KEY ( `stdSstIdTmp` ) REFERENCES `rg_StudentStatus` (`sstId`);
ALTER TABLE `regist`.`rg_StudentDetails`
ADD CONSTRAINT `sdtStdId` FOREIGN KEY (`sdtStdId`) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `sdtPrvIdBirth` FOREIGN KEY (`sdtPrvIdBirth`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtCntId` FOREIGN KEY (`sdtCntId`) REFERENCES peoplecenter.`Country` (`countryId`),
ADD CONSTRAINT `sdtNtId` FOREIGN KEY (`sdtNtId`) REFERENCES peoplecenter.`Nation` (`nationId`),
ADD CONSTRAINT `sdtRlgId` FOREIGN KEY (`sdtRlgId`) REFERENCES peoplecenter.`Religion` (`religionId`),
ADD CONSTRAINT `sdtMsId` FOREIGN KEY (`sdtMsId`) REFERENCES `rg_MaritalStatus` (`msId`),
ADD CONSTRAINT `sdtRtId` FOREIGN KEY (`sdtRtId`) REFERENCES `rg_RecruitmentType` (`rtId`),
ADD CONSTRAINT `sdtHpId` FOREIGN KEY (`sdtHpId`) REFERENCES `rg_HealthPrivilege` (`hpId`),
ADD CONSTRAINT `sdtPfIdParent` FOREIGN KEY (`sdtPfIdParent`) REFERENCES peoplecenter.`Prefix` (`prefixId`),
ADD CONSTRAINT `sdtDtIdHome` FOREIGN KEY (`sdtDtIdHome`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdHome` FOREIGN KEY (`sdtApIdHome`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdHome` FOREIGN KEY (`sdtPrvIdHome`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtDtIdCurrent` FOREIGN KEY (`sdtDtIdCurrent`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdCurrent` FOREIGN KEY (`sdtApIdCurrent`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdCurrent` FOREIGN KEY (`sdtPrvIdCurrent`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtDtIdWork` FOREIGN KEY (`sdtDtIdWork`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdWork` FOREIGN KEY (`sdtApIdWork`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdWork` FOREIGN KEY (`sdtPrvIdWork`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtDtIdFather` FOREIGN KEY (`sdtDtIdFather`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdFather` FOREIGN KEY (`sdtApIdFather`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdFather` FOREIGN KEY (`sdtPrvIdFather`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtDtIdMother` FOREIGN KEY (`sdtDtIdMother`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdMother` FOREIGN KEY (`sdtApIdMother`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdMother` FOREIGN KEY (`sdtPrvIdMother`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtDtIdParent` FOREIGN KEY (`sdtDtIdParent`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdParent` FOREIGN KEY (`sdtApIdParent`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdParent` FOREIGN KEY (`sdtPrvIdParent`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtDtIdContact` FOREIGN KEY (`sdtDtIdContact`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdContact` FOREIGN KEY (`sdtApIdContact`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdContact` FOREIGN KEY (`sdtPrvIdContact`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtDtIdGraduate` FOREIGN KEY (`sdtDtIdGraduate`) REFERENCES peoplecenter.`District` (`districtId`),
ADD CONSTRAINT `sdtApIdGraduate` FOREIGN KEY (`sdtApIdGraduate`) REFERENCES peoplecenter.`Amphur` (`amphurId`),
ADD CONSTRAINT `sdtPrvIdGraduate` FOREIGN KEY (`sdtPrvIdGraduate`) REFERENCES peoplecenter.`Province` (`provinceId`),
ADD CONSTRAINT `sdtEdgIdPre` FOREIGN KEY (`sdtEdgIdPre`) REFERENCES `rg_EduDegree` (`edgId`);
ALTER TABLE `regist`.`rg_StudentAbsent`
ADD CONSTRAINT `sabStdId` FOREIGN KEY ( `sabStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `sabSyId` FOREIGN KEY ( `sabSyId` ) REFERENCES `rg_StudyYear` (`syId`);
ALTER TABLE `regist`.`rg_StudentActivity`
ADD CONSTRAINT `sacStdId` FOREIGN KEY ( `sacStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `sacSyId` FOREIGN KEY ( `sacSyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `sacTmId` FOREIGN KEY ( `sacTmId` ) REFERENCES `rg_Term` (`tmId`);
-- ADD CONSTRAINT `sbePrsId` FOREIGN KEY ( `sbePrsId` ) REFERENCES `rg_Person` (`prsId`);
ALTER TABLE `regist`.`rg_StudentBehavior`
ADD CONSTRAINT `sbeStdId` FOREIGN KEY ( `sbeStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `sbeTmId` FOREIGN KEY ( `sbeTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `sbeDcpId` FOREIGN KEY ( `sbeDcpId` ) REFERENCES `rg_Discipline` (`dcpId`);
ALTER TABLE `regist`.`rg_StudentDomitory`
ADD CONSTRAINT `sdmStdId` FOREIGN KEY ( `sdmStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `sdmTmId` FOREIGN KEY ( `sdmTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `sdmDmId` FOREIGN KEY ( `sdmDmId` ) REFERENCES peoplecenter.`spc_Place` (`plHwId`);
ALTER TABLE `regist`.`rg_StudentEduHis`
ADD CONSTRAINT `sehStdId` FOREIGN KEY ( `sehStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `sehElvId` FOREIGN KEY ( `sehElvId` ) REFERENCES peoplecenter.`Level` (`levelId`),
ADD CONSTRAINT `sehPrvId` FOREIGN KEY ( `sehPrvId` ) REFERENCES peoplecenter.`Province` (`provinceId`);
ALTER TABLE `regist`.`rg_StudentReward`
ADD CONSTRAINT `srwStdId` FOREIGN KEY ( `srwStdId` ) REFERENCES `rg_Student` (`stdId`);
ALTER TABLE `regist`.`rg_StudentSummary`
ADD CONSTRAINT `ssmStdId` FOREIGN KEY ( `ssmStdId` ) REFERENCES `rg_Student` (`stdId`),
ADD CONSTRAINT `ssmTmId` FOREIGN KEY ( `ssmTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `ssmSstId` FOREIGN KEY ( `ssmSstId` ) REFERENCES `rg_StudentStatus` (`sstId`),
ADD CONSTRAINT `ssmSstIdApproveSpe` FOREIGN KEY ( `ssmSstIdApproveSpe` ) REFERENCES `rg_StudentStatus` (`sstId`),
ADD CONSTRAINT `ssmSyId` FOREIGN KEY ( `ssmSyId` ) REFERENCES `rg_StudyYear` (`syId`);
ALTER TABLE `regist`.`rg_StudyPlan`
ADD CONSTRAINT `spCurId` FOREIGN KEY ( `spCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `spSyId` FOREIGN KEY ( `spSyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `spTmId` FOREIGN KEY ( `spTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `spCrsId` FOREIGN KEY ( `spCrsId` ) REFERENCES `rg_Course` (`crsId`),
ADD CONSTRAINT `spCdId1` FOREIGN KEY ( `spCdId1` ) REFERENCES `rg_Condition` (`cdId`),
ADD CONSTRAINT `spCdId2` FOREIGN KEY ( `spCdId2` ) REFERENCES `rg_Condition` (`cdId`);
ALTER TABLE `regist`.`rg_SummaryStudent`
ADD CONSTRAINT `smCurId` FOREIGN KEY ( `smCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `smEtId` FOREIGN KEY ( `smEtId` ) REFERENCES `rg_EntryType` (`etId`);
ALTER TABLE `regist`.`rg_SummaryStudentStdY`
ADD CONSTRAINT `smyCurId` FOREIGN KEY ( `smyCurId` ) REFERENCES `rg_Curriculum` (`curId`),
ADD CONSTRAINT `smySyId` FOREIGN KEY ( `smySyId` ) REFERENCES `rg_StudyYear` (`syId`),
ADD CONSTRAINT `smyEtId` FOREIGN KEY ( `smyEtId` ) REFERENCES `rg_EntryType` (`etId`);
ALTER TABLE `regist`.`rg_TermConfig`
ADD CONSTRAINT `tmcTmId` FOREIGN KEY ( `tmcTmId` ) REFERENCES `rg_Term` (`tmId`);
ALTER TABLE `regist`.`rg_TimeTable`
ADD CONSTRAINT `ttCoId` FOREIGN KEY ( `ttCoId` ) REFERENCES `rg_CourseOpen` (`coId`),
ADD CONSTRAINT `ttDyId` FOREIGN KEY ( `ttDyId` ) REFERENCES `rg_Day` (`dyId`),
ADD CONSTRAINT `ttPrdFrTime` FOREIGN KEY ( `ttPrdFrTime` ) REFERENCES `rg_Period` (`prdId`),
ADD CONSTRAINT `ttPrdToTime` FOREIGN KEY ( `ttPrdToTime` ) REFERENCES `rg_Period` (`prdId`),
ADD CONSTRAINT `ttPrsId` FOREIGN KEY ( `ttPrsId` ) REFERENCES `rg_Person` (`prsId`),
ADD CONSTRAINT `ttStId` FOREIGN KEY ( `ttStId` ) REFERENCES `rg_StudyType` (`stId`),
ADD CONSTRAINT `ttEtpMepId` FOREIGN KEY ( `ttEtpMepId` ) REFERENCES `rg_ExternalPlace` (`etpMepId`),
ADD CONSTRAINT `ttEtpSepId` FOREIGN KEY ( `ttEtpSepId` ) REFERENCES `rg_ExternalPlace` (`etpSepId`),
ADD CONSTRAINT `rg_TimeTable_ibfk_1` FOREIGN KEY ( `ttEtpMepId`, `ttEtpSepId` ) REFERENCES `rg_ExternalPlace` (`etpMepId`, `etpSepId`),
ADD CONSTRAINT `ttRmId` FOREIGN KEY ( `ttRmId` ) REFERENCES peoplecenter.`spc_Place` (`plHwId`);
ALTER TABLE `regist`.`rg_TimeTableCopy`
ADD CONSTRAINT `ttcCoId` FOREIGN KEY ( `ttcCoId` ) REFERENCES `rg_CourseOpen` (`coId`),
ADD CONSTRAINT `rg_TimeTableCopy_ibfk_1` FOREIGN KEY ( `ttcEtpMepId`, `ttcEtpSepId` ) REFERENCES `rg_ExternalPlace` (`etpMepId`, `etpSepId`),
ADD CONSTRAINT `ttcEtpMepId` FOREIGN KEY ( `ttcEtpMepId` ) REFERENCES `rg_ExternalPlace` (`etpMepId`),
ADD CONSTRAINT `ttcEtpSepId` FOREIGN KEY ( `ttcEtpSepId` ) REFERENCES `rg_ExternalPlace` (`etpSepId`),
ADD CONSTRAINT `ttcDyId` FOREIGN KEY ( `ttcDyId` ) REFERENCES `rg_Day` (`dyId`),
ADD CONSTRAINT `ttcPrdFrTime` FOREIGN KEY ( `ttcPrdFrTime` ) REFERENCES `rg_Period` (`prdId`),
ADD CONSTRAINT `ttcPrdToTime` FOREIGN KEY ( `ttcPrdToTime` ) REFERENCES `rg_Period` (`prdId`),
ADD CONSTRAINT `ttcPrsId` FOREIGN KEY ( `ttcPrsId` ) REFERENCES `rg_Person` (`prsId`),
ADD CONSTRAINT `ttcStId` FOREIGN KEY ( `ttcStId` ) REFERENCES `rg_StudyType` (`stId`),
ADD CONSTRAINT `ttcTtId` FOREIGN KEY ( `ttcTtId` ) REFERENCES `rg_TimeTable` (`ttId`),
ADD CONSTRAINT `ttcLtId` FOREIGN KEY ( `ttcLtId` ) REFERENCES `rg_LoadType` (`ltId`),
ADD CONSTRAINT `ttcRmId` FOREIGN KEY ( `ttcRmId` ) REFERENCES peoplecenter.`spc_Place` (`plHwId`);
ALTER TABLE `regist`.`rg_TTTeachingMethod`
ADD CONSTRAINT `tttTtId` FOREIGN KEY ( `tttTtId` ) REFERENCES `rg_TimeTable` (`ttId`),
ADD CONSTRAINT `tttTcmId` FOREIGN KEY ( `tttTcmId` ) REFERENCES `rg_TeachingMethod` (`tcmId`);
ALTER TABLE `regist`.`rg_UnitConfig`
ADD CONSTRAINT `ucTmId` FOREIGN KEY ( `ucTmId` ) REFERENCES `rg_Term` (`tmId`),
ADD CONSTRAINT `ucLtId` FOREIGN KEY ( `ucLtId` ) REFERENCES `rg_LoadType` (`ltId`);
ALTER TABLE `regist`.`rg_WeekDate`
ADD CONSTRAINT `wdTmId` FOREIGN KEY ( `wdTmId` ) REFERENCES `rg_Term` (`tmId`);
ALTER TABLE `regist`.`rg_Condition`
ADD CONSTRAINT `cdGtpId` FOREIGN KEY ( `cdGtpId` ) REFERENCES `rg_GradeTp` (`gtpId`);
|