--
-- 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`);