Home
tonercorner
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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