SocialFoot

A Web App written with full backend on Golang.

Static Content in /assets/ (html/css/javascript)

Pages (Not including assets):

• /live

  - Logged in homepage

• /live/profile

  - Verify before editing profile settings

• /live/profile/settings

  - Edit profile settings

• /live/view/post/{identifier}

  - View a specific page

• /live/messages

  - Messages Home Page

• /live/messages/{convo}

  - Message/Conversation

main.go

This file sets up the router and starts a database connection, handling the requests and some functions

store.go

This is the database interaction file.

tools.go

Contains tools like password hashing, etc.

Database Tables + Explanations

users:

• id - serial - PRIMARY KEY
• username - VARCHAR(26)
• gender - BOOL
• age - INT
• password - VARCHAR(355)
• email - VARCHAR(55)

user_settings:

• userid - INT - PRIMARY KEY
• bio - TEXT
• website - TEXT
• location - TEXT
• publicity - BOOL

posts:

• postid - SERIAL - PRIMARY KEY
• userid - INT
• tags - TEXT
• caption - TEXT
• type - TEXT
• posted - date
• extension - TEXT

private_conversations:

• convoID - SERIAL - PRIMARY KEY
• userOne - VARCHAR(26)
• userTwo - VARCHAR(26)
• created - DATE