diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-07 23:22:07 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-08 04:02:37 +0900 |
| commit | 47d81ffbd3e4fe178d2935325e312cef77276250 (patch) | |
| tree | 341f7aaa3429dbecc60cbfad0a84e6846152814e /backend/schema.sql | |
| parent | 14f48b4e4f7463e0972c2a5b39e94ee674ec93ba (diff) | |
| download | phperkaigi-2025-albatross-47d81ffbd3e4fe178d2935325e312cef77276250.tar.gz phperkaigi-2025-albatross-47d81ffbd3e4fe178d2935325e312cef77276250.tar.zst phperkaigi-2025-albatross-47d81ffbd3e4fe178d2935325e312cef77276250.zip | |
feat(backend): create submission_results table
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/backend/schema.sql b/backend/schema.sql index 7188d72..74d1202 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -64,6 +64,17 @@ CREATE TABLE submissions ( CONSTRAINT fk_user_id FOREIGN KEY(user_id) REFERENCES users(user_id) ); +CREATE TABLE submission_results ( + submission_result_id SERIAL PRIMARY KEY, + submission_id INT NOT NULL UNIQUE, + status VARCHAR(16) NOT NULL, + stdout TEXT NOT NULL, + stderr TEXT NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + CONSTRAINT fk_submission_id FOREIGN KEY(submission_id) REFERENCES submissions(submission_id) +); +CREATE INDEX idx_submission_results_submission_id ON submission_results(submission_id); + CREATE TABLE testcase_results ( testcase_result_id SERIAL PRIMARY KEY, submission_id INT NOT NULL, |