{"id":78,"date":"2025-03-20T11:07:02","date_gmt":"2025-03-20T02:07:02","guid":{"rendered":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/?page_id=78"},"modified":"2025-05-13T12:45:25","modified_gmt":"2025-05-13T03:45:25","slug":"%ea%b0%9c%eb%b0%9c%ed%99%98%ea%b2%bd","status":"publish","type":"page","link":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/%ea%b0%9c%eb%b0%9c%ed%99%98%ea%b2%bd\/","title":{"rendered":"\uac1c\ubc1c\ud658\uacbd"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>\ub514\uc790\uc778<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.figma.com\/ko-kr\/\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"117\" height=\"104\" src=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/03\/\ub514\uc790\uc778-1-edited.png\" alt=\"\" class=\"wp-image-138\" \/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud504\ub808\uc784\uc6cc\ud06c<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ko.legacy.reactjs.org\/\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"467\" height=\"104\" src=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/04\/react-1-edited.png\" alt=\"\" class=\"wp-image-182\" srcset=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/04\/react-1-edited.png 467w, https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/04\/react-1-edited-300x67.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/nodejs.org\/ko\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"467\" height=\"104\" src=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/04\/nodejs-1-edited.png\" alt=\"\" class=\"wp-image-183\" srcset=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/04\/nodejs-1-edited.png 467w, https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/04\/nodejs-1-edited-300x67.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/dev.mysql.com\/downloads\/workbench\/\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"121\" height=\"105\" src=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/03\/\ub370\uc774\ud130\ubca0\uc774\uc2a4-edited.png\" alt=\"\" class=\"wp-image-140\" \/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ubc84\uc804\uad00\ub9ac<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/github.com\/\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"119\" height=\"103\" src=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/03\/\ubc84\uc804\uad00\ub9ac-edited.png\" alt=\"\" class=\"wp-image-142\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/msdio.github.io\/stackticon\/#\">https:\/\/msdio.github.io\/stackticon\/#<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/infognu.ansan.ac.kr\/~i2151040\/show.php\">https:\/\/infognu.ansan.ac.kr\/~i2151040\/show.php<\/a><\/p>\n\n\n\n<p><strong>DB\ub0b4 \ub370\uc774\ud130<\/strong> \ud655\uc778 \ub9c1\ud06c<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc124\uacc4<\/h2>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:11px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading has-medium-font-size\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984<\/h1>\n\n\n\n<p>db2151040_capstone<\/p>\n\n\n\n<div style=\"height:11px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:11px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading has-medium-font-size\">\ud14c\uc774\ube14 \uc694\uc57d<\/h1>\n\n\n\n<div style=\"height:11px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>pk\ub294 \uae30\ubcf8 \ud0a4, fk\ub294 \uc678\ub798\ud0a4\ub97c \uc758\ubbf8\ud558\uba70 auto\ub294 \uc790\ub3d9 \ud0a4 \uc99d\uac00<\/p>\n\n\n\n<div style=\"height:11px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">1. Users (\uc720\uc800 \uc815\ubcf4)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>user_id<\/td><td>INT (PK, AUTO)<\/td><td>\uc720\uc800 \uace0\uc720 ID<\/td><\/tr><tr><td>student_id<\/td><td>VARCHAR(20)<\/td><td>\ud559\ubc88(\uad00\ub9ac\uc790 \uacc4\uc815\uc740 \uae30\ubcf8\uac12 NULL)<\/td><\/tr><tr><td>username<\/td><td>VARCHAR(50)<\/td><td>\uc774\ub984<\/td><\/tr><tr><td>email<\/td><td>VARCHAR(100)<\/td><td>\uc774\uba54\uc77c (\uace0\uc720)<\/td><\/tr><tr><td>is_admin<\/td><td>BOOLEAN<\/td><td>\uad00\ub9ac\uc790 \uc5ec\ubd80<\/td><\/tr><tr><td>created_at<\/td><td>DATETIME<\/td><td>\uac00\uc785\uc77c\uc2dc<\/td><\/tr><tr><td>password<\/td><td>VARCHAR(255)<\/td><td>\ube44\ubc00\ubc88\ud638<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2. Foods (\uc74c\uc2dd \uc815\ubcf4)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>food_id<\/td><td>INT (PK, AUTO)<\/td><td>\uc74c\uc2dd ID<\/td><\/tr><tr><td>restaurant_id<\/td><td>INT (FK)<\/td><td>\uc81c\uacf5 \uc2dd\ub2f9 ID<\/td><\/tr><tr><td>name<\/td><td>VARCHAR(100)<\/td><td>\uc74c\uc2dd \uc774\ub984<\/td><\/tr><tr><td>description<\/td><td>TEXT<\/td><td>\uc124\uba85<\/td><\/tr><tr><td>price<\/td><td>INT<\/td><td>\uac00\uaca9<\/td><\/tr><tr><td>discount_rate<\/td><td>FLOAT<\/td><td>\ud560\uc778\uc728 (%)<\/td><\/tr><tr><td>image_url<\/td><td>VARCHAR(255)<\/td><td>\uc74c\uc2dd \uc0ac\uc9c4 URL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3. Restaurants (\uc2dd\ub2f9 \uc815\ubcf4)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>restaurant_id<\/td><td>INT (PK, AUTO)<\/td><td>\uc2dd\ub2f9 ID<\/td><\/tr><tr><td>name<\/td><td>VARCHAR(100)<\/td><td>\uc2dd\ub2f9 \uc774\ub984<\/td><\/tr><tr><td>location<\/td><td>VARCHAR(255)<\/td><td>\uc704\uce58<\/td><\/tr><tr><td>phone<\/td><td>VARCHAR(20)<\/td><td>\uc804\ud654\ubc88\ud638<\/td><\/tr><tr><td>opening_hours<\/td><td>VARCHAR(100)<\/td><td>\uc601\uc5c5 \uc2dc\uac04<\/td><\/tr><tr><td>image_url<\/td><td>VARCHAR(255)<\/td><td>\uc2dd\ub2f9 \uc774\ubbf8\uc9c0 URL<\/td><\/tr><tr><td>featured_food_id<\/td><td>INT (FK)<\/td><td>\ucd94\ucc9c \uc74c\uc2dd (food_id)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">4. Reservations (\uc608\uc57d \uc815\ubcf4)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>reservation_id<\/td><td>INT (PK, AUTO)<\/td><td>\uc608\uc57d ID<\/td><\/tr><tr><td>user_id<\/td><td>INT (FK)<\/td><td>\uc608\uc57d\uc790 ID<\/td><\/tr><tr><td>reservation_time<\/td><td>DATETIME<\/td><td>\uc608\uc57d \uc77c\uc2dc<\/td><\/tr><tr><td>food_id<\/td><td>INT (FK)<\/td><td>\uc608\uc57d \uc74c\uc2dd ID<\/td><\/tr><tr><td>status<\/td><td>ENUM<\/td><td>\uc608\uc57d \uc0c1\ud0dc<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">5. Reviews (\ub9ac\ubdf0)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>review_id<\/td><td>INT (PK, AUTO)<\/td><td>\ub9ac\ubdf0 ID<\/td><\/tr><tr><td>user_id<\/td><td>INT (FK)<\/td><td>\uc791\uc131\uc790 ID<\/td><\/tr><tr><td>restaurant_id<\/td><td>INT (FK)<\/td><td>\uc2dd\ub2f9 ID<\/td><\/tr><tr><td>rating<\/td><td>INT<\/td><td>\ud3c9\uc810 (1~5)<\/td><\/tr><tr><td>comment<\/td><td>TEXT<\/td><td>\ub0b4\uc6a9<\/td><\/tr><tr><td>photo_url<\/td><td>VARCHAR(255)<\/td><td>\ub9ac\ubdf0 \uc774\ubbf8\uc9c0<\/td><\/tr><tr><td>created_at<\/td><td>DATETIME<\/td><td>\uc791\uc131 \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">6. Cart (\uc7a5\ubc14\uad6c\ub2c8)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>cart_id<\/td><td>INT (PK, AUTO)<\/td><td>\uc7a5\ubc14\uad6c\ub2c8 \ud56d\ubaa9 ID<\/td><\/tr><tr><td>user_id<\/td><td>INT (FK)<\/td><td>\uc720\uc800 ID<\/td><\/tr><tr><td>food_id<\/td><td>INT (FK)<\/td><td>\uc74c\uc2dd ID<\/td><\/tr><tr><td>quantity<\/td><td>INT<\/td><td>\uc218\ub7c9<\/td><\/tr><tr><td>added_at<\/td><td>DATETIME<\/td><td>\ub2f4\uc740 \uc2dc\uac04<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">7. Orders (\uc8fc\ubb38 \ubaa9\ub85d) &#8211; \uc8fc\ubb38\uc758 \uac2f\uc218<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>order_id<\/td><td>INT (PK, AUTO)<\/td><td>\uc8fc\ubb38 ID<\/td><\/tr><tr><td>user_id<\/td><td>INT (FK)<\/td><td>\uc720\uc800 ID<\/td><\/tr><tr><td>total_price<\/td><td>INT<\/td><td>\ucd1d \uae08\uc561<\/td><\/tr><tr><td>order_time<\/td><td>DATETIME<\/td><td>\uc8fc\ubb38 \uc2dc\uac01<\/td><\/tr><tr><td>status<\/td><td>ENUM<\/td><td>\uc0c1\ud0dc (\uc9c4\ud589\uc911, \uc644\ub8cc \ub4f1)<\/td><\/tr><tr><td>special_request<\/td><td>TEXT<\/td><td>\uc694\uccad \uc0ac\ud56d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">8. OrderItems (\uc8fc\ubb38 \uc0c1\uc138) &#8211; \uc8fc\ubb38\uc758 \uc74c\uc2dd \uc218\ub7c9 \ubc0f \uac01\uac01\uc758 \uac00\uaca9<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>order_item_id<\/td><td>INT (PK, AUTO)<\/td><td>\ud56d\ubaa9 ID<\/td><\/tr><tr><td>order_id<\/td><td>INT (FK)<\/td><td>\uc8fc\ubb38 ID<\/td><\/tr><tr><td>food_id<\/td><td>INT (FK)<\/td><td>\uc74c\uc2dd ID<\/td><\/tr><tr><td>quantity<\/td><td>INT<\/td><td>\uc218\ub7c9<\/td><\/tr><tr><td>price<\/td><td>INT<\/td><td>\uac00\uaca9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">9. Coupons (\ucfe0\ud3f0 \ubaa9\ub85d) &#8211; \ud55c \uc74c\uc2dd\ub9cc \uc801\uc6a9\ub418\uac8c? &gt;&gt;&gt; \uace0\ubbfc\uc911<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>coupon_id<\/td><td>INT (PK, AUTO)<\/td><td>\ucfe0\ud3f0 ID<\/td><\/tr><tr><td>code<\/td><td>VARCHAR(50) UNIQUE<\/td><td>\ucfe0\ud3f0 \ucf54\ub4dc<\/td><\/tr><tr><td>discount_percent<\/td><td>FLOAT<\/td><td>\ud560\uc778\uc728 (%)<\/td><\/tr><tr><td>valid_until<\/td><td>DATE<\/td><td>\uc720\ud6a8\uae30\uac04<\/td><\/tr><tr><td>min_order_amount<\/td><td>INT<\/td><td>\ucd5c\uc18c \uc8fc\ubb38 \uae08\uc561<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">10. UserCoupons (\uc720\uc800\uc758 \ucfe0\ud3f0 \ubaa9\ub85d)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>user_coupon_id<\/td><td>INT (PK, AUTO)<\/td><td>ID<\/td><\/tr><tr><td>user_id<\/td><td>INT (FK)<\/td><td>\uc720\uc800 ID<\/td><\/tr><tr><td>coupon_id<\/td><td>INT (FK)<\/td><td>\ucfe0\ud3f0 ID<\/td><\/tr><tr><td>used<\/td><td>BOOLEAN<\/td><td>\uc0ac\uc6a9 \uc5ec\ubd80<\/td><\/tr><tr><td>assigned_at<\/td><td>DATETIME<\/td><td>\ubc1c\uae09 \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">11. Payments (\uacb0\uc81c \uc815\ubcf4)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>payment_id<\/td><td>INT (PK, AUTO)<\/td><td>\uacb0\uc81c ID<\/td><\/tr><tr><td>user_id<\/td><td>INT (FK)<\/td><td>\uc720\uc800 ID<\/td><\/tr><tr><td>order_id<\/td><td>INT (FK)<\/td><td>\uc8fc\ubb38 ID<\/td><\/tr><tr><td>payment_method<\/td><td>ENUM<\/td><td>\uacb0\uc81c \ubc29\uc2dd<\/td><\/tr><tr><td>amount_paid<\/td><td>INT<\/td><td>\uacb0\uc81c \uae08\uc561<\/td><\/tr><tr><td>discount_applied<\/td><td>INT<\/td><td>\ud560\uc778 \uae08\uc561<\/td><\/tr><tr><td>payment_time<\/td><td>DATETIME<\/td><td>\uacb0\uc81c \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">12. SalesSummary (\ub9e4\ucd9c)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>summary_id<\/td><td>INT (PK, AUTO)<\/td><td>\ub9e4\ucd9c ID<\/td><\/tr><tr><td>restaurant_id<\/td><td>INT (FK)<\/td><td>\uc2dd\ub2f9 ID<\/td><\/tr><tr><td>date<\/td><td>DATE<\/td><td>\ub0a0\uc9dc<\/td><\/tr><tr><td>total_sales<\/td><td>INT<\/td><td>\ucd1d \ub9e4\ucd9c\uc561<\/td><\/tr><tr><td>total_orders<\/td><td>INT<\/td><td>\uc8fc\ubb38 \uac74\uc218<\/td><\/tr><tr><td>total_foods_sold<\/td><td>INT<\/td><td>\uc74c\uc2dd \ucd1d \uc218\ub7c9<\/td><\/tr><tr><td>last_updated<\/td><td>DATETIME<\/td><td>\uac31\uc2e0 \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">13. user_favorites (\uc720\uc800 \ucc1c \uc815\ubcf4)<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uceec\ub7fc\uba85<\/th><th>\uc790\ub8cc\ud615<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>user_id<\/td><td>INT (11)<\/td><td>\uc720\uc800 ID<\/td><\/tr><tr><td>restaurant_id<\/td><td>INT (11)<\/td><td>\uc2dd\ub2f9 ID<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>https:\/\/msdio.github.io\/stackticon\/# https:\/\/infognu.ansan.ac.kr\/~i2151040\/show.php DB\ub0b4 \ub370\uc774\ud130 \ud655\uc778 \ub9c1\ud06c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc124\uacc4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984 db2151040_capstone \ud14c\uc774\ube14 \uc694\uc57d pk\ub294 \uae30\ubcf8 \ud0a4, fk\ub294 \uc678\ub798\ud0a4\ub97c \uc758\ubbf8\ud558\uba70 auto\ub294 \uc790\ub3d9 \ud0a4 \uc99d\uac00 1. <a class=\"mh-excerpt-more\" href=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/%ea%b0%9c%eb%b0%9c%ed%99%98%ea%b2%bd\/\" title=\"\uac1c\ubc1c\ud658\uacbd\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-78","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/pages\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/comments?post=78"}],"version-history":[{"count":0,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/pages\/78\/revisions"}],"wp:attachment":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/media?parent=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}