a3laf - Laravel Schema Designer

users

id bigIncrements
email string
password string
phone string
type_id ^FK bigInteger
timestamps timestamps

ads

id bigIncrements
name string
body longText
status enum
price decimal (10,2)
city_id ^FK bigInteger
user_id ^FK bigInteger
category_id ^FK bigInteger
timestamps timestamps

cities

id bigIncrements
timestamps timestamps

ratings

id increments
score enum
body text
ratingable_id bigInteger
ratingable_type string
user_id ^FK bigInteger
timestamps timestamps

categories

id bigIncrements
name string
timestamps timestamps

favorites

id bigIncrements
ad_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

banks

id bigIncrements
name string
timestamps timestamps

accounts

id bigIncrements
number string
iban string
note text
bank_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

types

id bigIncrements
name string
timestamps timestamps

conversations

id bigIncrements
from_id ^FK bigInteger
to_id ^FK bigInteger
timestamps timestamps

messages

id bigIncrements
content longText
conversation_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

followers

id increments
timestamps timestamps
user_id integer
follower_id integer

comments

id increments
timestamps timestamps
body text
post_id integer
user_id integer

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