jobizz - Laravel Schema Designer

users

id increments
name string (200)
email string (200)
password string (200)
provider_id bigInteger
provider_name string (200)
rememberToken rememberToken
confermed_email boolean
pin_code char (200)
timestamps timestamps
pin_created_at datetime
email_verified_at timestampTz
fcm_token string (255)

applications

id increments
profile_id integer
job_id integer
status enum
cover_later string (250)
resume_path string (255)
timestamps timestamps

experiences

id increments
profile_id integer
company string (200)
position string (200)
start_date date
end_date date
is_current tinyInteger
description string (255)
location string (200)
image string (255)
timestamps timestamps

educations

id increments
college string (200)
degree string (250)
field_of_study string (200)
start_date date
end_date date
profile_id integer
is_current tinyInteger
description string
location string (200)
image string (255)
timestamps timestamps

documents

id increments
profile_id integer
type enum
name string (200)
image_count integer
format enum
path string (200)
url string (200)
timestamps timestamps

categories

id increments
name string (200)
slug string (200)
image string (200)
timestamps timestamps

jobs

id increments
title string (200)
company_id ^FK integer
category_name string
jop_type string (255)
salary float
description text
requirement text
position enum
job_status enum
location string (255)
benefits string (255)
timestamps timestamps

profiles

id increments
user_id ^FK integer
title_job string (200)
profile_image string
is_default tinyInteger
position_job string (200)
timestamps timestamps

companies

id increments
name string (200)
admin_id ^FK integer
website text
logo string (255)
description string (255)
location string (200)
size string (255)
hired_people string (255)
timestamps timestamps

notifications

id increments
job_id ^FK integer
message string (200)
title string (200)
timestamps timestamps

job_profile

id increments
profile_id ^FK integer
job_id ^FK integer
timestamps timestamps

notification_profile

id increments
timestamps timestamps
notification_id ^FK integer
profile_id ^FK integer

admins

id increments
email string (200)
password string
name string (200)
phone string (200)
photo string (255)
pin_code string (10)
verification_token string (255)
token_created_at timestamp
pin_created_at timestamp
confirmed_email tinyInteger
email_verified_at timeTz
company_id ^FK integer
is_approved tinyInteger
approved_by tinyInteger
timestamps timestamps

application_status_histories

id increments
application_id ^FK integer
status string (200)
feedback string (200)
timestamps timestamps

roles

id increments
name string (200)
guard_name string (200)
timestamps timestamps

permissions

id increments
name string (100)
guard_name string (200)
timestamps timestamps

model_has_roles

role_id integer
model_type string (200)
model_id string (200)

model_has_permissions

permission_id integer
model_type string (200)
model_id integer

role_has_permissions

role_id ^FK integer
permission_id ^FK integer

cache

value string (255)
expiration integer

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