aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/schema.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2024-08-07 22:49:33 +0900
committernsfisis <nsfisis@gmail.com>2024-08-08 04:02:37 +0900
commit5a2217f7a9d01b925c3db6491a363e6e4db9ca42 (patch)
tree9b6dcc019834a720a97348d26f1942eb05e84ec1 /backend/schema.sql
parentd799993a4fe0d05aa72c9a48d4a76c6db2240038 (diff)
downloadiosdc-japan-2024-albatross-5a2217f7a9d01b925c3db6491a363e6e4db9ca42.tar.gz
iosdc-japan-2024-albatross-5a2217f7a9d01b925c3db6491a363e6e4db9ca42.tar.zst
iosdc-japan-2024-albatross-5a2217f7a9d01b925c3db6491a363e6e4db9ca42.zip
feat(backend): rename testcase_executions to testcase_results
Diffstat (limited to 'backend/schema.sql')
-rw-r--r--backend/schema.sql16
1 files changed, 8 insertions, 8 deletions
diff --git a/backend/schema.sql b/backend/schema.sql
index 27a63d1..3cc7ed9 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -64,14 +64,14 @@ CREATE TABLE submissions (
CONSTRAINT fk_user_id FOREIGN KEY(user_id) REFERENCES users(user_id)
);
-CREATE TABLE testcase_executions (
- testcase_execution_id SERIAL PRIMARY KEY,
- submission_id INT NOT NULL,
- testcase_id INT NOT NULL,
- status VARCHAR(16) NOT NULL,
- stdout TEXT NOT NULL,
- stderr TEXT NOT NULL,
+CREATE TABLE testcase_results (
+ testcase_result_id SERIAL PRIMARY KEY,
+ submission_id INT NOT NULL,
+ testcase_id INT NOT NULL,
+ status VARCHAR(16) NOT NULL,
+ stdout TEXT NOT NULL,
+ stderr TEXT NOT NULL,
CONSTRAINT fk_submission_id FOREIGN KEY(submission_id) REFERENCES submissions(submission_id),
CONSTRAINT fk_testcase_id FOREIGN KEY(testcase_id) REFERENCES testcases(testcase_id)
);
-CREATE INDEX idx_testcase_executions_submission_id ON testcase_executions(submission_id);
+CREATE INDEX idx_testcase_results_submission_id ON testcase_results(submission_id);