Schema
GilBu edited this page Jun 23, 2020
·
7 revisions
Welcome to the modestpack wiki!
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
username |
string | not null, indexed, unique |
email |
string | not null, indexed, unique |
password_digest |
string | not null |
session_token |
string | not null, indexed, unique |
created_at |
datetime | not null |
updated_at |
datetime | not null |
- index on
username, unique: true
- index on
email, unique: true
- index on
session_token, unique: true
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
title |
string | not null, indexed, unique |
price |
integer | not null |
description |
text | not null |
sale |
integer | not null |
platform |
array | not null |
operating system |
string | not null |
developer |
string | not null |
publisher |
string | not null |
system requirements |
string | not null |
links |
string | |
ratings |
string | |
rating list |
array | |
created_at |
datetime | not null |
updated_at |
datetime | not null |
- index on
title, unique: true
- index on
price
- index on
platform
- index on
operating system
- index on
developer
- index on
publisher
- index on
ratings
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
owner_id |
integer | not null, unique |
game_id |
integer | not null |
purchase_date |
datetime | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
-
owner_id
referenceusers
-
game_id
referencegames
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
user_id |
integer | not null |
fulfilled |
boolean | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
-
user_id
referencesusers
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
cart_id |
integer | not null |
game_id |
integer | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
-
cart_id
referencesshopping_carts
-
game_id
referencesgames
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
name |
name | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
genre_id |
integer | not null |
game_id |
integer | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
-
genre_id
referencesgenres
-
game_id
referencesgames