mehmetpazar - Laravel Schema Designer

users

id increments
nickname string
avatar string
cover_image string
fullname string
email string
password string
phone string
birthdate datetime
verified boolean
timestamps timestamps
softDeletes softDeletes

user_wallet

id increments
user_id ^FK bigInteger
balance decimal (14,4)
gift_balance decimal (14,4)
timestamps timestamps
softDeletes softDeletes

user_relation

id increments
follower_user_id ^FK bigInteger
following_user_id ^FK bigInteger
timestamps timestamps

user_wallet_log

id increments
timestamps timestamps
user_id ^FK bigInteger
balance_before decimal (14,4)
balance_after decimal (14,4)
balance_type enum
source enum

user_bank_account

id increments
user_id ^FK bigInteger
bank_name string (100)
iban string (34)
fullname string (100)
timestamps timestamps
softDeletes softDeletes

user_visitor

id increments
timestamps timestamps
user_id ^FK bigInteger
visitor_user_id ^FK bigInteger

category

id increments
name string (100)
description string (300)
timestamps timestamps
softDeletes softDeletes

product_category

id increments
main_category ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

advert_category

id increments
main_category ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

product

id increments
product_category ^FK bigInteger
name string (300)
timestamps timestamps
softDeletes softDeletes

product_item

id increments
product_id ^FK bigInteger
key string (200)
timestamps timestamps
softDeletes softDeletes

advert

id increments
advert_category ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

category_detail

id increments
category_id ^FK bigInteger
title string (100)
description string (500)
timestamps timestamps
softDeletes softDeletes

product_rewiews

id increments
user_id ^FK bigInteger
product_id ^FK bigInteger
comment string (300)
timestamps timestamps
softDeletes softDeletes

product_images

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK bigInteger

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