jsa - Laravel Schema Designer

user

id increments
email string
password string
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes

post

id increments
title string (255)
content text
user_id ^FK integer
category_id ^FK integer
slug string (255)
timestamps timestamps
softDeletes softDeletes

category

id increments
name string
slug string
description string
parent_id ^FK integer

tag

id increments
name string
slug string

subscription

id increments
timestamps timestamps

post_tag

id increments
post_id ^FK integer
tag_id ^FK integer

job_advert

id increments
user_id ^FK integer
job_id ^FK integer
nb_of_candidates integer
trainee_accepted boolean
language_id ^FK integer
driving_licence_id ^FK integer
hospitality_id ^FK integer
department_id ^FK integer
speciality_id ^FK integer
public_id ^FK integer
start_date date
end_date date
contract_type_id ^FK integer
wage float
wage_type_id ^FK integer
title string
description string
file binary
contact string
email string
url string
slug string
timestamps timestamps
softDeletes softDeletes

cv

id increments
timestamps timestamps
user_id ^FK integer

course_advert

id increments
user_id ^FK integer
type string
graduation_id ^FK integer
formation_id ^FK integer
single_day boolean
start_date date
end_date date
department_id ^FK integer
address string
zipcode string
city string
price float
description string
contact string
email string
url string
slug string
timestamps timestamps
softDeletes softDeletes

graduation

id increments
name string

language

id increments
code string
name string

driving_licence

id increments
name string

public

id increments
name string

notation

id increments
user_id ^FK integer
post_id ^FK integer
timestamps timestamps

job

id increments
name string

region

id increments
name string

department

id increments
code string
name string
region_id ^FK integer

period

id increments
name string
start_date string
end_date string

formation

id increments
name string

speciality

id increments
name string

hospitality

id increments
name string

contract_type

id increments
name string

address

id increments
timestamps timestamps
user_id ^FK integer

wage_type

id increments
name string

option

id increments
timestamps timestamps
title string
description string
price string

bookmark

id increments
timestamps timestamps
type enum
bookmarkable_id string
user_id ^FK integer

forum_category

id increments

forum_discussion

id increments
timestamps timestamps

forum_post

id increments
timestamps timestamps

day_of_week

id increments
name string

user_pro

id ^FK integer

user_individual

id ^FK integer

job_advert_graduation

id increments
job_advert_id ^FK integer
graduation_id ^FK integer

job_advert_option

id increments
option_id ^FK integer
job_advert_id ^FK integer
timestamps timestamps

course_advert_hospitality

id increments
course_advert_id ^FK integer
hospitality_id ^FK integer

course_advert_day_of_week

id increments
course_advert_id ^FK integer
day_of_week_id ^FK integer

course_advert_option

id increments
option_id ^FK integer
course_advert_id ^FK integer
timestamps timestamps