project - Laravel Schema Designer

has_skill

id integer
freelancer_id ^FK integer
skill_id ^FK integer
timestamps timestamps

freelancer

id integer
user_account_id ^FK integer
reg_date date
location string (255)
timestamps timestamps

user_account

id integer
user_name string (128)
password string (32)
email string (50)
firstname string (32)
lastname string (32)
timestamps timestamps

client

id integer
company_name string (32)
company_location string (128)
timestamps timestamps

hire_manager

id integer
user_account ^FK integer
reg_date date
location string (128)
company_id ^FK integer
timestamps timestamps

job

id integer
hire_manager_id ^FK integer
description string (512)
main_skill_id ^FK integer
payment_type_id ^FK integer
payment_amount integer
timestamps timestamps

other_skills

id integer
job_id ^FK integer
skill_id ^FK integer
timestamps timestamps

skill

id integer
skill_name string (128)
timestamps timestamps

payment_type

id integer
type_name string (128)
timestamps timestamps

attachment

id integer
message_id ^FK integer
timestamps timestamps

proposal

id string
job_id ^FK integer
freelancer_id ^FK integer
pro_time timestamp
payment_type_id ^FK integer
payment_amount integer
current_proposal_status ^FK integer
client_grade integer
client_commnet text
freelancer_grade integer
freelancer_comment text
timestamps timestamps

message

id integer
freelancer_id ^FK integer
hire_manager_id ^FK integer
message_time timestamp
message_text text
pro_id ^FK integer
proposal_status_catalog ^FK integer
timestamps timestamps

free_proposal_and_contract

id integer
user_account_id ^FK integer
reg_date date
location string (255)
overview text
timestamps timestamps

proposal_status_catalog

id integer
status_name string (255)
timestamps timestamps

company_proposal_and_contract

id integer
timestamps timestamps
comany_name string (32)
company_location string (32)

contract

id integer
pro_id ^FK integer
company_id ^FK integer
freelancer_id ^FK integer
start_time timestamp
end_time timestamp
payment_type_id ^FK integer
payment_amount integer
timestamps timestamps

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