diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-05 04:36:02 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-05 05:14:30 +0900 |
| commit | 940fc430a5c8fa7a1454cc84586eaca2722ac757 (patch) | |
| tree | 1f17376f1c49d8b4f61a0add377be102e057943a /backend/db/models.go | |
| parent | 296aa3f8a145a8fbc08db9f5b1d45fe6f72a38a4 (diff) | |
| download | phperkaigi-2025-albatross-940fc430a5c8fa7a1454cc84586eaca2722ac757.tar.gz phperkaigi-2025-albatross-940fc430a5c8fa7a1454cc84586eaca2722ac757.tar.zst phperkaigi-2025-albatross-940fc430a5c8fa7a1454cc84586eaca2722ac757.zip | |
feat(backend): create table `submissions` and `testcase_execution`
Diffstat (limited to 'backend/db/models.go')
| -rw-r--r-- | backend/db/models.go | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/backend/db/models.go b/backend/db/models.go index 51157bc..431d860 100644 --- a/backend/db/models.go +++ b/backend/db/models.go @@ -30,6 +30,15 @@ type Problem struct { Description string } +type Submission struct { + SubmissionID int32 + GameID int32 + UserID int32 + Code string + CodeSize int32 + CreatedAt pgtype.Timestamp +} + type Testcase struct { TestcaseID int32 ProblemID int32 @@ -37,6 +46,15 @@ type Testcase struct { Stdout string } +type TestcaseExecution struct { + TestcaseExecutionID int32 + SubmissionID int32 + TestcaseID *int32 + Status string + Stdout string + Stderr string +} + type User struct { UserID int32 Username string |