erp - Laravel Schema Designer

managements

id increments
name string
parent_id ^FK integer
image string
description text
deactivated_at timestamp
deleted_at timestamp
timestamps timestamps

jobs

id increments
name string
management_id ^FK integer
description text
deactivated_at timestamp
deleted_at timestamp
timestamps timestamps

employees

id increments
image string
identification_number string (10)
nationality_id ^FK integer
first_name string (60)
second_name string (60)
third_name string (60)
last_name string (60)
phone string
identity_date date
identity_source string
date_of_birth date
marital_status enum
email string
gender enum
qualification string
address string
employee_job_information_id ^FK integer
deactivated_at timestamp
deleted_at softDeletes
timestamps timestamps

nationalities

id increments
name string
deactivated_at timestamp
deleted_at softDeletes
timestamps timestamps

attachments

id increments
file string
type string
employee_id ^FK integer
deleted_at softDeletes
timestamps timestamps

employee_job_informations

id increments
job_id ^FK integer
employee_number string
contract_type string
receiving_work_date date
contract_period integer
salary double
salary_percentage double
timestamps timestamps

custodies

id increments
type string
count integer
description text
received_date date
delivery_date date
employee_id ^FK integer
deleted_at softDeletes
timestamps timestamps

users

id increments
employee_id ^FK integer
employee_number string
password string
is_send_otp tinyInteger
otp string (8)
blocked_key string
deactivated_from timestamp
deactivated_at timestamp
deleted_at softDeletes
timestamps timestamps

allowances

id increments
title string (100)
timestamps timestamps
softDeletes softDeletes

allowance_employee

id increments
allowance_id ^FK integer
employee_id ^FK integer
value double
timestamps timestamps
softDeletes softDeletes

customer_services

id increments
employee_id ^FK integer
status string (40)
calls_count integer
sms_messages_count integer
whatsapp_messages_count integer
call_duration time
call_duration_average time
rate double
timestamps timestamps
softDeletes softDeletes

calls

id increments
customer_name string
phone string (10)
call_duration time
identification_number string (10)
customer_service_id ^FK integer
softDeletes softDeletes
timestamps timestamps

call_access_employees

id increments
call_id ^FK integer
employee_id ^FK integer
softDeletes softDeletes
timestamps timestamps

messages

id increments
customer_name string (150)
phone string (10)
identification_number string (10)
customer_service_id ^FK integer
type string (50)
content string (255)
timestamps timestamps
softDeletes softDeletes

meetings

id increments
title string (150)
employee_id ^FK integer
meeting_date datetime
meeting_room_id ^FK integer
type string (20)
meeting_duration smallInteger
note text
status enum
timestamps timestamps
softDeletes softDeletes

employee_meeting

id increments
employee_id ^FK integer
meeting_id ^FK integer
timestamps timestamps
softDeletes softDeletes

meeting_rooms

id increments
name string (50)
timestamps timestamps
softDeletes softDeletes

meeting_discussion_points

id increments
content text
meeting_id ^FK integer
timestamps timestamps
softDeletes softDeletes

meeting_decisions

id increments
content text
meeting_id ^FK integer
timestamps timestamps
softDeletes softDeletes

visits

id increments
date datetime
management_id ^FK integer
type string (150)
note text
status enum
timestamps timestamps
softDeletes softDeletes

appointments

id increments
employee_id ^FK integer
appointment_date datetime
title string (150)
details mediumText
timestamps timestamps
softDeletes softDeletes

visitors

id increments
name string (150)
identity_number string (12)
visit_id ^FK integer
timestamps timestamps

employee_visit

id increments
employee_id ^FK integer
visit_id ^FK integer
timestamps timestamps

reception_reports

id increments
title string (150)
management_id ^FK integer
description text
status enum
date datetime
timestamps timestamps
softDeletes softDeletes

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