erp - Laravel Schema Designer

managments

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
managment_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
attachment_id ^FK integer
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
deleted_at softDeletes
timestamps timestamps

employee_job_informations

id increments
employee_number string
contract_type string
job_id ^FK integer
receiving_work_date date
contract_period integer
salary double
allowance double
housing_allowance enum
housing_allowance_value double
transfer_allowance enum
transfer_allowance_value double
timestamps timestamps

custodies

id increments
type string
number 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

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