This repository was archived by the owner on Jun 15, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
Database Documentation
Rachel Lau edited this page Apr 27, 2019
·
10 revisions
These tables are defined in server/db/portal.sql
| Column Name | Type | Description |
|---|---|---|
project_id |
SERIAL PRIMARY KEY | This is a unique numerical identifier automatically generated for each project. |
blah |
blah | blah blah blah. |
| Column Name | Type | Description |
|---|---|---|
judgeId |
SERIAL PRIMARY KEY | This is a unique numerical identifier automatically generated for each judge. |
name |
VARCHAR | This displays the name of each judge. |
API |
VARCHAR | This displays the API that judge is using (General Categories means no specific API). |
| Column Name | Type | Description |
|---|---|---|
blah |
blah | blah blah blah. |
| Column Name | Type | Description |
|---|---|---|
judgeId |
INTEGER | This allows us to REFERENCE the judges table using the judgeId as foreign key. |
projectId |
INTEGER | This allows us to REFERENCE the projects table using the projectID as foreign key. |
category |
VARCHAR | This is one of the categories or a single API the project of the row is getting scored for. |
score |
INTEGER | This is a numeric value between 0 and 5 given to the project by the judge for the category of a particular row. |