Wafir ERD - Laravel Schema Designer

users

id bigIncrements
timestamps timestamps
name string
email string
password string
status string
remember_token string
email_verified_at timestamp
created_at date
updated_at date

roles

id increments
timestamps timestamps
name string
updated_at date
created_at date

permissions

id increments
timestamps timestamps
name string
updated_at date
created_at date

user_roles

id increments
timestamps timestamps
user_id ^FK integer
role_id ^FK integer
created_at date

role_permissions

id increments
timestamps timestamps
role_id ^FK integer
permission_id ^FK integer
created_at date
updated_at date

zones

id increments
timestamps timestamps
name string
zone_code string
created_at date
updated_at date

facilities

id increments
timestamps timestamps
user_id ^FK integer
zone_id ^FK integer
name string
license_number string
location string
compliance_percentage decimal
status string
created_at date
updated_at date

inspector_profiles

id increments
timestamps timestamps
user_id ^FK integer
zone_id ^FK integer
max_daily_visits integer
created_at date
updated_at date

packages

id increments
timestamps timestamps
name string
description text
created_at date
updated_at date

services

id increments
timestamps timestamps
name string
description text
created_at date
updated_at date

package_services

id increments
timestamps timestamps
package_id ^FK integer
service_id ^FK integer
default_visits integer
sort_order integer
created_at date
updated_at date

attachments

id increments
timestamps timestamps
file_url string
mime_type string
size integer
created_at date
updated_at date

facility_packages

id increments
timestamps timestamps
facility_id ^FK integer
package_id ^FK integer
start_date date
end_date date
price decimal
contract_file_id ^FK integer
status string
created_at date
updated_at string

facility_services

id increments
timestamps timestamps
facility_package_id ^FK integer
service_id ^FK integer
visit_count integer
status string
created_at string
updated_at string

applications

id increments
timestamps timestamps
facility_id ^FK integer
user_id ^FK integer
package_id ^FK bigInteger
status string
rejection_reason string
created_at date
updated_at string

application_documents

id increments
timestamps timestamps
application_id ^FK integer
attachment_id ^FK integer
doc_type string
created_at date
updated_at date

report_templates

id increments
timestamps timestamps
service_id ^FK integer
name string
description text
created_at date
updated_at date

template_versions

id increments
timestamps timestamps
report_template_id ^FK integer
version_number string
is_active boolean
created_at date
updated_at date

question_bank

id increments
timestamps timestamps
text text
type string
weight integer
violation_id ^FK integer
default_corrective_action text
requires_attachment boolean
created_at date
updated_at date

question_options

id increments
timestamps timestamps
question_id ^FK integer
value string
label string
sort_order integer
created_at date
updated_at date

template_questions

id increments
timestamps timestamps
template_version_id ^FK integer
question_id ^FK integer
sort_order integer
created_at date
updated_at date

appointments

id increments
timestamps timestamps
facility_id ^FK integer
facility_service_id ^FK integer
inspector_id ^FK integer
supervisor_id ^FK integer
template_version_id ^FK integer
scheduled_start datetime
scheduled_end datetime
current_status_id ^FK integer
created_at date
updated_at date

report_submissions

id increments
timestamps timestamps
appointment_id ^FK integer
inspector_id ^FK integer
started_at datetime
submitted_at datetime
status string
compliance_percentage decimal
pdf_url string
created_at date
updated_at date
verified_by ^FK integer
verified_at datetime
review_notes text

answers

id increments
timestamps timestamps
report_submission_id ^FK integer
template_question_id ^FK integer
value text
compliant boolean
weight integer
created_at date
updated_at date

violations

id increments
timestamps timestamps
code string
title string
description text
fine_amount decimal
created_at date
updated_at date

tickets

id increments
timestamps timestamps
facility_id ^FK integer
appointment_id ^FK integer
status string
created_at date
updated_at date

ticket_versions

id increments
timestamps timestamps
ticket_id ^FK integer
version_number integer
created_at date
updated_at date

ticket_items

id increments
timestamps timestamps
ticket_version_id ^FK integer
question_id ^FK integer
violation_id ^FK integer
priority string
status string
corrective_action text
notes text
created_at date
updated_at date

notifications

id increments
timestamps timestamps
notifiable_type string
notifiable_id bigInteger
channel string
title string
message text
read_at timestamp
created_at date
updated_at date

attachment_links

id increments
timestamps timestamps
attachment_id ^FK integer
attachable_type string
attachable_id bigInteger
created_at date
updated_at date

kitchens

id increments
timestamps timestamps
facility_id ^FK integer
name string
zone_id ^FK integer
address string
is_active boolean

report_sections

id increments
timestamps timestamps
template_version_id ^FK integer
name string
sort_order integer

requirements

id increments
timestamps timestamps
level enum
package_id ^FK integer
service_id ^FK integer
name string
description text
is_mandatory boolean

facility_requirement_submissions

id increments
timestamps timestamps
facility_id ^FK integer
requirement_id ^FK integer
attachment_id ^FK integer
status enum
reviewed_by ^FK integer
reviewed_at datetime
note text

lookup_groups

id increments
timestamps timestamps
code string
name string

lookup_values

id increments
timestamps timestamps
group_id ^FK integer
code string
label string
sort_order integer
color string
is_active boolean

appointment_status_history

id increments
timestamps timestamps
appointment_id ^FK integer
status_id ^FK integer
changed_by ^FK integer
changed_at timestamp
note text