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