DAO

type Event struct {
	ID        uint      `gorm:"column:idevent;primary_key"`
	Name      string    `gorm:"column:name"`
	StartDate time.Time `gorm:"column:start_date"`
	EndDate   time.Time `gorm:"column:end_date"`
	Address   string    `gorm:"column:address"`
	Credit    float64   `gorm:"column:credit"`
	// TODO: Constraints     []string    `gorm:"column:constraints"`
	Details         string `gorm:"column:details"`
	MaxParticipants uint   `gorm:"column:max_participants"`
	Status          string `gorm:"column:fk_status"`
	// TODO Type            string      `gorm:"column:type"`
	// TODO Group           string      `gorm:"column:group"`
	AttachedProgram uint      `gorm:"column:fk_program"`
	CreatedAt       time.Time `gorm:"column:created_date"`
}

type EventSubscription struct {
	ID       uint   `gorm:"column:idevent_subscription"`
	FkUser   uint   `gorm:"column:fk_user"`
	FkEvent  uint   `gorm:"column:fk_event"`
	FkStatus string `gorm:"column:fk_status"`
}

type Program struct {
	ID                 uint                   `gorm:"column:idprogram;primary_key"`
	Name               string                 `gorm:"column:name"`
	Description        string                 `gorm:"column:description"`
	StartDate          time.Time              `gorm:"column:start_date"`
	EndDate            time.Time              `gorm:"column:end_date"`
	NbrHoursToComplete int                    `gorm:"column:nbr_hours_to_complete"`
	CreatedAt          time.Time              `gorm:"column:created_date"`
	Users              []ProgramsSubscription `gorm:"many2many:programs_subscriptions;"`
}

type ProgramsSubscription struct {
	FkUser    uint   `gorm:"column:fk_user"`
	FkProgram uint   `gorm:"column:fk_program"`
	FkStatus  string `gorm:"column:fk_status"`
}

type StudentBasic struct {
	Id        int    `sql:"iduser"`
	FirstName string `sql:"first_name"`
	LastName  string `sql:"last_name"`
}

type Type struct {
	Name string
}

type User struct {
	ID        uint   `gorm:"column:iduser"`
	FirstName string `gorm:"column:forst_name"`
	LastName  string `gorm:"column:last_name"`
	Email     string `gorm:"column:email"`
	Phone     string `gorm:"column:phone"`
}