candidatures - Laravel Schema Designer

applicants

id increments
degree_level enum
degree_infos string (255)
additional_information text
person_id ^FK integer
job_id ^FK integer
title_id ^FK integer
statute_id ^FK integer
timestamps timestamps
softDeletes softDeletes

title_applicants

id increments
applicant_id ^FK integer
title_id ^FK integer
timestamps timestamps
softDeletes softDeletes

thirds

id increments
dignity string (255)
entity_name string (255)
person_id ^FK integer
timestamps timestamps
softDeletes softDeletes

agents

id increments
name string (128)
firstname string (128)
email string (255)
password string (255)
timestamps timestamps
softDeletes softDeletes

responses

id increments
object string (255)
timestamps timestamps
softDeletes softDeletes

jurys

id increments
place string (255)
date_time datetime
position integer
timestamps timestamps
softDeletes softDeletes

candidacies

id increments
date datetime
processing_step enum
archive boolean
comment text
offer_id ^FK integer
applicant_id ^FK integer
third_id ^FK integer
agent_id ^FK integer
timestamps timestamps
email_send tinyInteger
softDeletes softDeletes
applicant tinyInteger
third tinyInteger
jury_convocation tinyInteger

jury_candidacies

id increments
jury_id ^FK integer
candidacy_id ^FK integer
timestamps timestamps
softDeletes softDeletes

attachments

id increments
origin enum
candidacy_id ^FK integer
timestamps timestamps
softDeletes softDeletes

jobs

id increments
label string (255)
domain enum
timestamps timestamps
softDeletes softDeletes

titles

id increments
label string (255)
slug enum
timestamps timestamps
softDeletes softDeletes

statutes

id increments
label string (255)
timestamps timestamps
softDeletes softDeletes

services

id increments
name string (255)
chief_email string (255)
timestamps timestamps
softDeletes softDeletes

persons

id increments
civility enum
name string (128)
firstname string (128)
email string (255)
address_1 string (255)
address_2 string (255)
address_3 string (255)
zip_code smallInteger
city string (255)
phone_1 integer
phone_2 integer
timestamps timestamps
softDeletes softDeletes

candidacy_services

id increments
candidacy_id ^FK integer
service_id ^FK integer
timestamps timestamps
softDeletes softDeletes

response_candidacy

id increments
candidacy_id ^FK integer
response_id ^FK integer
timestamps timestamps
softDeletes softDeletes

offers

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
active tinyInteger

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