Database Schema - JohnRamberger/dsgt-member-portal Wiki

Database Schema

The current schema for all of the tables in our database.

user Table

session Table

passwordreset Table

billing_details Table

event Table

forms Table

feedback Table

checkin_event Table

team Table

Manages all of the different teams within DSGT. Provides a way for members to confirm that they are a part of a team.

Columns

Column Name Type Description Specialty Foreign Key
team_id integer The team's id auto_increment
name string The team's name
description string The team's description
members number[] A list of member ids