diff options
| -rw-r--r-- | backend/db/models.go | 17 | ||||
| -rw-r--r-- | backend/schema.sql | 18 |
2 files changed, 27 insertions, 8 deletions
diff --git a/backend/db/models.go b/backend/db/models.go index a54fd8c..e60cb8a 100644 --- a/backend/db/models.go +++ b/backend/db/models.go @@ -9,10 +9,19 @@ import ( ) type Game struct { - GameID int32 - Type string - CreatedAt pgtype.Timestamp - State string + GameID int32 + State string + DisplayName string + DurationSeconds int32 + CreatedAt pgtype.Timestamp + StartedAt pgtype.Timestamp + ProblemID pgtype.Int4 +} + +type Problem struct { + ProblemID int32 + Title string + Description string } type User struct { diff --git a/backend/schema.sql b/backend/schema.sql index 6696242..1cd0700 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -16,8 +16,18 @@ CREATE TABLE user_auths ( ); CREATE TABLE games ( - game_id SERIAL PRIMARY KEY, - type VARCHAR(255) NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - state VARCHAR(255) NOT NULL + game_id SERIAL PRIMARY KEY, + state VARCHAR(32) NOT NULL, + display_name VARCHAR(255) NOT NULL, + duration_seconds INT NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + started_at TIMESTAMP, + problem_id INT, + CONSTRAINT fk_problem_id FOREIGN KEY(problem_id) REFERENCES problems(problem_id) +); + +CREATE TABLE problems ( + problem_id SERIAL PRIMARY KEY, + title VARCHAR(255) NOT NULL, + description TEXT NOT NULL ); |