models

type AHP struct {
	StudentId        string  `db:"student_id"`
	Id               int32   `db:"id"`
	ConsistencyRatio float32 `db:"consistency_ratio"`
}

type AHPToAlternatives struct {
	Score         float32 `db:"score"`
	AhpId         int32   `db:"ahp_id"`
	AlternativeId int     `db:"alternative_id"`
}

type Admin struct {
	Id          string      `db:"id" json:"id"`
	Username    string      `db:"username" json:"username"`
	Email       null.String `db:"email" json:"email,omitempty"`
	Password    string      `db:"password" json:"-"`
	PhoneNumber null.String `db:"phone_number" json:"phone_number,omitempty"`
}

type AhpRecommendation struct {
	Result           []RecommendationResult `db:"result" json:"result"`
	ConsistencyRatio null.Float             `db:"consistency_ratio" json:"consistency_ratio"`
}

type Alternative struct {
	Alternative string      `db:"alternative" json:"alternative"`
	Description null.String `db:"description" json:"description"`
	Id          int         `db:"id" json:"id"`
}

type Answer struct {
	StudentId  string      `db:"student_id" json:"student_id"`
	Answer     null.String `db:"answer" json:"answer"`
	Id         int64       `db:"id" json:"id"`
	QuestionId int         `db:"question_id" json:"question_id"`
}

type LoginRequest struct {
	Username string `json:"username"`
	Password string `json:"password"`
	Type     string `json:"type"`
}

type LoginResponse struct {
	Token string `json:"token"`
	Role  string `json:"role"`
}

type Question struct {
	Code        string      `db:"code" json:"code"`
	Question    string      `db:"question" json:"question"`
	Category    string      `db:"category" json:"category"`
	Description null.String `db:"description" json:"description"`
	Id          int         `db:"id" json:"id"`
	Number      int         `db:"number" json:"number"`
}

type QuestionResponse struct {
	Question string   `json:"question"`
	Type     string   `json:"type"`
	MinText  string   `json:"min_text"`
	MaxText  string   `json:"max_text"`
	Options  []string `json:"options"`
	Id       int      `json:"id"`
	Number   int      `json:"number"`
}

type QuestionnareSetting struct {
	SchoolId                    string     `db:"school_id" json:"school_id"`
	Id                          int        `db:"id" json:"id"`
	AlternativeId               int        `db:"alternative_id" json:"alternative_id"`
	TotalOpenJobs               null.Int16 `db:"total_open_jobs" json:"total_open_jobs"`
	EntrepreneurshipOpportunity null.Int16 `db:"entrepreneurship_opportunity" json:"entrepreneurship_opportunity"`
	Salary                      null.Int16 `db:"salary" json:"salary"`
}

type QuestionnareSettingAlternative struct {
	Alternative                 string     `db:"alternative" json:"alternative"`
	Id                          int        `db:"id" json:"id"`
	TotalOpenJobs               null.Int16 `db:"total_open_jobs" json:"total_open_jobs"`
	EntrepreneurshipOpportunity null.Int16 `db:"entrepreneurship_opportunity" json:"entrepreneurship_opportunity"`
	Salary                      null.Int16 `db:"salary" json:"salary"`
}

type Recommendation struct {
	Ahp    AhpRecommendation    `db:"ahp" json:"ahp"`
	Topsis TopsisRecommendation `db:"topsis" json:"topsis"`
}

type RecommendationResult struct {
	Alternative string      `db:"alternative" json:"alternative"`
	Description null.String `db:"description" json:"description"`
	Score       null.Float  `db:"score" json:"score"`
	Id          int32       `db:"id" json:"id"`
}

type School struct {
	Id   string `db:"id" json:"id"`
	Name string `db:"name" json:"name"`
}

type Statistic struct {
	RegisteredStudents    int64      `db:"registered_students" json:"registered_students"`
	QuestionnareCompleted int64      `db:"questionnare_completed" json:"questionnare_completed"`
	ConsistencyAvg        null.Float `db:"consistency_avg" json:"consistency_avg"`
}

type Student struct {
	Id          string      `db:"id" json:"id"`
	Username    string      `db:"username" json:"username"`
	Password    string      `db:"password" json:"-"`
	Fullname    string      `db:"fullname" json:"fullname"`
	Nisn        string      `db:"nisn" json:"nisn"`
	Email       null.String `db:"email" json:"email,omitempty"`
	PhoneNumber null.String `db:"phone_number" json:"phone_number,omitempty"`
}

type StudentProfile struct {
	Id          string      `db:"id" json:"id"`
	Username    string      `db:"username" json:"username"`
	Fullname    string      `db:"fullname" json:"fullname"`
	Nisn        string      `db:"nisn" json:"nisn"`
	School      string      `json:"school"`
	Email       null.String `db:"email" json:"email,omitempty"`
	PhoneNumber null.String `db:"phone_number" json:"phone_number,omitempty"`
}

type StudentRecommendation struct {
	StudentId        string                 `db:"student_id" json:"student_id"`
	Fullname         string                 `db:"fullname" json:"fullname"`
	Nisn             string                 `db:"nisn" json:"nisn"`
	AhpResults       []RecommendationResult `db:"ahp_results" json:"ahp_results"`
	TopsisResults    []RecommendationResult `db:"topsis_results" json:"topsis_results"`
	ConsistencyRatio null.Float             `db:"consistency_ratio" json:"consistency_ratio"`
	Id               int32                  `db:"id" json:"id"`
}

type SubmitAnswerRequest struct {
	Answer string `json:"answer"`
	Id     int    `json:"id"`
	Number int    `json:"number"`
}

type TopsisRecommendation struct {
	Result RecommendationResult `db:"result" json:"result"`
	Id     int32                `db:"id" json:"id"`
}

type UpdateAdminRequest struct {
	Username    string `json:"username"`
	Email       string `json:"email"`
	PhoneNumber string `json:"phone_number"`
}