whitedocs - Laravel Schema Designer

hmo_cases

id increments
user_id integer
organisation_id integer
status_id ^FK integer
reference string (255)
property_id integer
licence_generated boolean
submitted_at timestamp
due_date date
close_reason integer
landlord_last_updated timestamp
new_messages integer
timestamps timestamps

hmo_case_documents

id increments
name string (255)
mime_type string (255)
storage_name string (255)
document_type_id ^FK integer
hmo_case_id ^FK integer
uploaded_by integer
timestamps timestamps

hmo_case_document_types

id increments
name string
timestamps timestamps

case_officer_hmo_cases

id increments
user_id integer
hmo_case_id ^FK integer

hmo_case_associates

id increments
hmo_case_id ^FK integer
user_id integer
associate_type integer
timestamps timestamps

hmo_case_declarations

id increments
name string (255)
hmo_case_id ^FK integer
declaration_type_id integer
date_signed timestamp
timestamps timestamps

hmo_case_statuses

id increments
name string (255)
timestamps timestamps

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