dokan - Laravel Schema Designer

masters

id increments
timestamps timestamps
softDeletes softDeletes
username string (255)
password string (255)

companies

id increments
timestamps timestamps
softDeletes softDeletes
name string
base_url string (1000)
expiry_date date
plan_id ^FK integer
status boolean
country_id ^FK integer
username string
password string

employees

id increments
timestamps timestamps
softDeletes softDeletes
username string
password string
status boolean
name string
egroup_id ^FK integer

plans

id increments
timestamps timestamps
softDeletes softDeletes
name string
description text

egroups

id increments
timestamps timestamps
softDeletes softDeletes
company_id ^FK integer
name string

marketers

id increments
timestamps timestamps
softDeletes softDeletes
facebook_id string
google_id string
username string
email string
phone string
password string
email_status boolean
phone_status boolean
vcode_email integer
vcode_phone integer
status boolean
payment_method_id ^FK integer
name string
page_link string
brand_name string
city_id ^FK integer

payment_methods

id increments
timestamps timestamps
softDeletes softDeletes
name string

fcm_token

id increments
timestamps timestamps
softDeletes softDeletes
user morphs
token string

browser_token

id increments
timestamps timestamps
softDeletes softDeletes
user morphs
token string

marketermoderator

id increments
timestamps timestamps
softDeletes softDeletes
username string
password string
marketer-id morphs
permissions_4 string

governorates

id increments
timestamps timestamps
softDeletes softDeletes
name string
country_id ^FK integer

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string
governorate_id ^FK integer

warehouses

id increments
timestamps timestamps
softDeletes softDeletes
city_id ^FK integer
name string

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string
company_id ^FK integer
icon string

shipping_companies

id increments
timestamps timestamps
softDeletes softDeletes
company_id ^FK integer
name string

wallets

id increments
timestamps timestamps
softDeletes softDeletes
user morphs
expected double
available double
withdrawal double

transactions

id increments
timestamps timestamps
softDeletes softDeletes
user morphs
amount double
status enum
order_id integer

payment_request

id increments
timestamps timestamps
softDeletes softDeletes
user morphs
transaction_id ^FK integer
status enum

suppliers

id increments
timestamps timestamps
softDeletes softDeletes
facebook_id string
google_id string
username string
email string
phone string
password string
email_status boolean
phone_status boolean
vcode_email integer
vcode_phone integer
status boolean
payment_method_id integer
name string
brand_name string
city_id integer

contacts

id increments
timestamps timestamps
softDeletes softDeletes
type enum
product_id integer
order_id integer
status boolean
company_id ^FK integer
user morphs
name string
phone string
msg text

cms

id increments
timestamps timestamps
softDeletes softDeletes
group_name string
key string
data string
company_id ^FK integer

notifications

id increments
timestamps timestamps
softDeletes softDeletes
user morphs
type enum
title string
description text

products

id increments
timestamps timestamps
softDeletes softDeletes
name string
category_id integer
supplier_profit double
marketer_profit double
system_profit double
description text
barcode string
video_url string
status enum
code string
is_private boolean

units

id increments
timestamps timestamps
softDeletes softDeletes
name string
classification_id string

product_details

id increments
timestamps timestamps
softDeletes softDeletes
type string
data string
product_id integer
parent_id integer
quantity integer

supplier_product_quantity_control

id increments
timestamps timestamps
softDeletes softDeletes
type enum
quantity integer
supplier_id string
product_id string

supplier_product_quantity_control_details

id increments
timestamps timestamps
softDeletes softDeletes
type string
data string
request_id integer
parent_id integer
quantity integer

classifications

id increments
timestamps timestamps
softDeletes softDeletes
name string