Ramo - Laravel Schema Designer

users

id increments
timestamps timestamps
name string (255)
phone_number string (255)
Email string (255)
Password string (255)
Type enum

supplier_info

id increments
timestamps timestamps
governorate_id ^FK bigInteger
city_id ^FK bigInteger
Opening_time date
Closing_time date
phone_number json

governorates

id increments
timestamps timestamps
name json

cities

id increments
timestamps timestamps
name json
governorate_id ^FK bigInteger

product_categories

id increments
timestamps timestamps
name json
status enum

Colors

id increments
timestamps timestamps
name json

Sizes

id increments
timestamps timestamps
name json

Materials

id increments
timestamps timestamps
name json

Products

id increments
timestamps timestamps
type enum
price double
season enum
description json
category_id ^FK bigInteger
minimum_order_quantity integer
discount_start_date date
discount_end_date date
stock integer
views integer
discount_percentage integer
Material_id ^FK bigInteger

color_product

id increments
timestamps timestamps
product_id ^FK bigInteger
color_id ^FK bigInteger

Product_size

id increments
timestamps timestamps
product_id ^FK bigInteger
size_id ^FK bigInteger

Subscription

id increments
timestamps timestamps
amount_paid double
payment_method enum
notes text
status enum
user_id ^FK bigInteger
start_date date
end_date date

Subscription_package

id increments
timestamps timestamps
name enum
number_of_ads integer
number_of_product integer
price double
period enum

Supplier_location

id increments
timestamps timestamps
location string
supplier_info_id ^FK bigInteger
lat double
long double

category_supplier

id increments
timestamps timestamps
supplier_info_id ^FK bigInteger
supplier_categories_id ^FK bigInteger

wishlists

id increments
timestamps timestamps
user_id ^FK bigInteger
favoriteable morphs

rates

id increments
timestamps timestamps
rateable morphs
user_id ^FK bigInteger
rate decimal
comment string

supplier_categories

id increments
timestamps timestamps
name json

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