Home
Apoyo
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
clients
id
increments
timestamps
timestamps
name
string
nit
string
phone
string
(15)
email
string
address
string
users_quantity
integer
contact_name
string
(50)
contact_position
string
(50)
logo
string
processes
id
increments
timestamps
timestamps
client_id
FK
integer
profile_id
FK
integer
responsible_id
FK
integer
deadline
date
requirements
text
state
tinyInteger
area
string
company
string
closing_observations
text
start_date
date
candidates
id
increments
timestamps
timestamps
name
string
identification
string
email
string
phone
string
phase_id
FK
integer
process_id
FK
integer
state_id
FK
integer
reason_not_continuous
text
cv
string
(100)
phases
id
increments
required
boolean
name
string
tests
id
increments
timestamps
timestamps
name
string
(50)
url
string
(100)
description
text
protocol_test
id
increments
protocol_id
FK
integer
test_id
FK
integer
users
id
increments
timestamps
timestamps
name
string
email
string
(40)
password
string
client_id
FK
integer
terms_accepted
boolean
position
string
(20)
roles
id
increments
timestamps
timestamps
name
string
display_name
string
description
string
role_user
id
increments
timestamps
timestamps
role_id
FK
integer
user_id
FK
integer
permissions
id
increments
timestamps
timestamps
name
string
description
string
display_name
string
permission_role
id
increments
timestamps
timestamps
role_id
FK
integer
permission_id
FK
integer
interviews
id
increments
timestamps
timestamps
candidate_id
FK
integer
interviewer_name
string
(50)
residence_city
string
description_core_res
text
description_core
text
values
text
education
text
career_path
text
current_salary
string
salary_expectation
string
motivation
text
competence
text
other
text
result
tinyInteger
observations_area_manager
text
tests_results
id
increments
timestamps
timestamps
candidate_id
FK
integer
test_id
FK
integer
description
text
result
tinyInteger
protocols
id
increments
timestamps
timestamps
name
string
competences
id
increments
timestamps
timestamps
name
string
definition
string
(250)
competence_type_id
FK
integer
competence_protocol
id
increments
competence_id
FK
integer
protocol_id
FK
integer
profiles
id
increments
timestamps
timestamps
protocol_id
FK
integer
client_id
FK
integer
position
string
(50)
competence_profile
id
increments
timestamps
timestamps
competence_id
FK
integer
profile_id
FK
integer
score
integer
states
id
increments
name
string
phase_process
id
increments
phase_id
FK
integer
process_id
FK
integer
filter
id
increments
timestamps
timestamps
candidate_id
FK
integer
residence_city
string
relevant_info
text
education_requirements
text
experience_requirements
text
other_requirements
text
current_salary
string
salary_to_change
string
motivation
text
other
text
hiring
id
increments
timestamps
timestamps
candidate_id
FK
integer
hire_date
date
salary
decimal
(8,2)
comments
id
increments
timestamps
timestamps
comment
text
candidate_id
FK
integer
phase_id
FK
integer
statistics
id
increments
timestamps
timestamps
process_id
FK
integer
test_sent
integer
tests_answered
integer
tests_passed
integer
interviews
integer
assessment
integer
security_study
integer
medical_check
integer
hired
integer
questions
id
increments
timestamps
timestamps
item
string
question
string
answer
string
test_id
FK
integer
weight
integer
scale_id
FK
integer
candidate_answers
id
increments
timestamps
timestamps
question_id
FK
integer
candidate_id
FK
integer
sent_test_id
FK
integer
sent_tests
id
increments
timestamps
timestamps
test_id
FK
integer
candidate_id
FK
integer
token
string
baremos
id
increments
timestamps
timestamps
centil
integer
gender_id
FK
integer
position_level_id
FK
integer
test_id
FK
integer
pd_init
integer
pd_end
integer
position_levels
id
increments
timestamps
timestamps
name
string
description
string
gender
id
increments
timestamps
timestamps
name
string
competence_types
id
increments
name
string
(100)
competence_ranges
id
increments
timestamps
timestamps
competence_id
FK
integer
min
integer
max
integer
combination
string
text_1
string
(500)
text_2
text
scales
id
increments
timestamps
timestamps
scale
string
is_factor
boolean
is_scale
boolean
interactions
id
increments
timestamps
timestamps
scale_id
FK
integer
score_level_id
FK
integer
combination
string
(10)
score_levels
id
increments
timestamps
timestamps
name
string
(50)
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01