test
Tables (5)
menu
- menu_id — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(30) — NOT NULL
- price — INTEGER — NOT NULL
- category — VARCHAR(20) — NOT NULL
- menu_desc — VARCHAR2(100) — NOT NULL
- menu_path — VARCHAR(500) — NOT NULL
order_detail
- detail_id — NUMBER — Primary key — NOT NULL
- menu_menu_id — INTEGER — Foreign key → menu.menu_id — NOT NULL
- user_order_order_id — INTEGER — Foreign key → user_order.order_id — NOT NULL
- quantity — INTEGER — NOT NULL
review
- review_id — NUMBER — Primary key — NOT NULL
- title — VARCHAR2(50) — NOT NULL
- content — VARCHAR2(500) — NOT NULL
- rating — INTEGER — NOT NULL
- review_date — DATE — NOT NULL
- menu_menu_id — INTEGER — Foreign key → menu.menu_id — NOT NULL
- order_detail_detail_id — INTEGER — Foreign key → order_detail.detail_id — NOT NULL
user_info
- user_id — NUMBER — Primary key — NOT NULL
- phonenum — INTEGER — NOT NULL
- join_date — DATE — NOT NULL
- point — INTEGER — NOT NULL
- status — INTEGER — NOT NULL
user_order
- order_id — NUMBER — Primary key — NOT NULL
- order_date — DATE — NOT NULL
- menu_menu_id — INTEGER — NOT NULL
- user_id — INTEGER — Foreign key → user_info.user_id — NOT NULL