cos - Laravel Schema Designer

businessowners

id increments
name string (250)
email string (250)
softDeletes softDeletes
timestamps timestamps

businesscategory

id increments
name string (150)
description string (250)
ImageUrl string
softDeletes softDeletes
timestamps timestamps

branch

id increments
businessactivity_id ^FK integer
name string
latitutude string
longitude string
softDeletes softDeletes
timestamps timestamps

timeofwork

id increments
day string
timestart timestamps
timestamps timestamps
timeend timestamps
branch_id ^FK integer

businessactivity

id increments
businessowner_id ^FK integer
businesscategory_id ^FK integer
businessname string
business_document_type string
business_document_file string
softDeletes softDeletes
timestamps timestamps

offer

id increments
description string (250)
timeOfstart integer
timeOfend timestamps
isActive boolean
originalprice string
discount_percent double
discount_price decimal
timestamps timestamps
softDeletes softDeletes

offermedia

id increments
url string
type string
timestamps timestamps
softDeletes softDeletes
offer_id ^FK integer

keyword

id increments
timestamps timestamps
softDeletes softDeletes
words string
offer_id ^FK integer

offer_items

id increments
timestamps timestamps
softDeletes softDeletes
itemname string
image string
price string
offer_id ^FK integer
originalPrice decimal
discountPrice integer
percent integer

offerrate

id increments
command string
time timestamps
rate integer
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
offer_id ^FK integer

offerview

id increments
timestamps timestamps
softDeletes softDeletes

customer

id increments
timestamps timestamps
softDeletes softDeletes
email string
name string

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