2 files changed, 15 insertions, 0 deletions
diff --git a/backend/db/models.go b/backend/db/models.go
index 35ebd03..5ad4b6b 100644
--- a/backend/db/models.go
+++ b/backend/db/models.go
@@ -29,6 +29,13 @@ type Problem struct {
 	Description string
 }
 
+type Testcase struct {
+	TestcaseID int32
+	ProblemID  int32
+	Stdin      string
+	Stdout     string
+}
+
 type User struct {
 	UserID      int32
 	Username    string
diff --git a/backend/schema.sql b/backend/schema.sql
index f0b5b37..7f98d91 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -39,3 +39,11 @@ CREATE TABLE problems (
     title       VARCHAR(255) NOT NULL,
     description TEXT         NOT NULL
 );
+
+CREATE TABLE testcases (
+    testcase_id SERIAL PRIMARY KEY,
+    problem_id  INT    NOT NULL,
+    stdin       TEXT   NOT NULL,
+    stdout      TEXT   NOT NULL,
+    CONSTRAINT fk_problem_id FOREIGN KEY(problem_id) REFERENCES problems(problem_id)
+);