dream_pool - Laravel Schema Designer

admin_users

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)
email string (100)
email_verified_at datetime
password string (500)
image string (100)
role_id string (20)
is_active string (5)
remember_token string (250)

roles

id increments
timestamps timestamps
title string (100)
slug string (250)
is_active string (20)
description string (300)
softDeletes softDeletes
status integer

permissions

id increments
title string (250)
timestamps timestamps
slug string (250)
softDeletes softDeletes
status integer

role_permissions

id increments
timestamps timestamps
role_id string (10)
permission_id string (10)
softDeletes softDeletes

customers

id increments
timestamps timestamps
phone_number string (250)
name string (100)
email string (250)
email_verified_at datetime
otp string (10)
device_token string (500)
device_type string (10)
is_active string (10)
softDeletes softDeletes

slots

draw_id string (100)
id increments
product_id integer
slot_code string (10)
slot_count integer
slot_price double (10,2)
slot_start string (100)
slot_sold_out integer
last_sold_out_slot string (100)
status integer
softDeletes softDeletes
timestamps timestamps

products

id increments
timestamps timestamps
product_name string (150)
product_title string (150)
product_code string (50)
category_id integer
gst string (20)
product_description string (500)
product_price double (20,2)
stock integer
softDeletes softDeletes
status integer

categories

id increments
category_name string (250)
timestamps timestamps
softDeletes softDeletes
category_image string (100)
status string (10)

product_photos

id increments
timestamps timestamps
softDeletes softDeletes
image_name string (100)
product_id integer
status integer

online_partners

id increments
timestamps timestamps
online_partner_name string (200)
url string (500)
product_id integer
softDeletes softDeletes
status integer

orders

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
status integer
address_id integer
product_id integer
quantity integer
grand_total double (20,2)
unit_price double (20,2)
payment_id string (100)
delivery_charge float (8,2)

participations

id increments
softDeletes softDeletes
draw_id string (100)
purchased_slot_count integer
unit_slot_price double (20,2)
grand_slot_price double (20,2)
slot_start integer
user_id integer
product_id string
timestamps timestamps
address_id string
status integer

addresses

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
full_name string (100)
phone_number string (20)
alternate_number string (20)
house_no string (50)
state string (50)
road_name string (200)
city string (100)
pincode string (20)
status integer

quizes

id increments
timestamps timestamps
softDeletes softDeletes
question string (500)
correct_option string (100)
option2 string (100)
option3 string (100)
option4 string (100)
status integer
quiz_id string (20)

quiz_winners

id increments
timestamps timestamps
softDeletes softDeletes
quiz_id integer
played_user_id integer
status enum

draws

id increments
timestamps timestamps
softDeletes softDeletes
draw_id string (100)
won_user_id integer
product_id integer
won_slot_id string (50)
status integer

banners

id increments
timestamps timestamps
softDeletes softDeletes
banner_image string (100)
heading string (150)
description string (250)
status string (10)

wallets

id increments
timestamps timestamps
softDeletes softDeletes
customer_id integer
wallet_amount double (20,2)
wallet_reward integer
wallet_status string

wallet_credits

id increments
wallet_id integer
customer_id integer
wallet_credit_amount double (20,2)
wallet_credit_type string (100)
wallet_credit_by_id integer
wallet_credit_status integer
wallet_credit_description string
softDeletes softDeletes
timestamps timestamps

wallet_debits

id increments
wallet_id integer
customer_id integer
wallet_debit_amount double (20,2)
wallet_debit_type string (100)
wallet_debit_status string
wallet_debit_description string (200)
wallet_debit_for integer
softDeletes softDeletes
timestamps timestamps

sliders

id increments
timestamps timestamps
softDeletes softDeletes
type string (20)
slider_image string (100)
product_id integer
draw_id string
external_link string

quiz_datas

id increments
timestamps timestamps
softDeletes softDeletes
quiz_id string (30)
status integer

like_products

id increments
softDeletes softDeletes
timestamps timestamps
product_id integer
user_id integer
like_status integer
status integer

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