--
-- script   ADD CONSTRAINT 000 foreign key
--
     
ALTER TABLE `Amphur`
    ADD CONSTRAINT `provinceId` FOREIGN KEY (`provinceId`) REFERENCES `Province` (`provinceId`);

ALTER TABLE `District`
    ADD CONSTRAINT `amphurId` FOREIGN KEY (`amphurId`) REFERENCES `Amphur` (`amphurId`),
    ADD CONSTRAINT `fk_provinceId` FOREIGN KEY (`provinceId`) REFERENCES `Province` (`provinceId`);

ALTER TABLE `PersonT`
    ADD CONSTRAINT `personId` FOREIGN KEY (`personId`) REFERENCES `Person` (`personId`);

ALTER TABLE `spc_Place`
    ADD CONSTRAINT `plRtId` FOREIGN KEY (`plRtId`) REFERENCES `spc_RoomType` (`rtId`);