liv_energy - Laravel Schema Designer

tabBrand

id increments
logo string
avatar string
name string
status string (10)
description text
owner string
last_updated_by string
timestamps timestamps

tabCity

id increments
name string
status string (10)
description text
owner string
country_id ^FK integer
last_updated_by string
timestamps timestamps

tabCustomer

id increments
avatar string
name string
gender string (10)
dob date
email_id string
contact_no string
notes text
owner string
last_updated_by string
timestamps timestamps

tabCustomerBookmark

id increments
customer_id ^FK integer
type string
type_id integer
owner string
last_updated_by string
timestamps timestamps

tabServiceProvider

id increments
avatar string
name string
status string (10)
city_id ^FK integer
verified string (10)
email_id string
contact_no string
website string
description text
owner string
last_updated_by string
timestamps timestamps

tabServices

id increments
service_provider_id ^FK integer
avatar string
title string
description text
owner string
last_updated_by string
timestamps timestamps

tabCategory

id increments
avatar string
name string
status string (10)
parent_id integer
parent string
description text
owner string
last_updated_by string
timestamps timestamps

tabSupplier

id increments
name string
avatar string
status string (10)
tagline string
verified string (10)
email_id string
contact_no string
address text
city_id ^FK integer
website string
country string
type string
no_of_employees string
legal_status string
member_since date
description text
owner string
last_updated_by string
timestamps timestamps

tabSubscriber

id increments
email_id string
status string (10)
subscribed_at timestamp
unsubscribed_at timestamp
owner string
last_updated_by string
timestamps timestamps

tabServiceCity

id increments
service_provider_id ^FK integer
city_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabServiceBrand

id increments
service_provider_id ^FK integer
brand_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabServiceCategory

id increments
service_provider_id ^FK integer
category_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabSupplierCategory

id increments
supplier_id ^FK integer
category_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabSupplierCity

id increments
supplier_id ^FK integer
city_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabOffer

id increments
avatar string
status string (10)
title string
type string
sort_order integer
description text
owner string
last_updated_by string
timestamps timestamps

tabProduct

id increments
avatar string
name string
status string (10)
brand_id ^FK integer
category_id ^FK integer
description text
technical_drawing string
owner string
last_updated_by string
timestamps timestamps
features text

tabEvent

id increments
avatar string
status string (10)
name string
category_id ^FK integer
description text
event_date date
event_time time
address text
city_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabApproval

id increments
name string (100)
owner string (10)
last_updated_by string
timestamps timestamps

tabSupplierApproval

id increments
supplier_id ^FK integer
approval_id ^FK integer
owner string (10)
last_updated_by string
timestamps timestamps

tabSupplierDetail

id increments
supplier_id ^FK integer
label string (255)
value text
level integer
owner string (10)
last_updated_by string (20)
timestamps timestamps

tabProductDetail

id increments
product_id ^FK integer
label string
value string
level integer
owner string
last_updated_by string
timestamps timestamps

tabProductApproval

id increments
product_id ^FK integer
approval_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabProductThumbnails

id increments
product_id ^FK integer
avatar string
owner string
last_updated_by string
timestamps timestamps

tabProductSupplier

id increments
product_id ^FK integer
supplier_id ^FK integer
owner string
last_updated_by string
timestamps timestamps

tabCountry

id increments
country_code string (10)
country_name string (100)
owner string
last_updated_by string
timestamps timestamps