{"id":14393,"date":"2025-08-27T09:01:16","date_gmt":"2025-08-27T00:01:16","guid":{"rendered":"https:\/\/blog.agentsoft.co.kr\/index.php\/2025\/08\/27\/14393\/"},"modified":"2025-08-27T09:01:16","modified_gmt":"2025-08-27T00:01:16","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%98%a8%eb%9d%bc%ec%9d%b8-%eb%b0%b0%eb%8b%ac-%ec%95%b1-%ea%b3%bc%ec%a0%9c-%ec%86%8c%ec%8a%a4%ec%bd%94%eb%93%9c-a","status":"publish","type":"post","link":"https:\/\/blog.agentsoft.co.kr\/index.php\/2025\/08\/27\/14393\/","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc628\ub77c\uc778 \ubc30\ub2ec \uc571 \uacfc\uc81c \uc18c\uc2a4\ucf54\ub4dc A+"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/image4.happycampus.com\/Production\/thumb212\/2024\/02\/13\/data29453459-0001.jpg\"><img decoding=\"async\" src=\"https:\/\/image4.happycampus.com\/Production\/thumb212\/2024\/02\/13\/data29453459-0002.jpg\"><\/p>\n<p><strong>\ubaa9\ucc28<\/strong><\/p>\n<p>\uc5c6\uc74c<\/p>\n<p><strong>\ubcf8\ubb38\ub0b4\uc6a9<\/strong><\/p>\n<p>CREATE TABLE Members (<br \/>\n    MemberID VARCHAR2(32) PRIMARY KEY,<br \/>\n    Password VARCHAR2(64) NOT NULL,<br \/>\n    PhoneNumber NUMBER(16) NOT NULL,<br \/>\n    MemberType VARCHAR2(8) CHECK (MemberType IN (&#8216;\uc77c\ubc18&#8217;, &#8216;\uc0ac\uc7a5&#8217;)) NOT NULL,<br \/>\n    Email VARCHAR2(128),<br \/>\n    AddressProvince VARCHAR2(32) NOT NULL,<br \/>\n    AddressCity VARCHAR2(32) NOT NULL,<br \/>\n    AddressDistrict VARCHAR2(32) NOT NULL,<br \/>\n    AddressDetail VARCHAR2(128) NOT NULL,<br \/>\n    CreationDate TIMESTAMP<br \/>\n);<\/p>\n<p>CREATE TABLE Store (<br \/>\n    StoreID NUMBER(9) PRIMARY KEY,<br \/>\n    StoreName VARCHAR2(32) NOT NULL,<br \/>\n    AddressProvince VARCHAR2(32) NOT NULL,<br \/>\n    AddressCity VARCHAR2(32) NOT NULL,<br \/>\n    AddressDistrict VARCHAR2(32) NOT NULL,<br \/>\n    AddressDetail VARCHAR2(128) NOT NULL,<br \/>\n    PhoneNumber NUMBER(16) NOT NULL,<br \/>\n    Introduction VARCHAR2(255),<br \/>\n    MinOrderCost NUMBER(8) NOT NULL,<br \/>\n    TotalReviewCount NUMBER(8) DEFAULT 0,<br \/>\n    TotalRating NUMBER(16) DEFAULT 0,<br \/>\n    AverageRating GENERATED ALWAYS AS (CASE WHEN TotalReviewCount > 0<\/p>\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/www.happycampus.com\/report-doc\/29453459\/\" target=\"_blank\">\ud574\ud53c\ucea0\ud37c\uc2a4<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ubaa9\ucc28 \uc5c6\uc74c \ubcf8\ubb38\ub0b4\uc6a9 CREATE TABLE Members ( MemberID VARCHAR2(32) PRIMARY KEY, Password VARCHAR2(64) NOT NULL, PhoneNumber NUMBER(16) NOT NULL, MemberType VARCHAR2(8) CHECK (MemberType IN (&#8216;\uc77c\ubc18&#8217;, &#8216;\uc0ac\uc7a5&#8217;)) NOT NULL, Email VARCHAR2(128), AddressProvince VARCHAR2(32) NOT NULL, AddressCity VARCHAR2(32) NOT NULL, AddressDistrict VARCHAR2(32) NOT NULL, AddressDetail VARCHAR2(128) NOT NULL, CreationDate TIMESTAMP ); CREATE TABLE Store ( StoreID NUMBER(9) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[8290,19486,19490,19488,19487,19491,19492,545,4209,19489],"class_list":["post-14393","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-3d","tag-db","tag-er-","tag-erd","tag-sql","tag-19491","tag-19492","tag-545","tag-4209","tag-19489"],"_links":{"self":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/14393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/comments?post=14393"}],"version-history":[{"count":0,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/14393\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/media?parent=14393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/categories?post=14393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/tags?post=14393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}