From 940fc430a5c8fa7a1454cc84586eaca2722ac757 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Mon, 5 Aug 2024 04:36:02 +0900
Subject: feat(backend): create table `submissions` and `testcase_execution`

---
 backend/db/models.go | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'backend/db/models.go')

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
-- 
cgit v1.2.3-70-g09d2