Enstate - Laravel Schema Designer

enstate_types

id increments
type tinyInteger
name string

estate_subtypes

id increments
name string

estate_type_subtypes

id increments
timestamps timestamps
type_id ^FK integer
subtype_id ^FK integer

estate_structures

name string
id increments

estates

id increments
timestamps timestamps
type_id ^FK integer
sub_type_id ^FK integer
sale_representative_id integer
saler_id integer
company_id integer
address_id integer
house_number integer
station_id integer
location_name_id integer
price decimal
advertising_condition_id integer
sale_status_id integer
commission_id integer
time_walkcommission_percent decimal
time_walk integer
distance_walk integer
time_station_to_bus integer
bus_stop_name string
distance_by_car integer
time_walk_to_bus integer
estate_structure_id integer
land_privilege_id integer
total_floor integer
room_arrangement string
land_rental_fee integer
delivery_time_condition_id integer
delivery_time_type_id integer
delivered_at datetime
delivery_season_id integer
primary_school_name string
distance_to_primary_school integer
secondary_school_name string
distance_to_secondary_school string
hospital_name string
distance_to_hospital string
kindergarten_name string
distance_to_kindergarten integer
mediator text
created_atconfirmed_at datetime
deleted_at datetime
gyopro_public_status tinyInteger
gyopro_public_created_at date
status integer
registered_by integer
commission_value decimal
organization_id decimal
recommendations string

estate_stations

id increments
timestamps timestamps
estate_id ^FK integer
station_id integer
time_walk integer
distance_walk integer
distance_by_car string
time_station_to_bus integer
bus_stop_name string
time_walk_to_bus string
deleted_at datetime

estate_images

id increments
timestamps timestamps
softDeletes softDeletes
name string
image_url string
shooted_at date
distance string
image_type_id integer
estate_id ^FK integer

estate_image_types

id increments
timestamps timestamps
name string

estate_sides

id increments
timestamps timestamps
estate_id ^FK integer
direction_id integer
road_type_id integer
width integer
deleted_at datetime

estate_slides

id increments
timestamps timestamps
estate_id integer
estate_image_id ^FK integer
position smallInteger

estate_image_logs

id increments
timestamps timestamps
estate_id ^FK integer
images string

estate_price_logs

id increments
timestamps timestamps
estate_id ^FK integer
price string

estate_notices

id increments
timestamps timestamps
estate_id ^FK integer
notice_id integer

estate_mansions

id increments
timestamps timestamps
estate_id ^FK integer
total integer
total_sold integer
sold_building_no string
sold_building_floor smallInteger
possession_area_type_id integer
lighting_direction_id integer
rent_period date
balcony_area decimal
roof_balcony_area decimal
roof_balcony_fee decimal
roof_balcony_fee_unit integer
terrace_area string
terrace_fee decimal
terrace_fee_unitgarden_area string
garden_fee string
garden_fee_unit string
built_at date
completion_status_id integer
room_status_id integer
total_basement string
mansion_parking_lot_id string
parking_site string
parking_confirmed_at date
parking_empty_spaces integer
parking_fee_from decimal
parking_fee_to integer
parking_fee_unit string
is_price_including_parking_fee integer
is_parking_free string
construction_company_id integer
responsibility_company_id string
management_method_id string
manager_status_id string
is_management_group string
management_fee string
repair_reserve_fee string
repair_reserve_base_fee string
other_fee string
other_fee_name string
interior_reform_status_id string
interior_reformed_at string
exterior_reform_status_id string
exterior_reformed_at string
renovation_status_id string
renovated_at string
restriction text
deleted_at string
exterior_reformed_items string
interior_reform_item_idsinterior_reform_item_ids string
renovation_items string

estate_lands

id increments
timestamps timestamps
estate_lands integer
construction_area string
construction_area_type_id string
total string
total_sold string
sold_number string
land_type_id string
land_area string
land_area_type_id string
land_status_id string
is_has_construction_condition string
construction_condition_type string
construction_condition_id string
development_approval_number string
urban_plan_id string
aisle_area string
high_voltage_line_area string
slope_area string
out_basement_area string
use_area_id string
building_coverage string
driveway_area string
share_enumerator string
share_denominator string
water_service_id string
sewage_id string
gas_id string
drainage_id string
is_all_electric string
equipment_remark string
total_month_for_rent string
total_year_for_rent string
floor_area_ratio string
contact_road_status_id string
building_standard_type_id string
building_standard_permission_reason string
deleted_at datetime
construction_condition_period string
notice_ids string

estate_houses

id increments
timestamps timestamps
estate_id integer
construction_area_type_id integer
total string
total_sold string
sold_number string
land_type_id string
land_area string
land_area_type_id string
architecture_no string
urban_plan_id string
aisle_area string
high_voltage_line_area string
slope_area string
out_basement_area string
use_area_id string
driveway_area string
building_coverage string
share_enumerator string
share_denominator string
water_service_id string
sewage_id string
gas_id string
drainage_id string
is_all_electric string
equipment_remark string
total_month_for_rent string
total_year_for_rent string
floor_area_ratio string
built_at datetime
completion_status_id string
room_status_id string
contact_road_status_id string
house_parking_lot_id string
total_cars string
is_car_base string
is_car_port string
is_parking_built_in string
is_parking_underground string
parking_area string
is_parking_in_building string
building_standard_type_id string
building_standard_permission_reason string
flat_35_id string
notice_ids string

estate_contact_statuses

id increments
timestamps timestamps
estate_id integer
contact_road_direction_id integer
contact_road_type_id integer
width integer

estate_areas

id increments
timestamps timestamps
estate_id integer
use_area_id string
building_coverage string
floor_area_ratio string
deleted_at datetime