Skip to content
This repository was archived by the owner on Jun 15, 2020. It is now read-only.

Database Documentation

Jump to bottom
Parth Shah edited this page Apr 26, 2019 · 10 revisions

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

Judges Table

Column Name Type Description
blah blah blah blah blah.

APIs Table

Column Name Type Description
blah blah blah blah blah.

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.
Clone this wiki locally