-
Notifications
You must be signed in to change notification settings - Fork 4
Database Schemas
qtipee edited this page Apr 14, 2020
·
6 revisions
Column | Type | Options |
---|---|---|
id | int | |
user_id | int | |
name | varchar | max=255 |
file | varchar | FileField |
datetime_uploaded | datetime | automatic |
duration | float | [s] |
tempo | int | |
tone | enum | [A-G] |
min_maj | enum | [mM] |
nb_dl_unauthenticated | int |
Uses auth_user table from Django.
Column | Type | Options |
---|---|---|
user_id | int | |
description | text | Rich text ; enables links |
profile_picture | varchar | FileField |
email_public | boolean |
Column | Type | Options |
---|---|---|
user_id | int | |
user_following_id | int |
Column | Type | Options |
---|---|---|
id | int | |
user_id | int | |
sample_id | int | |
datetime_liked | datetime | automatic |
Column | Type | Options |
---|---|---|
id | int | |
user_id | int | |
sample_id | int | |
text | text | |
datetime_posted | datetime | automatic |
Column | Type | Options |
---|---|---|
id | int | |
name | varchar | max=255 |
Column | Type | Options |
---|---|---|
sample_id | int | |
tag_id | int |
Column | Type | Options |
---|---|---|
user_id | int | |
sample_id | int | |
datetime_downloaded | datetime | automatic |
Column | Type | Options |
---|---|---|
id | int | |
sample_id | int | |
sample_from_id | int |
Column | Type | Options |
---|---|---|
id | int | |
sample_id | int | |
sample_to_id | int |