Dataset: Zomato Database

About this Dataset

Zomato Database

The food delivery app database is a comprehensive collection of tables that store all the important information related to the food delivery app **(Credentials like users name, email, password, and sales(change it as your requirement) are generated other than everything is real ). It contains information about the orders placed by users, the food items available on the app, the menus of different restaurants, the restaurants themselves, and the users registered on the app. The tables are interrelated and store specific information, allowing for efficient data retrieval. The Orders table contains information about the orders, including the order date and time, sales quantity, sales amount, currency, user ID, and restaurant ID. The Food table stores information about the food items, including their ID, name, and vegetarian or non-vegetarian status. The Menu table contains information about the restaurant menus, including the menu ID, restaurant ID, food ID, cuisine, and price. The Restaurant table stores information about the restaurants, including the ID, name, location, rating, number of ratings, cost, cuisine, license number, website link, address, and menu. The Users table contains information about the app users, including their ID, name, email, password, age, gender, marital status, occupation, monthly income, educational qualifications, and family size. This database ensures seamless and efficient operations for the food delivery app.

Tables

Food

@kaggle.anas123siddiqui_zomato_database.food

7.99 MB
371561 rows
4 columns


CREATE TABLE food (
  "unnamed_0" BIGINT,
  "f_id" VARCHAR,
  "item" VARCHAR,
  "veg_or_non_veg" VARCHAR
);

@kaggle.anas123siddiqui_zomato_database.menu

17.98 MB
1179936 rows
6 columns


CREATE TABLE menu (
  "unnamed_0" BIGINT,
  "menu_id" VARCHAR,
  "r_id" BIGINT,
  "f_id" VARCHAR,
  "cuisine" VARCHAR,
  "price" VARCHAR
);

Orders

@kaggle.anas123siddiqui_zomato_database.orders

3 MB
150281 rows
7 columns


CREATE TABLE orders (
  "unnamed_0" BIGINT,
  "order_date" TIMESTAMP,
  "sales_qty" BIGINT,
  "sales_amount" BIGINT,
  "currency" VARCHAR,
  "user_id" BIGINT,
  "r_id" DOUBLE
);

Restaurant

@kaggle.anas123siddiqui_zomato_database.restaurant

17.48 MB
148541 rows
12 columns


CREATE TABLE restaurant (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "city" VARCHAR,
  "rating" VARCHAR,
  "rating_count" VARCHAR,
  "cost" VARCHAR,
  "cuisine" VARCHAR,
  "lic_no" VARCHAR,
  "link" VARCHAR,
  "address" VARCHAR,
  "menu" VARCHAR
);

Users

@kaggle.anas123siddiqui_zomato_database.users

4.39 MB
100000 rows
12 columns


CREATE TABLE users (
  "unnamed_0" BIGINT,
  "user_id" BIGINT,
  "name" VARCHAR,
  "email" VARCHAR,
  "password" VARCHAR,
  "age" BIGINT,
  "gender" VARCHAR,
  "marital_status" VARCHAR,
  "occupation" VARCHAR,
  "monthly_income" VARCHAR,
  "educational_qualifications" VARCHAR,
  "family_size" BIGINT
);