exteco - Laravel Schema Designer

representatives

id increments
fk_place_id ^FK bigInteger
fk_position_id ^FK bigInteger
position_id bigInteger
timestamps timestamps
softDeletes softDeletes
first_name string
last_name string
email string
phone string
note string
contract boolean

place_types

id increments
timestamps timestamps
softDeletes softDeletes
name string

addresses

id increments
fk_country_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
street string
housenumber_a string
housenumber_b string
zip string
city string

companies

id increments
fk_company_type_id ^FK integer
fk_contract_id ^FK bigInteger
name string
description text
softDeletes softDeletes
timestamps timestamps

places

id increments
fk_company_id ^FK bigInteger
fk_place_type_id ^FK bigInteger
fk_address_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
email string
phone string
ico string
dic string

users

id increments
fk_place_id ^FK bigInteger
fk_position_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

positions

id increments
timestamps timestamps
softDeletes softDeletes
name string

company_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

countries

id increments
timestamps timestamps

meetings

id increments
fk_company_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
matter string
conclusion text

mtasks

id increments
fk_meeting_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
matter string
due timestamp

sessions

id increments
fk_company_id ^FK bigInteger
timestamps timestamps
matter string
softDeletes softDeletes
conclusion text

contracts

id increments
timestamps timestamps
softDeletes softDeletes
name string
filename string

company_countries_pivot

id increments
fk_company_id ^FK bigInteger
fk_country_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

stasks

id increments
fk_session_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
matter string
due timestamp

representatives_stasks_pivot

id increments
fk_stask_id ^FK bigInteger
fk_representative_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

representatives_mtasks_pivot

id increments
fk_mtask_id ^FK bigInteger
fk_representative_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

representative_session

id increments
timestamps timestamps
softDeletes softDeletes
fk_representative_id ^FK bigInteger
fk_session_id ^FK bigInteger

representative_meeting

id increments
timestamps timestamps
softDeletes softDeletes
fk_representative_id ^FK bigInteger
fk_meeting_id ^FK bigInteger

session_user

id increments
timestamps timestamps
softDeletes softDeletes
fk_user_id ^FK bigInteger
fk_session_id ^FK bigInteger

meeting_user

id increments
timestamps timestamps
softDeletes softDeletes
fk_user_id ^FK bigInteger
fk_meeting_id ^FK bigInteger

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