ate_recruitment - Laravel Schema Designer

users

id increments
timestamps timestamps
email string
password string
company_id ^FK integer
agent_id ^FK integer

applications

id increments
timestamps timestamps
user_id ^FK integer
type string (255)
first_name string
last_name string
sex string
birthdate date
birthplace string
passport_number string
mothers_name string
phone string
contact_name string
contact_relationship string
contact_email string
contact_phone string
speaks_hungarian boolean
application_period_id ^FK integer
citizenship ^FK integer
citizenship2 ^FK integer

documents

id increments
timestamps timestamps
path string (255)
order smallInteger
type string (255)

exams

id increments
timestamps timestamps
name string
seats smallInteger
type string

payments

id increments
timestamps timestamps
type string
amount integer

transactions

id increments
timestamps timestamps
payment_id ^FK integer
type string
status string
vendor_id string

state_histories

id increments
timestamps timestamps

educations

id increments
timestamps timestamps
application_id ^FK integer
name string
location string
date_from date
date_to date
type string

addresses

id increments
timestamps timestamps
country_id integer
postal_code string
city string
street string
number string
type enum
application_id ^FK integer

languages

id increments
timestamps timestamps
name_en string
name_de string
code string

application_periods

id increments
timestamps timestamps
start_date datetime
end_date datetime
type string

companies

id increments
timestamps timestamps

countries

id increments
timestamps timestamps

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