diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-29 03:14:03 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-29 03:14:03 +0900 |
| commit | 3f95e0e6d62267cf8863e98f3ab7de8971a91000 (patch) | |
| tree | 58d12a4657445f17282cff3f1a9742d520379e5d | |
| parent | 19b19e7f48d6375806f827713a98cffd2c57a434 (diff) | |
| download | phperkaigi-2025-albatross-3f95e0e6d62267cf8863e98f3ab7de8971a91000.tar.gz phperkaigi-2025-albatross-3f95e0e6d62267cf8863e98f3ab7de8971a91000.tar.zst phperkaigi-2025-albatross-3f95e0e6d62267cf8863e98f3ab7de8971a91000.zip | |
feat: add testcases table
| -rw-r--r-- | backend/db/models.go | 7 | ||||
| -rw-r--r-- | backend/schema.sql | 8 |
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) +); |