{"id":217,"date":"2022-01-10T09:00:00","date_gmt":"2022-01-10T00:00:00","guid":{"rendered":"https:\/\/www.miracleave.co.jp\/contents\/?p=217"},"modified":"2023-05-23T10:53:23","modified_gmt":"2023-05-23T01:53:23","slug":"db-table-schema","status":"publish","type":"post","link":"https:\/\/www.miracleave.co.jp\/contents\/217\/db-table-schema\/","title":{"rendered":"DB\u2192\u308f\u304b\u308b\u3002Table\u2192\u308f\u304b\u308b\u3002Schema\u2192\u304a\u524d\u306f\u4e00\u4f53\u306a\u3093\u306a\u3093\u3060\u30fb\u30fb\u30fb\uff01"},"content":{"rendered":"\n<div class=\"wp-block-cocoon-blocks-icon-box common-icon-box block-box information-box\">\n\n<p>\u8a18\u4e8b\u4f5c\u6210\u304b\u30891\u5e74\u4ee5\u4e0a\u7d4c\u904e\u3057\u3066\u3044\u307e\u3059\u3002<br>\u5185\u5bb9\u304c\u53e4\u3044\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n<\/div>\n\n\n\n<p><strong>public\u30b9\u30ad\u30fc\u30de\u3063\u3066\u306a\u3093\u3058\u3083\uff01\uff01\uff01<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TL;DR\uff08\u8981\u7d04\u3059\u308b\u3068\u30fb\u30fb\u30fb\uff09<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>MySQL\u3067\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30b9\u30ad\u30fc\u30de\u306f\u540c\u3058\u3068\u601d\u3063\u3066\u5927\u4e08\u592b\u3002<\/li>\n\n\n\n<li>PostgreSQL\u3067\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u3042\u3063\u3066\u305d\u306e\u4e0b\u306b\u30b9\u30ad\u30fc\u30de\u304c\u5b58\u5728\u3059\u308b\u3002<\/li>\n\n\n\n<li>\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f public \u30b9\u30ad\u30fc\u30de\u304c\u4f5c\u6210\u3055\u308c\u308b\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u3053\u308c\u307e\u3067\u306e\u7d4c\u7def<\/h2>\n\n\n\n<p>\u3068\u3042\u308b\u65e5\u306e\u663c\u4e0b\u304c\u308a<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>BOSS: \u3061\u3087\u3063\u3068\u60aa\u3044\u3093\u3060\u3051\u3069\u3055\u3001\u691c\u8a3c\u7528\u306ePostgreSQL\u306bdevelop\u30b9\u30ad\u30fc\u30de\u8ffd\u52a0\u3057\u3066\u3082\u3089\u3048\u306a\u3044\u304b\u306a\uff1f<\/p>\n\n\n\n<p>\u79c1: develop\u30b9\u30ad\u30fc\u30de\u3067\u3059\u306d\u3001\u3044\u3044\u3063\u3059\u3088\u3002<\/p>\n\n\n\n<p>\u79c1 : (\u30e6\u30fc\u30b6\u4f5c\u3063\u3066\u3001DB\u4f5c\u3063\u3066\u3001\u6a29\u9650\u4ed8\u4e0e\u3057\u3066\u3068\u2026)<\/p>\n\n\n\n<p>\u79c1: BOSS\uff01develop\u30b9\u30ad\u30fc\u30de\u3067\u304d\u307e\u3057\u305f\uff01<\/p>\n\n\n\n<p>BOSS: \u3042\u308a\u304c\u3068\u3046\uff01<\/p>\n\n\n\n<p>BOSS: \u30fb\u30fb\u30fb\u3093\uff1f \u3053\u308cpublic\u306b\u7e4b\u3052\u3070\u3044\u3044\u306e\uff1f<\/p>\n\n\n\n<p>\u79c1: \u30fb\u30fb\u30fb\u3093\uff1f public\uff1f \u307b\u3093\u3068\u3060\uff01public\u30b9\u30ad\u30fc\u30de\u3063\u3066\u306a\u3093\u3058\u3083\uff01\uff01\uff01<\/p>\n<\/blockquote>\n\n\n\n<p>\u3068\u3044\u3046\u308f\u3051\u3067\u3001\u4eca\u56de\u306f MySQL \u3068 PostgreSQL \u306e\u30b9\u30ad\u30fc\u30de\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5fc5\u8981\u306a\u3082\u306e<\/h2>\n\n\n\n<p>Docker\u4e0a\u306b  MySQL \u3068 PostgreSQL  \u3092\u69cb\u7bc9\u3057\u78ba\u8a8d\u3057\u3066\u3044\u304d\u307e\u3059\u304c\u3001<br>\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u3067\u3082\u554f\u984c\u7121\u3044\u3067\u3059\u3002<br>\u307e\u305f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u64cd\u4f5c\u306fA5 SQL Mk-2\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u9808\n<ul class=\"wp-block-list\">\n<li>MySQL:8.0<\/li>\n\n\n\n<li>PostgreSQL:12.3<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u4efb\u610f\n<ul class=\"wp-block-list\">\n<li>Docker, Docker Compose<\/li>\n\n\n\n<li>A5 SQL Mk-2<\/li>\n\n\n\n<li>Sublime Text<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL\u3067\u78ba\u8a8d<\/h2>\n\n\n\n<p>DockerCompose\u3067MySQL\u3092\u8d77\u52d5\u3057\u3066\u3001<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>version: &#39;3&#39;\n\nservices:\n  mysql:\n    image: mysql:8.0\n    environment:\n      MYSQL_ROOT_PASSWORD: root\n      TZ: &#39;Asia\/Tokyo&#39;\n    ports:\n    - &quot;3306:3306&quot;<\/code><\/pre><\/div>\n\n\n\n<p>A5M2 \u3067\u63a5\u7d9a\u3057\u3066\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"600\" height=\"432\" src=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img01.png\" alt=\"\" class=\"wp-image-218\" srcset=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img01.png 600w, https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img01-300x216.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>develop\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u3001<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>\/* \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210 *\/\nCREATE DATABASE develop;\n\n\/* \u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210 *\/\nCREATE TABLE develop.schema_info (\n    id int,\n    name varchar(255)\n);\n\n\/* \u9069\u5f53\u306b\u30c7\u30fc\u30bf\u3092 insert *\/\nINSERT INTO develop.schema_info values(1, &#39;MySQL.develop&#39;);<\/code><\/pre><\/div>\n\n\n\n<p>\u4e00\u5ea6\u63a5\u7d9a\u3092\u9589\u3058\u3066DB\u306e\u5185\u5bb9\u3092A5M2\u3067\u78ba\u8a8d\u3057\u3066\u307f\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"256\" height=\"302\" src=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2022\/07\/img0002.png\" alt=\"\" class=\"wp-image-1706\" srcset=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2022\/07\/img0002.png 256w, https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2022\/07\/img0002-254x300.png 254w\" sizes=\"(max-width: 256px) 100vw, 256px\" \/><\/figure>\n\n\n\n<p>RDBMS(local_mysql) &gt; Database(develop) &gt; Table(schema_info) \u306e\u69cb\u6210\u306a\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30b9\u30ad\u30fc\u30de\u306f\u540c\u3058\u3068\u3044\u3046\u8a8d\u8b58\u3067\u3082\u554f\u984c\u306a\u3055\u305d\u3046\u3002<\/p>\n\n\n\n\n\n\n\n<p>\u6b21\u306f\u3001PostgreSQL\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">PostgreSQL\u3067\u78ba\u8a8d<\/h2>\n\n\n\n<p>MySQL\u3068\u540c\u69d8\u306b\u78ba\u8a8d\u3057\u307e\u3059\u3002<br>\u203b PostgreSQL:12.3 \u3060\u3068 A5M2 \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u306f\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u306e\u3067\u8981\u6ce8\u610f\uff01\u8a73\u7d30\u306f\u4e0b\u90e8\u306e\u304a\u307e\u3051\u306b\u3066<\/p>\n\n\n\n<p> DockerCompose\u3067 PostgreSQL \u3092\u8d77\u52d5\u3057\u3066\u3001 <\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>version: &#39;3&#39;\n\nservices:\n  postgres:\n    image: postgres:11.8\n    environment:\n      POSTGRES_PASSWORD: postgres\n    ports:\n      - &quot;5432:5432&quot;<\/code><\/pre><\/div>\n\n\n\n<p>A5M2 \u3067\u63a5\u7d9a\u3057\u3066\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"595\" height=\"393\" src=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img03.png\" alt=\"\" class=\"wp-image-220\" srcset=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img03.png 595w, https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img03-300x198.png 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/figure>\n\n\n\n<p>develop\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u3001<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>\/* \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210 *\/\nCREATE DATABASE develop;\n\n\/* \u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210 *\/\nCREATE TABLE schema_info (\n    id integer,\n    name varchar(255)\n);\n\n\/* \u9069\u5f53\u306b\u30c7\u30fc\u30bf\u3092 insert *\/\nINSERT INTO schema_info values(2, &#39;PostgreSQL.develop&#39;);<\/code><\/pre><\/div>\n\n\n\n<p>\u4e00\u5ea6\u63a5\u7d9a\u3092\u9589\u3058\u3066DB\u306e\u5185\u5bb9\u3092\u78ba\u8a8d\u3057\u3066\u307f\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/image1.jpg\" alt=\"\" class=\"wp-image-221\" width=\"545\" height=\"532\"\/><\/figure>\n\n\n\n<p>\u3044\u3064\u306e\u9593\u306b\u304b public \u304c\u3044\u305f\uff01 \u305d\u3057\u3066 develop \u304c\u3044\u306a\u3044\uff01\uff01<\/p>\n\n\n\n<p>develop\u306b\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u306bDB\u8a2d\u5b9a\u3092\u4fee\u6b63\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308a\u76f4\u3059<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"595\" height=\"393\" src=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img0005.png\" alt=\"\" class=\"wp-image-222\" srcset=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img0005.png 595w, https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img0005-300x198.png 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"240\" height=\"295\" src=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img0006-1.png\" alt=\"\" class=\"wp-image-223\"\/><\/figure>\n\n\n\n<p>Database(local_postgres.develop) &gt; schema(public) &gt; Table(schema_info) \u306e\u69cb\u6210\u306a\u306e\u3067\u3001MySQL\u3068\u306f\u7570\u306a\u308a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30c6\u30fc\u30d6\u30eb\u306e\u9593\u306b\u30b9\u30ad\u30fc\u30de\u304c\u631f\u307e\u3063\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u305f\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30a8\u30d4\u30ed\u30fc\u30b0<\/h2>\n\n\n\n<p>\u79c1: BOSS!! \u30b9\u30ad\u30fc\u30de\u306e\u6982\u5ff5\u306b\u3064\u3044\u3066\u79c1\u304c\u9593\u9055\u3063\u3066\u304a\u308a\u307e\u3057\u305f\uff01\u63a5\u7d9a\u624b\u9806\u66f8\u3082\u3064\u3051\u308b\u306e\u3067\u8a31\u3057\u3066\u304f\u3060\u3055\u3044\uff01<\/p>\n\n\n\n<p>BOSS: \u3046\u3080\uff01\uff01 \u624b\u9806\u66f8\u3042\u308a\u304c\u3068\u3046\uff01\u52a9\u304b\u308a\u307e\u3059\uff01<\/p>\n\n\n\n<p>\u307f\u3093\u306a\u958b\u767a\u306b\u7740\u624b\u3067\u304d\u307e\u3057\u305f\u3068\u3055\u3001\u3081\u3067\u305f\u3057\u3081\u3067\u305f\u3057\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u304a\u307e\u3051<\/h2>\n\n\n\n<p>PostgreSQL:12.3 \u306b A5M2:2.14.1 \u3067\u63a5\u7d9a\u3059\u308b\u3068<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"347\" height=\"147\" src=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img04.png\" alt=\"\" class=\"wp-image-224\" srcset=\"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img04.png 347w, https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/img04-300x127.png 300w\" sizes=\"(max-width: 347px) 100vw, 347px\" \/><\/figure>\n\n\n\n<p>\u304c\u51fa\u3066\u304f\u308b\u3002<\/p>\n\n\n\n<p>\u30dd\u30b9\u30b0\u30ec\u5185\u306e\u69cb\u6210\u304c\u5909\u308f\u3063\u305f\u3053\u3068\u304c\u539f\u56e0\u307f\u305f\u3044\u3002<br><a href=\"https:\/\/a5m2.mmatsubara.com\/wp\/?topic=%e3%80%90%e4%b8%8d%e5%85%b7%e5%90%88%e5%a0%b1%e5%91%8a%e3%80%91%e6%8e%a5%e7%b6%9a%e3%82%a8%e3%83%a9%e3%83%bc\">\u30c8\u30d4\u30c3\u30af: \u3010\u4e0d\u5177\u5408\u5831\u544a\u3011\u63a5\u7d9a\u30a8\u30e9\u30fc |<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>public\u30b9\u30ad\u30fc\u30de\u3063\u3066\u306a\u3093\u3058\u3083\uff01\uff01\uff01 TL;DR\uff08\u8981\u7d04\u3059\u308b\u3068\u30fb\u30fb\u30fb\uff09 \u3053\u308c\u307e\u3067\u306e\u7d4c\u7def \u3068\u3042\u308b\u65e5\u306e\u663c\u4e0b\u304c\u308a BOSS: \u3061\u3087\u3063\u3068\u60aa\u3044\u3093\u3060\u3051\u3069\u3055\u3001\u691c\u8a3c\u7528\u306ePostgreSQL\u306bdevelop\u30b9\u30ad\u30fc\u30de\u8ffd\u52a0\u3057\u3066\u3082\u3089\u3048\u306a\u3044\u304b\u306a\uff1f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":979,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"swell_btn_cv_data":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[12,92],"class_list":["post-217","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-mysql","tag-postgresql"],"jetpack_featured_media_url":"https:\/\/www.miracleave.co.jp\/contents\/wp-content\/uploads\/2021\/10\/DB\u2192\u308f\u304b\u308b\u3002Table\u2192\u308f\u304b\u308b\u3002Schema\u2192\u304a\u524d\u306f\u4e00\u4f53\u306a\u3093\u306a\u3093\u3060\u30fb\u30fb\u30fb\uff01.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/posts\/217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/comments?post=217"}],"version-history":[{"count":6,"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/posts\/217\/revisions"}],"predecessor-version":[{"id":2395,"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/posts\/217\/revisions\/2395"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/media\/979"}],"wp:attachment":[{"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/media?parent=217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/categories?post=217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.miracleave.co.jp\/contents\/wp-json\/wp\/v2\/tags?post=217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}