mnsa - Laravel Schema Designer

users

id increments
plan_id ^FK integer
type enum
username string
account_name string
status boolean
email string
phone string
wallet float
hwia string
sgl string
country_id ^FK integer
area_id ^FK integer
timestamps timestamps

user_code

id increments
user_id ^FK integer
code string (50)
timestamps timestamps

plans

id increments
status boolean
name json
price float
period_count integer
period_type enum
content json
timestamps timestamps

images

id increments
imageable_id integer
imageable_type string
path string
type string (100)
timestamps timestamps

services

id increments
status boolean
name json
timestamps timestamps

plan_options

id increments
plan_id ^FK integer
option_id ^FK integer
timestamps timestamps

countires

id increments
status boolean
name json
dial_code string
timestamps timestamps

areas

id increments
status boolean
country_id ^FK integer
area_id ^FK integer
name json
timestamps timestamps

copons

id increments
status boolean
code string
type string
discount float
started_at date
ended_at date
timestamps timestamps

categories

id increments
parent_id ^FK integer
name json
timestamps timestamps

Nationalities

id increments
status boolean
name json
timestamps timestamps

cities

id increments
status boolean
area_id ^FK integer
name json
timestamps timestamps

ads_effect_slides

id increments
status boolean
name json
code string
timestamps timestamps

ads_followers_slides

id increments
status boolean
name json
code string
timestamps timestamps

ads_types

id increments
timestamps timestamps
name json
status boolean

ads_account_types

id increments
status boolean
name json
timestamps timestamps

pages

id increments
status boolean
type string
name json
content json
timestamps timestamps

questions

id increments
status boolean
title json
answer json
timestamps timestamps

rate_types

id increments
status boolean
type string (50)
for string (50)
name json
points integer
timestamps timestamps

claim_reasons

id increments
status boolean
name json
timestamps timestamps

settings

id increments
type string (50)
key string
value text
timestamps timestamps

setting_commission_slides

id increments
status boolean
name json
min float
max float
amount float
timestamps timestamps

plan_options_all

id increments
name json
timestamps timestamps

user_working_days

id increments
user_id ^FK integer
week_day string (50)
from integer
to integer
timestamps timestamps

user_points

id increments
points float
reason string (250)
timestamps timestamps

user_wallet_actions

id increments
status boolean
points integer
added_at date
notes string (350)
timestamps timestamps

user_followers

id increments
user_id ^FK integer
follower_id ^FK integer
timestamps timestamps

ads_channels_effects

id increments
name json
timestamps timestamps

user_channels

id increments
status boolean
user_id ^FK integer
channel_id ^FK integer
name string (250)
link string (500)
timestamps timestamps

user_channel_followers_slides

id increments
channel_id integer
slide_id ^FK integer
total integer
timestamps timestamps

user_channel_countries

id increments
channel_id ^FK integer
country_id ^FK integer
timestamps timestamps

user_channel_areas

id increments
channel_id ^FK integer
area_id ^FK integer
timestamps timestamps

user_channel_cities

id increments
timestamps timestamps
channel_id ^FK integer
city_id ^FK integer

user_employees

id increments
status boolean
user_id ^FK integer
employee_id ^FK integer
timestamps timestamps

user_employees_roles

id increments
timestamps timestamps
user_id ^FK integer
role_id integer

user_employees_roles_all

id increments
key string (100)
name json
timestamps timestamps