business - Laravel Schema Designer

role

id bigIncrements
timestamps timestamps
libelle string (50)

sellers

id bigIncrements
timestamps timestamps
type string (30)
description text
nif string (200)
taxnumber string (150)
contact string (50)
activity_certificate string (200)
verified_at timestamp
user_id ^FK bigInteger

stores

id bigIncrements
timestamps timestamps
name string (250)
description text
img_cover string (150)
logo string (150)
tags text
slug string (200)
note decimal (8,2)
gallery json
activation boolean
user_id ^FK bigInteger
feedback_id ^FK integer
store_payment_id ^FK integer
store_location_id ^FK integer

feedbacks

id increments
timestamps timestamps
content text

users

id bigIncrements
timestamps timestamps
firstname string (200)
lastname string (200)
email string (200)
ssn string (250)
passport string (250)
date_of_birth timestamp
identity_verified_at timestamp
role_id ^FK bigInteger
location_id ^FK integer

stripes

id increments
timestamps timestamps
card_number string (100)
expiration_date string (100)
security_code string (100)
name_on_card string (100)
currency string (50)
stripe_api_id string (100)

paypals

id increments
timestamps timestamps
paypal_api_id string (150)
cart string (100)
create_time timestamp
payer_country_code string (200)
payer_name string (200)
payer_id string (150)
payment_method string (100)
payment_status string (100)
transactions_currency string (100)
transactions_total string (200)
items_description text

products

id increments
timestamps timestamps
name string (255)
description text
tags string (255)
dimension string (100)
weight string (100)
price decimal (8,2)
stock integer
condition string (50)
publied boolean
reference string (150)
slug string (250)
store_id ^FK bigInteger
image_id ^FK integer

images

id increments
timestamps timestamps
images json
store_id ^FK bigInteger
product_id ^FK integer

store_payments

id increments
timestamps timestamps
stripe_id ^FK integer
paypal_id ^FK integer

store_admins

id increments
timestamps timestamps
user_id ^FK bigInteger
store_id ^FK bigInteger

locations

id increments
timestamps timestamps
city string (200)
country string (200)
state string (200)
address text

store_locations

id increments
timestamps timestamps
store_id ^FK bigInteger
location_id ^FK integer

commands

id increments
timestamps timestamps
user_id ^FK bigInteger
date_commande timestamp
subtotal decimal
location_id ^FK integer

taxes

id increments
timestamps timestamps
name string (100)
pourcentage float (8,2)
activation boolean

command_products

id increments
timestamps timestamps
quantity bigInteger
unit string (50)
unit_price decimal (8,2)
subtotal decimal (8,2)
command_id ^FK integer
product_id ^FK integer

invoices

id increments
timestamps timestamps
reference string (100)
store_id ^FK bigInteger
command_id ^FK integer
total decimal (8,2)
store_stripe_id ^FK integer
store_paypal_id ^FK integer

invoice_admins

id increments
timestamps timestamps
reference string (100)
command_id ^FK integer
pourcentage decimal (8,2)
total decimal (8,2)

promotions

id increments
timestamps timestamps
name string (250)
date_start timestamp
date_end timestamp
description text
rate decimal (8,2)

product_promotions

id increments
timestamps timestamps
promotional_price decimal (8,2)
promotion_id ^FK integer
product_id ^FK integer

services

id increments
timestamps timestamps
name string (200)
disponibility boolean
activation boolean

deliveries

id increments
timestamps timestamps
date_delivrery timestamp
status_delivrery boolean
command_id ^FK integer
service_id ^FK integer

Categories

id increments
name string (200)
parent_id ^FK integer

taxe_products

id increments
timestamps timestamps
taxe_id ^FK integer
status boolean
product_id ^FK integer

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