Inspections - Laravel Schema Designer

inspection_docs

id increments
inspection_report_id ^FK integer
doc_path string
timestamps timestamps
softDeletes softDeletes

inspection_doc_downloads

id increments
inspection_doc_id ^FK integer
downloaded_by integer
doc_downloaded_at datetime

inspection_report_summary

id increments
inspection_report_id ^FK integer
category_order integer
category_name string
saf integer
rr integer
mm integer
ser integer
np integer
ni integer
na tinyInteger
inspection_category_id tinyInteger
timestamps timestamps
softDeletes softDeletes

inspection_reports

id increments
house_id integer
submitted_by integer
inspection_type string (50)
grade string
timestamps timestamps
softDeletes softDeletes

inspection_comments

id increments
inspection_report_id ^FK integer
comment longText
replied_to_comment_id integer
comment_by integer
timestamps timestamps
softDeletes softDeletes

inspection_categories

id increments
name string (100)
all_properties tinyInteger
state string (10)
property_type string (100)
status tinyInteger
timestamps timestamps

inspection_grades

id increments
grade string
grade_discription string
timestamps timestamps

inspection_sharing

id increments
inspection_report_id ^FK integer
shared_by integer
shared_with integer
timestamps timestamps
softDeletes softDeletes

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