{"id":186,"date":"2025-04-09T12:12:09","date_gmt":"2025-04-09T03:12:09","guid":{"rendered":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/?p=186"},"modified":"2025-04-20T00:34:07","modified_gmt":"2025-04-19T15:34:07","slug":"4%ec%a3%bc%ec%b0%a8-%ec%a3%bc%ea%b0%84%eb%b3%b4%ea%b3%a0%ec%84%9c","status":"publish","type":"post","link":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/2025\/04\/09\/4%ec%a3%bc%ec%b0%a8-%ec%a3%bc%ea%b0%84%eb%b3%b4%ea%b3%a0%ec%84%9c\/","title":{"rendered":"4\uc8fc\ucc28 \uc8fc\uac04\ubcf4\uace0\uc11c"},"content":{"rendered":"\n

\uc784\uc2dc \uad6c\ud604, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4, \ucd94\uac00 \ub514\uc790\uc778<\/h2>\n\n\n\n
\n\n\n\n

\uba54\uc778\ud654\uba74<\/h2>\n\n\n\n

https:\/\/infognu.ansan.ac.kr\/~i2151040\/Capstone\/main.html<\/a><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n\n\n\n

\uac00\uac8c \ud654\uba74<\/h2>\n\n\n\n

https:\/\/infognu.ansan.ac.kr\/~i2151040\/Capstone\/pages\/menulist.html<\/a><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


<\/h2>\n\n\n\n\n\n\n\n

\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc124\uacc4<\/h2>\n\n\n\n
<\/div>\n\n\n\n

\uc640\uc774\uc5b4 \ud504\ub808\uc784\uc744 \ubcf4\uace0 \ud575\uc2ec \uae30\ub2a5 \ud0a4\uc6cc\ub4dc\ub97c \ubf51\uc544\ub0b8 \ub4a4, \uadf8\uac78 \ud14c\uc774\ube14\ub85c \uc62e\uacbc\uc2b5\ub2c8\ub2e4<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n\n\n\n
<\/div>\n\n\n\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984<\/h1>\n\n\n\n

db2151040_capstone<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n\n\n\n
<\/div>\n\n\n\n

\ud14c\uc774\ube14 \uc694\uc57d<\/h1>\n\n\n\n
<\/div>\n\n\n\n

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>\n\n\n\n

1. Users (\uc720\uc800 \uc815\ubcf4)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
user_id<\/td>INT (PK, AUTO)<\/td>\uc720\uc800 \uace0\uc720 ID<\/td><\/tr>
student_id<\/td>VARCHAR(20)<\/td>\ud559\ubc88(\uad00\ub9ac\uc790 \uacc4\uc815\uc740 \uae30\ubcf8\uac12 NULL)<\/td><\/tr>
username<\/td>VARCHAR(50)<\/td>\uc774\ub984<\/td><\/tr>
email<\/td>VARCHAR(100)<\/td>\uc774\uba54\uc77c (\uace0\uc720)<\/td><\/tr>
is_admin<\/td>BOOLEAN<\/td>\uad00\ub9ac\uc790 \uc5ec\ubd80<\/td><\/tr>
created_at<\/td>DATETIME<\/td>\uac00\uc785\uc77c\uc2dc<\/td><\/tr>
password<\/td>VARCHAR(255)<\/td>\ube44\ubc00\ubc88\ud638<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

2. Foods (\uc74c\uc2dd \uc815\ubcf4)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
food_id<\/td>INT (PK, AUTO)<\/td>\uc74c\uc2dd ID<\/td><\/tr>
restaurant_id<\/td>INT (FK)<\/td>\uc81c\uacf5 \uc2dd\ub2f9 ID<\/td><\/tr>
name<\/td>VARCHAR(100)<\/td>\uc74c\uc2dd \uc774\ub984<\/td><\/tr>
description<\/td>TEXT<\/td>\uc124\uba85<\/td><\/tr>
price<\/td>INT<\/td>\uac00\uaca9<\/td><\/tr>
discount_rate<\/td>FLOAT<\/td>\ud560\uc778\uc728 (%)<\/td><\/tr>
image_url<\/td>VARCHAR(255)<\/td>\uc74c\uc2dd \uc0ac\uc9c4 URL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

3. Restaurants (\uc2dd\ub2f9 \uc815\ubcf4)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
restaurant_id<\/td>INT (PK, AUTO)<\/td>\uc2dd\ub2f9 ID<\/td><\/tr>
name<\/td>VARCHAR(100)<\/td>\uc2dd\ub2f9 \uc774\ub984<\/td><\/tr>
location<\/td>VARCHAR(255)<\/td>\uc704\uce58<\/td><\/tr>
phone<\/td>VARCHAR(20)<\/td>\uc804\ud654\ubc88\ud638<\/td><\/tr>
opening_hours<\/td>VARCHAR(100)<\/td>\uc601\uc5c5 \uc2dc\uac04<\/td><\/tr>
image_url<\/td>VARCHAR(255)<\/td>\uc2dd\ub2f9 \uc774\ubbf8\uc9c0 URL<\/td><\/tr>
featured_food_id<\/td>INT (FK)<\/td>\ucd94\ucc9c \uc74c\uc2dd (food_id)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

4. Reservations (\uc608\uc57d \uc815\ubcf4)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
reservation_id<\/td>INT (PK, AUTO)<\/td>\uc608\uc57d ID<\/td><\/tr>
user_id<\/td>INT (FK)<\/td>\uc608\uc57d\uc790 ID<\/td><\/tr>
reservation_time<\/td>DATETIME<\/td>\uc608\uc57d \uc77c\uc2dc<\/td><\/tr>
food_id<\/td>INT (FK)<\/td>\uc608\uc57d \uc74c\uc2dd ID<\/td><\/tr>
status<\/td>ENUM<\/td>\uc608\uc57d \uc0c1\ud0dc<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

5. Reviews (\ub9ac\ubdf0)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
review_id<\/td>INT (PK, AUTO)<\/td>\ub9ac\ubdf0 ID<\/td><\/tr>
user_id<\/td>INT (FK)<\/td>\uc791\uc131\uc790 ID<\/td><\/tr>
restaurant_id<\/td>INT (FK)<\/td>\uc2dd\ub2f9 ID<\/td><\/tr>
rating<\/td>INT<\/td>\ud3c9\uc810 (1~5)<\/td><\/tr>
comment<\/td>TEXT<\/td>\ub0b4\uc6a9<\/td><\/tr>
photo_url<\/td>VARCHAR(255)<\/td>\ub9ac\ubdf0 \uc774\ubbf8\uc9c0<\/td><\/tr>
created_at<\/td>DATETIME<\/td>\uc791\uc131 \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

6. Cart (\uc7a5\ubc14\uad6c\ub2c8)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
cart_id<\/td>INT (PK, AUTO)<\/td>\uc7a5\ubc14\uad6c\ub2c8 \ud56d\ubaa9 ID<\/td><\/tr>
user_id<\/td>INT (FK)<\/td>\uc720\uc800 ID<\/td><\/tr>
food_id<\/td>INT (FK)<\/td>\uc74c\uc2dd ID<\/td><\/tr>
quantity<\/td>INT<\/td>\uc218\ub7c9<\/td><\/tr>
added_at<\/td>DATETIME<\/td>\ub2f4\uc740 \uc2dc\uac04<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

7. Orders (\uc8fc\ubb38 \ubaa9\ub85d) – \uc8fc\ubb38\uc758 \uac2f\uc218<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
order_id<\/td>INT (PK, AUTO)<\/td>\uc8fc\ubb38 ID<\/td><\/tr>
user_id<\/td>INT (FK)<\/td>\uc720\uc800 ID<\/td><\/tr>
total_price<\/td>INT<\/td>\ucd1d \uae08\uc561<\/td><\/tr>
order_time<\/td>DATETIME<\/td>\uc8fc\ubb38 \uc2dc\uac01<\/td><\/tr>
status<\/td>ENUM<\/td>\uc0c1\ud0dc (\uc9c4\ud589\uc911, \uc644\ub8cc \ub4f1)<\/td><\/tr>
special_request<\/td>TEXT<\/td>\uc694\uccad \uc0ac\ud56d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

8. OrderItems (\uc8fc\ubb38 \uc0c1\uc138) – \uc8fc\ubb38\uc758 \uc74c\uc2dd \uc218\ub7c9 \ubc0f \uac01\uac01\uc758 \uac00\uaca9<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
order_item_id<\/td>INT (PK, AUTO)<\/td>\ud56d\ubaa9 ID<\/td><\/tr>
order_id<\/td>INT (FK)<\/td>\uc8fc\ubb38 ID<\/td><\/tr>
food_id<\/td>INT (FK)<\/td>\uc74c\uc2dd ID<\/td><\/tr>
quantity<\/td>INT<\/td>\uc218\ub7c9<\/td><\/tr>
price<\/td>INT<\/td>\uac00\uaca9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

9. Coupons (\ucfe0\ud3f0 \ubaa9\ub85d) – \ud55c \uc74c\uc2dd\ub9cc \uc801\uc6a9\ub418\uac8c? >>> \uace0\ubbfc\uc911<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
coupon_id<\/td>INT (PK, AUTO)<\/td>\ucfe0\ud3f0 ID<\/td><\/tr>
code<\/td>VARCHAR(50) UNIQUE<\/td>\ucfe0\ud3f0 \ucf54\ub4dc<\/td><\/tr>
discount_percent<\/td>FLOAT<\/td>\ud560\uc778\uc728 (%)<\/td><\/tr>
valid_until<\/td>DATE<\/td>\uc720\ud6a8\uae30\uac04<\/td><\/tr>
min_order_amount<\/td>INT<\/td>\ucd5c\uc18c \uc8fc\ubb38 \uae08\uc561<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

10. UserCoupons (\uc720\uc800\uc758 \ucfe0\ud3f0 \ubaa9\ub85d)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
user_coupon_id<\/td>INT (PK, AUTO)<\/td>ID<\/td><\/tr>
user_id<\/td>INT (FK)<\/td>\uc720\uc800 ID<\/td><\/tr>
coupon_id<\/td>INT (FK)<\/td>\ucfe0\ud3f0 ID<\/td><\/tr>
used<\/td>BOOLEAN<\/td>\uc0ac\uc6a9 \uc5ec\ubd80<\/td><\/tr>
assigned_at<\/td>DATETIME<\/td>\ubc1c\uae09 \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

11. Payments (\uacb0\uc81c \uc815\ubcf4)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
payment_id<\/td>INT (PK, AUTO)<\/td>\uacb0\uc81c ID<\/td><\/tr>
user_id<\/td>INT (FK)<\/td>\uc720\uc800 ID<\/td><\/tr>
order_id<\/td>INT (FK)<\/td>\uc8fc\ubb38 ID<\/td><\/tr>
payment_method<\/td>ENUM<\/td>\uacb0\uc81c \ubc29\uc2dd<\/td><\/tr>
amount_paid<\/td>INT<\/td>\uacb0\uc81c \uae08\uc561<\/td><\/tr>
discount_applied<\/td>INT<\/td>\ud560\uc778 \uae08\uc561<\/td><\/tr>
payment_time<\/td>DATETIME<\/td>\uacb0\uc81c \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

12. SalesSummary (\ub9e4\ucd9c)<\/h3>\n\n\n\n
\uceec\ub7fc\uba85<\/th>\uc790\ub8cc\ud615<\/th>\uc124\uba85<\/th><\/tr><\/thead>
summary_id<\/td>INT (PK, AUTO)<\/td>\ub9e4\ucd9c ID<\/td><\/tr>
restaurant_id<\/td>INT (FK)<\/td>\uc2dd\ub2f9 ID<\/td><\/tr>
date<\/td>DATE<\/td>\ub0a0\uc9dc<\/td><\/tr>
total_sales<\/td>INT<\/td>\ucd1d \ub9e4\ucd9c\uc561<\/td><\/tr>
total_orders<\/td>INT<\/td>\uc8fc\ubb38 \uac74\uc218<\/td><\/tr>
total_foods_sold<\/td>INT<\/td>\uc74c\uc2dd \ucd1d \uc218\ub7c9<\/td><\/tr>
last_updated<\/td>DATETIME<\/td>\uac31\uc2e0 \uc2dc\uac01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n\n\n\n\n

\ucd94\uac00 \ub514\uc790\uc778 (\uc9c4\ud589 \uc911)<\/h2>\n\n\n\n
<\/div>\n\n\n\n
\n\n\n\n
<\/div>\n\n\n\n

\ucc1c\ud55c \uac00\uac8c<\/h2>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n\n\n\n
<\/div>\n\n\n\n

\uc8fc\ubb38\ub0b4\uc5ed<\/h2>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n\n\n\n
<\/div>\n\n\n\n

\uc7a5\ubc14\uad6c\ub2c8<\/h2>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n\n\n\n
<\/div>\n\n\n\n

\ub9ac\ubdf0<\/h2>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n\n\n\n
<\/div>\n\n\n\n

\ub9ac\ubdf0\uc791\uc131<\/h2>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n\n\n\n\n

\ub2e4\uc74c \uc8fc \uc9c4\ud589 \uc0ac\ud56d<\/h2>\n\n\n\n
<\/div>\n\n\n\n

\uc774\ubc88\uc8fc\uc640 \ub3d9\uc77c\ud558\uac8c \ud654\uba74 HTML\ub85c \uc784\uc2dc \uad6c\ud604 \ubc0f \ucd94\uac00 \ub514\uc790\uc778 \uc608\uc815\uc785\ub2c8\ub2e4<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc784\uc2dc \uad6c\ud604, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4, \ucd94\uac00 \ub514\uc790\uc778 \uba54\uc778\ud654\uba74 https:\/\/infognu.ansan.ac.kr\/~i2151040\/Capstone\/main.html \uac00\uac8c \ud654\uba74 https:\/\/infognu.ansan.ac.kr\/~i2151040\/Capstone\/pages\/menulist.html<\/p>\n<\/div>","protected":false},"author":53,"featured_media":201,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[2],"tags":[],"class_list":["post-186","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-2"],"jetpack_featured_media_url":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-content\/uploads\/sites\/53\/2025\/04\/\uc6f9\uc0ac\uc774\ud2b8.jpg","_links":{"self":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/posts\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/comments?post=186"}],"version-history":[{"count":0,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/media\/201"}],"wp:attachment":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151040\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}