{"id":442007,"date":"2021-04-19T03:42:50","date_gmt":"2021-04-18T19:42:50","guid":{"rendered":"http:\/\/4563.org\/?p=442007"},"modified":"2021-04-19T03:42:50","modified_gmt":"2021-04-18T19:42:50","slug":"%e4%b8%8d%e6%87%82%e5%b0%b1%e9%97%ae%ef%bc%8c%e5%9c%a8-mysql-%e4%b8%ad%e5%85%b3%e4%ba%8e-associative-entity%ef%bc%88credentials%ef%bc%89%e6%8a%a5%e9%94%99%e5%ba%94%e8%af%a5%e6%80%8e%e4%b9%88%e6%94%b9","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=442007","title":{"rendered":"\u4e0d\u61c2\u5c31\u95ee\uff0c\u5728 mysql \u4e2d\u5173\u4e8e associative entity\uff08Credentials\uff09\u62a5\u9519\u5e94\u8be5\u600e\u4e48\u6539\uff1f"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  \u4e0d\u61c2\u5c31\u95ee\uff0c\u5728 mysql \u4e2d\u5173\u4e8e associative entity\uff08Credentials\uff09\u62a5\u9519\u5e94\u8be5\u600e\u4e48\u6539\uff1f               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Lzjss <\/span>  <span><i><\/i> 3<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\">                        \u62a5\u9519\uff1aFailed to add the foreign key constraint. Missing index for constraint &#8216;FK_CREDENTIALS_USER&#8217; in the referenced table &#8216;User&#8217;<\/p>\n<p>\u5177\u4f53\u4ee3\u7801\uff1a<br \/>DROP TABLE IF EXISTS `PharmacyManagementSystemDB`.`User` ;<\/p>\n<p>CREATE TABLE IF NOT EXISTS `PharmacyManagementSystemDB`.`User` (<br \/> `user_id` TINYINT(9) NOT NULL AUTO_INCREMENT,<br \/> `email` VARCHAR(45) NOT NULL,<br \/> `first_name` VARCHAR(45) NOT NULL,<br \/> `last_name` VARCHAR(45) NOT NULL,<br \/> `full_name` VARCHAR(100) GENERATED ALWAYS AS (CONCAT(first_name,&#8221; &#8220;,last_name)),<br \/> `phone_num` INT NOT NULL,<br \/> PRIMARY KEY (`user_id`, `email`))<br \/>ENGINE = InnoDB;<\/p>\n<p>&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>&#8212; Table `PharmacyManagementSystemDB`.`Account`<br \/>&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>DROP TABLE IF EXISTS `PharmacyManagementSystemDB`.`Account` ;<\/p>\n<p>CREATE TABLE IF NOT EXISTS `PharmacyManagementSystemDB`.`Account` (<br \/> `account_id` TINYINT NOT NULL AUTO_INCREMENT,<br \/> `created` TIMESTAMP NOT NULL,<br \/> `expires` TIMESTAMP NOT NULL,<br \/> `user_id` TINYINT NOT NULL,<br \/> `region` TINYINT NOT NULL,<br \/> `role` TINYINT NOT NULL,<br \/> PRIMARY KEY (`account_id`),<br \/> INDEX `FK_PK_USER_ACCOUNT_idx` (`user_id` ASC) VISIBLE,<br \/> INDEX `FK_PK_REGION_ACCOUNT_idx` (`region` ASC) VISIBLE,<br \/> INDEX `FK_PK_ROLES_ACCOUNT_idx` (`role` ASC) VISIBLE,<br \/> CONSTRAINT `FK_PK_USER_ACCOUNT`<br \/> FOREIGN KEY (`user_id`)<br \/> REFERENCES `PharmacyManagementSystemDB`.`User` (`user_id`)<br \/> ON DELETE NO ACTION<br \/> ON UPDATE NO ACTION,<br \/> CONSTRAINT `FK_PK_REGION_ACCOUNT`<br \/> FOREIGN KEY (`region`)<br \/> REFERENCES `PharmacyManagementSystemDB`.`Region` (`region_id`)<br \/> ON DELETE NO ACTION<br \/> ON UPDATE NO ACTION,<br \/> CONSTRAINT `FK_PK_ROLES_ACCOUNT`<br \/> FOREIGN KEY (`role`)<br \/> REFERENCES `PharmacyManagementSystemDB`.`Roles` (`Roles_id`)<br \/> ON DELETE NO ACTION<br \/> ON UPDATE NO ACTION)<br \/>ENGINE = InnoDB;<\/p>\n<p>&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>&#8212; Table `PharmacyManagementSystemDB`.`Credentials`<br \/>&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>DROP TABLE IF EXISTS `PharmacyManagementSystemDB`.`Credentials` ;<\/p>\n<p>CREATE TABLE IF NOT EXISTS `PharmacyManagementSystemDB`.`Credentials` (<br \/> `credentials_id` TINYINT NOT NULL,<br \/> `email` VARCHAR(45) NOT NULL,<br \/> `passwork` VARCHAR(45) NOT NULL,<br \/> `account_id` TINYINT NOT NULL,<br \/> PRIMARY KEY (`credentials_id`, `email`, `account_id`),<br \/> INDEX `FK_CREDENTIALS_USER_idx` (`email` ASC) VISIBLE,<br \/> INDEX `FK_CREDENTIALS_ACCTOUNT_idx` (`account_id` ASC) VISIBLE,<br \/> CONSTRAINT `FK_CREDENTIALS_USER`<br \/> FOREIGN KEY (`email`)<br \/> REFERENCES `PharmacyManagementSystemDB`.`User` (`email`)<br \/> ON DELETE CASCADE<br \/> ON UPDATE CASCADE,<br \/> CONSTRAINT `FK_CREDENTIALS_ACCTOUNT`<br \/> FOREIGN KEY (`account_id`)<br \/> REFERENCES `PharmacyManagementSystemDB`.`Account` (`user_id`)<br \/> ON DELETE CASCADE<br \/> ON UPDATE CASCADE)<br \/>ENGINE = InnoDB;      <\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>0<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0d\u61c2\u5c31\u95ee\uff0c\u5728 mysql \u4e2d\u5173\u4e8e &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/442007"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=442007"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/442007\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=442007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=442007"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=442007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}