tawasol-social - Laravel Schema Designer

intros

id increments
title text
description longText
type enum
timestamps timestamps
softDeletes softDeletes

users

id increments
avatar string
username string
country_code string (5)
phone string (50)
email string
password string
show_phone boolean
lat decimal
lng decimal
map_desc text
ratings_count bigInteger
ratings_avg decimal
comments_count bigInteger
timestamps timestamps
softDeletes softDeletes

verification_codes

id increments
user_type string (50)
country_code string (5)
phone string (50)
type enum
is_verified boolean
code_expire timestamp
timestamps timestamps

social_accounts

id increments
accountable morphs
provider_type enum
provider_user_id string (100)
email string
access_token text
timestamps timestamps

contacts

id increments
user_id bigInteger
name string
country_code string (50)
phone string (50)
is_registered boolean
timestamps timestamps
softDeletes softDeletes

groups

user_id ^FK bigInteger
id increments
name string
timestamps timestamps
softDeletes softDeletes

contact_groups

id increments
contact_id ^FK bigInteger
group_id ^FK bigInteger
timestamps timestamps

follows

id increments
follower morphs
followee morphs
status enum
timestamps timestamps

blocks

id increments
blocker morphs
blocked morphs
timestamps timestamps

likes

id increments
liker morphs
likeable morphs
timestamps timestamps

posts

id increments
type enum
purchse_id bigInteger
attachment_type enum
wash_list_type enum
author morphs
caption longText
comments_count bigInteger
likes_count bigInteger
views_count bigInteger
link string
mentionable nullableMorphs
ratings_count bigInteger
ratings_avg decimal
timestamps timestamps
softDeletes softDeletes

attachments

id increments
attachable morphs
type enum
file string (50)
timestamps timestamps
softDeletes softDeletes

post_target_groups

id increments
post_id ^FK bigInteger
group_id ^FK bigInteger
mode enum
timestamps timestamps

post_target_group_exclusions

id increments
post_id ^FK bigInteger
group_id ^FK bigInteger
contact_id ^FK bigInteger
timestamps timestamps

comments

id increments
commentable morphs
author morphs
parent_id ^FK bigInteger
body longText
type enum
comments_count bigInteger
likes_count bigInteger
timestamps timestamps
softDeletes softDeletes

views

id increments
viewer nullableMorphs
viewable morphs
views_count bigInteger
first_viewed_at timestamp
last_viewed_at timestamp
timestamps timestamps

wishlist_categories

id increments
user_id ^FK bigInteger
type enum
timestamps timestamps

wishlist_category_groups

id increments
timestamps timestamps
wishlist_category_id ^FK bigInteger
group_id ^FK bigInteger

category_store

id increments
store_id ^FK bigInteger
category_id ^FK bigInteger
timestamps timestamps

categories

id increments
name string
is_active string
timestamps timestamps
softDeletes softDeletes

communications

id increments
is_active boolean
type string (50)
name string
icon string (50)
timestamps timestamps
softDeletes softDeletes

stores

id increments
avatar string (50)
username string
country_code string (20)
phone string (50)
email string (100)
lat decimal
lng decimal
map_desc decimal
is_blocked boolean
is_active boolean
is_aproved string
ratings_count bigInteger
ratings_avg bigInteger
comments_count bigInteger
softDeletes softDeletes
timestamps timestamps

store_infos

id increments
store_id ^FK bigInteger
logo string (50)
email string (100)
description text
timestamps timestamps

store_socials

id increments
communication_id ^FK bigInteger
store_id ^FK bigInteger
value text
is_active boolean
timestamps timestamps

store_images

id increments
store_id ^FK bigInteger
type string (10)
file string (50)
timestamps timestamps

favorite_stores

id increments
user_id ^FK bigInteger
store_id ^FK bigInteger
lat decimal
lng decimal
map_desc string
timestamps timestamps

post_ratings

id increments
userable morphs
rateable morphs
post_id ^FK bigInteger
rate decimal
comment text
timestamps timestamps
softDeletes softDeletes

points

id increments
pointable morphs
point decimal
available_point decimal
debt_point decimal
softDeletes softDeletes
timestamps timestamps

point_histories

id increments
point_id ^FK bigInteger
type integer
point decimal
point_before decimal
point_after decimal
timestamps timestamps

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