// 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 AedtCalibrationBin struct {
	ModelKey      string          `json:"model_key"`
	Version       int32           `json:"version"`
	BinIndex      int32           `json:"bin_index"`
	BinLo         decimal.Decimal `json:"bin_lo"`
	BinHi         decimal.Decimal `json:"bin_hi"`
	EmpiricalRate decimal.Decimal `json:"empirical_rate"`
}

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 AedtLearnedModel struct {
	ModelKey      string    `json:"model_key"`
	Version       int32     `json:"version"`
	Family        string    `json:"family"`
	OutputKind    string    `json:"output_kind"`
	FeatureSpec   []byte    `json:"feature_spec"`
	EffectiveFrom time.Time `json:"effective_from"`
	Champion      bool      `json:"champion"`
	Notes         string    `json:"notes"`
}

type AedtModelCoefficient struct {
	ModelKey    string          `json:"model_key"`
	Version     int32           `json:"version"`
	FeatureName string          `json:"feature_name"`
	Coefficient decimal.Decimal `json:"coefficient"`
}

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 AioeRun struct {
	ID              uuid.UUID `json:"id"`
	RanAt           time.Time `json:"ran_at"`
	AsOf            time.Time `json:"as_of"`
	WindowDays      int32     `json:"window_days"`
	OrgsScanned     int32     `json:"orgs_scanned"`
	OutcomesSeen    int32     `json:"outcomes_seen"`
	ProfilesUpdated int32     `json:"profiles_updated"`
	TriggeredBy     string    `json:"triggered_by"`
}

type AioeWeightAdjustment struct {
	OrganizationID  uuid.UUID       `json:"organization_id"`
	ID              uuid.UUID       `json:"id"`
	ProfileID       uuid.UUID       `json:"profile_id"`
	ProducedVersion int32           `json:"produced_version"`
	Dimension       string          `json:"dimension"`
	OldValue        decimal.Decimal `json:"old_value"`
	NewValue        decimal.Decimal `json:"new_value"`
	WindowStart     time.Time       `json:"window_start"`
	WindowEnd       time.Time       `json:"window_end"`
	OutcomesUsed    int32           `json:"outcomes_used"`
	Rationale       string          `json:"rationale"`
	CreatedAt       time.Time       `json:"created_at"`
}

type AioeWeightProfile struct {
	OrganizationID   uuid.UUID `json:"organization_id"`
	ID               uuid.UUID `json:"id"`
	ProfileVersion   int32     `json:"profile_version"`
	DimensionWeights []byte    `json:"dimension_weights"`
	Status           string    `json:"status"`
	CreatedAt        time.Time `json:"created_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 Application struct {
	OrganizationID    uuid.UUID  `json:"organization_id"`
	ID                uuid.UUID  `json:"id"`
	RequisitionID     uuid.UUID  `json:"requisition_id"`
	CandidateID       uuid.UUID  `json:"candidate_id"`
	Stage             string     `json:"stage"`
	StageChangedAt    time.Time  `json:"stage_changed_at"`
	DispositionReason *string    `json:"disposition_reason"`
	SourceFirstTouch  string     `json:"source_first_touch"`
	SourceLastTouch   string     `json:"source_last_touch"`
	OwnerUserID       *uuid.UUID `json:"owner_user_id"`
	CreatedBy         *uuid.UUID `json:"created_by"`
	CreatedAt         time.Time  `json:"created_at"`
	UpdatedAt         time.Time  `json:"updated_at"`
}

type ApplicationStageEvent struct {
	OrganizationID uuid.UUID  `json:"organization_id"`
	ID             int64      `json:"id"`
	ApplicationID  uuid.UUID  `json:"application_id"`
	FromStage      *string    `json:"from_stage"`
	ToStage        string     `json:"to_stage"`
	Reason         string     `json:"reason"`
	ActorUserID    *uuid.UUID `json:"actor_user_id"`
	OccurredAt     time.Time  `json:"occurred_at"`
	CreatedAt      time.Time  `json:"created_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"`
	SourceFirstTouch      string           `json:"source_first_touch"`
	SourceLastTouch       string           `json:"source_last_touch"`
	SourceDetail          string           `json:"source_detail"`
}

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"`
	WeightProfileVersion string          `json:"weight_profile_version"`
}

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 Client struct {
	OrganizationID uuid.UUID  `json:"organization_id"`
	ID             uuid.UUID  `json:"id"`
	Name           string     `json:"name"`
	Uei            string     `json:"uei"`
	Industry       string     `json:"industry"`
	Website        string     `json:"website"`
	Status         string     `json:"status"`
	Notes          string     `json:"notes"`
	CreatedBy      *uuid.UUID `json:"created_by"`
	CreatedAt      time.Time  `json:"created_at"`
	UpdatedAt      time.Time  `json:"updated_at"`
}

type ClientContact struct {
	OrganizationID  uuid.UUID `json:"organization_id"`
	ID              uuid.UUID `json:"id"`
	ClientID        uuid.UUID `json:"client_id"`
	FullName        string    `json:"full_name"`
	Title           string    `json:"title"`
	Email           string    `json:"email"`
	Phone           string    `json:"phone"`
	IsHiringManager bool      `json:"is_hiring_manager"`
	IsPrimary       bool      `json:"is_primary"`
	Status          string    `json:"status"`
	CreatedAt       time.Time `json:"created_at"`
	UpdatedAt       time.Time `json:"updated_at"`
}

type ConnectorSyncState struct {
	OrganizationID uuid.UUID  `json:"organization_id"`
	ConnectorName  string     `json:"connector_name"`
	Watermark      time.Time  `json:"watermark"`
	LastRunAt      *time.Time `json:"last_run_at"`
	RecordsSynced  int64      `json:"records_synced"`
}

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 Interview struct {
	OrganizationID uuid.UUID  `json:"organization_id"`
	ID             uuid.UUID  `json:"id"`
	ApplicationID  uuid.UUID  `json:"application_id"`
	Round          int32      `json:"round"`
	Kind           string     `json:"kind"`
	ScheduledAt    *time.Time `json:"scheduled_at"`
	CompletedAt    *time.Time `json:"completed_at"`
	Outcome        string     `json:"outcome"`
	Interviewer    string     `json:"interviewer"`
	Notes          string     `json:"notes"`
	CreatedBy      *uuid.UUID `json:"created_by"`
	CreatedAt      time.Time  `json:"created_at"`
	UpdatedAt      time.Time  `json:"updated_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 Offer struct {
	OrganizationID uuid.UUID      `json:"organization_id"`
	ID             uuid.UUID      `json:"id"`
	ApplicationID  uuid.UUID      `json:"application_id"`
	Status         string         `json:"status"`
	EmploymentType string         `json:"employment_type"`
	BillRate       pgtype.Numeric `json:"bill_rate"`
	PayRate        pgtype.Numeric `json:"pay_rate"`
	Salary         pgtype.Numeric `json:"salary"`
	FeePct         pgtype.Numeric `json:"fee_pct"`
	ExtendedAt     time.Time      `json:"extended_at"`
	RespondedAt    *time.Time     `json:"responded_at"`
	ExpiresAt      *time.Time     `json:"expires_at"`
	DeclineReason  string         `json:"decline_reason"`
	CreatedBy      *uuid.UUID     `json:"created_by"`
	CreatedAt      time.Time      `json:"created_at"`
	UpdatedAt      time.Time      `json:"updated_at"`
}

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"`
	DisplayName   *string    `json:"display_name"`
	Logo          []byte     `json:"logo"`
	LogoMime      *string    `json:"logo_mime"`
	LogoUpdatedAt *time.Time `json:"logo_updated_at"`
}

type OutcomeEvent struct {
	OrganizationID uuid.UUID       `json:"organization_id"`
	ID             uuid.UUID       `json:"id"`
	Module         string          `json:"module"`
	SubjectType    string          `json:"subject_type"`
	SubjectID      uuid.UUID       `json:"subject_id"`
	EventType      string          `json:"event_type"`
	SignalValue    decimal.Decimal `json:"signal_value"`
	ReasonCode     string          `json:"reason_code"`
	ActorID        *uuid.UUID      `json:"actor_id"`
	OccurredAt     time.Time       `json:"occurred_at"`
	Metadata       []byte          `json:"metadata"`
	CreatedAt      time.Time       `json:"created_at"`
}

type Placement struct {
	OrganizationID uuid.UUID      `json:"organization_id"`
	ID             uuid.UUID      `json:"id"`
	ApplicationID  uuid.UUID      `json:"application_id"`
	OfferID        *uuid.UUID     `json:"offer_id"`
	Status         string         `json:"status"`
	EmploymentType string         `json:"employment_type"`
	StartDate      pgtype.Date    `json:"start_date"`
	EndDate        pgtype.Date    `json:"end_date"`
	BillRate       pgtype.Numeric `json:"bill_rate"`
	PayRate        pgtype.Numeric `json:"pay_rate"`
	Salary         pgtype.Numeric `json:"salary"`
	FeeAmount      pgtype.Numeric `json:"fee_amount"`
	GuaranteeDays  int32          `json:"guarantee_days"`
	CreatedBy      *uuid.UUID     `json:"created_by"`
	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 RecruiterActivity struct {
	OrganizationID uuid.UUID  `json:"organization_id"`
	ID             int64      `json:"id"`
	ActorUserID    uuid.UUID  `json:"actor_user_id"`
	Kind           string     `json:"kind"`
	Direction      string     `json:"direction"`
	Outcome        string     `json:"outcome"`
	CandidateID    *uuid.UUID `json:"candidate_id"`
	ContactID      *uuid.UUID `json:"contact_id"`
	RequisitionID  *uuid.UUID `json:"requisition_id"`
	ApplicationID  *uuid.UUID `json:"application_id"`
	Body           string     `json:"body"`
	AutoCaptured   bool       `json:"auto_captured"`
	OccurredAt     time.Time  `json:"occurred_at"`
	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 Requisition struct {
	OrganizationID  uuid.UUID      `json:"organization_id"`
	ID              uuid.UUID      `json:"id"`
	ClientID        *uuid.UUID     `json:"client_id"`
	HiringManagerID *uuid.UUID     `json:"hiring_manager_id"`
	OwnerUserID     *uuid.UUID     `json:"owner_user_id"`
	RequirementID   *uuid.UUID     `json:"requirement_id"`
	Title           string         `json:"title"`
	Description     string         `json:"description"`
	LaborCategory   string         `json:"labor_category"`
	Openings        int32          `json:"openings"`
	Priority        string         `json:"priority"`
	EmploymentType  string         `json:"employment_type"`
	Status          string         `json:"status"`
	RequiredLevel   string         `json:"required_level"`
	RequiredPoly    string         `json:"required_poly"`
	WorkLocation    string         `json:"work_location"`
	RemoteAllowed   bool           `json:"remote_allowed"`
	BillRateMin     pgtype.Numeric `json:"bill_rate_min"`
	BillRateMax     pgtype.Numeric `json:"bill_rate_max"`
	PayRateMin      pgtype.Numeric `json:"pay_rate_min"`
	PayRateMax      pgtype.Numeric `json:"pay_rate_max"`
	SalaryMin       pgtype.Numeric `json:"salary_min"`
	SalaryMax       pgtype.Numeric `json:"salary_max"`
	OpenedAt        time.Time      `json:"opened_at"`
	TargetFillDate  pgtype.Date    `json:"target_fill_date"`
	ClosedAt        *time.Time     `json:"closed_at"`
	HeldDays        int32          `json:"held_days"`
	CreatedBy       *uuid.UUID     `json:"created_by"`
	CreatedAt       time.Time      `json:"created_at"`
	UpdatedAt       time.Time      `json:"updated_at"`
	DeletedAt       *time.Time     `json:"deleted_at"`
}

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 StaffingVendor struct {
	OrganizationID uuid.UUID `json:"organization_id"`
	ID             uuid.UUID `json:"id"`
	Name           string    `json:"name"`
	Uei            string    `json:"uei"`
	VendorType     string    `json:"vendor_type"`
	CreatedAt      time.Time `json:"created_at"`
	UpdatedAt      time.Time `json:"updated_at"`
}

type Task struct {
	OrganizationID uuid.UUID  `json:"organization_id"`
	ID             uuid.UUID  `json:"id"`
	AssignedTo     uuid.UUID  `json:"assigned_to"`
	Title          string     `json:"title"`
	Detail         string     `json:"detail"`
	Status         string     `json:"status"`
	Priority       string     `json:"priority"`
	DueAt          *time.Time `json:"due_at"`
	CompletedAt    *time.Time `json:"completed_at"`
	CandidateID    *uuid.UUID `json:"candidate_id"`
	ContactID      *uuid.UUID `json:"contact_id"`
	RequisitionID  *uuid.UUID `json:"requisition_id"`
	ApplicationID  *uuid.UUID `json:"application_id"`
	CreatedBy      *uuid.UUID `json:"created_by"`
	CreatedAt      time.Time  `json:"created_at"`
	UpdatedAt      time.Time  `json:"updated_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 TermExpansion struct {
	ID             uuid.UUID  `json:"id"`
	OrganizationID *uuid.UUID `json:"organization_id"`
	Alias          string     `json:"alias"`
	Expansion      string     `json:"expansion"`
	CreatedBy      *uuid.UUID `json:"created_by"`
	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"`
}

type VendorSubmission struct {
	OrganizationID uuid.UUID  `json:"organization_id"`
	VendorID       uuid.UUID  `json:"vendor_id"`
	CandidateID    uuid.UUID  `json:"candidate_id"`
	RequirementID  uuid.UUID  `json:"requirement_id"`
	SubmittedAt    time.Time  `json:"submitted_at"`
	DecidedAt      *time.Time `json:"decided_at"`
	Status         string     `json:"status"`
	CreatedAt      time.Time  `json:"created_at"`
}