database

type Admin struct {
	AdminID   uuid.UUID  `db:"admin_id" json:"admin_id"`
	UserID    uuid.UUID  `db:"user_id" json:"user_id"`
	Role      AdminRole  `db:"role" json:"role"`
	LastLogin *time.Time `db:"last_login" json:"last_login,omitempty"` // Nullable field
	IsActive  bool       `db:"is_active" json:"is_active"`
	CreatedAt time.Time  `db:"created_at" json:"created_at"`
	UpdatedAt time.Time  `db:"updated_at" json:"updated_at"`
}

type AdminResponse struct {
	UserID    uuid.UUID  `json:"user_id" db:"user_id"`
	AdminID   uuid.UUID  `json:"admin_id" db:"admin_id"`
	Username  string     `json:"username" db:"username"`
	Email     string     `json:"email" db:"email"`
	Role      string     `json:"admin_role" db:"role"`
	LastLogin *time.Time `json:"last_login,omitempty" db:"last_login"` // Nullable field
	IsActive  bool       `json:"is_active" db:"is_active"`
	CreatedAt time.Time  `json:"created_at" db:"created_at"`
	UpdatedAt time.Time  `json:"updated_at" db:"updated_at"`
}

type AdminRole string

type Company struct {
	ID          uuid.UUID        `json:"id" db:"id"`
	UserID      uuid.UUID        `json:"user_id" db:"user_id"` // Foreign key to users table
	Name        string           `json:"name" db:"name"`
	Description *string          `json:"description,omitempty" db:"description"` // Use pointer for nullable fields
	Industry    *string          `json:"industry,omitempty" db:"industry"`
	Website     *string          `json:"website,omitempty" db:"website"`
	Email       string           `json:"email" db:"email"`
	Phone       *string          `json:"phone,omitempty" db:"phone"`
	LogoURL     *string          `json:"logo_url,omitempty" db:"logo_url"`
	CreatedAt   time.Time        `json:"created_at" db:"created_at"`
	UpdatedAt   time.Time        `json:"updated_at" db:"updated_at"`
	Status      CompanyStatus    `json:"status" db:"status"`
	Size        CompanySizeRange `json:"size" db:"size"`
	IsVerified  bool             `json:"is_verified" db:"is_verified"`
	AddressID   uuid.UUID        `json:"address_id" db:"address_id"` // Foreign key to company_addresses
	Address     *CompanyAddress  `json:"address,omitempty"`          // One-to-one relationship
}

type CompanyAddress struct {
	ID           uuid.UUID `json:"id" db:"id"`
	CompanyID    uuid.UUID `json:"company_id" db:"company_id"` // Foreign key to company table
	AddressLine1 string    `json:"address_line_1" db:"address_line_1"`
	AddressLine2 *string   `json:"address_line_2,omitempty" db:"address_line_2"` // Use pointer for nullable fields
	City         string    `json:"city" db:"city"`
	State        string    `json:"state" db:"state"`
	ZipCode      string    `json:"zip_code" db:"zip_code"`
	Country      string    `json:"country" db:"country"`
	CreatedAt    time.Time `json:"created_at" db:"created_at"`
	UpdatedAt    time.Time `json:"updated_at" db:"updated_at"`
}

type CompanySizeRange string

type CompanyStatus string

type DB struct {
	*sqlx.DB
	*sync.Mutex
}

type JobSeeker struct {
	ID                uuid.UUID `db:"id" json:"id"`
	UserID            uuid.UUID `db:"user_id" json:"user_id"`
	FirstName         string    `db:"first_name" json:"first_name"`
	LastName          string    `db:"last_name" json:"last_name"`
	DateOfBirth       time.Time `db:"date_of_birth" json:"date_of_birth"`
	Bio               string    `db:"bio" json:"bio"`
	ProfilePictureURL *string   `db:"profile_picture_url" json:"profile_picture_url"`
	CreatedAt         time.Time `db:"created_at" json:"created_at"`
	UpdatedAt         time.Time `db:"updated_at" json:"updated_at"`
}

type JobSeekerEducation struct {
	ID              uuid.UUID  `db:"id" json:"id"`
	JobSeekerID     uuid.UUID  `db:"job_seeker_id" json:"job_seeker_id"`
	InstitutionName string     `db:"institution_name" json:"institution_name"`
	Degree          string     `db:"degree" json:"degree"`
	FieldOfStudy    string     `db:"field_of_study" json:"field_of_study"`
	StartDate       time.Time  `db:"start_date" json:"start_date"`
	EndDate         *time.Time `db:"end_date" json:"end_date"` // Use a pointer to allow null
	Grade           string     `db:"grade" json:"grade"`
	Description     string     `db:"description" json:"description"`
	CreatedAt       time.Time  `db:"created_at" json:"created_at"`
	UpdatedAt       time.Time  `db:"updated_at" json:"updated_at"`
}

type JobSeekerExperience struct {
	ID          uuid.UUID  `db:"id" json:"id"`
	JobSeekerID uuid.UUID  `db:"job_seeker_id" json:"job_seeker_id"`
	JobTitle    string     `db:"job_title" json:"job_title"`
	CompanyName string     `db:"company_name" json:"company_name"`
	StartDate   time.Time  `db:"start_date" json:"start_date"`
	EndDate     *time.Time `db:"end_date" json:"end_date"` // Use a pointer to allow null
	Description string     `db:"description" json:"description"`
	CreatedAt   time.Time  `db:"created_at" json:"created_at"`
	UpdatedAt   time.Time  `db:"updated_at" json:"updated_at"`
}

type JobSeekerLink struct {
	ID          uuid.UUID `db:"id" json:"id"`
	JobSeekerID uuid.UUID `db:"job_seeker_id" json:"job_seeker_id"`
	LinkType    string    `db:"link_type" json:"link_type"`
	URL         string    `db:"url" json:"url"`
	CreatedAt   time.Time `db:"created_at" json:"created_at"`
	UpdatedAt   time.Time `db:"updated_at" json:"updated_at"`
}

type JobSeekerPreference struct {
	ID                uuid.UUID `db:"id" json:"id"`
	JobSeekerID       uuid.UUID `db:"job_seeker_id" json:"job_seeker_id"`
	PreferredJobType  string    `db:"preferred_job_type" json:"preferred_job_type"`
	PreferredIndustry string    `db:"preferred_industry" json:"preferred_industry"`
	PreferredLocation string    `db:"preferred_location" json:"preferred_location"`
	SalaryExpectation *int      `db:"salary_expectation" json:"salary_expectation"` // Use a pointer to allow null
	RemotePreference  bool      `db:"remote_preference" json:"remote_preference"`
	CreatedAt         time.Time `db:"created_at" json:"created_at"`
	UpdatedAt         time.Time `db:"updated_at" json:"updated_at"`
}

type JobSeekerProject struct {
	ID          uuid.UUID  `db:"id" json:"id"`
	JobSeekerID uuid.UUID  `db:"job_seeker_id" json:"job_seeker_id"`
	Title       string     `db:"title" json:"title"`
	Description string     `db:"description" json:"description"`
	StartDate   time.Time  `db:"start_date" json:"start_date"`
	EndDate     *time.Time `db:"end_date" json:"end_date"` // Use a pointer to allow null
	Link        string     `db:"link" json:"link"`
	CreatedAt   time.Time  `db:"created_at" json:"created_at"`
	UpdatedAt   time.Time  `db:"updated_at" json:"updated_at"`
}

type JobSeekerSkill struct {
	ID               uuid.UUID `db:"id" json:"id"`
	JobSeekerID      uuid.UUID `db:"job_seeker_id" json:"job_seeker_id"`
	SkillName        string    `db:"skill_name" json:"skill_name"`
	ProficiencyLevel string    `db:"proficiency_level" json:"proficiency_level"`
	CreatedAt        time.Time `db:"created_at" json:"created_at"`
	UpdatedAt        time.Time `db:"updated_at" json:"updated_at"`
}

type Permissions struct {
	ViewUsers   bool `json:"view_users"`
	EditUsers   bool `json:"edit_users"`
	DeleteUsers bool `json:"delete_users"`
	ViewRoles   bool `json:"view_roles"`
	EditRoles   bool `json:"edit_roles"`
	DeleteRoles bool `json:"delete_roles"`
}

type User struct {
	UserID    uuid.UUID `db:"user_id" json:"user_id"`       // UUID for user UserID
	Username  string    `db:"username" json:"username"`     // User's username
	Email     string    `db:"email" json:"email"`           // User's email address
	Password  string    `db:"password" json:"-"`            // User's password (hashed)
	UserType  UserType  `db:"type" json:"type"`             // User type (employee, employer, admin)
	CreatedAt time.Time `db:"created_at" json:"created_at"` // Timestamp for when the user was created
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"` // Timestamp for when the user was last updated
}

type UserType string