db_devsclub_alpha - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
email string (100)
username string (50)
password string (60)
status tinyInteger
role string (20)
photo_path string (150)
cover_photo_path string (150)
birth_date date
activation_token string (100)
remember_token string (100)

status

id increments
timestamps timestamps
softDeletes softDeletes
body text
user_id ^FK integer
status tinyInteger

comments

id increments
timestamps timestamps
softDeletes softDeletes
comment text
user_id ^FK integer
status_id ^FK integer

companies

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
uri string (100)
website string (100)
email string (100)
logo_photo_path string (150)
cover_photo_path string (150)
address string (250)
latitude string (30)
longitude string (30)
company_type string (30)
business_type string (30)
established_date date
about_company text
phone_number string (20)
is_verified boolean

company_associate_users

id increments
company_id ^FK integer
user_id ^FK integer
role string (20)

on_demand_hire

id increments
timestamps timestamps
softDeletes softDeletes
availability tinyInteger
available_days string (100)
hourly_rate integer
minimum_rate integer
notes text
status tinyInteger

jobs

id increments
timestamps timestamps
softDeletes softDeletes
title string (120)
vacancies integer
nature enum
working_experience_time string (20)
keywords string (100)
salary integer
location string (100)
featured_photo string (100)
company_id ^FK integer

networks

id increments
timestamps timestamps
following_id ^FK integer
follower_id ^FK integer
status boolean

events

id increments
timestamps timestamps
title string (150)
detail text
location string (150)
latitude string (30)
longitude string (30)
start_date date
end_date date
cover_photo_path string (150)
max_seat smallInteger
reg_last_date date
event_type tinyInteger
status tinyInteger
hosted_by ^FK integer
is_paid boolean
price float

event_participant

id increments
timestamps timestamps
role string (20)
is_paid boolean
status tinyInteger
event_id ^FK integer
user_id ^FK integer

users_info

id increments
timestamps timestamps
email string (120)
location string (200)
latitude string (30)
longitude string (30)
mobile string (20)
url string (150)
objective text
nid string (100)
passport string (100)
driving_license string (100)
user_id ^FK integer

educations

id increments
timestamps timestamps
title string (80)
institute string (150)
start_at string (25)
end_at string (25)
major string (80)
gpa float (1,2)
location string (100)
url string (100)
status tinyInteger
user_id ^FK integer

works

id increments
timestamps timestamps
title string (80)
company_name string (100)
company_id ^FK integer
start_at string (25)
end_at string (25)
location string (100)
url string (100)
status tinyInteger
user_id ^FK integer

social_link

id increments
service_name string (20)
url string (150)
status tinyInteger
user_id ^FK integer

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