Database Documentation

These tables are defined in server/db/portal.sql

Projects Table

Column Name	Type	Description
project_id	SERIAL PRIMARY KEY	This is a unique numerical identifier automatically generated for each project.
name	VARCHAR	name of the project
github	VARCHAR	github repo URL of the project
categories	VARCHAR[]	a list of all the categories that this project is set to be judged for. Includes each of the general categories
tableName	VARCHAR	table of this project
wave	INTEGER	wave number during which this project will be judged

Judges Table

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).

APIs Table

Column Name	Type	Description
name	VARCHAR	This is the name of the API being judged, structured as such: '{API Category}: {API Name}', where {API Category} is either API or GC (for general category). An example would be 'API: CodeBase', or 'GC: Best Mobile'.
type	VARCHAR	This is the type of the API being judged, taking on the value of 'API' or 'GC'.

Scores Table

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.