mlp_after-settlement - Laravel Schema Designer

legal_case_after_settlement

id increments
legal_case_id ^FK bigInteger
gas_plan boolean
internet_plan boolean
electricity_plan boolean
consent_form_pdf_path text
timestamps timestamps

legal_case_service_requests

id increments
legal_case_id ^FK bigInteger
ref_number string
request_user_id bigInteger
request_role_id bigInteger
assignee_user_id bigInteger
assignee_role_id bigInteger
assigned_at datetime
timestamps timestamps
softDeletes softDeletes

legal_case_service_plans

id increments
legal_case_service_request_id ^FK bigInteger
service_type enum
rating tinyInteger
rating_note text
progress_status enum
assignee_user_id bigInteger
assignee_role_id bigInteger
assigned_at datetime
provider_id ^FK bigInteger
bank_id ^FK bigInteger
request_note text
manager_note text
client_note longText
plan_name string
bank_account_number string
price float
is_additional_file_needed boolean
installation_date datetime
is_request_price boolean
is_terminated boolean
terminated_at datetime
termination_note text
timestamps timestamps
softDeletes softDeletes

param_providers

id increments
service_type enum
name string
logo_path string
contact_phone string
contact_email string
additional_info longText
timestamps timestamps
softDeletes softDeletes

plan_attachments

id increments
legal_case_service_plan_id ^FK bigInteger
original_name string
system_name string
file_path string
timestamps timestamps
document_type enum

legal_cases

id increments
timestamps timestamps
softDeletes softDeletes

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