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)