-
Notifications
You must be signed in to change notification settings - Fork 0
Schema
Schploink edited this page May 27, 2021
·
4 revisions
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 |
description |
string | not null |
uploader_id |
integer | not null, indexed, foreign key |
created_at |
datetime | not null |
updated_at |
datetime | not null |
-
uploader_id
referencesusers
- index on
uploader_id
column name | data type | details |
---|---|---|
id |
integer | not null, primary key |
user_id |
integer | not null, indexed, foreign key |
sound_id |
integer | not null, indexed, foreign key |
comment_text |
string | not null |
created_at |
datetime | not null |
updated_at |
datetime | not null |
-
user_id
referencesusers
-
sound_id
referencessounds