44 lines (35 loc) · 830 Bytes

Database Layout

Tables

Tables
Users
Games
Comments
Join Tables

Users

Field Name	Data Type
id	Increment
username	String
password	String
email	String

Games

Field Name	Data Type
id	Increment
user_id	Integer
date_time	Timestamp
location^	String
team_a_name	String
team_b_name	String
is_complete	Boolean
team_a_score	Integer
team_b_score	Integer
sport_name	String

^ eg; 'Fraser Park 1'

Comments

Field Name	Data Type
id	Increment
game_id	Integer
comment	String