A contestant is a student who participates in a contest.
|
Attribute |
Data Type |
Definition |
Example |
|---|---|---|---|
|
ContestantID |
int* |
Sequentially generated identifier that uniquely identifies a contestant |
253 |
|
Name |
Char(40)* |
Contestant full name |
Fred Jones |
|
Classification |
Integer* |
Contestant's classification in school |
Values: 31 - Freshman 32 - Sophomore 33 - Junior 34 - Senior |
|
Status |
Char(1)* |
Contestant's registration status |
Values: R - Requested A - Approved |
A submission is a solution submitted by a contestant for judging. A contestant may make many submissions for a given problem.
|
Attribute |
Data Type |
Definition |
Example |
|---|---|---|---|
|
SubmissionID |
Int* |
Sequentially generated identifier that uniquely identifies a submission |
3 |
|
SubmissionTime |
DateTime* |
Date/Time at which submission occurred |
5/2/2006 3:00p |
|
ProblemID |
Integer* |
Number of problem that was submitted |
3 |
|
SubmissionStatus |
Char(1)* |
Status of submission |
Values: S - Submitted J - Judged C - Cancelled |
Key:
Primary key
* - required (NOT NULL)