models

type Category struct {
	gorm.Model
	Title       string `gorm:"type:varchar(255); not null"`
	Description string `gorm:"type:text"`
}

type Feedback struct {
	gorm.Model
	FeedbackForm     FeedbackForm
	Title            string `gorm:"type:varchar(255); not null"`
	FeedbackFormID   uint   `gorm:"not null"`
	ForUserProfile   UserProfile
	ForUserProfileID uint
	ByUserProfile    UserProfile
	ByUserProfileID  uint `gorm:"not null"`
	Team             Team
	TeamID           uint `gorm:"not null"`
	Status           int8 `gorm:"default:0; not null;"`
	SubmittedAt      *time.Time
	DurationStart    time.Time `gorm:"not null"`
	DurationEnd      time.Time `gorm:"not null"`
	ExpireAt         time.Time `gorm:"not null"`
}

type FeedbackForm struct {
	gorm.Model
	Title       string `gorm:"type:varchar(255); not null"`
	Description string `gorm:"type:text;"`
	Status      int8   `gorm:"default:0; not null"`
	Archive     bool   `gorm:"default:false; not null"`
}

type FeedbackFormContent struct {
	gorm.Model
	FeedbackForm   FeedbackForm
	FeedbackFormID uint `gorm:"not null"`
	Skill          Skill
	SkillID        uint `gorm:"not null"`
	Category       Category
	CategoryID     uint `gorm:"not null"`
}

type OTP struct {
	Code     string `gorm:"type:varchar(16);not null"`
	ExpiryAt time.Time
	User     User
	UserID   uint `gorm:"unique"`
}

type Question struct {
	gorm.Model
	Text    string `gorm:"type:text; not null"`
	Type    int8   `gorm:"default:0; not null"`
	Skill   Skill
	SkillID uint         `gorm:"not null"`
	Options fields.JSONB `gorm:"type:jsonb; not null; default:'{}'::jsonb"`
	Weight  int          `gorm:"default:1; not null"`
}

type QuestionResponse struct {
	gorm.Model
	Feedback              Feedback
	FeedbackID            uint `gorm:"not null"`
	FeedbackFormContent   FeedbackFormContent
	FeedbackFormContentID uint `gorm:"not null"`
	Question              Question
	QuestionID            uint   `gorm:"not null"`
	Response              string `gorm:"type:text"`
	Comment               string `gorm:"type:text"`
}

type Retrospective struct {
	gorm.Model
	Title              string       `gorm:"type:varchar(255); not null"`
	ProjectName        string       `gorm:"type:varchar(255); not null"`
	TaskProviderConfig fields.JSONB `gorm:"type:jsonb; not null; default:'[]'::jsonb"`
	Team               Team
	TeamID             uint `gorm:"not null"`
	Sprints            []Sprint
	HrsPerStoryPoint   float64 `gorm:"not null"`
	CreatedBy          User
	CreatedByID        uint `gorm:"not null"`
}

type RetrospectiveFeedback struct {
	gorm.Model
	SubType         string `gorm:"type:varchar(30); not null"`
	Type            int8   `gorm:"default:0; not null"`
	Retrospective   Retrospective
	RetrospectiveID uint   `gorm:"not null"`
	Text            string `gorm:"type:text; not null"`
	Scope           int8   `gorm:"default:0; not null"`
	AssigneeID      uint
	Assignee        userModels.User
	AddedAt         *time.Time
	ResolvedAt      *time.Time
	ExpectedAt      *time.Time
	CreatedByID     uint `gorm:"not null"`
	CreatedBy       userModels.User
}

type Role struct {
	gorm.Model
	Name string `gorm:"type:varchar(64)"`
}

type Schedule struct {
	gorm.Model
	Team          Team
	TeamID        uint      `gorm:"not null"`
	PeriodValue   uint      `gorm:"not null"`                   // consecutive period units, after which event need to be recreated
	PeriodUnit    string    `gorm:"type:varchar(15); not null"` // Unit of period, eg: year, week, days
	PeriodOffset  uint      `gorm:"default:1; not null"`        // Offset in days between the period end and actual event date
	FeedbackTitle string    `gorm:"type:varchar(255); not null"`
	ExpireInDays  uint      `gorm:"default:10; not null"`
	NextEventAt   time.Time `gorm:"not null"`
	Active        bool      `gorm:"default:true; not null"`
}

type Skill struct {
	gorm.Model
	Title        string `gorm:"type:varchar(255); not null"`
	DisplayTitle string `gorm:"type:varchar(255)"`
	Description  string `gorm:"type:text"`
	Weight       int    `gorm:"default:1"`
	Questions    []Question
}

type Sprint struct {
	gorm.Model
	Title            string `gorm:"type:varchar(255); not null"`
	SprintID         string `gorm:"type:varchar(30); not null"`
	Retrospective    Retrospective
	RetrospectiveID  uint `gorm:"not null"`
	Status           int8 `gorm:"default:0; not null"`
	StartDate        *time.Time
	EndDate          *time.Time
	SprintMembers    []SprintMember
	LastSyncedAt     *time.Time
	CurrentlySyncing bool `gorm:"default:true;not null"`
	CreatedBy        User
	CreatedByID      uint `gorm:"not null"`
}

type SprintMember struct {
	gorm.Model
	Sprint             Sprint
	SprintID           uint `gorm:"not null"`
	Member             User
	MemberID           uint    `gorm:"not null"`
	AllocationPercent  float64 `gorm:"not null;default:100"`
	ExpectationPercent float64 `gorm:"not null;default:100"`
	Tasks              []SprintMemberTask
	Vacations          float64 `gorm:"not null;default:0"`
	Rating             int8    `gorm:"default:2; not null"`
	Comment            string  `gorm:"type:text"`
}

type SprintMemberTask struct {
	gorm.Model
	SprintMember     SprintMember
	SprintMemberID   uint `gorm:"not null"`
	Task             Task
	TaskID           uint    `gorm:"not null"`
	TimeSpentMinutes uint    `gorm:"not null"`
	PointsEarned     float64 `gorm:"default:0; not null"`
	PointsAssigned   float64 `gorm:"default:0; not null"`
	Rating           int8    `gorm:"default:2; not null"`
	Comment          string  `gorm:"type:text"`
}

type SprintSyncStatus struct {
	gorm.Model
	SprintID uint `gorm:"not null"`
	Sprint   Sprint
	Status   int8 `gorm:"default:0; not null"`
}

type SprintTask struct {
	gorm.Model
	Sprint   Sprint
	SprintID uint `gorm:"not null"`
	Task     Task
	TaskID   uint `gorm:"not null"`
}

type Task struct {
	gorm.Model
	TaskID            string `gorm:"type:varchar(30); not null"`
	Retrospective     Retrospective
	RetrospectiveID   uint   `gorm:"not null"`
	Summary           string `gorm:"type:varchar(255); not null"`
	Type              string `gorm:"type:varchar(30); not null"`
	Status            string `gorm:"type:varchar(50); not null"`
	Priority          string `gorm:"type:varchar(50); not null"`
	Assignee          string `gorm:"type:varchar(100); not null"`
	Estimate          *float64
	Fields            fields.JSONB `gorm:"type:jsonb; not null; default:'{}'::jsonb"`
	SprintMemberTasks []SprintMemberTask
}

type TaskKeyMap struct {
	gorm.Model
	TaskID uint `gorm:"not null"`
	Task   Task
	Key    string `gorm:"type:varchar(30); not null"`
}

type Team struct {
	gorm.Model
	Name        string `gorm:"type:varchar(64);not null"`
	Description string `gorm:"type:text"`
	Active      bool   `gorm:"default:true; not null"`
	Users       []User
}

type TeamFeedbackForm struct {
	gorm.Model
	Team           Team
	TeamID         uint `gorm:"not null"`
	ForRole        Role
	ForRoleID      uint `gorm:"not null"`
	FeedbackForm   FeedbackForm
	FeedbackFormID uint `gorm:"not null"`
	Active         bool `gorm:"default:false; not null"`
}

type Trail struct {
	gorm.Model
	Action       string `gorm:"type:varchar(255); not null"`
	ActionItem   string `gorm:"type:varchar(255); not null"`
	ActionItemID uint   `gorm:"not null"`
	ActionBy     User
	ActionByID   uint `gorm:"not null"`
}

type User struct {
	gorm.Model
	Email     string `gorm:"type:varchar(255); not null; unique_index"`
	FirstName string `gorm:"type:varchar(30); not null"`
	LastName  string `gorm:"type:varchar(150)"`
	Active    bool   `gorm:"default:true; not null"`
	Teams     []Team
	Profiles  []UserProfile
}

type UserProfile struct {
	gorm.Model
	User   User
	UserID uint `gorm:"not null"`
	Role   Role
	RoleID uint `gorm:"not null"`
	Active bool `gorm:"default:false; not null"`
}

type UserTeam struct {
	gorm.Model
	User     User
	UserID   uint `gorm:"not null"`
	Team     Team
	TeamID   uint      `gorm:"not null"`
	Role     int8      `gorm:"default:0; not null"`
	JoinedAt time.Time `gorm:"not null"`
	LeavedAt *time.Time
}