$/*$The schema includes tables for users, user sessions, categories, cuisines, fooditems,

restaurants, menus, menuitems, shopping carts, cart items, shipping details, orders and orderitems.

The user table stores information about registered users like username, fullname, emailId, phoneNo and password.

The usersession table is used to manage user sessions and stores information like userId and sessionToken.

The category table stores information about categories like category name, description and image url.

The cuisine table stores information about cuisines like cuisine name, description and image url.

The restaurant table stores information about restaurants like restaurant name, address, contact and image url.

The fooditem table stores information about fooditems like fooditem name, description, categoryId, cuisineId, isVeg and image url.

The menu table stores information about food menu like restaurantId of the restaurant offering the particular menu.

The menuitem table stores information about fooditems for a menu like menuId, fooditemId and fooditemPrice for the particular fooditem.

The cart table stores information about shopping carts created by users like userId, restaurantId, orderTotalPrice.

The cart$\_$items table stores information about the fooditems added to each cart like cartId, fooditemId, fooditemPrice and UnitsInCart.

The shippingDetails table stores information about the shipping address, email, and phone number.

The order table stores information about each order, including the user who placed the order, the shipping details, the order total price, the restaurant from where the order fooditems are ordered and the order status.

Finally, the order$\_$items table stores information about the fooditems ordered in each order like orderId, fooditemId, fooditemPrice and UnitsPurchased.

Each table also includes some additional columns, such as createdTs and updatedTs, which are used to store timestamps of when each record was created and last updated.

Additionally, each table has an isActive column, which is used to mark records as inactive rather than deleting them outright.

This allows for data to be retained for future reference without cluttering the database with unnecessary data.$*/$

$/*$Create database command$*/$

CREATE DATABASE $`$food$\_$order$\_$app$`$;

$/*$Select the newly created database$*/$

USE $`$food$\_$order$\_$app$`$;

$/*$Create table command for user table$*/$

CREATE TABLE $`$user$`($

$`$id$`$ int NOT NULL,

$`$userName$`$ varchar$(50)$ NOT NULL,

$`$fullName$`$ varchar$(100)$ NOT NULL,

$`$emailId$`$ varchar$(100)$ NOT NULL,

$`$phoneNo$`$ int NOT NULL,

$`$password$`$ varchar$(50)$ NOT NULL,

$`$isActive$`$ int NOT NULL DEFAULT $\text{'}1\text{'},$

$`$createdTs$`$ datetime NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$updatedTs$`$ datetime NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

PRIMARY KEY $(`$id$`)$

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_0900\_$ai$\_$ci;

$/*$Create table command for usersession table$*/$

CREATE TABLE $`$usersession$`($

$`$id$`$ int NOT NULL,

$`$userId$`$ int NOT NULL,

$`$sessionToken$`$ varchar$(200)$ NOT NULL,

$`$isActive$`$ int NOT NULL DEFAULT $\text{'}1\text{'},$

$`$createdTs$`$ datetime NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$updatedTs$`$ datetime NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

PRIMARY KEY $(`$id$`)$

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_0900\_$ai$\_$ci;

$/*$Create table command for category table$*/$

CREATE TABLE $`$category$`($

$`$id$`$ int NOT NULL,

$`$name$`$ varchar$(45)$ NOT NULL,

$`$description$`$ varchar$(200)$ NOT NULL,

$`$image$`$ varchar$(200)$ NOT NULL,

$`$isActive$`$ int NOT NULL DEFAULT $\text{'}1\text{'},$

$`$createdTs$`$ datetime NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$updatedTs$`$ datetime NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

PRIMARY KEY $(`$id$`)$

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_0900\_$ai$\_$ci;

$/*$Q$.1.$ Create table command for cuisine table$*/$

$/*$Q$.2.$ Create table command for restaurant table$*/$

$/*$Q$.3.$ Create table command for fooditem table$*/$

$/*$Q$.4.$ Create table command for menu table$*/$

$/*$Q$.5.$ Create table command for menu$\_$items table$*/$

$/*$Q$.6.$ Create table command for cart table$*/$

$/*$Q$.7.$ Create table command for cart$\_$items table$*/$

$/*$Q$.8.$ Create table command for shippingDetails table$*/$

$/*$Q$.9.$ Create table command for order table$*/$

$/*$Q$.10.$ Create table command for order$\_$items table$*/$