m2a - Laravel Schema Designer

companies

id increments
timestamps timestamps
name string (200)
siret bigInteger
siren bigInteger
address string
city string
postal_code string
country string
phone string
contact_name string
archived boolean
region_id ^FK bigInteger
sector_id ^FK bigInteger
user_id ^FK bigInteger

users

id increments
timestamps timestamps

employees

id increments
timestamps timestamps
firstname string
lastname string
birthday date
gender string (25)
archived boolean
company_id ^FK bigInteger

regions

id increments
name string (200)

business_lines

id increments
name string
code string (10)

indicators

id increments
code string
type string

companies_indicators

id increments
timestamps timestamps
company_id ^FK bigInteger
indicator_id ^FK bigInteger

employees_jobs

id increments
timestamps timestamps
start date
end date
salary_gross float
base_hour float
handicap boolean
regrading boolean
work_hardness integer
quiet_days boolean
employee_id ^FK bigInteger
business_branches_id ^FK bigInteger
business_job_id ^FK bigInteger
professional_class_id smallInteger
contract_id smallInteger
position string (5)
coefficient integer
ending_argument_id ^FK bigInteger

employees_formations

id increments
timestamps timestamps
start date
end date
name string
mandatory boolean
employee_id ^FK bigInteger

employees_conflicts

id increments
timestamps timestamps
start date
end date
name string
employee_id ^FK bigInteger

employees_absenteeisms

id increments
timestamps timestamps
start date
end date
argument_id smallInteger
employee_id ^FK bigInteger

employees_formations_absenteeisms

id increments
timestamps timestamps
start date
end date
argument_id smallInteger
formation_id ^FK bigInteger

business_branches

id increments
name string
company_id ^FK bigInteger
timestamps timestamps

business_jobs

id increments
timestamps timestamps
name string
company_id ^FK bigInteger

business_branches_jobs

id increments
timestamps timestamps
business_branch_id ^FK bigInteger
business_job_id ^FK bigInteger

ending_arguments

id increments
contract_id smallInteger
source string
name string

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