tonercorner - Laravel Schema Designer

users

id increments
first_name string (255)
last_name string (255)
email string (255)
phone_number bigInteger
gender enum
profile_pic string (255)
dob date
device_token string (255)
device_id string (255)
os_type string (20)
verification_code string (10)
is_email_verified boolean
is_phone_verified boolean
timestamps timestamps
softDeletes softDeletes

user_addresses

id increments
user_id ^FK integer
address_l1 string (255)
address_l2 string (255)
country integer
state string (255)
city string (255)
pincode integer
is_primary boolean
timestamps timestamps
softDeletes softDeletes

user_social_logins

id increments
user_id ^FK integer
social_type string (20)
timestamps timestamps

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description text
image string (255)

products

id increments
name string (255)
sku string (255)
short_description string (255)
long_description text
price float
ratings float
rating_count integer
stock integer
status enum
timestamps timestamps
softDeletes softDeletes

product_categories

id increments
category_id ^FK integer
product_id ^FK integer

product_ratings

id increments
product_id ^FK integer
rating float
title string (255)
comment text
timestamps timestamps

product_images

id increments
timestamps timestamps
image string (255)
product_id ^FK integer

promocodes

id increments
discount_code string (20)
discount_percentage string (10)
description text
max_discount string (20)
min_discount string
min_order_amount integer
total_users integer
start_date date
expire_date date
is_valid boolean
timestamps timestamps
softDeletes softDeletes

orders

id increments
user_id ^FK integer
discount_id integer
order_unique_code string (20)
pre_order_amount double
tax_amount double
discount_amount float
total_amount double
address_id ^FK integer
date datetime
status enum
timestamps timestamps
softDeletes softDeletes

order_items

id increments
order_id ^FK integer
product_id ^FK integer
price double
quantity integer

payments

id increments
order_id ^FK integer
transaction_id string (255)
type string (20)
amount double
date date
status string (20)
timestamps timestamps
softDeletes softDeletes

cart

id increments
user_id ^FK integer
timestamps timestamps

cart_items

id increments
cart_id ^FK integer
product_id ^FK integer
quantity integer
amount double

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01