HICMR - Laravel Schema Designer

facilities

id increments
owner_id ^FK integer
manager_owner_id ^FK integer
timestamps timestamps
softDeletes softDeletes
name string (256)
timezone string (80)
state enum
country string (2)
service_level tinyInteger
category tinyInteger
facility_type enum
legacy_id string (32)
import_id string (64)
source string (32)
import_version string (15)
permissions string
facility_role string (32)

owners

id increments
timestamps timestamps
softDeletes softDeletes
name string (256)
acronym string (8)
owner_type enum
role_type enum
import_id string (64)
source string (32)
import_version string (15)
permissions string
owner_role string (32)

owner_defined_categories

id increments
owner_id ^FK integer
timestamps timestamps
softDeletes softDeletes
name string (128)
description string (256)

facility_classes

id increments
timestamps timestamps
softDeletes softDeletes
name string (128)
description string (256)

facility_facility_classes

id increments
facility_class_id ^FK integer
facility_id ^FK integer
timestamps timestamps

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (120)
last_name string (120)
user_name string (512)
email string (512)
password string (60)
legacy_user_id string (32)
contact_number string (20)
user_type enum
disabled boolean
import_id string (64)
source string (32)
import_version string (15)
whitelist_ips string
token string (256)
token_expires datetime

user_password_histories

id increments
user_id ^FK integer
timestamps timestamps
password string (60)
reason string (64)

user_facilities

id increments
facility_id ^FK integer
user_id ^FK integer
timestamps timestamps
permissions string
user_role enum

departments

id increments
department_type_id ^FK integer
facility_id ^FK integer
timestamps timestamps
softDeletes softDeletes
import_id string (64)
source string (32)
import_version string (15)
scope enum
meta_data string
client_department_name string (256)
client_patient_term string (60)
client_department_type_name string (256)

department_types

id increments
timestamps timestamps
name string (64)
description string (256)
code string (10)
acronym string (8)

assessments

id increments
department_id ^FK integer
tool_id ^FK integer
previous_assessment_id ^FK integer
timestamps timestamps
softDeletes softDeletes
import_id string (64)
source string (32)
import_version string (15)
date_conducted timestamp
tool_version_major tinyInteger
assessment_type enum
assessment_class enum
user_id ^FK integer
tool_version_minor tinyInteger
tool_version_patch integer
tool_version_label string (16)
assessment_dats string

tools

id increments
timestamps timestamps
softDeletes softDeletes
title string (64)
import_id string (64)
description string (256)
source string (32)
import_version string (15)

reviews

id increments
timestamps timestamps
softDeletes softDeletes
facility_id ^FK integer
owner_id ^FK integer
import_id string (64)
title string (128)
source string (32)
description string (512)
import_version string (15)
year smallInteger
month smallInteger

review_assessments

id increments
timestamps timestamps
assessment_id ^FK integer
review_id ^FK integer

facility_owner_defined_categories

id increments
timestamps timestamps
owner_defined_category_id ^FK integer
facility_id ^FK integer

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