mazad - Laravel Schema Designer

categories

id increments
timestamps timestamps
image string
count_items integer
parent_id bigInteger

category_translations

id increments
timestamps timestamps
locale string
name string
category_id ^FK bigInteger

materials

id increments
timestamps timestamps
image string

material_translations

id increments
timestamps timestamps
locale string
name string
material_id ^FK bigInteger

colors

id increments
timestamps timestamps
code string

color_translations

id increments
timestamps timestamps
locale string
name string
color_id ^FK bigInteger

brands

id increments
timestamps timestamps
image string

brand_translations

id increments
timestamps timestamps
locale string
name string
brand_id ^FK bigInteger

stones

id increments
timestamps timestamps

stone_translation

id increments
timestamps timestamps
locale string
name string
description string
stone_id ^FK bigInteger

favourites

id increments
timestamps timestamps
favoriteable_id integer
favoriteable_type string
keyword string
user_id ^FK bigInteger

items

id increments
timestamps timestamps
category_id ^FK bigInteger
main_image string
views_count integer
closed_at timestamp
color_id ^FK bigInteger
total_weight_carat decimal (15,4)
shape_cut string
clarity string
is_sealed boolean
is_laser_engraved boolean
owner_id ^FK bigInteger
buyer_id ^FK bigInteger
is_fixed_price boolean
fixed_price decimal (15,5)
starting_bid decimal (15,2)
max_payment_term integer
is_admin_approval boolean
open_at timestamps

users

id increments
timestamps timestamps

shippings

id increments
timestamps timestamps
item_id ^FK bigInteger
seller_id ^FK bigInteger
buyer_id ^FK bigInteger
address_id ^FK bigInteger
quantity integer
coupon_id ^FK bigInteger
payment_type string
is_shipping_free boolean
delivery_time string
transaction_id string
sub_total decimal (15,5)
total decimal (15,5)
delivery_fees decimal (15,5)
delivery_id ^FK bigInteger
order_code string
status_id ^FK bigInteger

item_images

id increments
timestamps timestamps
item_id ^FK bigInteger
image string

item_stones

id increments
timestamps timestamps
item_id ^FK bigInteger
stone_id ^FK bigInteger

bids

id increments
timestamps timestamps
user_id ^FK bigInteger
item_id ^FK bigInteger
place_bid decimal (15,5)
bid_time timestamp

addresses

id increments
timestamps timestamps
fullname string
short_address string
country_id ^FK bigInteger
city_id ^FK bigInteger
street text
building_number string
phone_number string
country_code string
is_default boolean

countries

id increments
timestamps timestamps

cities

id increments
timestamps timestamps

coupons

id increments
timestamps timestamps
code string
discount_percentage float
number_of_use integer
user_used_code_count integer
is_active boolean
use_as_ad boolean
coupon_type enum
coupon_price decimal (15,5)
expire_date date

coupon_users

id increments
timestamps timestamps
user_id ^FK bigInteger
coupon_id ^FK bigInteger
number_of_use integer
is_used boolean

settings

id increments
timestamps timestamps
key string
value longText
title string
logo string

abouts

id increments
timestamps timestamps
name string
description longText

privacies

id increments
timestamps timestamps
name string
description longText

termsandconditions

id increments
timestamps timestamps

reviews

id increments
timestamps timestamps
buyer_id ^FK bigInteger
seller_id ^FK bigInteger
rating decimal (2,1)
comment text
item_id ^FK bigInteger

statuses

id increments
timestamps timestamps
name string
description text

shipping_statuses

id increments
timestamps timestamps
shipping_id ^FK bigInteger
status_id ^FK bigInteger

item_translations

id increments
timestamps timestamps
locale string
name string
description text

item_materials

id increments
timestamps timestamps
item_id ^FK bigInteger
material_id ^FK bigInteger