{"id":10228,"date":"2014-04-18T17:23:02","date_gmt":"2014-04-18T08:23:02","guid":{"rendered":"http:\/\/vitalify.jp\/blog\/?p=10228"},"modified":"2022-11-08T18:34:54","modified_gmt":"2022-11-08T09:34:54","slug":"mysql-workbench","status":"publish","type":"post","link":"https:\/\/vitalify.jp\/blog\/2014\/04\/mysql-workbench.html","title":{"rendered":"MySQL Workbench\u306e\u5b58\u5728\u3092\u521d\u3081\u3066\u77e5\u3063\u3066\u885d\u6483"},"content":{"rendered":"<p>\u5236\u4f5c\u90e8\u306e\u91cc\u5c71\u3067\u3059\u3002<br \/>\n\u30b7\u30b9\u30c6\u30e0\u958b\u767a\u6848\u4ef6\u306e\u5834\u5408\u3001<br \/>\n\u5fc5\u305a\u767a\u751f\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u306e\u4f5c\u696d\u306a\u306e\u3067\u3059\u304c\u3001<br \/>\n\u5f93\u6765\u306fExcel\u306a\u3093\u304b\u306e\u8a2d\u8a08\u66f8\u3067\u3061\u307e\u3061\u307e\u66f8\u3044\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>ER\u56f3\u306a\u3069\u3092\u624b\u4f5c\u308a\u3059\u308b\u306e\u304c\u4e2d\u3005\u306b\u9762\u5012\u3060\u3063\u305f\u3093\u3067\u3059\u304c\u3001<br \/>\n\u3042\u308b\u6642\u3001MySQL Workbench\u306b\u51fa\u4f1a\u3044\u307e\u3057\u305f\u3002<br \/>\n<!--more--><br \/>\nMySQL\u306e\u30aa\u30d5\u30a3\u30b7\u30e3\u30eb\u30c4\u30fc\u30eb\u306a\u306e\u3067\u3059\u304c\u3001\u4e2d\u3005\u4f7f\u3044\u3084\u3059\u3044\u3067\u3059\u3002<br \/>\nGUI\u30d9\u30fc\u30b9\u3067ER\u56f3\u3092\u4f5c\u308c\u308b\u3046\u3048\u3001\u305d\u3053\u304b\u3089CREATE\u6587\u3092\u751f\u6210\u3067\u304d\u305f\u308a\u3059\u308b\u306e\u3067\u3001<br \/>\nExcel\u306b\u7279\u5225\u306a\u601d\u3044\u5165\u308c\u304c\u7121\u3051\u308c\u3070\u4f7f\u3046\u3079\u304d\u30c4\u30fc\u30eb\u3068\u8a00\u3048\u307e\u3059\u3002<br \/>\n\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u975e\u5e38\u306b\u4fbf\u5229\u306a\u30c7\u30fc\u30bf\u30e2\u30c7\u30ea\u30f3\u30b0\u306e\u90e8\u5206\u306b\u3064\u3044\u3066\u3001<br \/>\n\u307b\u3093\u306e\u5c11\u3057\u3060\u3051\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p>\u8d77\u52d5\u753b\u9762\u306b\u3042\u308bModels\u4ed8\u8fd1\u306e\u300c\uff0b\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/vitalify.jp\/blog\/wp-content\/uploads\/2014\/04\/img1-e1397808899927.png\" \/><\/p>\n<p>Add Diagram\u3092\u9078\u629e\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/vitalify.jp\/blog\/wp-content\/uploads\/2014\/04\/img2-e1397808864342.png\" \/><\/p>\n<p>\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308a\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/vitalify.jp\/blog\/wp-content\/uploads\/2014\/04\/img3-e1397808830302.png\" \/><\/p>\n<p>\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u7de8\u96c6\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/vitalify.jp\/blog\/wp-content\/uploads\/2014\/04\/img4-e1397808939875.png\" \/><\/p>\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5f35\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<br \/>\n\u3053\u3093\u306a\u611f\u3058\u3067\u8272\u3093\u306a\u8272\u3005\u3068\u5b9a\u7fa9\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/vitalify.jp\/blog\/wp-content\/uploads\/2014\/04\/img5-e1397808920113.png\" \/><br \/>\n\u3053\u3053\u304b\u3089\u3001CREATE\u6587\u3082\u4e00\u767a\u3067\u4f5c\u308c\u307e\u3059\u3002<\/p>\n<pre>-- MySQL Script generated by MySQL Workbench\r\n-- 04\/18\/14 17:09:42\r\n-- Model: New Model    Version: 1.0\r\nSET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;\r\nSET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;\r\nSET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';\r\n\r\n-- -----------------------------------------------------\r\n-- Schema mydb\r\n-- -----------------------------------------------------\r\nCREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;\r\nUSE `mydb` ;\r\n-- -----------------------------------------------------\r\n-- Table `mydb`.`tbl_user`\r\n-- -----------------------------------------------------\r\nCREATE TABLE IF NOT EXISTS `mydb`.`tbl_user` (\r\n  `user_id` INT NOT NULL,\r\n  `user_name` VARCHAR(45) NOT NULL,\r\n  `birth_date` DATETIME NOT NULL,\r\n  `mail_address` VARCHAR(256) NULL,\r\n  `del_flg` TINYINT NOT NULL,\r\n  `insert_date` DATETIME NOT NULL,\r\n  `update_date` DATETIME NOT NULL,\r\n  PRIMARY KEY (`user_id`),\r\n  UNIQUE INDEX `user_name_UNIQUE` (`user_name` ASC),\r\n  UNIQUE INDEX `mail_address_UNIQUE` (`mail_address` ASC))\r\nENGINE = InnoDB;\r\n\r\n-- -----------------------------------------------------\r\n-- Table `mydb`.`tbl_diary`\r\n-- -----------------------------------------------------\r\nCREATE TABLE IF NOT EXISTS `mydb`.`tbl_diary` (\r\n  `diary_id` INT NOT NULL,\r\n  `user_id` INT NOT NULL,\r\n  `title` VARCHAR(30) NOT NULL,\r\n  `text` TEXT NOT NULL,\r\n  PRIMARY KEY (`diary_id`),\r\n  INDEX `fk_tbl_diary_tbl_user_idx` (`user_id` ASC),\r\n  CONSTRAINT `fk_tbl_diary_tbl_user`\r\n    FOREIGN KEY (`user_id`)\r\n    REFERENCES `mydb`.`tbl_user` (`user_id`)\r\n    ON DELETE NO ACTION\r\n    ON UPDATE NO ACTION)\r\nENGINE = InnoDB;\r\n\r\nSET SQL_MODE=@OLD_SQL_MODE;\r\nSET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;\r\nSET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;<\/pre>\n<p>\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u3092\u53d6\u308b\u6642\u9593\u3092\u9664\u3051\u3070\u3001<br \/>\n\u3053\u3053\u307e\u3067\u4e00\u9023\u306e\u4f5c\u696d\u304c\u7d0410\u5206\u3067\u3057\u305f\u3002<br \/>\nGUI\u30d9\u30fc\u30b9\u306a\u306e\u3067\u64cd\u4f5c\u306b\u6163\u308c\u308c\u3070\u5168\u304f\u554f\u984c\u306a\u3044\u3067\u3059\u3002<br \/>\nER\u56f3\u306fPDF\u306a\u3069\u306e\u5f62\u5f0f\u3067\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u5316\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u30d5\u30a3\u30fc\u30eb\u30c9\u30ea\u30b9\u30c8\u3092\u4f55\u3089\u304b\u306e\u5f62\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3067\u304d\u308c\u3070\u30d1\u30fc\u30d5\u30a7\u30af\u30c8\u306a\u3093\u3067\u3059\u304c\u3001<br \/>\n\u305d\u306e\u8fba\u306e\u6a5f\u80fd\u304c\u3042\u308b\u304b\u306f\u78ba\u8a8d\u4e2d\u3002<\/p>\n<p>\u3061\u306a\u307f\u306b\u3001\u65e2\u5b58\u306eMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u65e2\u306b\u3042\u308b\u5834\u5408\u3001<br \/>\nDB\u69cb\u9020\u3092SQL\u5f62\u5f0f\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308c\u3070\u3001<br \/>\n\u305d\u3053\u306b\u5165\u3063\u3066\u3044\u308bCREATE\u6587\u3092\u30ea\u30d0\u30fc\u30b9\u3057\u3066\u81ea\u52d5\u3067ER\u56f3\u3092\u4f5c\u3063\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n<p>\u3082\u3061\u308d\u3093\u3001\u30ea\u30e2\u30fc\u30c8\u30b5\u30fc\u30d0\u30fc\uff08\u516c\u958b\u9375\u8a8d\u8a3c\u3084\u8e0f\u307f\u53f0\u30a2\u30af\u30bb\u30b9\u3082OK\uff09\u306b\u5bfe\u3057\u3066\u3001<br \/>\n\u30c7\u30fc\u30bf\u306e\u4e2d\u8eab\u3092\u30d6\u30e9\u30a6\u30b8\u30f3\u30b0\u3057\u305f\u308a\u3082\u3067\u304d\u308b\u306e\u3067\u3001<br \/>\nphpMyAdmin\u307f\u305f\u3044\u306a\u30c4\u30fc\u30eb\u3082\u4e0d\u8981\u3067\u3059\u3002<br \/>\n\u3053\u3093\u306a\u4fbf\u5229\u306a\u30c4\u30fc\u30eb\u304c\u3001\u306a\u3093\u3068\u30bf\u30c0\u3067\u3059\u3088\u3002<br \/>\n\u3059\u3070\u3089\u3057\u3044\u3002<\/p>\n<div class='wp_social_bookmarking_light'>\n            <div class=\"wsbl_facebook_like\"><div id=\"fb-root\"><\/div><fb:like href=\"https:\/\/vitalify.jp\/blog\/2014\/04\/mysql-workbench.html\" layout=\"button_count\" action=\"like\" share=\"false\" show_faces=\"false\" ><\/fb:like><\/div>\n            <div class=\"wsbl_google_plus_one\"><g:plusone size=\"medium\" annotation=\"none\" href=\"https:\/\/vitalify.jp\/blog\/2014\/04\/mysql-workbench.html\" ><\/g:plusone><\/div>\n            <div class=\"wsbl_hatena_button\"><a href=\"\/\/b.hatena.ne.jp\/entry\/https:\/\/vitalify.jp\/blog\/2014\/04\/mysql-workbench.html\" class=\"hatena-bookmark-button\" data-hatena-bookmark-title=\"MySQL Workbench\u306e\u5b58\u5728\u3092\u521d\u3081\u3066\u77e5\u3063\u3066\u885d\u6483\" data-hatena-bookmark-layout=\"standard\" title=\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"> <img src=\"\/\/b.hatena.ne.jp\/images\/entry-button\/button-only@2x.png\" alt=\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\" width=\"20\" height=\"20\" style=\"border: none;\" \/><\/a><script type=\"text\/javascript\" src=\"\/\/b.hatena.ne.jp\/js\/bookmark_button.js\" charset=\"utf-8\" async=\"async\"><\/script><\/div>\n            <div class=\"wsbl_tumblr\"><a href=\"\/\/www.tumblr.com\/share?v=3&u=https%3A%2F%2Fvitalify.jp%2Fblog%2F2014%2F04%2Fmysql-workbench.html&t=MySQL%20Workbench%E3%81%AE%E5%AD%98%E5%9C%A8%E3%82%92%E5%88%9D%E3%82%81%E3%81%A6%E7%9F%A5%E3%81%A3%E3%81%A6%E8%A1%9D%E6%92%83\" title=\"Share on Tumblr\" style=\"display:inline-block; text-indent:-9999px; overflow:hidden; width:81px; height:20px; background:url('\/\/platform.tumblr.com\/v1\/share_1.png') top left no-repeat transparent;\">Share on Tumblr<\/a><\/div>\n            <div class=\"wsbl_twitter\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\" data-url=\"https:\/\/vitalify.jp\/blog\/2014\/04\/mysql-workbench.html\" data-text=\"MySQL Workbench\u306e\u5b58\u5728\u3092\u521d\u3081\u3066\u77e5\u3063\u3066\u885d\u6483\" data-lang=\"ja\">Tweet<\/a><\/div>\n    <\/div>\n<br class='wp_social_bookmarking_light_clear' \/>\n","protected":false},"excerpt":{"rendered":"<p>\u5236\u4f5c\u90e8\u306e\u91cc\u5c71\u3067\u3059\u3002 \u30b7\u30b9\u30c6\u30e0\u958b\u767a\u6848\u4ef6\u306e\u5834\u5408\u3001 \u5fc5\u305a\u767a\u751f\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u306e\u4f5c\u696d\u306a\u306e\u3067\u3059\u304c\u3001 \u5f93\u6765\u306fExcel\u306a\u3093\u304b\u306e\u8a2d\u8a08\u66f8\u3067\u3061\u307e\u3061\u307e\u66f8\u3044\u3066\u3044\u307e\u3057\u305f\u3002 ER\u56f3\u306a\u3069\u3092\u624b\u4f5c\u308a\u3059\u308b\u306e\u304c\u4e2d\u3005\u306b\u9762\u5012\u3060\u3063\u305f\u3093\u3067\u3059\u304c\u3001 \u3042\u308b\u6642\u3001MyS &hellip; <a href=\"https:\/\/vitalify.jp\/blog\/2014\/04\/mysql-workbench.html\" class=\"more-link more_btn\"><span class=\"screen-reader-text\">&#8220;MySQL Workbench\u306e\u5b58\u5728\u3092\u521d\u3081\u3066\u77e5\u3063\u3066\u885d\u6483&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":34,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[44],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/posts\/10228"}],"collection":[{"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/comments?post=10228"}],"version-history":[{"count":7,"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/posts\/10228\/revisions"}],"predecessor-version":[{"id":38146,"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/posts\/10228\/revisions\/38146"}],"wp:attachment":[{"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/media?parent=10228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/categories?post=10228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vitalify.jp\/blog\/wp-json\/wp\/v2\/tags?post=10228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}