students

type Students struct {
	// contains filtered or unexported fields
}

type Submission struct {
	Cohort              string                 `db:"cohort"`
	Milestone           string                 `db:"milestone"`
	MilestoneTimestatus skylab.Timestatus      `db:"-"`
	Tid                 int                    `db:"tid"`
	TeamName            sql.NullString         `db:"team_name"`
	Questions           formx.Questions        `db:"questions"`
	Answers             formx.Answers          `db:"answers"`
	Submitted           sql.NullBool           `db:"submitted"`
	UpdatedAt           sql.NullTime           `db:"updated_at"`
	OverrideOpen        sql.NullBool           `db:"override_open"`
	QuestionAnswers     []formx.QuestionAnswer `db:"-"`
}

type Team struct {
	// Team
	TeamID       int            `db:"tid"`
	Cohort       string         `db:"cohort"`
	TeamName     sql.NullString `db:"team_name"`
	ProjectLevel string         `db:"project_level"`
	TeamData     types.JSONText `db:"team_data"`
	Status       string         `db:"status"`

	// Student One
	StudentOneID          int            `db:"stu1_uid"`
	StudentOneURID        int            `db:"stu1_urid"`
	StudentOneDisplayname sql.NullString `db:"stu1_displayname"`
	StudentOneEmail       string         `db:"stu1_email"`
	StudentOneData        types.JSONText `db:"stu1_data"`

	// Student Two
	StudentTwoID          int            `db:"stu2_uid"`
	StudentTwoURID        int            `db:"stu2_urid"`
	StudentTwoDisplayname sql.NullString `db:"stu2_displayname"`
	StudentTwoEmail       string         `db:"stu2_email"`
	StudentTwoData        types.JSONText `db:"stu2_data"`

	// Adviser
	AdviserID          sql.NullInt64  `db:"adv_uid"`
	AdviserURID        sql.NullInt64  `db:"adv_urid"`
	AdviserDisplayname sql.NullString `db:"adv_displayname"`
	AdviserEmail       sql.NullString `db:"adv_email"`

	// Mentor
	MentorID          sql.NullInt64  `db:"mnt_uid"`
	MentorURID        sql.NullInt64  `db:"mnt_urid"`
	MentorDisplayname sql.NullString `db:"mnt_displayname"`
	MentorEmail       sql.NullString `db:"mnt_email"`

	CreatedAt sql.NullTime `db:"created_at"`
	UpdatedAt sql.NullTime `db:"updated_at"`
	DeletedAt sql.NullTime `db:"deleted_at"`
}