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