test
Tables (5)
Customer (고객정보)
- cus_id (주문회원id) — varchar2(30) — Primary key — NOT NULL
- cus_name (주문회원 주소) — varchar2(30)
- cus_tel (주문회원 전화번호) — number(20)
menu (메뉴)
- menuid (메뉴 id) — number(20) — Primary key — NOT NULL
- menu_name (음식이름) — varchar2(30)
- menu_price (음식가격) — number(20)
- res_id (음식점id) — number(20) — Foreign key → restaurant.res_id — NOT NULL
order (배송정보)
- oder_id (주문id) — number(20) — Primary key — NOT NULL
- res_id (음식점id) — number(20) — Foreign key → restaurant.res_id — NOT NULL
- cus_id (주문회원id) — varchar2(30) — Foreign key → Customer.cus_id — NOT NULL
- order_address (주문주소) — varchar2(30)
- order_wnat (주문요청사항) — varchar2(100)
- order_price (주문 총 결제 금액) — number(30)
- order_how (주문방식(포장/배달)) — varchar2(30)
- order_done (결제여부) — boolean
- order_time (주문시간) — varchar2(30)
order_detail (주문상세)
- detail_id (주문상세id) — number(20) — Primary key — NOT NULL
- oder_id (주문id) — number(20) — Foreign key → order.oder_id — NOT NULL
- menuid (메뉴 id) — number(20) — Foreign key → menu.menuid — NOT NULL
restaurant (음식점)
- res_id (음식점id) — number(20) — Primary key — NOT NULL
- res_name (음식점이름) — number(20)
- res_tel (전화번호) — varchar2(40)
- res_address (음식점주소) — varchar2(40)