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)