Daliluna - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (255)
last_name string (255)
phone string (255)
email string (255)
password string (255)
birthday date

countries

id increments
timestamps timestamps
name string (255)
code string (255)

provinces

id increments
timestamps timestamps
name string (255)
country_id ^FK bigInteger

cities

id increments
timestamps timestamps
name string (255)
province_id ^FK bigInteger

yellow_pages

id increments
timestamps timestamps
name string (255)
description string (255)
image string (255)

yellow_page_departments

id increments
timestamps timestamps
name string (255)
image string (255)
yellow_page_id ^FK bigInteger

site_languages

id increments
timestamps timestamps
name string (255)
code char (10)

yellow_services

id increments
timestamps timestamps
name string (255)
price double
period_value integer
period_name enum

affiliates

id increments
timestamps timestamps
active boolean
profit_ratio double
income_tax double
attachments json
contract_signed string (255)
city_id ^FK bigInteger
user_id ^FK bigInteger

affiliates_transfers_to_admin

id increments
timestamps timestamps
transfer_number string (255)
transfer_date date
amount double
receive_status_by_admin enum
affiliate_id ^FK bigInteger

affiliate_clients

id increments
timestamps timestamps
name string (255)
mobile string (255)
phone string (255)
address string (255)
email string (255)
total_price string (255)
admin_percentage string (255)
tax_percentage string (255)
profit double
extra_tax_type enum
extra_tax_name string (255)
extra_tax_value double
discount_type enum
discount_name string (255)
discount_value double
affiliate_transfer_to_admin_id ^FK bigInteger
yellow_page_department_id ^FK bigInteger
city_id ^FK bigInteger
affiliate_id ^FK bigInteger

affiliate_contracts

id increments
timestamps timestamps
file string (255)

affiliate_balance_not_receiveds

id increments
timestamps timestamps
balance double
affiliate_id ^FK bigInteger

affiliate_balance_receiveds

id increments
timestamps timestamps
balance double
affiliate_id ^FK bigInteger

currencies

id increments
timestamps timestamps
name string (255)
code string (255)

classifieds

id increments
timestamps timestamps
name string (255)
icon string (255)
type enum

classified_departments

id increments
timestamps timestamps
name string (255)
classified_id ^FK bigInteger

classified_department_fields

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
type enum
placeholder string (255)
min bigInteger
max bigInteger
values json
required boolean
searched boolean
classified_department_id ^FK bigInteger

abouts

id increments
timestamps timestamps
image_about string (255)
image_footer string (255)
description_about text
description_footer text
number_of_visitors string (255)
unsigned_contract_image string (255)

posts

id increments
timestamps timestamps
title string (255)
price double
description text
email string (255)
facebook string
location text
mobiles json
address string
status enum
images json
video string
number_of_visitors bigInteger
city_id ^FK bigInteger
classified_department_id ^FK bigInteger
currency_id ^FK bigInteger

yellow_services_affiliate_clients

id increments
timestamps timestamps
yellow_service_id ^FK bigInteger
affiliate_client_id ^FK bigInteger

visitor_messages

id increments
timestamps timestamps
name string
email string
subject string
image string
comment text
status enum

footers

id increments
timestamps timestamps
text text
email string
address string
instagram string
google string
youtube string
twitter string

elements

id increments
timestamps timestamps
name string
description string
email string
phones json
time_open string
address string
logo string
images json
video string
facebook string
twitter string
youtube string
website string
instagram string
location string
affiliate_id ^FK bigInteger
approved_admin boolean
number_of_visitors bigInteger
city_id ^FK bigInteger
yellow_page_department_id ^FK bigInteger
affiliate_client_id ^FK bigInteger

blogs

id increments
timestamps timestamps
title string
details text
image string
country_id ^FK bigInteger

our_partners

id increments
timestamps timestamps
name string
image string

advertisement_categories

id increments
timestamps timestamps
name string