usercreclub - Laravel Schema Designer

users

id increments
phone_number string
name string
email string
otp string
profile_pic_url string
username string
address string
timestamps timestamps
softDeletes softDeletes
country_id ^FK bigInteger
city_id ^FK bigInteger
state_id ^FK bigInteger
balance float

posts

id increments
user_id ^FK bigInteger
barnd_id ^FK bigInteger
filename string
post_url string
likes integer
comments integer
description string
product_id ^FK bigInteger
brand_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
tags text

brands

id increments
name string
logo_url string
website string
tagline string
description string
timestamps timestamps

offers

id increments
description string
brand_id ^FK bigInteger
title string
product_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

products

id increments
brand_id ^FK bigInteger
name string
price string
external_link string
action string
timestamps timestamps
softDeletes softDeletes

user_auth_tokens

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

countries

id increments
name string
iso2 string
logo_url string
softDeletes softDeletes
timestamps timestamps
featured_image text

states

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK bigInteger
name string
code string
featured_image text

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string
state_id ^FK bigInteger
country_id ^FK bigInteger
code string
featured_image text

user_social_accounts

id increments
timestamps timestamps
softDeletes softDeletes
facebook string
instagram string
youtube string

transactions

id increments
user_id ^FK bigInteger
amount float
type string
softDeletes softDeletes
timestamps timestamps
description string

post_likes

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

post_vision

id increments
timestamps timestamps
softDeletes softDeletes

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