saudiGram - Laravel Schema Designer

stories

id increments
timestamps timestamps
creatable morphs
type enum
api_key string
event_id bigInteger
session_id string
category_id ^FK bigInteger
expired_at timestamp
privacy enum
is_expired boolean

story_tags

id increments
timestamps timestamps
story_id ^FK bigInteger
user_id ^FK bigInteger
x string
y string

users

id increments
timestamps timestamps
name string
phone string
email string
image string
is_account_private boolean
bio text
country_code string
is_live boolean

story_answers

id increments
timestamps timestamps
story_id ^FK bigInteger
answer string
is_correct boolean

user_answers

id increments
timestamps timestamps
user_id ^FK bigInteger
story_id ^FK bigInteger
answer_id ^FK bigInteger

attachments

id increments
timestamps timestamps
attachmentable morphs
file string
type enum
extension string

intros

id increments
timestamps timestamps
title string
description string
app_type enum
image string

categories

id increments
timestamps timestamps
image string
parent_id ^FK bigInteger
name string
type enum

regions

id increments
timestamps timestamps
image string
title string

posts

id increments
timestamps timestamps
creatable morphs
content string
voice_url string
is_archieved boolean
likes_count integer
type enum

interests

id increments
timestamps timestamps
name string
image string
parent_id string

post_interest

id increments
timestamps timestamps
post_id ^FK bigInteger
interest_id ^FK bigInteger

hashtags

id increments
timestamps timestamps
title string

post_hashtag

id increments
timestamps timestamps
post_id ^FK bigInteger
hashtag_id ^FK bigInteger

interest_user

id increments
timestamps timestamps
interest_id ^FK bigInteger
user_id ^FK bigInteger

sliders

id increments
timestamps timestamps
file string
type enum
extension string

likes

id increments
timestamps timestamps
likable morphs
creatable morphs

comments

id increments
timestamps timestamps
commentable morphs
creatable morphs
parent_id ^FK bigInteger
content text

saved_posts

id increments
timestamps timestamps
post_id ^FK bigInteger
user_id ^FK bigInteger

highlights

id increments
timestamps timestamps
image string
title string
user_id ^FK bigInteger

highlight_stories

id increments
timestamps timestamps
highlight_id ^FK bigInteger
story_id ^FK bigInteger

follows

id increments
follower_id ^FK bigInteger
followed_id ^FK bigInteger
is_close_friend boolean
is_restricted boolean
status enum

contacts

id increments
timestamps timestamps
name string
phone string
email string
message string
contactable morphs

providers

id increments
timestamps timestamps
name string
phone string
image string
commercial_number string
commercial_image string
category_id string
is_approved string
email string
is_live boolean

privileges

id increments
timestamps timestamps
name string

provider_previlage

id increments
timestamps timestamps
privilege_id ^FK bigInteger
provider_id ^FK bigInteger

user_updates

id increments
timestamps timestamps
type enum
phone string
email string
user_id ^FK bigInteger
provider_id ^FK bigInteger

features

id increments
timestamps timestamps
name string
parent_id string
type enum

options

id increments
timestamps timestamps
feature_id integer
name string

category_feature

id increments
timestamps timestamps
category_id string
feature_id string

blocks

id increments
timestamps timestamps
user_id string
blocked_id string

report_reasons

id increments
timestamps timestamps
name string

story_attachments

id increments
timestamps timestamps
story_id ^FK bigInteger
content string
type enum
x string
y string
title string
file string
extension string

views

id increments
timestamps timestamps
viewable morphs
creatable morphs
is_liked string

comment_tags

id increments
timestamps timestamps
comment_id ^FK bigInteger
user_id ^FK bigInteger