Vivi - Laravel Schema Designer

users

id bigIncrements
first_name string (100)
last_name string (100)
gender enum
email string (255)
contact_number string (20)
birth_date date
password string (255)
two_factor_code string (4)
two_factor_expires_at datetime
profile_pic string (100)
type enum
social_id string (2000)
social_type enum
timestamps timestamps
softDeletes softDeletes
stripe_id string (255)
is_document_verify boolean
fcm_token string (255)

property_types

id increments
name string (100)
img string (100)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

room_types

id increments
property_type_id bigInteger
name string (100)
img string (100)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

properties_features

id increments
room_type_id bigInteger
name string (100)
img string (100)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

properties

id bigIncrements
name string (255)
description string (1000)
property_type_id bigInteger
room_type_id bigInteger
want_guests enum
base_price decimal (6,2)
min_price decimal (6,2)
max_price decimal (6,2)
created_by bigInteger
updated_by bigInteger
mobile_status string (1000)
weekly_discount smallInteger
monthly_descount smallInteger
status enum
timestamps timestamps
softDeletes softDeletes
hosted_by_host tinyInteger
admin_approval tinyInteger
max_guest smallInteger
cleaning_fee decimal (6,2)
service_fee decimal (6,2)

amenities

id increments
name string (100)
img string (100)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_amenity

id increments
property_id bigInteger
amenity_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_has_images

id increments
name string (100)
property_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

properties_rules

id increments
property_type_id bigInteger
name string (100)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_rules

id increments
property_id bigInteger
rule_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

properties_infos

id increments
name string (100)
property_type_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_info

id increments
property_id bigInteger
property_info_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_feature

id increments
property_id bigInteger
property_feature_id bigInteger
value integer
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_checkin_detailes

id increments
property_id bigInteger
arrive_after time
arrive_before time
leave_before time
min_stay integer
max_stay integer
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_blocking_dates

id increments
property_id bigInteger
date date
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_addresses

id increments
property_id bigInteger
street_address string (100)
land_mark string (100)
zip_code string (10)
latitude string (20)
longitude string (20)
city_id bigInteger
state_id bigInteger
country_id bigInteger
timestamps timestamps
softDeletes softDeletes

property_booking_availabilities

id increments
property_id bigInteger
advance_notice tinyInteger
reservation_requests boolean
availability_window tinyInteger (3)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

rejection_reasons

id increments
property_id bigInteger
name string (255)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

property_rejection_reasons

id increments
property_id bigInteger
rejection_reason_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes
note string (500)

mobile_languages

id increments
name string (255)
english string (255)
french string (255)
spanish string (255)
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

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