daftor - Laravel Schema Designer

countries

id increments
timestamps timestamps
softDeletes softDeletes
code string (6)
iso_code string (2)
is_active boolean
is_default boolean
flag string

country_translations

id increments
timestamps timestamps
name string
nationality string
locale string (2)
country_id ^FK integer

cities

id increments
timestamps timestamps
softDeletes softDeletes
is_active boolean
country_id ^FK integer
time_zone string

city_translations

id increments
timestamps timestamps
name string
locale string (2)
city_id ^FK integer

districts

id increments
timestamps timestamps
softDeletes softDeletes
is_active boolean
city_id ^FK integer
country_id ^FK integer

district_translations

id increments
name string
district_id ^FK integer
locale string (2)
timestamps timestamps

admins

id increments
full_name string
phone string (20)
email string
password string
is_active boolean
address string
national_id string
country_id ^FK integer
nationality_id ^FK integer
softDeletes softDeletes
timestamps timestamps

roles

id increments
timestamps timestamps
name string
is_active boolean
guard_name string
description string

permissions

id increments
timestamps timestamps
name string
guard_name string

role_has_permission

id increments
role_id bigInteger
permission_id bigInteger
timestamps timestamps

model_has_roles

id increments
timestamps timestamps
role_id ^FK integer
modelable morphs

model_has_permissions

id increments
timestamps timestamps
permission_id ^FK integer
modelable morphs

cultural_entity

id increments
timestamps timestamps
softDeletes softDeletes
code string (20)
email string
password string
temp_password string
city_id ^FK integer
country_id ^FK integer
district_id ^FK integer
is_active boolean
address string
phone string (20)
cultural_entity_type_id integer
logo string
lat string
long string
licence_number string
license_document string
location string

cultural_entity_translations

id increments
timestamps timestamps
locale string (2)
name string

cultural_entity_type

id increments
timestamps timestamps
is_active boolean

cultural_entity_type_translations

id increments
timestamps timestamps
locale string (2)
name string
cultural_entity_type_id ^FK integer

cultural_entity_type_employees

id increments
timestamps timestamps
fuii_name string
email string
role_id ^FK integer
phone string (20)
national_id string
is_active boolean
cultural_entity_id ^FK integer

catrgory

id increments
timestamps timestamps
parent_id ^FK integer
type string
is_active boolean
image string

catrgory_translations

id increments
timestamps timestamps
locale string (2)
book_catrgoriy_id ^FK integer
name string
description string

tags

id increments
timestamps timestamps
name string
is_active boolean

books

id increments
timestamps timestamps
format string
author_name string
is_emerging_author boolean
paper_price decimal
paper_discount_price decimal
paper_quantity integer
paper_model string
pages integer
year date
language string
status string
title string
description string
pricing_model string
ebook_price decimal
ebook_file_path string
cover_image_path string
publisher string
views integer
shares integer

book_tag

id increments
timestamps timestamps
book_id ^FK integer
tag_id ^FK integer

book_category

id increments
timestamps timestamps
book_id ^FK integer
catrgory_id ^FK integer

book_ratings

id increments
timestamps timestamps
book_id ^FK integer
client_id ^FK integer
rating tinyInteger

book_readers

id increments
timestamps timestamps
book_id ^FK integer
client_id ^FK integer
read_at timestamp

book_reviews

id increments
timestamps timestamps
book_id ^FK integer
client_id ^FK integer
review text

paper_book_inventories

id increments
timestamps timestamps
book_id ^FK integer
statusupdated_by ^FK integer

clients

id increments
timestamps timestamps
phone string (20)
email string
password string
is_guest boolean
full_name string
terms_accepted boolean
phone_verified_at timestamp
email_verified_at timestamp

social_login

id increments
timestamps timestamps
client_id ^FK integer
provider string
provider_id string
access_token string
refresh_token string
expired_at timestamp

subscription_plans

id increments
timestamps timestamps
plan_type string
name string
price decimal
duration string
is_active boolean

plan_features

id increments
timestamps timestamps
subscription_plan_id ^FK integer
feature string

plan_discounts

id increments
timestamps timestamps
subscription_plan_id ^FK integer
discount_type string
discount_value decimal
trigger string
is_permanent boolean
start_date date
end_date date
relative_days integer

cultural_entity_subscriptions

id increments
timestamps timestamps
cultural_entity_id ^FK integer
subscription_plan_id ^FK integer
start_date date
end_date date
is_active boolean
usage_percent integer

authenticatable_otps

id increments
timestamps timestamps
code string (6)
email string
phone string (20)
is_active boolean
authenticatable morphs

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