20250521-menudb-postgres
Tables (4)
category (Untitled2)
- category_code (Key) — int — Primary key — NOT NULL
- category_name (Field) — varchar — NOT NULL
- uppercategory_code (Key2) — int — Foreign key → category.category_code
menu (Untitled)
- menu_code (Key) — int — Primary key — NOT NULL
- Field — varchar(30) — NOT NULL
- menu_price (Field2) — int — NOT NULL
- category_code (Key2) — int — Foreign key → category.category_code — NOT NULL
- orderable_status (Field4) — char — NOT NULL
order (Untitled3)
- order_number (Key) — int — Primary key — NOT NULL
- order_date (Field) — varchar — NOT NULL
- order_time (Field2) — varchar — NOT NULL
- total_price (Field3) — int — NOT NULL
order_menu (Untitled4)
- menu_code (Key) — int — Foreign key → menu.menu_code — NOT NULL
- order_number (Key2) — int — Foreign key → order.order_number — NOT NULL
- order_count (Field) — int — NOT NULL