test
Tables (5)
Customer (주문고객)
- cus_id (고객ID) — number(10) — Primary key — NOT NULL
- cus_addr (고객주소) — varchar2(100)
- cus_info (고객정보) — varchar2(20)
Menu (메뉴)
- menu_id (메뉴ID) — number(10) — Primary key
- menu_name (메뉴이름) — varchar2(20)
- menu_price (메뉴가격) — number(20)
- menu_img (메뉴이미지) — varchar2(20)
- menu_des (메뉴설명) — varchar2(100)
- res_id (가게ID) — number(10) — Foreign key → Restaurant.res_id — NOT NULL
Order (주문)
- order_id (주문ID) — number(10) — Primary key — NOT NULL
- order_time (주문시간) — date
- totalPrice (총가격) — number(20)
- takeout_delivery (배달유무) — boolean
- pay (결제여부) — boolean
- request (요청사항) — varchar2(100)
- res_id (가게ID) — number(10) — Foreign key → Restaurant.res_id — NOT NULL
- cus_id (고객ID) — number(10) — Foreign key → Customer.cus_id — NOT NULL
OrderDetail (주문상세)
- orderDetail_id (주문상세ID) — number(10) — Primary key — NOT NULL
- menu_id (메뉴ID) — number(10) — Foreign key → Menu.menu_id
- order_id (주문ID) — number(10) — Foreign key → Order.order_id — NOT NULL
- quantity (메뉴 갯수) — number(10)
- totalPrice (총가격) — number(20)
Restaurant (음식점)
- res_id (가게ID) — number(10) — Primary key — NOT NULL
- res_name (가게이름) — varchar2(50)
- res_addr (가게주소) — varchar2(100)
- res_tel (가게연락처) — varchar2(20)