wefund - Laravel Schema Designer

users

id increments
name string (50)
email string (50)
password string (60)
phone_no string (20)
birthday date
gender tinyInteger
country string (25)
city string (25)
info string (500)
facebook string (150)
youtube string (150)
website string (150)
permission tinyInteger
avator string (150)
facebook_id string (150)
remember_token string (100)
created_at timestamp
updated_at timestamp

projects

id increments
name string (16)
class tinyInteger
pre_amount decimal (8,2)
outline string (255)
start_data date
end_date date
cover_img_path string (100)
video_link string (100)
content text
status tinyInteger
hitpoint integer
created_date timestamp
updated_at timestamp
starters_id ^FK integer

project_reward

id increments
reward_amount float (8,2)
reward_img string (100)
reward_introduction string
created_at timestamp
updated_at timestamp
project_id ^FK integer

project_report

id increments
report_title string (100)
report_content text
created_at timestamp
updated_at timestamp
project_id ^FK integer

project_qandas

id increments
qanda_content string (500)
qanda_answer string (500)
created_at timestamp
updated_at timestamp
project_id ^FK integer
user_id ^FK integer

suggestions

id increments
starter_info string (500)
project_info string (500)
project_outline string (500)
project_reward string (500)
project_id ^FK integer
user_id ^FK integer
created_at timestamp
updated_at timestamp

sponsors

id increments
company_name string (50)
logo_path string (100)
updated_at timestamp
created_at date
user_id ^FK integer

payments

id increments
amount decimal (8,2)
type tinyInteger
created_at timestamp
updated_at timestamp
user_id ^FK integer
project_id ^FK integer

messages

id increments
user_id ^FK integer
receiver_id ^FK integer
title string (150)
content string (500)
ifread tinyInteger
created_at timestamp
updated_at timestamp

follow_projects

id increments
created_at timestamp
updated_at timestamp
project_id ^FK integer
user_id ^FK integer

sponsor_projects

id increments
amount decimal (8,2)
messages string (500)
created_at timestamp
updated_at timestamp
sponsor_id ^FK integer
project_id ^FK integer

password_resets

email string (255)
token string (255)
created_at timestamp

starters

id increments
name string (50)
id_no string (25)
email string (50)
phone_no string (20)
introduction string (1000)
created_at timestamp
updated_at timestamp
user_id ^FK integer

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