schema

Database Schema

Users

id	int	not null, primary
username	string	not null, indexed
email	string	not null, indexed, unique
password	string	not null
image_url	string	not null
session_token	string	not null
created_at	date	not null, primary
updated_at	date	not null, primary

Items

id	int	not null, primary
author_id	int	not null, indexed
parent_id	int	not null, indexed
parent_type	string	not null
body	string	not null

Likes

id	int	not null, primary
author_id	int	not null, indexed
parent_id	int	not null, indexed
parent_type	string	not null