Database Schema

Users

column	data type	details
id	integer	not null, primary key
username	string	not null, indexed, unique
image_url	string
password_digest	string	not null
session_token	string	not null
created_at	datetime	not null
updated_at	datetime	not null

• image_url optional, add as bonus

Servers

column	data type	details
id	integer	not null, primary key
name	string	not null, indexed
owner_id	integer	not null, indexed, foreign key
direct_messsage	boolean	not null
created_at	datetime	not null
updated_at	datetime	not null

ServerMembership

column	data type	details
id	integer	not null, primary key
server_id	integer	not null, indexed, foreign key
user_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

Channels

column	data type	details
id	integer	not null, primary key
name	string	not null
server_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null

Messages

column	data type	details
id	integer	not null, primary key
message	string	not null
channel_id	integer	not null, indexed, foreign key
author_id	integer	not null, indexed, foreign key
created_at	datetime	not null
updated_at	datetime	not null