WestorePortal - Laravel Schema Designer

users

id uuid
first_name string
last_name string
email string
password string
status enum
phone string (10)
merchant_id uuid
timestamps timestamps
softDeletes softDeletes

quote_requests

id uuid
request_needed string (250)
product_type string (100)
shipment_type string (100)
item_insured char (10)
warehouse_city_id uuid
products_temperature_needed string (200)
packed_type string (100)
inbound_shipments string (250)
user_id uuid
status integer
merchant_id uuid
request_number string
timestamps timestamps
softDeletes softDeletes

admins

id uuid
first_name string
last_name string
email string
username string
password string
timestamps timestamps
softDeletes softDeletes

orders

id uuid
user_id uuid
recipient_name string
area_id uuid
recipient_email string
delivery_speed string
payment_term string
status integer
order_number string (10)
merchant_id uuid
timestamps timestamps
softDeletes softDeletes

products

id uuid
name string
SKU string
price float
quantity integer
order_id uuid
type integer
reason_return string (200)
timestamps timestamps
softDeletes softDeletes

cities

id uuid
country_id uuid
timestamps timestamps
softDeletes softDeletes

areas

id uuid
city_id uuid
timestamps timestamps
softDeletes softDeletes

inbound_shipments

id uuid
receiving_date date
receiving_time string (200)
item_type_id uuid
boxes_pallets string (50)
user_id uuid
merchant_id uuid
status integer
shipment_number string (10)
timestamps timestamps
softDeletes softDeletes

support_tickets

id uuid
urgency string (50)
subject string
description text
user_id uuid
status integer
order_id uuid
merchant_id uuid
ticket_number string (10)
timestamps timestamps
softDeletes softDeletes

items_types

id uuid
name string (100)
status integer
timestamps timestamps
softDeletes softDeletes

merchants

id uuid
first_name string (50)
last_name string (100)
email string (100)
phone string (10)
status integer
password string
company_name string (100)
business_link text
timestamps timestamps
softDeletes softDeletes

regions

id uuid
timestamps timestamps
softDeletes softDeletes

countries

id uuid
region_id uuid
timestamps timestamps
softDeletes softDeletes

website_services

id increments
title string (100)
description text
status integer
timestamps timestamps
softDeletes softDeletes

contact_us_messages

id increments
name string (100)
email string (50)
phone string (10)
status integer
timestamps timestamps
softDeletes softDeletes

faqs

id increments
question string (150)
answer text
status integer
timestamps timestamps
softDeletes softDeletes

returns

id increments
order_number string (10)
customer_name string (50)
customer_phone string (50)
customer_email string (50)
area_id uuid
city_id uuid
address string (150)
expected_delivery_date date
status integer
merchant_id uuid
user_id uuid
order_id uuid
softDeletes softDeletes
timestamps timestamps

website_settings

id increments
name string (100)
type string (20)
value text
status integer
timestamps timestamps

our_values

id increments
title string (50)
description text
status integer
timestamps timestamps

how_it_works

id increments
title string (150)
description text
status integer
timestamps timestamps

quote_request_items_type

id increments
item_type_id uuid
quote_request_id uuid
timestamps timestamps

documents

id increments
name string (100)
documentable_id uuid
document_type string (50)
timestamps timestamps

names

id increments
name json
name_type string
nameable_id string
timestamps timestamps

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