// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.31.1

package dbgen

import (
	"time"

	"github.com/google/uuid"
	"github.com/jackc/pgx/v5/pgtype"
	pgvector "github.com/pgvector/pgvector-go"
	"github.com/shopspring/decimal"
)

type AedtCandidateNotice struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	CandidateID    uuid.UUID  `json:"candidate_id"`
	NoticeVersion  string     `json:"notice_version"`
	DataCategories []byte     `json:"data_categories"`
	RetentionDays  int32      `json:"retention_days"`
	DisclosedBy    *uuid.UUID `json:"disclosed_by"`
	DisclosedAt    time.Time  `json:"disclosed_at"`
}

type AedtInventory struct {
	ID             uuid.UUID `json:"id"`
	OrganizationID uuid.UUID `json:"organization_id"`
	ToolKey        string    `json:"tool_key"`
	DisplayName    string    `json:"display_name"`
	Purpose        string    `json:"purpose"`
	ModelVersion   *string   `json:"model_version"`
	Active         bool      `json:"active"`
	CreatedAt      time.Time `json:"created_at"`
	UpdatedAt      time.Time `json:"updated_at"`
}

type AedtModelVersion struct {
	Version       string    `json:"version"`
	Weights       []byte    `json:"weights"`
	BandCuts      []byte    `json:"band_cuts"`
	Notes         *string   `json:"notes"`
	EffectiveFrom time.Time `json:"effective_from"`
	CreatedAt     time.Time `json:"created_at"`
}

type AiMemory struct {
	ID             uuid.UUID        `json:"id"`
	OrganizationID uuid.UUID        `json:"organization_id"`
	CandidateID    *uuid.UUID       `json:"candidate_id"`
	Kind           string           `json:"kind"`
	Content        string           `json:"content"`
	Embedding      *pgvector.Vector `json:"embedding"`
	CreatedAt      time.Time        `json:"created_at"`
	UpdatedAt      time.Time        `json:"updated_at"`
}

type Alert struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	AlertType      string     `json:"alert_type"`
	Severity       string     `json:"severity"`
	SubjectType    string     `json:"subject_type"`
	SubjectID      *uuid.UUID `json:"subject_id"`
	Title          string     `json:"title"`
	Detail         string     `json:"detail"`
	DedupeKey      string     `json:"dedupe_key"`
	Status         string     `json:"status"`
	CreatedAt      time.Time  `json:"created_at"`
	UpdatedAt      time.Time  `json:"updated_at"`
}

type AuditLog struct {
	ID             int64      `json:"id"`
	OrganizationID *uuid.UUID `json:"organization_id"`
	ActorUserID    *uuid.UUID `json:"actor_user_id"`
	Action         string     `json:"action"`
	EntityType     *string    `json:"entity_type"`
	EntityID       *string    `json:"entity_id"`
	OldValues      []byte     `json:"old_values"`
	NewValues      []byte     `json:"new_values"`
	IpAddress      *string    `json:"ip_address"`
	UserAgent      *string    `json:"user_agent"`
	CreatedAt      time.Time  `json:"created_at"`
}

type AuthCredential struct {
	UserID            uuid.UUID  `json:"user_id"`
	OrganizationID    uuid.UUID  `json:"organization_id"`
	EmailNormalized   string     `json:"email_normalized"`
	PasswordHash      string     `json:"password_hash"`
	PepperVersion     int32      `json:"pepper_version"`
	FailedStreak      int32      `json:"failed_streak"`
	LockedUntil       *time.Time `json:"locked_until"`
	PasswordChangedAt time.Time  `json:"password_changed_at"`
	CreatedAt         time.Time  `json:"created_at"`
	UpdatedAt         time.Time  `json:"updated_at"`
}

type AuthSession struct {
	ID                uuid.UUID  `json:"id"`
	TokenHash         []byte     `json:"token_hash"`
	UserID            uuid.UUID  `json:"user_id"`
	OrganizationID    uuid.UUID  `json:"organization_id"`
	State             string     `json:"state"`
	MfaSatisfied      bool       `json:"mfa_satisfied"`
	CreatedAt         time.Time  `json:"created_at"`
	LastSeenAt        time.Time  `json:"last_seen_at"`
	IdleExpiresAt     time.Time  `json:"idle_expires_at"`
	AbsoluteExpiresAt time.Time  `json:"absolute_expires_at"`
	RevokedAt         *time.Time `json:"revoked_at"`
	RotatedFrom       *uuid.UUID `json:"rotated_from"`
	IpAddress         *string    `json:"ip_address"`
	UserAgent         *string    `json:"user_agent"`
}

type AwardIncumbentRole struct {
	RecordTable   string    `json:"record_table"`
	RecordID      string    `json:"record_id"`
	LaborCategory string    `json:"labor_category"`
	RoleCount     int32     `json:"role_count"`
	Evidence      string    `json:"evidence"`
	ClassifiedAt  time.Time `json:"classified_at"`
}

type BenchImportLog struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	CandidateID    *uuid.UUID `json:"candidate_id"`
	Source         string     `json:"source"`
	FileOrBatch    string     `json:"file_or_batch"`
	LegalBasis     string     `json:"legal_basis"`
	CollectedAt    time.Time  `json:"collected_at"`
}

type BidOutcome struct {
	ID             uuid.UUID   `json:"id"`
	OrganizationID uuid.UUID   `json:"organization_id"`
	OpportunityID  *uuid.UUID  `json:"opportunity_id"`
	RequirementID  *uuid.UUID  `json:"requirement_id"`
	SlateID        *uuid.UUID  `json:"slate_id"`
	SubmittedAt    *time.Time  `json:"submitted_at"`
	Result         string      `json:"result"`
	AwardDate      pgtype.Date `json:"award_date"`
	AwardeeUei     string      `json:"awardee_uei"`
	Notes          string      `json:"notes"`
	CreatedAt      time.Time   `json:"created_at"`
	UpdatedAt      time.Time   `json:"updated_at"`
}

type BlsWage struct {
	SeriesID        string           `json:"series_id"`
	OccupationCode  string           `json:"occupation_code"`
	OccupationTitle string           `json:"occupation_title"`
	Role            string           `json:"role"`
	Area            string           `json:"area"`
	AreaName        string           `json:"area_name"`
	Metric          string           `json:"metric"`
	PeriodYear      string           `json:"period_year"`
	Value           *decimal.Decimal `json:"value"`
	Raw             []byte           `json:"raw"`
	SyncedAt        time.Time        `json:"synced_at"`
}

type Candidate struct {
	ID                    uuid.UUID        `json:"id"`
	OrganizationID        uuid.UUID        `json:"organization_id"`
	FullName              string           `json:"full_name"`
	Email                 *string          `json:"email"`
	Headline              *string          `json:"headline"`
	ClearanceLevel        string           `json:"clearance_level"`
	ClearancePoly         string           `json:"clearance_poly"`
	ClearanceStatus       string           `json:"clearance_status"`
	ClearanceGrantedAt    pgtype.Date      `json:"clearance_granted_at"`
	ClearanceExpiresAt    pgtype.Date      `json:"clearance_expires_at"`
	ReinvestigationDueAt  pgtype.Date      `json:"reinvestigation_due_at"`
	YearsExperience       int32            `json:"years_experience"`
	Location              *string          `json:"location"`
	Remote                bool             `json:"remote"`
	Relocatable           bool             `json:"relocatable"`
	Available             bool             `json:"available"`
	ResumeEmbedding       *pgvector.Vector `json:"resume_embedding"`
	SearchTsv             interface{}      `json:"search_tsv"`
	CreatedAt             time.Time        `json:"created_at"`
	UpdatedAt             time.Time        `json:"updated_at"`
	DeletedAt             *time.Time       `json:"deleted_at"`
	Source                string           `json:"source"`
	ExternalID            *string          `json:"external_id"`
	AnonymizedAt          *time.Time       `json:"anonymized_at"`
	ClearanceProvenance   string           `json:"clearance_provenance"`
	ClearanceVerifiedAt   *time.Time       `json:"clearance_verified_at"`
	ClearanceCompartments []string         `json:"clearance_compartments"`
}

type CandidateCertification struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	CandidateID    uuid.UUID `json:"candidate_id"`
	Name           string    `json:"name"`
}

type CandidateCustomerExperience struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	CandidateID    uuid.UUID `json:"candidate_id"`
	Agency         string    `json:"agency"`
}

type CandidateEvaluation struct {
	OrganizationID  uuid.UUID       `json:"organization_id"`
	CandidateID     uuid.UUID       `json:"candidate_id"`
	RequirementID   uuid.UUID       `json:"requirement_id"`
	TotalScore      decimal.Decimal `json:"total_score"`
	Band            string          `json:"band"`
	ClearanceScore  decimal.Decimal `json:"clearance_score"`
	SkillsScore     decimal.Decimal `json:"skills_score"`
	CertsScore      decimal.Decimal `json:"certs_score"`
	CustomerScore   decimal.Decimal `json:"customer_score"`
	ExperienceScore decimal.Decimal `json:"experience_score"`
	LocationScore   decimal.Decimal `json:"location_score"`
	Explanation     string          `json:"explanation"`
	MatchedSkills   []byte          `json:"matched_skills"`
	GapSummary      []byte          `json:"gap_summary"`
	ModelVersion    string          `json:"model_version"`
	EvaluatedBy     *uuid.UUID      `json:"evaluated_by"`
	EvaluatedAt     time.Time       `json:"evaluated_at"`
	UpdatedAt       time.Time       `json:"updated_at"`
}

type CandidateMissionTag struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	CandidateID    uuid.UUID `json:"candidate_id"`
	MissionCode    string    `json:"mission_code"`
	Mechanism      string    `json:"mechanism"`
	Evidence       string    `json:"evidence"`
}

type CandidateSkill struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	CandidateID    uuid.UUID `json:"candidate_id"`
	SkillID        uuid.UUID `json:"skill_id"`
}

type ClearanceCompartment struct {
	Code  string `json:"code"`
	Kind  string `json:"kind"`
	Label string `json:"label"`
}

type ClearanceLevel struct {
	Code              string `json:"code"`
	Rank              int32  `json:"rank"`
	RequiresPolygraph bool   `json:"requires_polygraph"`
	Label             string `json:"label"`
}

type ClearanceReciprocity struct {
	HeldCode     string `json:"held_code"`
	RequiredCode string `json:"required_code"`
	Satisfies    bool   `json:"satisfies"`
	Source       string `json:"source"`
}

type CurationProposal struct {
	ID                   uuid.UUID        `json:"id"`
	Kind                 string           `json:"kind"`
	FromSkillID          *uuid.UUID       `json:"from_skill_id"`
	ToSkillID            *uuid.UUID       `json:"to_skill_id"`
	Relation             *string          `json:"relation"`
	ProposedStrength     *decimal.Decimal `json:"proposed_strength"`
	EvidenceObservations int32            `json:"evidence_observations"`
	EvidenceSuccesses    int32            `json:"evidence_successes"`
	ModelVersion         string           `json:"model_version"`
	Status               string           `json:"status"`
	Approver             *uuid.UUID       `json:"approver"`
	ApprovedAt           *time.Time       `json:"approved_at"`
	CreatedAt            time.Time        `json:"created_at"`
}

type DpBudgetLedger struct {
	ID                      uuid.UUID       `json:"id"`
	ModelVersion            string          `json:"model_version"`
	TenantID                *uuid.UUID      `json:"tenant_id"`
	RdpOrders               []byte          `json:"rdp_orders"`
	AccumulatedRdp          decimal.Decimal `json:"accumulated_rdp"`
	EpsilonAtDelta          decimal.Decimal `json:"epsilon_at_delta"`
	Delta                   decimal.Decimal `json:"delta"`
	ContributingTenantCount int32           `json:"contributing_tenant_count"`
	ReleasedAt              time.Time       `json:"released_at"`
}

type FederalMissionTag struct {
	RecordTable  string          `json:"record_table"`
	RecordID     string          `json:"record_id"`
	MissionCode  string          `json:"mission_code"`
	Mechanism    string          `json:"mechanism"`
	Evidence     string          `json:"evidence"`
	Confidence   decimal.Decimal `json:"confidence"`
	ClassifiedAt time.Time       `json:"classified_at"`
}

type LoginAttempt struct {
	ID              int64      `json:"id"`
	EmailNormalized string     `json:"email_normalized"`
	OrganizationID  *uuid.UUID `json:"organization_id"`
	IpAddress       *string    `json:"ip_address"`
	Succeeded       bool       `json:"succeeded"`
	Reason          *string    `json:"reason"`
	CreatedAt       time.Time  `json:"created_at"`
}

type MfaRecoveryCode struct {
	ID             uuid.UUID  `json:"id"`
	UserID         uuid.UUID  `json:"user_id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	CodeHash       string     `json:"code_hash"`
	PepperVersion  int32      `json:"pepper_version"`
	LookupTag      []byte     `json:"lookup_tag"`
	UsedAt         *time.Time `json:"used_at"`
	CreatedAt      time.Time  `json:"created_at"`
}

type MfaTotp struct {
	UserID           uuid.UUID  `json:"user_id"`
	OrganizationID   uuid.UUID  `json:"organization_id"`
	SecretCiphertext []byte     `json:"secret_ciphertext"`
	SecretNonce      []byte     `json:"secret_nonce"`
	KeyVersion       int32      `json:"key_version"`
	Status           string     `json:"status"`
	LastUsedStep     int64      `json:"last_used_step"`
	CreatedAt        time.Time  `json:"created_at"`
	ActivatedAt      *time.Time `json:"activated_at"`
}

type MissionArea struct {
	Code        string    `json:"code"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
	SpineTerm   *string   `json:"spine_term"`
	SortOrder   int32     `json:"sort_order"`
	CreatedAt   time.Time `json:"created_at"`
}

type MissionSpine struct {
	ID                  uuid.UUID   `json:"id"`
	Version             string      `json:"version"`
	Term                string      `json:"term"`
	CanonicalDefinition string      `json:"canonical_definition"`
	Authority           string      `json:"authority"`
	SourceDoc           string      `json:"source_doc"`
	SourceUrl           string      `json:"source_url"`
	EffectiveDate       pgtype.Date `json:"effective_date"`
}

type OntologyCrosswalk struct {
	ID         uuid.UUID `json:"id"`
	FromSystem string    `json:"from_system"`
	FromCode   string    `json:"from_code"`
	ToSystem   string    `json:"to_system"`
	ToCode     string    `json:"to_code"`
	Relation   string    `json:"relation"`
	SourceName string    `json:"source_name"`
	SyncedAt   time.Time `json:"synced_at"`
}

type OntologyTerm struct {
	ID             uuid.UUID `json:"id"`
	SourceName     string    `json:"source_name"`
	SourceRecordID string    `json:"source_record_id"`
	TermKind       string    `json:"term_kind"`
	Term           string    `json:"term"`
	Code           string    `json:"code"`
	Category       string    `json:"category"`
	Description    string    `json:"description"`
	RawObjectKey   string    `json:"raw_object_key"`
	RawSha256      string    `json:"raw_sha256"`
	FetchedAt      time.Time `json:"fetched_at"`
	SyncedAt       time.Time `json:"synced_at"`
}

type Opportunity struct {
	ID                 uuid.UUID        `json:"id"`
	OrganizationID     uuid.UUID        `json:"organization_id"`
	Name               string           `json:"name"`
	SolicitationNumber *string          `json:"solicitation_number"`
	CustomerAgency     *string          `json:"customer_agency"`
	DueDate            pgtype.Date      `json:"due_date"`
	Status             string           `json:"status"`
	CreatedAt          time.Time        `json:"created_at"`
	UpdatedAt          time.Time        `json:"updated_at"`
	Value              *decimal.Decimal `json:"value"`
	ValueSource        string           `json:"value_source"`
	FederalRef         *string          `json:"federal_ref"`
}

type OpportunityRecord struct {
	ID                 uuid.UUID        `json:"id"`
	SourceName         string           `json:"source_name"`
	SourceRecordID     string           `json:"source_record_id"`
	DedupeKey          string           `json:"dedupe_key"`
	RecordKind         string           `json:"record_kind"`
	Title              string           `json:"title"`
	Agency             string           `json:"agency"`
	SubAgency          string           `json:"sub_agency"`
	Naics              string           `json:"naics"`
	Psc                string           `json:"psc"`
	PopCity            string           `json:"pop_city"`
	PopState           string           `json:"pop_state"`
	PopCountry         string           `json:"pop_country"`
	PopZip             string           `json:"pop_zip"`
	SetAside           string           `json:"set_aside"`
	SetAsideCode       string           `json:"set_aside_code"`
	ContractVehicle    string           `json:"contract_vehicle"`
	EstimatedValue     *decimal.Decimal `json:"estimated_value"`
	ValueSource        string           `json:"value_source"`
	IncumbentName      string           `json:"incumbent_name"`
	IncumbentUei       string           `json:"incumbent_uei"`
	PostedDate         pgtype.Date      `json:"posted_date"`
	ResponseDeadline   *time.Time       `json:"response_deadline"`
	AwardDate          pgtype.Date      `json:"award_date"`
	EstimatedAwardDate pgtype.Date      `json:"estimated_award_date"`
	PopStartDate       pgtype.Date      `json:"pop_start_date"`
	PopEndDate         pgtype.Date      `json:"pop_end_date"`
	UiLink             string           `json:"ui_link"`
	IsPlanning         bool             `json:"is_planning"`
	RawObjectKey       string           `json:"raw_object_key"`
	RawSha256          string           `json:"raw_sha256"`
	FetchedAt          time.Time        `json:"fetched_at"`
	SyncedAt           time.Time        `json:"synced_at"`
}

type Organization struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	Slug      string    `json:"slug"`
	Status    string    `json:"status"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type PolygraphType struct {
	Code  string `json:"code"`
	Rank  int32  `json:"rank"`
	Label string `json:"label"`
}

type RecommendationRun struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	View           string     `json:"view"`
	ScopeRef       *uuid.UUID `json:"scope_ref"`
	ModelVersion   string     `json:"model_version"`
	Parameters     []byte     `json:"parameters"`
	CreatedBy      *uuid.UUID `json:"created_by"`
	CreatedAt      time.Time  `json:"created_at"`
}

type RequiredCertification struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	RequirementID  uuid.UUID `json:"requirement_id"`
	Name           string    `json:"name"`
}

type RequiredSkill struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	RequirementID  uuid.UUID `json:"requirement_id"`
	SkillID        uuid.UUID `json:"skill_id"`
	Mandatory      bool      `json:"mandatory"`
}

type Requirement struct {
	ID                   uuid.UUID  `json:"id"`
	OrganizationID       uuid.UUID  `json:"organization_id"`
	OpportunityID        *uuid.UUID `json:"opportunity_id"`
	Title                string     `json:"title"`
	CustomerAgency       *string    `json:"customer_agency"`
	RequiredLevel        string     `json:"required_level"`
	RequiredPoly         string     `json:"required_poly"`
	RequiredYears        int32      `json:"required_years"`
	WorkLocation         *string    `json:"work_location"`
	RemoteAllowed        bool       `json:"remote_allowed"`
	KeyPersonnel         bool       `json:"key_personnel"`
	CreatedAt            time.Time  `json:"created_at"`
	UpdatedAt            time.Time  `json:"updated_at"`
	DeletedAt            *time.Time `json:"deleted_at"`
	LaborCategory        *string    `json:"labor_category"`
	Quantity             int32      `json:"quantity"`
	RequiredCompartments []string   `json:"required_compartments"`
}

type RequirementMissionTag struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	RequirementID  uuid.UUID `json:"requirement_id"`
	MissionCode    string    `json:"mission_code"`
	Mechanism      string    `json:"mechanism"`
	Evidence       string    `json:"evidence"`
}

type SamOpportunity struct {
	NoticeID           string      `json:"notice_id"`
	Title              string      `json:"title"`
	SolicitationNumber string      `json:"solicitation_number"`
	Department         string      `json:"department"`
	FullParentPath     string      `json:"full_parent_path"`
	SubAgency          string      `json:"sub_agency"`
	NaicsCode          string      `json:"naics_code"`
	PscCode            string      `json:"psc_code"`
	SetAsideCode       string      `json:"set_aside_code"`
	SetAside           string      `json:"set_aside"`
	NoticeType         string      `json:"notice_type"`
	BaseType           string      `json:"base_type"`
	PostedDate         pgtype.Date `json:"posted_date"`
	ResponseDeadline   *time.Time  `json:"response_deadline"`
	Active             bool        `json:"active"`
	PopCity            string      `json:"pop_city"`
	PopState           string      `json:"pop_state"`
	PopZip             string      `json:"pop_zip"`
	UiLink             string      `json:"ui_link"`
	DescriptionUrl     string      `json:"description_url"`
	ResourceLinks      []byte      `json:"resource_links"`
	Poc                []byte      `json:"poc"`
	Raw                []byte      `json:"raw"`
	Source             string      `json:"source"`
	SyncedAt           time.Time   `json:"synced_at"`
}

type Skill struct {
	ID        uuid.UUID        `json:"id"`
	Name      string           `json:"name"`
	Category  *string          `json:"category"`
	Embedding *pgvector.Vector `json:"embedding"`
	CreatedAt time.Time        `json:"created_at"`
	Source    string           `json:"source"`
	SocCode   string           `json:"soc_code"`
}

type SkillAlias struct {
	ID         uuid.UUID       `json:"id"`
	SkillID    uuid.UUID       `json:"skill_id"`
	AliasText  string          `json:"alias_text"`
	AliasType  string          `json:"alias_type"`
	Source     string          `json:"source"`
	Confidence decimal.Decimal `json:"confidence"`
	VerifiedAt *time.Time      `json:"verified_at"`
	CreatedAt  time.Time       `json:"created_at"`
}

type SkillRelationship struct {
	ID          uuid.UUID       `json:"id"`
	FromSkillID uuid.UUID       `json:"from_skill_id"`
	ToSkillID   uuid.UUID       `json:"to_skill_id"`
	Relation    string          `json:"relation"`
	Strength    decimal.Decimal `json:"strength"`
	Source      string          `json:"source"`
	VerifiedAt  *time.Time      `json:"verified_at"`
	CreatedAt   time.Time       `json:"created_at"`
	Verifier    *uuid.UUID      `json:"verifier"`
}

type Slate struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	RequirementID  uuid.UUID  `json:"requirement_id"`
	Name           string     `json:"name"`
	Status         string     `json:"status"`
	CreatedBy      *uuid.UUID `json:"created_by"`
	CreatedAt      time.Time  `json:"created_at"`
	UpdatedAt      time.Time  `json:"updated_at"`
}

type SlateMember struct {
	OrganizationID  uuid.UUID       `json:"organization_id"`
	SlateID         uuid.UUID       `json:"slate_id"`
	CandidateID     uuid.UUID       `json:"candidate_id"`
	TotalScore      decimal.Decimal `json:"total_score"`
	Band            string          `json:"band"`
	ClearanceScore  decimal.Decimal `json:"clearance_score"`
	SkillsScore     decimal.Decimal `json:"skills_score"`
	CertsScore      decimal.Decimal `json:"certs_score"`
	CustomerScore   decimal.Decimal `json:"customer_score"`
	ExperienceScore decimal.Decimal `json:"experience_score"`
	LocationScore   decimal.Decimal `json:"location_score"`
	Explanation     string          `json:"explanation"`
	Trace           []byte          `json:"trace"`
	GapSummary      []byte          `json:"gap_summary"`
	Decision        string          `json:"decision"`
	DecidedBy       *uuid.UUID      `json:"decided_by"`
	DecidedAt       *time.Time      `json:"decided_at"`
	Rank            *int32          `json:"rank"`
	CreatedAt       time.Time       `json:"created_at"`
	ModelVersion    *string         `json:"model_version"`
	DecisionNote    *string         `json:"decision_note"`
}

type SourcingLog struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	CandidateID    *uuid.UUID `json:"candidate_id"`
	ExternalID     string     `json:"external_id"`
	Source         string     `json:"source"`
	Provider       string     `json:"provider"`
	Query          string     `json:"query"`
	LegalBasis     string     `json:"legal_basis"`
	CollectedAt    time.Time  `json:"collected_at"`
	CreatedAt      time.Time  `json:"created_at"`
}

type StaffingRecommendation struct {
	ID              uuid.UUID       `json:"id"`
	OrganizationID  uuid.UUID       `json:"organization_id"`
	RunID           uuid.UUID       `json:"run_id"`
	RequirementID   uuid.UUID       `json:"requirement_id"`
	CandidateID     *uuid.UUID      `json:"candidate_id"`
	Action          string          `json:"action"`
	Rank            int32           `json:"rank"`
	Confidence      decimal.Decimal `json:"confidence"`
	ValueScore      *int64          `json:"value_score"`
	Rationale       string          `json:"rationale"`
	RationaleSource string          `json:"rationale_source"`
	Evidence        []byte          `json:"evidence"`
	Status          string          `json:"status"`
	DecidedBy       *uuid.UUID      `json:"decided_by"`
	DecidedAt       *time.Time      `json:"decided_at"`
	DecisionNote    *string         `json:"decision_note"`
	CreatedAt       time.Time       `json:"created_at"`
}

type TeachingSignalAggregate struct {
	ID           uuid.UUID   `json:"id"`
	TenantID     *uuid.UUID  `json:"tenant_id"`
	DpApplied    bool        `json:"dp_applied"`
	Pattern      string      `json:"pattern"`
	Band         string      `json:"band"`
	Outcome      string      `json:"outcome"`
	ModelVersion string      `json:"model_version"`
	Observations int32       `json:"observations"`
	Successes    int32       `json:"successes"`
	WindowStart  pgtype.Date `json:"window_start"`
	WindowEnd    pgtype.Date `json:"window_end"`
	CreatedAt    time.Time   `json:"created_at"`
}

type UsaspendingAward struct {
	GeneratedInternalID string           `json:"generated_internal_id"`
	AwardID             string           `json:"award_id"`
	RecipientName       string           `json:"recipient_name"`
	RecipientUei        string           `json:"recipient_uei"`
	RecipientID         string           `json:"recipient_id"`
	AwardAmount         *decimal.Decimal `json:"award_amount"`
	AwardingAgency      string           `json:"awarding_agency"`
	AwardingSubAgency   string           `json:"awarding_sub_agency"`
	PopStartDate        pgtype.Date      `json:"pop_start_date"`
	PopEndDate          pgtype.Date      `json:"pop_end_date"`
	NaicsCode           string           `json:"naics_code"`
	NaicsDescription    string           `json:"naics_description"`
	Description         string           `json:"description"`
	IsGalapagos         bool             `json:"is_galapagos"`
	Raw                 []byte           `json:"raw"`
	Source              string           `json:"source"`
	SyncedAt            time.Time        `json:"synced_at"`
}

type User struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID uuid.UUID  `json:"organization_id"`
	Email          string     `json:"email"`
	FullName       string     `json:"full_name"`
	Role           string     `json:"role"`
	Status         string     `json:"status"`
	LastLoginAt    *time.Time `json:"last_login_at"`
	CreatedAt      time.Time  `json:"created_at"`
	UpdatedAt      time.Time  `json:"updated_at"`
	MfaEnrolled    bool       `json:"mfa_enrolled"`
}

type UserInvite struct {
	ID              uuid.UUID  `json:"id"`
	OrganizationID  uuid.UUID  `json:"organization_id"`
	EmailNormalized string     `json:"email_normalized"`
	InvitedUserID   uuid.UUID  `json:"invited_user_id"`
	TokenHash       []byte     `json:"token_hash"`
	Role            string     `json:"role"`
	ExpiresAt       time.Time  `json:"expires_at"`
	AcceptedAt      *time.Time `json:"accepted_at"`
	CreatedBy       uuid.UUID  `json:"created_by"`
	CreatedAt       time.Time  `json:"created_at"`
}