Users

Column Name	Data	Details
id	int	prim.key, not null
name	str	not null, indexed, unique
email	str	not null, indexed, unique
password_digest	str	not null
session-token	str	not null, indexed
created at	datetime	not null
updated at	datetime	not null

• Index on name, email, and session-token

Movies

Column Name	Data	Details
id	int	prim.key, not null
title	string	not null
year	int	not null
rating	int	not null
description	text	not null
video_url	string	not null
created at	timestamps	not null
updated at	timestamps	not null

Shows

Column Name	Data	Details
id	int	prim.key, not null
title	string	not null
year	int	not null
rating	int	not null
description	text	not null
video_url	string	not null
created at	timestamps	not null
updated at	timestamps	not null

Seasons

Column Name	Data	Details
id	int	prim.key, not null
number	int	not null
show_id	int	not null
created at	datetime	not null
updated at	datetime	not null

Episodes

Column Name	Data	Details
id	int	prim.key, not null
title	string	not null
number	int	not null
description	text	not null
season_id	int	not null
created at	datetime	not null
updated at	datetime	not null

Categories

Column Name	Data	Details
id	int	prim.key, not null
name	string	not null
created at	datetime	not null
updated at	datetime	not null

Video Categories

Column Name	Data	Details
id	int	prim.key, not null
video_id	int	not null
video_type	string	not null
created at	datetime	not null
updated at	datetime	not null

myStuff

Column Name	Data	Details
id	int	prim.key, not null
user_id	int	not null
video_id	int	not null
video_type	string	not null
created at	datetime	not null
updated at	datetime	not null