db

type Application struct {
	ID          int32                 `json:"id"`
	JobSeekerID sql.NullInt32         `json:"job_seeker_id"`
	JobID       sql.NullInt32         `json:"job_id"`
	CoverLetter sql.NullString        `json:"cover_letter"`
	Resume      sql.NullString        `json:"resume"`
	Status      NullApplicationStatus `json:"status"`
	CreatedAt   sql.NullTime          `json:"created_at"`
	UpdatedAt   sql.NullTime          `json:"updated_at"`
}

type ApplicationStatus string

type Chatbotconversation struct {
	ID                 int32          `json:"id"`
	ChatbotInterviewID sql.NullInt32  `json:"chatbot_interview_id"`
	SenderType         sql.NullString `json:"sender_type"`
	Content            string         `json:"content"`
	CreatedAt          sql.NullTime   `json:"created_at"`
}

type Chatbotinterview struct {
	ID          int32               `json:"id"`
	JobSeekerID sql.NullInt32       `json:"job_seeker_id"`
	JobID       sql.NullInt32       `json:"job_id"`
	Status      NullInterviewStatus `json:"status"`
	Review      sql.NullString      `json:"review"`
	CreatedAt   sql.NullTime        `json:"created_at"`
	UpdatedAt   sql.NullTime        `json:"updated_at"`
}

type Company struct {
	ID          int32          `json:"id"`
	UserID      sql.NullInt32  `json:"user_id"`
	Name        string         `json:"name"`
	Email       string         `json:"email"`
	Phone       sql.NullString `json:"phone"`
	Website     sql.NullString `json:"website"`
	Logo        sql.NullString `json:"logo"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullTime   `json:"created_at"`
	UpdatedAt   sql.NullTime   `json:"updated_at"`
}

type Companyentity struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type CreateJobParams struct {
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	CompanyID    sql.NullInt32  `json:"company_id"`
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteJobSeekerSkillParams struct {
	JobSeekerID    int32           `json:"job_seeker_id"`
	TechnicalSkill Technicalskills `json:"technical_skill"`
	PassiveSkill   Passiveskills   `json:"passive_skill"`
}

type Education struct {
	ID            int32          `json:"id"`
	JobSeekerID   sql.NullInt32  `json:"job_seeker_id"`
	InstitutionID sql.NullInt32  `json:"institution_id"`
	Degree        sql.NullString `json:"degree"`
	FieldOfStudy  sql.NullString `json:"field_of_study"`
	StartDate     sql.NullTime   `json:"start_date"`
	EndDate       sql.NullTime   `json:"end_date"`
	CreatedAt     sql.NullTime   `json:"created_at"`
	UpdatedAt     sql.NullTime   `json:"updated_at"`
}

type Experience struct {
	ID          int32          `json:"id"`
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	Title       sql.NullString `json:"title"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	Location    sql.NullString `json:"location"`
	StartDate   sql.NullTime   `json:"start_date"`
	EndDate     sql.NullTime   `json:"end_date"`
	TypeID      sql.NullInt32  `json:"type_id"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullTime   `json:"created_at"`
	UpdatedAt   sql.NullTime   `json:"updated_at"`
}

type Experiencetype struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type GetJobsRow struct {
	ID           int32          `json:"id"`
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	CompanyID    sql.NullInt32  `json:"company_id"`
	CreatedAt    sql.NullTime   `json:"created_at"`
	UpdatedAt    sql.NullTime   `json:"updated_at"`
}

type InsertApplicationParams struct {
	JobSeekerID sql.NullInt32         `json:"job_seeker_id"`
	JobID       sql.NullInt32         `json:"job_id"`
	CoverLetter sql.NullString        `json:"cover_letter"`
	Resume      sql.NullString        `json:"resume"`
	Status      NullApplicationStatus `json:"status"`
}

type InsertChatbotConversationParams struct {
	ChatbotInterviewID sql.NullInt32  `json:"chatbot_interview_id"`
	SenderType         sql.NullString `json:"sender_type"`
	Content            string         `json:"content"`
}

type InsertChatbotInterviewParams struct {
	JobSeekerID sql.NullInt32       `json:"job_seeker_id"`
	JobID       sql.NullInt32       `json:"job_id"`
	Status      NullInterviewStatus `json:"status"`
	Review      sql.NullString      `json:"review"`
}

type InsertCompanyParams struct {
	UserID      sql.NullInt32  `json:"user_id"`
	Name        string         `json:"name"`
	Email       string         `json:"email"`
	Phone       sql.NullString `json:"phone"`
	Website     sql.NullString `json:"website"`
	Logo        sql.NullString `json:"logo"`
	Description sql.NullString `json:"description"`
}

type InsertEducationParams struct {
	JobSeekerID   sql.NullInt32  `json:"job_seeker_id"`
	InstitutionID sql.NullInt32  `json:"institution_id"`
	Degree        sql.NullString `json:"degree"`
	FieldOfStudy  sql.NullString `json:"field_of_study"`
	StartDate     sql.NullTime   `json:"start_date"`
	EndDate       sql.NullTime   `json:"end_date"`
}

type InsertExperienceParams struct {
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	Title       sql.NullString `json:"title"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	Location    sql.NullString `json:"location"`
	StartDate   sql.NullTime   `json:"start_date"`
	EndDate     sql.NullTime   `json:"end_date"`
	TypeID      sql.NullInt32  `json:"type_id"`
	Description sql.NullString `json:"description"`
}

type InsertJobSeekerSkillParams struct {
	JobSeekerID    int32           `json:"job_seeker_id"`
	TechnicalSkill Technicalskills `json:"technical_skill"`
	PassiveSkill   Passiveskills   `json:"passive_skill"`
}

type InsertJobViewParams struct {
	JobID     int32         `json:"job_id"`
	ViewCount sql.NullInt32 `json:"view_count"`
}

type InsertMessageParams struct {
	SenderID   int32          `json:"sender_id"`
	ReceiverID int32          `json:"receiver_id"`
	Content    string         `json:"content"`
	SenderType sql.NullString `json:"sender_type"`
}

type InsertScheduledInterviewParams struct {
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	ScheduledAt sql.NullTime   `json:"scheduled_at"`
	Location    sql.NullString `json:"location"`
	Notes       sql.NullString `json:"notes"`
	MeetingLink sql.NullString `json:"meeting_link"`
}

type InsertUserParams struct {
	Name  string         `json:"name"`
	Email string         `json:"email"`
	Phone sql.NullString `json:"phone"`
	Role  sql.NullString `json:"role"`
}

type Institution struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type InterviewStatus string

type Job struct {
	ID           int32          `json:"id"`
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	CompanyID    sql.NullInt32  `json:"company_id"`
	CategoryID   sql.NullInt32  `json:"category_id"`
	Status       NullJobStatus  `json:"status"`
	CreatedAt    sql.NullTime   `json:"created_at"`
	UpdatedAt    sql.NullTime   `json:"updated_at"`
}

type JobStatus string

type Jobcategory struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type Jobseeker struct {
	ID        int32         `json:"id"`
	UserID    sql.NullInt32 `json:"user_id"`
	CreatedAt sql.NullTime  `json:"created_at"`
	UpdatedAt sql.NullTime  `json:"updated_at"`
}

type Jobseekerskill struct {
	JobSeekerID    int32           `json:"job_seeker_id"`
	TechnicalSkill Technicalskills `json:"technical_skill"`
	PassiveSkill   Passiveskills   `json:"passive_skill"`
}

type Jobview struct {
	JobID     int32         `json:"job_id"`
	ViewCount sql.NullInt32 `json:"view_count"`
}

type Message struct {
	ID         int32          `json:"id"`
	SenderID   int32          `json:"sender_id"`
	ReceiverID int32          `json:"receiver_id"`
	Content    string         `json:"content"`
	SenderType sql.NullString `json:"sender_type"`
	CreatedAt  sql.NullTime   `json:"created_at"`
}

type NullApplicationStatus struct {
	ApplicationStatus ApplicationStatus
	Valid             bool // Valid is true if ApplicationStatus is not NULL
}

type NullInterviewStatus struct {
	InterviewStatus InterviewStatus
	Valid           bool // Valid is true if InterviewStatus is not NULL
}

type NullJobStatus struct {
	JobStatus JobStatus
	Valid     bool // Valid is true if JobStatus is not NULL
}

type NullPassiveskills struct {
	Passiveskills Passiveskills
	Valid         bool // Valid is true if Passiveskills is not NULL
}

type NullTechnicalskills struct {
	Technicalskills Technicalskills
	Valid           bool // Valid is true if Technicalskills is not NULL
}

type Passiveskills string

type Queries struct {
	// contains filtered or unexported fields
}

type Scheduledinterview struct {
	ID          int32          `json:"id"`
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	ScheduledAt sql.NullTime   `json:"scheduled_at"`
	Location    sql.NullString `json:"location"`
	Notes       sql.NullString `json:"notes"`
	MeetingLink sql.NullString `json:"meeting_link"`
	CreatedAt   sql.NullTime   `json:"created_at"`
}

type SelectMessagesBySenderAndReceiverParams struct {
	SenderID   int32 `json:"sender_id"`
	ReceiverID int32 `json:"receiver_id"`
}

type Skill struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type Store struct {
	*Queries
	// contains filtered or unexported fields
}

type Technicalskills string

type UpdateApplicationParams struct {
	CoverLetter sql.NullString        `json:"cover_letter"`
	Resume      sql.NullString        `json:"resume"`
	Status      NullApplicationStatus `json:"status"`
	ID          int32                 `json:"id"`
}

type UpdateChatbotConversationParams struct {
	ChatbotInterviewID sql.NullInt32  `json:"chatbot_interview_id"`
	SenderType         sql.NullString `json:"sender_type"`
	Content            string         `json:"content"`
	ID                 int32          `json:"id"`
}

type UpdateChatbotInterviewParams struct {
	Status NullInterviewStatus `json:"status"`
	Review sql.NullString      `json:"review"`
	ID     int32               `json:"id"`
}

type UpdateCompanyEntityParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateCompanyParams struct {
	Name        string         `json:"name"`
	Email       string         `json:"email"`
	Phone       sql.NullString `json:"phone"`
	Website     sql.NullString `json:"website"`
	Logo        sql.NullString `json:"logo"`
	Description sql.NullString `json:"description"`
	ID          int32          `json:"id"`
}

type UpdateEducationParams struct {
	InstitutionID sql.NullInt32  `json:"institution_id"`
	Degree        sql.NullString `json:"degree"`
	FieldOfStudy  sql.NullString `json:"field_of_study"`
	StartDate     sql.NullTime   `json:"start_date"`
	EndDate       sql.NullTime   `json:"end_date"`
	ID            int32          `json:"id"`
}

type UpdateExperienceParams struct {
	Title       sql.NullString `json:"title"`
	Location    sql.NullString `json:"location"`
	StartDate   sql.NullTime   `json:"start_date"`
	EndDate     sql.NullTime   `json:"end_date"`
	TypeID      sql.NullInt32  `json:"type_id"`
	Description sql.NullString `json:"description"`
	ID          int32          `json:"id"`
}

type UpdateExperienceTypeParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateInstitutionParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateJobCategoryParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateJobParams struct {
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	ID           int32          `json:"id"`
}

type UpdateJobSeekerParams struct {
	UserID sql.NullInt32 `json:"user_id"`
	ID     int32         `json:"id"`
}

type UpdateJobViewsParams struct {
	ViewCount sql.NullInt32 `json:"view_count"`
	JobID     int32         `json:"job_id"`
}

type UpdateScheduledInterviewParams struct {
	ScheduledAt sql.NullTime   `json:"scheduled_at"`
	Location    sql.NullString `json:"location"`
	Notes       sql.NullString `json:"notes"`
	MeetingLink sql.NullString `json:"meeting_link"`
	ID          int32          `json:"id"`
}

type UpdateSkillParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateUserParams struct {
	Name  string         `json:"name"`
	Email string         `json:"email"`
	Phone sql.NullString `json:"phone"`
	Role  sql.NullString `json:"role"`
	ID    int32          `json:"id"`
}

type User struct {
	ID        int32          `json:"id"`
	Name      string         `json:"name"`
	Email     string         `json:"email"`
	Phone     sql.NullString `json:"phone"`
	Role      sql.NullString `json:"role"`
	CreatedAt sql.NullTime   `json:"created_at"`
	UpdatedAt sql.NullTime   `json:"updated_at"`
}