merchant - Laravel Schema Designer

users

id increments
email string (191)
password string (191)
remember_token string (100)
timestamps timestamps
softDeletes softDeletes

people

id increments
user_id ^FK integer
fist_name string (191)
last_name string (191)
fantasy_name string (191)
type boolean
gender boolean
birth_date date
civil_status tinyInteger
nationality string (191)
naturalness string (191)
mother_name string (191)
father_name string (191)
timestamps timestamps
softDeletes softDeletes

person_documents

id increments
person_id ^FK integer
rg char (20)
rg_dispatcher char (20)
ctps_number char (8)
ctps_series char (5)
ctps_uf char (2)
cpf char (11)
cnpj char (11)
timestamps timestamps
softDeletes softDeletes
pis_pasep char (11)

employees

id increments
user_id ^FK integer
person_id ^FK integer
timestamps timestamps
softDeletes softDeletes

employee_contracts

id increments
employee_id ^FK integer
registration_id integer
begin_date date
end_date date
contract_type integer
begin_in_experience boolean
begin_experience_days tinyInteger
determined_time boolean
timestamps timestamps
softDeletes softDeletes

password_resets

id increments
email string (191)
token string
timestamps timestamps

contract_timecards

id increments
contract_id bigInteger
date date
entrance1 time
entrance2 time
entrance3 time
entrance4 time
entrance5 time
entrance6 time
exit1 time
exit2 time
exit3 time
exit4 time
exit5 time
exit6 time
timestamps timestamps

contract_restday_tables

id increments
contract_id bigInteger
name string (191)
year smallInteger
timestamps timestamps

contract_restdays

id increments
restday_table_id bigInteger
name string (191)
begin_date datetime
end_date datetime
timestamps timestamps

contract_settings

id increments
contract_id bigInteger
name string (191)
primary boolean
begin_date date
end_date date
night_hours_begin time
night_hours_end time
eh_percent_between_0_2 decimal (6,2)
eh_percent_between_2_3 decimal (6,2)
eh_percent_between_3_4 decimal (6,2)
eh_percent_between_4_5 decimal (6,2)
eh_percent_more_5 decimal (6,2)
eh_percent_restday decimal (6,2)
limit_hours_day time
limit_hours_week time
work_shift boolean
limit_work_hours_day_in_work_shift time
limit_work_hours_week_in_work_shift time
rest_after_work_in_shift time
timestamps timestamps

contract_roles

id increments
contract_id bigInteger
name string (191)
begin_date date
end_date date
reason string (191)
timestamps timestamps

contract_salary_tables

id increments
contract_id bigInteger
begin_date date
end_date date
reason string (191)
timestamps timestamps

contract_salaries

id increments
salary_table_id bigInteger
value float (8,2)
is_commission boolean
is_min boolean
periodicity_of_payment tinyInteger
timestamps timestamps

contract_vacations

id increments
contract_id bigInteger
begin_acquisition_date date
end_acquisition_date date
begin_concession_date date
end_concession_date date
enjoyed boolean
begin_enjoy_date date
end_enjoy_date date
timestamps timestamps

contract_changes

id increments
contract_id bigInteger
modification_date date
contract_type tinyInteger
experience_renovation boolean
renovation_days tinyInteger
timestamps timestamps

contract_suspensions

id increments
contract_id bigInteger
reason string (191)
begin_suspension_date datetime
end_suspension_date datetime
timestamps timestamps

contract_interruptions

id increments
contract_id bigInteger
reason string (191)
begin_interruption_date datetime
end_interruption_date datetime
timestamps timestamps

contract_stabilities

id increments
contract_id bigInteger
begin_stability_date datetime
end_stability_date datetime
timestamps timestamps
reason string (191)

contract_rescissions

id increments
contract_id bigInteger
employee_category tinyInteger
syndical_code char (15)
syndicate_cnpj char (14)
syndicate_name string (191)
was_warned boolean
warning_date date
rescision_date date
rescision_code char (3)
last_salary float (8,2)
alimone float (8,2)
alimone_on_fgts float (8,2)
timestamps timestamps
softDeletes softDeletes

contract_rescission_composition

id increments
rescision_id bigInteger
code char (6)
title string (191)
value float (8,2)
type boolean
timestamps timestamps
softDeletes softDeletes

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