buypower - Laravel Schema Designer

user

id increments
username string
name string
email string
first_name string
last_name string
is_active boolean
softDeletes softDeletes
phone string
emergency_contact string
timestamps timestamps

set_price_ranges

id increments
timestamps timestamps
max_price decimal (8, 2)
min_price decimal (8, 2)
is_active boolean
location_id ^FK bigInteger
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
softDeletes softDeletes

set_suburbs

id increments
timestamps timestamps
suburb string
state_id ^FK bigInteger
is_active boolean
location ^FK bigInteger
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
softDeletes softDeletes

set_states

id increments
timestamps timestamps
state string
is_active boolean
country_id ^FK bigInteger
location_id ^FK bigInteger
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
softDeletes softDeletes

user_suburb

id increments
timestamps timestamps
suburb_id ^FK bigInteger
user_profile_id ^FK bigInteger
is_active bigInteger
softDeletes softDeletes

set_location

id increments
timestamps timestamps
location string
address text
is_active boolean
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
softDeletes softDeletes

set_countries

id increments
timestamps timestamps
country string
is_active boolean
location_id ^FK bigInteger
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
softDeletes softDeletes

user_survey_profiles

id bigInteger
timestamps timestamps
address text
lattitude string
move_in_month integer
move_in date
longtitude string
user_id ^FK bigInteger
is_active boolean
softDeletes softDeletes
min_travel_time integer
max_travel_time integer
garage integer
storey string

set_schools

id increments
timestamps timestamps
name string
is_active boolean
suburb_id ^FK bigInteger
location_id ^FK bigInteger
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
softDeletes softDeletes

properties

id increments
timestamps timestamps
title string
type string
price string
bed_room string
bath_room string
garage string
address string
availability_from datetime
availability_to datetime
is_active boolean
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
location_id ^FK bigInteger
softDeletes softDeletes

property_address

id increments
timestamps timestamps
property_id ^FK bigInteger
suburb_id ^FK bigInteger
street string
city string
po_box string
is_active boolean
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
location_id ^FK bigInteger
softDeletes softDeletes

property_info

id increments
timestamps timestamps
property_id ^FK bigInteger
bed_room string
storey string
garage integer
is_active boolean
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
location_id ^FK bigInteger
softDeletes softDeletes

property_user

id increments
timestamps timestamps
property_id ^FK bigInteger
user_profile_id ^FK integer
is_active boolean
create_user_id ^FK bigInteger
edit_user_id ^FK bigInteger
location_id ^FK bigInteger

more_refine_search

id increments
user_survey_profile_id ^FK bigInteger
school_id ^FK bigInteger
location_address string (1000)
location_lat string (255)
location_long string (255)
travel_time string (1000)
is_bus boolean
is_tram boolean
is_train boolean
garage integer
storey string (255)
softDeletes softDeletes
timestamps timestamps

user_price_renge

id increments
timestamps timestamps
softDeletes softDeletes
user_profile_id ^FK bigInteger
price_renge_id ^FK bigInteger

user_property_type

id increments
timestamps timestamps
softDeletes softDeletes
user_profile_id ^FK bigInteger
property_type string (255)

User_bed_room

id increments
timestamps timestamps
softDeletes softDeletes
user_profile_id ^FK bigInteger
Room string (255)

user_move_in

id increments
timestamps timestamps
softDeletes softDeletes
user_profile_id ^FK bigInteger
move_in string (255)

property_image

id increments
timestamps timestamps
softDeletes softDeletes
property_id ^FK bigInteger
image_path string (1000)

dashboard_advertise

id increments
timestamps timestamps
file_path string (255)

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