{"published":"2015-07-06 21:49:26","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmat5ukawa.hateblo.jp%2Fentry%2F2015%2F07%2F06%2F214926\" title=\"CHECK \u5236\u7d04 \u3068 ALTER TABLE tablename ADD CONSTRAINT - \u73fe\u5834\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"\u73fe\u5834\u30ed\u30b0","author_url":"https://blog.hatena.ne.jp/mat5ukawa/","author_name":"mat5ukawa","type":"rich","categories":["DB","PostgreSQL"],"version":"1.0","image_url":null,"provider_name":"Hatena Blog","title":"CHECK \u5236\u7d04 \u3068 ALTER TABLE tablename ADD CONSTRAINT","provider_url":"https://hatena.blog","description":"ALTER TABLE tablename ADD CONSTRAINT \u3092 \u65b0\u898f\u30c6\u30fc\u30d6\u30eb\u3078\u5b9f\u884c ALTER TABLE \u53ef\u80fd CREATE TABLE projects ( projectname text NOT NULL, membernum integer NOT NULL ); ALTER TABLE projects ADD CONSTRAINT projects_membernum_check CHECK(membernum BETWEEN 1 AND 100); => ALTER TABLE CONSTRAINT \u5236\u7d04\u5185\u306e\u96c6\u5408\u3092 INSERT \u3057\u305f\u30c6\u30fc\u30d6\u30eb\u3078\u5b9f\u884c ALTER T\u2026","width":"100%","height":"190","blog_url":"https://mat5ukawa.hateblo.jp/","url":"https://mat5ukawa.hateblo.jp/entry/2015/07/06/214926"}