dbstructure.txt

DevPledge


users
____
user_id
first_name
last_name
email
dob
git_hub_id
facebook_id
google_id
developer
password
data
created
modified

api_keys
_______
api_key_id
api_key
user_id
organisation_id
created
modified


organisations
_________
organisation_id
name
data
created
modified


user_organisation_maps
_______________
user_organisation_map_id
user_id
organisation_id
role (admin, guest)
created
modified


data_backups
___________
data_backup_id
table
primary_id
data
created


problems
_______
problem_id
user_id
organisation_id
title
description
specification
active_datetime
deadline_datetime (optional)
open_source_location (GitHub)
deleted
data
created
modified


problem_change_logs
_______________
problem_change_log_id
problem_id
user_id
name
description
spec
active_datetime
deadline_datetime
open_source_location
deleted
data
created


pledges
______
pledge_id
user_id
organisation_id
problem_id
kudos_points
value
currency
comment (optional)
data
created
modified

(Programming)
languages
________
language_id
name
description
example
data
created
modified


frameworks
________
framework_id
name
description
example
data
created
modified


problem_language_maps
___________________
problem_language_map_id
problem_id
language_id
optional
created
modified


problem_framework_maps
___________________
problem_language_map_id
problem_id
framework_id
optional
created
modified


solutions
_________
solution_id
problem_solution_group_id
solution_group_id
user_id
problem_id
open_source_location
data
created
modified

(Only for the life of the problem)
problem_solution_groups
_______________
problem_solution_group_id
problem_id
user_id
name
created
modified


user_problem_solution_group_maps
________________________
user_problem_solution_group_map_id
problem_solution_group_id
user_id
created
modified

(Permanent group)
solution_groups
_______________
solution_group_id
user_id
name
description
created
modified

user_solution_group_maps
________________________
user_solution_group_map_id
solution_group_id
user_id
created
modified


problem_like_maps
______________
problem_like_map
problem_id
user_id
type ( yes | no )
created
modified


solution_like_maps
_________________
solution_like_map
solution_id
user_id
type ( yes | no )
created
modified


organisation_like_maps
___________________
organisation_like_map
organisation_id
user_id
type ( yes | no )
created
modified


problem_comments
_______________
problem_comment_id
user_id
problem_id
comment
reply_comment_id
created
modified


problem_comment_like_maps
_______________________
problem_comment_like_map_id
user_id
problem_id
type
created
modified


payments
________
payment_id
user_id
solution_id
from_user_id
from_organiser_id
value
currency
paid
data
created
modified


connect_user_maps
______________
connect_user_map_id
user_id
follow_user_id
block
data
created
modified


follow_user_maps
______________
follow_user_map_id
user_id
follow_user_id
created
modified


follow_organisation_maps
____________________
follow_organisation_map_id
user_id
follow_organisation_id
created
modified


follow_language_maps
____________________

follow_language_map_id
user_id
follow_language_id
created
modified


follow_framework_maps
____________________

follow_framework_map_id
user_id
follow_framework_id
created
modified


private_messages
______________
private_message_id
organisation_id
user_id
to_user_id
message
created
modified


feature_maps
___________
feature_map_id
problem_id
solution_id
user_id
comment_id
position


kudos
_____
kudos_id
user_id
from_user_id
organisation_id
points
created
modified