FOOD DELIVERY_add

Tables (4)

main_member (member_table1)

  • Key — Primary key — NOT NULL
  • main_password (varchar(55)) — unique
  • main_name (varchar(45)) — unique
  • main_address (varchar(70)) — unique
  • main_ID(identity) (varchar(50)) — unique — NOT NULL

menu_order_summary (menu_order_table3)

  • order_turn_number (varchar(30)) — unique — Primary key — NOT NULL
  • product_item_new (varchar(20)) — unique — Foreign key → product_Items.product_item_new — NOT NULL
  • order_item_menu (varchar(15))
  • order_item_menu_counting (integer(100))
  • order_process_step (enum(done, cancel)) — order_done

payment (pay_method_table4)

  • pay_credit card (Key) — Primary key — NOT NULL
  • pay_check money (Field)
  • pay_check acount (Field2)
  • product_item_new (varchar(20)) — unique — Foreign key → product_Items.product_item_new — NOT NULL
  • order_turn_number (varchar(30)) — unique — Foreign key → menu_order_summary.order_turn_number — NOT NULL
  • product_item_new (varchar(20)2) — unique — Foreign key → menu_order_summary.product_item_new — NOT NULL

product_Items (item_table2)

  • product_item_new (varchar(20)) — unique — Primary key — NOT NULL
  • product_item_name (varchar(15)) — unique
  • producy_item_category (varchar) — unique