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