Database Schemas

Database Schemas

How to store files ?

Samples

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

Users

Uses auth_user table from Django.

UsersProfiles

Column	Type	Options
user_id	int
description	text	Rich text ; enables links
profile_picture	varchar	FileField
email_public	boolean

UsersFollowings

Column	Type	Options
user_id	int
user_following_id	int

Likes

Column	Type	Options
id	int
user_id	int
sample_id	int
datetime_liked	datetime	automatic

Comments

Column	Type	Options
id	int
user_id	int
sample_id	int
text	text
datetime_posted	datetime	automatic

Tags

Column	Type	Options
id	int
name	varchar	max=255

SamplesTags

Column	Type	Options
sample_id	int
tag_id	int

UsersSamplesDownloads

Column	Type	Options
user_id	int
sample_id	int
datetime_downloaded	datetime	automatic

SamplesForksFrom

Column	Type	Options
id	int
sample_id	int
sample_from_id	int

SamplesForksTo

Column	Type	Options
id	int
sample_id	int
sample_to_id	int