Schema

users

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

challenge

column name	data type	details
id	integer	not null, primary key
language_id	integer	not null, indexed, f_key
title	string	not null
content	string	not null
created_at	datetime	not null
updated_at	datetime	not null

languages

column name	data type	details
id	integer	not null, primary key
name	string	not null, indexed

tags

column name	data type	details
id	integer	not null, primary key
string	string	not null, indexed

tags-join

column name	data type	details
id	integer	not null, primary key
challenge_id	integer	not null, indexed
tag_id	integer	not null, indexed

completed_challenge

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed, f_key
challenge_id	integer	not null, foreign key
lines_written	integer	not null
created_at	datetime	not null
updated_at	datetime	not null

file

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed, f_key
challenge_id	integer	indexed, foreign key
content	string	not null
created_at	datetime	not null
updated_at	datetime	not null