slm - Laravel Schema Designer

users

id increments
email string
password string
user_type_id ^FK integer
subscription_id ^FK integer
first_name string
last_name string
nickname string
phone string (15)
date_of_birth date
gender enum
maritalstatus enum
country_id ^FK integer
city_id ^FK integer
birth_country_id ^FK integer
birth_city_id ^FK integer
current_place string
address string
timestamps timestamps

countries

id increments
name string
code string

cities

id increments
name string
code string

user_filters

id increments
user_id ^FK integer
body_structure_id ^FK integer
complexion_id ^FK integer
appearance_id ^FK integer
personality_id ^FK integer
employment_id ^FK integer
nationality_id ^FK integer
ethnicity_id ^FK integer
religion_id ^FK integer
education_id ^FK integer
height integer

body_structures

id increments
name string

complexions

id increments
name string

appearances

id increments
name string

personalities

id increments
name string

employments

id increments
name string

nationalities

id increments
name string

ethnicities

id increments
name string

religions

id increments
name string

educations

id increments
name string

user_types

id increments
type_id integer
is_paid boolean

subscription

id increments
start_date datetime
end_date datetime
package_id ^FK integer
timestamps timestamps

packages

id increments
name string
amount decimal (8,2)
period string
timestamps timestamps

show_interests

id increments
from_user_id ^FK integer
to_user_id ^FK integer
timestamps timestamps

chat_request

id increments
from_user_id ^FK integer
to_user_id ^FK integer
timestamps timestamps

block_list

id increments
from_user_id ^FK integer
to_user_id ^FK integer
timestamps timestamps

user_view_count

id increments
from_user_id ^FK integer
to_user_id ^FK integer
timestamps timestamps

images

id increments
entity_id integer
entity_tag string
type string
path string
name string
is_deleted boolean
is_profile_pic boolean
timestamps timestamps

abuse_reports

id increments
from_user_id ^FK integer
to_user_id ^FK integer
comment string
timestamps timestamps

user_notifications

id increments
user_id integer
title string
description string
timestamps timestamps

private_filters

id increments
user_id ^FK integer
filter_type string
timestamps timestamps

payments

id increments
timestamps timestamps
user_id ^FK integer
transaction_id integer
currency string
amount decimal (8,2)

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