korean - Laravel Schema Designer

category

id increments
timestamps timestamps
category_name string (191)
image string (191)
url string (191)
status enum

subcategory

id increments
timestamps timestamps
category_id ^FK integer
subcategory_name string (191)
url string
status enum

shop

id increments
timestamps timestamps
vendor_id ^FK integer
shop_name string (255)
tag_line string (191)
address text
mobile_no string
product_min_qty integer
min_qty_unit ^FK integer
product_max_qty integer
max_qty_unit ^FK integer

users

id increments
timestamps timestamps
name string (191)
api_token string (255)

measure_unit

id increments
timestamps timestamps
softDeletes softDeletes
unit_name string (191)
short_name string (191)

product

id increments
timestamps timestamps
softDeletes softDeletes
product_name string (255)
category_id ^FK integer
subcategory_id ^FK integer
description text
status enum
vendor_id ^FK integer
image string
price decimal

product_size_image

id increments
timestamps timestamps
softDeletes softDeletes
product_it ^FK integer
title string
image string

banner

id increments
timestamps timestamps
title string
image string

shop_banner

id increments
timestamps timestamps
title string
vendor_id ^FK integer
image string

coupon

id increments
timestamps timestamps
softDeletes softDeletes
coupon_code string
coupon_unit string
unit_value string
expiry_date date
min_purchase string

discount

id increments
timestamps timestamps
softDeletes softDeletes
vendor_id ^FK integer
title string
amount decimal

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