flancy - Laravel Schema Designer

users

user_id increments
email string (100)
password string (255)
type enum
notifications string
messages string
timestamps timestamps

enterprises

enterprise_id ^FK integer
enterprise_name string
phone integer
logo string (100)
enterprise_document string (100)
coins integer
premuim boolean
timestamps timestamp
country string
city string
address string

freelancers

freelancer_id ^FK integer
first_name string
last_name string
phone integer
image string (20)
freelancer_curriculum_vitae string (20)
premium boolean
coins integer
address string

skills

skill_id increments
title string (20)

projects

project_id increments
id_enterprise ^FK integer
title string (50)
description text
duration integer
timestamps timestamps

challenges

challenge_id increments
project_id ^FK integer
description text
challenge_document string
start_date datetime
end_date string
winner_number integer
timestamps timestamps

devices

device_id increments
user_id ^FK integer
deviceToken string (50)
platform string (20)
timestamps string

criterions

criterion_id increments
timestamps timestamps
title string
challenge_id ^FK integer

transactions

transaction_id increments
user_id ^FK integer
pack_id ^FK integer
transactionToken string (256)
price float
status integer
timestamps timestamps

packs

pack_id increments
title string (50)
price float
coins integer
description string
timestamps timestamps

challenge_freelancer_participation

freelancer_participation_id increments
id_challenge ^FK integer
id_freelancer ^FK integer
timestamps timestamps
document string

freelancer_project_interest

freelancer_project_interest_id increments
freelancer_id ^FK integer
project_id ^FK integer
timestamps timestamps

project_skill_required

skill_required_id increments
id_project ^FK integer
id_skill ^FK integer

freelancer_skill

freelancer_skill_id increments
skill_id ^FK integer
freelancer_id ^FK integer

features

feature_id increments
title string
description string
price_coins integer
type integer
timestamps timestamps

freelancer_criterion_evaluation

freelancer_evalution_id increments
timestamps timestamps
mark float
freelancer_id ^FK integer
criterion_id ^FK integer

user_feature_log

user_feature_id increments
user_id ^FK integer
feature_id ^FK integer
timestamps timestamps

freelancer_profile_unblocked

freelancer_profile_unblocked_id increments
freelancer_unblocked_id string
freelancer_id ^FK integer
enterprise_id ^FK integer
timestamps timestamps

notifications

notification_id increments
title string

user_notification

user_notification_id increments
notified_id ^FK integer
notification_id ^FK integer
notifier_id ^FK integer
timestamps timestamps

project_comments

project_comment_id increments
project_id ^FK integer
user_id ^FK integer
content text
timestamps timestamps

messages

message_id increments
receiver_id ^FK integer
sender_id ^FK integer
content text
timestamps timestamps

discussions

discussion_id increments
message_id ^FK integer
content string
timestamps timestamps

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