whitedocs_dev - Laravel Schema Designer

hmo_form

id increments
hmo_case_id integer
submitted_at datetime
timestamps timestamps

hmo_form_rooms

hmo_form_households

id increments
hmo_form_id ^FK integer
adults integer
children integer
timestamps timestamps

hmo_form_property_ownership

id increments
hmo_form_id ^FK integer
property_ownership_type_id ^FK integer
name string
email string
telephone string
company_name string
job_position string
interest_in_property string (255)
timestamps timestamps

room_types

id increments
name string (255)
timestamps timestamps

property_ownership_types

id increments
name string
timestamps timestamps

hmo_proposed_licence_holders

id increments
hmo_form_id ^FK integer
title string
name string
telephone string
email string
timestamps timestamps

hmo_form_fit_and_proper

id increments
hmo_form_id ^FK integer
timestamps timestamps

hmo_form_property_information

id increments
hmo_form_id ^FK integer
occupancy_type integer
property_age string
bedrooms integer
living_rooms integer
bathrooms integer
sinks integer
hand_basins integer
kitchens integer
shower_rooms integer
toilets integer
self_contained_flats integer
non_self_contained_flats integer
households integer
total_persons integer
total_households integer
max_persons_applied_for integer
max_households_applied_for integer
resident_landlord boolean
timestamps timestamps

addresses

id increments
addressable_id integer
addressable_type string
uprn string
address_1 string
address_2 string
address_3 string
town_city string
postcode string
timestamps timestamps

hmo_applicants

id increments
hmo_form_id ^FK integer
title string
name string
telephone string
email string
is_plh boolean
timestamps timestamps

hmo_plh_organisations

id increments
hmo_form_id ^FK integer
contact_name string
organisation_name string
telephone string
email string
timestamps timestamps

hmo_form_safety_arrangements

id increments
hmo_form_id ^FK integer
fire_detection boolean
control_panel boolean
heat_detectors boolean
smoke_detectors_in_rooms boolean
room_smoke_detector_battery_powered boolean
common_smoke_detector boolean
common_smoke_detector_battery_powered boolean
alarm_sounders boolean
system_tested string
fire_doors boolean
fire_blankets enum
safety_equipment_serviced boolean
fire_safety_training_provided boolean
training_details text
fire_risk_assessment_carried_out boolean
gas_appliances boolean
gas_appliances_legal boolean
gas_appliances_checked boolean
plh_gas_appliances_decarlation boolean
furniture_provided boolean
furniture_complies boolean
plh_furniture_declaration boolean
electrical_appliances boolean
electricals_pat_tested boolean
plh_electricals_declaration boolean
timestamps timestamps

hmo_form_property_management

id increments
hmo_form_id integer
regular_inspections boolean
inspection_frequency string
inspections_carried_out_by string
emergency_repair_arrangements boolean
emergency_repair_details text
emergency_contact boolean
timestamps timestamps

hmo_form_households_rooms

id increments
household_id ^FK integer
room_id ^FK integer
timestamps timestamps

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