test

Tables (4)

Customer (고객)

  • cus_id (고객ID) — Number — Primary key — NOT NULL
  • cus_address (고객주소) — Varchar2(10)
  • cus_name (고객이름) — Varchar2(5)

Food (음식점)

  • id (음식점ID) — Number — Primary key — NOT NULL
  • name (음식점이름) — Varchar2(10)
  • address (음식점주소) — Varchar2(10)
  • tel (음식점연락처) — Varchar2(10)
  • menu_id (메뉴ID) — Number — Foreign key → Menu.menu_id — NOT NULL
  • order_id (주문회원ID) — Number — Foreign key → Order.order_id — NOT NULL

Menu (메뉴)

  • menu_id (메뉴ID) — Number — Primary key — NOT NULL
  • munu_name (메뉴이름) — Varchar2(10)
  • menu_price (메뉴가격) — Number
  • menu_num (메뉴개수) — Number

Order (주문)

  • order_id (주문회원ID) — Number — Primary key — NOT NULL
  • time (주문시간) — date
  • total (총금액) — number(10)
  • method (주문방식) — boolean
  • address (주문주소) — Varchar2(20)
  • request (요청사항) — Varchar2(30)
  • price (결제여부) — boolean
  • cus_id (고객ID) — Number — Foreign key → Customer.cus_id — NOT NULL