AnswerSubmission and SummerSubmission

AnswerSubmission

The AnswerSubmission model tracks user answers to regular challenges. Table name: answer_submission

Fields

Integer

required

Primary key, auto-incrementing

user_id

Integer

required

Foreign key to users.id (indexed)

challenge_id

Integer

required

Foreign key to challenge.id (indexed)

answer_box_id

Integer

required

Foreign key to challenge_answer_box.id (indexed)

answer

String(100)

required

User’s submitted answer

is_correct

Boolean

Whether the answer was correct (nullable)

submitted_at

DateTime

default:"datetime.datetime.now"

required

Submission timestamp (indexed)

Relationships

Show user

Many-to-one relationship with User

Back populates: submissions

Show challenge

Many-to-one relationship with Challenge

Back populates: submissions

Show answer_box

Many-to-one relationship with ChallengeAnswerBox

Back populates: submissions

Indexes

Composite indexes for optimized query patterns:

ix_answer_submission_user_challenge on (user_id, challenge_id)
ix_answer_submission_challenge_submitted on (challenge_id, submitted_at)

SummerSubmission

The SummerSubmission model tracks user answers to summer competition challenges. Table name: summer_submission

Fields

Integer

required

Primary key, auto-incrementing

user_id

Integer

required

Foreign key to users.id (indexed)

school_id

Integer

required

Foreign key to school.id (indexed)

challenge_id

Integer

required

Foreign key to summer_challenge.id (indexed)

answer_box_id

Integer

required

Foreign key to summer_challenge_answer_box.id (indexed)

answer

String(100)

required

User’s submitted answer

is_correct

Boolean

Whether the answer was correct (nullable)

submitted_at

DateTime

default:"datetime.datetime.now"

required

Submission timestamp (indexed)

points_awarded

Integer

default:"0"

required

Points awarded for this submission

Relationships

Show user

Many-to-one relationship with User (via backref)

Backref: summer_submissions
Lazy loading: dynamic

Show school

Many-to-one relationship with School (via backref)

Backref: summer_submissions
Lazy loading: dynamic

Show challenge

Many-to-one relationship with SummerChallenge

Back populates: submissions

Show answer_box

Many-to-one relationship with SummerChallengeAnswerBox

Back populates: submissions

Indexes

Composite indexes for optimized query patterns:

ix_summer_submission_user_challenge on (user_id, challenge_id)
ix_summer_submission_school_points on (school_id, points_awarded)

Routes

Models

Utilities