package models

import "time"

type AstrologerEducation struct {
	ID uint `gorm:"primaryKey" json:"id"`

	AstrologerID uint `gorm:"column:astrologer_id;not null;index" json:"astrologer_id"`

	EducationType string `gorm:"column:education_type"`

	Degree string `gorm:"column:degree;type:varchar(150);not null" json:"degree"`

	Specialization string `gorm:"column:specialization;type:varchar(150)" json:"specialization"`

	Institute string `gorm:"column:institute;type:varchar(255);not null" json:"institute"`

	BoardUniversity string `gorm:"column:board_university;type:varchar(255)" json:"board_university"`

	PassingYear int `gorm:"column:passing_year" json:"passing_year"`

	Certificate string `gorm:"column:certificate;type:varchar(255)" json:"certificate"`

	Status string `gorm:"column:status;type:enum('PENDING','APPROVED','REJECTED');default:'PENDING'" json:"status"`

	CreatedAt *time.Time `gorm:"column:created_at;autoCreateTime" json:"created_at,omitempty"`

	UpdatedAt *time.Time `gorm:"column:updated_at;autoUpdateTime" json:"updated_at,omitempty"`

	// Relationships
	Astrologer Astrologer `gorm:"foreignKey:AstrologerID;references:ID" json:"-"`
}

func (AstrologerEducation) TableName() string {

	return "astrologer_educations"

}