Database Reference¶
users
Table¶
The users
table stores all the users. With DynamoDB, we only need to specify a
fixed attribute to be the primary index. In this case, the user’s slack_id
is
the primary index. All other attributes are specified in the model/user.py
file, and are also listed here:
Attribute Name | Description |
---|---|
slack_id |
String ; The user’s slack id |
email |
String ; The user’s email address |
github |
String ; The user’s Github handler |
github_user_id |
String ; The user’s Github user ID |
major |
String ; The subject major the user is in |
position |
String ; The user’s position in Launch Pad |
bio |
String ; A short (auto)biography |
image_url |
String ; The user’s avatar image URL |
permission_level |
String ; The user’s permission level |
karma |
Integer ; The user’s karma points |
The user’s permission level is one of [member
, admin
, team_lead
].
teams
Table¶
The teams
table stores all teams where github_team_id
is the primary index.
All other attributes are specified in the model/team.py
file, and are also
listed here:
Attribute Name | Description |
---|---|
github_team_id |
String ; The team’s Github ID |
github_team_name |
String ; The team’s Github name |
display_name |
String ; The teams’s display |
platform |
String ; The team’s working platform |
team_leads |
String Set ; The team’s set of team leads’ Github IDs |
members |
String Set ; The team’s set of members’ Github IDs |
projects
Table¶
The projects
table stores all projects where project_id
is the primary
index. All other attributes are specified in the model/project.py
file, and
are also listed here:
Attribute Name | Description |
---|---|
project_id |
String ; The project’s unique SHA1 ID, salted with a timestamp |
github_team_id |
String ; The team’s Github ID associated with the project |
github_urls |
String Set ; A set of URLs pointing to project repositories |
display_name |
String ; A name for the project |
short_description |
String ; A short description that outlines the project |
long_description |
String ; A longer and more in-depth description |
tags |
String Set ; A set of tags taken from the Github repositories |
website_url |
String ; A URL to the project’s website |
medium_url |
String ; A URL to the project’s medium page |
appstore_url |
String ; A URL to the project’s Apple Appstore page |
playstore_url |
String ; A URL to the project’s Google Playstore page |