mysql

Documentation

Index

• func MigrationTables(db *gorm.DB)
• type TblJobs
• type TblJobsApplicants
• type TblJobsDepartment
• type TblJobsEducation
• type TblJobsRegisters

Functions

func MigrationTables

func MigrationTables(db *gorm.DB)

Types

type TblJobs

type TblJobs struct {
	Id             int       `gorm:"primaryKey;auto_increment;type:int"`
	CategoriesId   int       `gorm:"type:int"`
	JobTitle       string    `gorm:"type:varchar (255)"`
	JobSlug        string    `gorm:"type:varchar (255)"`
	JobDescription string    `gorm:"type:varchar (255)"`
	JobLocation    string    `gorm:"type:varchar (255)"`
	JobType        string    `gorm:"type:varchar (255)"`
	Education      string    `gorm:"type:varchar (255)"`
	Department     string    `gorm:"type:varchar (255)"`
	Experience     string    `gorm:"type:varchar (255)"`
	Salary         string    `gorm:"type:varchar (255)"`
	CreatedOn      time.Time `gorm:"type:timestamp;DEFAULT:NULL"`
	CreatedBy      int       `gorm:"type:int"`
	IsDeleted      int       `gorm:"type:int"`
	DeletedOn      time.Time `gorm:"DEFAULT:NULL"`
	DeletedBy      int       `gorm:"DEFAULT:NULL"`
	Keywords       string    `gorm:"type:varchar (255)"`
	Skill          string    `gorm:"type:varchar (255)"`
	MinimumYears   int       `gorm:"type:int"`
	MaximumYears   int       `gorm:"type:int"`
	PostedDate     time.Time `gorm:"type:timestamp;DEFAULT:NULL"`
	ValidThrough   time.Time `gorm:"type:timestamp;DEFAULT:NULL"`
	Status         int       `gorm:"type:int"`
	ModifiedOn     time.Time `gorm:"type:timestamp;DEFAULT:NULL"`
	ModifiedBy     int       `gorm:"type:int"`
}

type TblJobsApplicants

type TblJobsApplicants struct {
	Id          int       `gorm:"primaryKey;auto_increment;type:int"`
	MemberId    int       `gorm:"type:int"`
	Name        string    `gorm:"type:varchar (255)"`
	EmailId     string    `gorm:"type:varchar (255)"`
	MobileNo    string    `gorm:"type:varchar (255)"`
	JobType     string    `gorm:"type:varchar (255)"`
	Password    string    `gorm:"type:varchar(255)"`
	Location    string    `gorm:"type:varchar (255)"`
	Education   string    `gorm:"type:varchar (255)"`
	Graduation  int       `gorm:"type:int"`
	CompanyName string    `gorm:"type:varchar (255)"`
	Experience  string    `gorm:"type:varchar (255)"`
	Skills      string    `gorm:"type:varchar (255)"`
	ImagePath   string    `gorm:"type:varchar (255)"`
	Image       string    `gorm:"type:varchar (255)"`
	CreatedOn   time.Time `gorm:"type:timestamp;DEFAULT:NULL"`
	CreatedBy   int       `gorm:"type:int"`
	ModifiedOn  time.Time `gorm:"type:timestamp;DEFAULT:NULL"`
	ModifiedBy  int       `gorm:"type:int"`
	IsDeleted   int       `gorm:"type:int"`
	DeletedOn   time.Time `gorm:"type:timestamp;DEFAULT:NULL"`
	DeletedBy   int       `gorm:"type:int"`
}

type TblJobsDepartment

type TblJobsDepartment struct {
	Id         int    `gorm:"primaryKey;auto_increment;type:int"`
	Department string `gorm:"type:varchar (255)"`
}

type TblJobsEducation

type TblJobsEducation struct {
	Id        int    `gorm:"primaryKey;auto_increment;type:int"`
	Education string `gorm:"type:varchar (255)"`
}

type TblJobsRegisters

type TblJobsRegisters struct {
	Id          int               `gorm:"primaryKey;auto_increment;type:int"`
	JobId       TblJobsApplicants `gorm:"type:int;foreignKey:Id"`
	ApplicantId int               `gorm:"type:int"`
	CreatedBy   int               `gorm:"type:int"`
	CreatedOn   time.Time         `gorm:"type:timestamp;DEFAULT:NULL"`
}