Janady13/missionmatch / internal/platform/database/dbgen/models.go

1// Code generated by sqlc. DO NOT EDIT. 2// versions: 3// sqlc v1.31.1 4 5package dbgen 6 7import ( 8 "net/netip" 9 "time" 10 11 "github.com/google/uuid" 12 "github.com/jackc/pgx/v5/pgtype" 13 pgvector "github.com/pgvector/pgvector-go" 14 "github.com/shopspring/decimal" 15) 16 17type AedtCalibrationBin struct { 18 ModelKey string `json:"model_key"` 19 Version int32 `json:"version"` 20 BinIndex int32 `json:"bin_index"` 21 BinLo decimal.Decimal `json:"bin_lo"` 22 BinHi decimal.Decimal `json:"bin_hi"` 23 EmpiricalRate decimal.Decimal `json:"empirical_rate"` 24} 25 26type AedtCandidateNotice struct { 27 ID uuid.UUID `json:"id"` 28 OrganizationID uuid.UUID `json:"organization_id"` 29 CandidateID uuid.UUID `json:"candidate_id"` 30 NoticeVersion string `json:"notice_version"` 31 DataCategories []byte `json:"data_categories"` 32 RetentionDays int32 `json:"retention_days"` 33 DisclosedBy *uuid.UUID `json:"disclosed_by"` 34 DisclosedAt time.Time `json:"disclosed_at"` 35} 36 37type AedtInventory struct { 38 ID uuid.UUID `json:"id"` 39 OrganizationID uuid.UUID `json:"organization_id"` 40 ToolKey string `json:"tool_key"` 41 DisplayName string `json:"display_name"` 42 Purpose string `json:"purpose"` 43 ModelVersion *string `json:"model_version"` 44 Active bool `json:"active"` 45 CreatedAt time.Time `json:"created_at"` 46 UpdatedAt time.Time `json:"updated_at"` 47} 48 49type AedtLearnedModel struct { 50 ModelKey string `json:"model_key"` 51 Version int32 `json:"version"` 52 Family string `json:"family"` 53 OutputKind string `json:"output_kind"` 54 FeatureSpec []byte `json:"feature_spec"` 55 EffectiveFrom time.Time `json:"effective_from"` 56 Champion bool `json:"champion"` 57 Notes string `json:"notes"` 58} 59 60type AedtModelCoefficient struct { 61 ModelKey string `json:"model_key"` 62 Version int32 `json:"version"` 63 FeatureName string `json:"feature_name"` 64 Coefficient decimal.Decimal `json:"coefficient"` 65} 66 67type AedtModelVersion struct { 68 Version string `json:"version"` 69 Weights []byte `json:"weights"` 70 BandCuts []byte `json:"band_cuts"` 71 Notes *string `json:"notes"` 72 EffectiveFrom time.Time `json:"effective_from"` 73 CreatedAt time.Time `json:"created_at"` 74} 75 76type AiMemory struct { 77 ID uuid.UUID `json:"id"` 78 OrganizationID uuid.UUID `json:"organization_id"` 79 CandidateID *uuid.UUID `json:"candidate_id"` 80 Kind string `json:"kind"` 81 Content string `json:"content"` 82 Embedding *pgvector.Vector `json:"embedding"` 83 CreatedAt time.Time `json:"created_at"` 84 UpdatedAt time.Time `json:"updated_at"` 85} 86 87type AioeRun struct { 88 ID uuid.UUID `json:"id"` 89 RanAt time.Time `json:"ran_at"` 90 AsOf time.Time `json:"as_of"` 91 WindowDays int32 `json:"window_days"` 92 OrgsScanned int32 `json:"orgs_scanned"` 93 OutcomesSeen int32 `json:"outcomes_seen"` 94 ProfilesUpdated int32 `json:"profiles_updated"` 95 TriggeredBy string `json:"triggered_by"` 96} 97 98type AioeWeightAdjustment struct { 99 OrganizationID uuid.UUID `json:"organization_id"` 100 ID uuid.UUID `json:"id"` 101 ProfileID uuid.UUID `json:"profile_id"` 102 ProducedVersion int32 `json:"produced_version"` 103 Dimension string `json:"dimension"` 104 OldValue decimal.Decimal `json:"old_value"` 105 NewValue decimal.Decimal `json:"new_value"` 106 WindowStart time.Time `json:"window_start"` 107 WindowEnd time.Time `json:"window_end"` 108 OutcomesUsed int32 `json:"outcomes_used"` 109 Rationale string `json:"rationale"` 110 CreatedAt time.Time `json:"created_at"` 111} 112 113type AioeWeightProfile struct { 114 OrganizationID uuid.UUID `json:"organization_id"` 115 ID uuid.UUID `json:"id"` 116 ProfileVersion int32 `json:"profile_version"` 117 DimensionWeights []byte `json:"dimension_weights"` 118 Status string `json:"status"` 119 CreatedAt time.Time `json:"created_at"` 120} 121 122type Alert struct { 123 ID uuid.UUID `json:"id"` 124 OrganizationID uuid.UUID `json:"organization_id"` 125 AlertType string `json:"alert_type"` 126 Severity string `json:"severity"` 127 SubjectType string `json:"subject_type"` 128 SubjectID *uuid.UUID `json:"subject_id"` 129 Title string `json:"title"` 130 Detail string `json:"detail"` 131 DedupeKey string `json:"dedupe_key"` 132 Status string `json:"status"` 133 CreatedAt time.Time `json:"created_at"` 134 UpdatedAt time.Time `json:"updated_at"` 135} 136 137type Application struct { 138 OrganizationID uuid.UUID `json:"organization_id"` 139 ID uuid.UUID `json:"id"` 140 RequisitionID uuid.UUID `json:"requisition_id"` 141 CandidateID uuid.UUID `json:"candidate_id"` 142 Stage string `json:"stage"` 143 StageChangedAt time.Time `json:"stage_changed_at"` 144 DispositionReason *string `json:"disposition_reason"` 145 SourceFirstTouch string `json:"source_first_touch"` 146 SourceLastTouch string `json:"source_last_touch"` 147 OwnerUserID *uuid.UUID `json:"owner_user_id"` 148 CreatedBy *uuid.UUID `json:"created_by"` 149 CreatedAt time.Time `json:"created_at"` 150 UpdatedAt time.Time `json:"updated_at"` 151 FurthestStageOrd int16 `json:"furthest_stage_ord"` 152 DispositionCode *string `json:"disposition_code"` 153} 154 155type ApplicationStageEvent struct { 156 OrganizationID uuid.UUID `json:"organization_id"` 157 ID int64 `json:"id"` 158 ApplicationID uuid.UUID `json:"application_id"` 159 FromStage *string `json:"from_stage"` 160 ToStage string `json:"to_stage"` 161 Reason string `json:"reason"` 162 ActorUserID *uuid.UUID `json:"actor_user_id"` 163 OccurredAt time.Time `json:"occurred_at"` 164 CreatedAt time.Time `json:"created_at"` 165 DispositionCode *string `json:"disposition_code"` 166 SecondsInFrom pgtype.Numeric `json:"seconds_in_from"` 167 ActorName string `json:"actor_name"` 168} 169 170type AuditLog struct { 171 ID int64 `json:"id"` 172 OrganizationID *uuid.UUID `json:"organization_id"` 173 ActorUserID *uuid.UUID `json:"actor_user_id"` 174 Action string `json:"action"` 175 EntityType *string `json:"entity_type"` 176 EntityID *string `json:"entity_id"` 177 OldValues []byte `json:"old_values"` 178 NewValues []byte `json:"new_values"` 179 IpAddress *string `json:"ip_address"` 180 UserAgent *string `json:"user_agent"` 181 CreatedAt time.Time `json:"created_at"` 182} 183 184type AuthCredential struct { 185 UserID uuid.UUID `json:"user_id"` 186 OrganizationID uuid.UUID `json:"organization_id"` 187 EmailNormalized string `json:"email_normalized"` 188 PasswordHash string `json:"password_hash"` 189 PepperVersion int32 `json:"pepper_version"` 190 FailedStreak int32 `json:"failed_streak"` 191 LockedUntil *time.Time `json:"locked_until"` 192 PasswordChangedAt time.Time `json:"password_changed_at"` 193 CreatedAt time.Time `json:"created_at"` 194 UpdatedAt time.Time `json:"updated_at"` 195} 196 197type AuthSession struct { 198 ID uuid.UUID `json:"id"` 199 TokenHash []byte `json:"token_hash"` 200 UserID uuid.UUID `json:"user_id"` 201 OrganizationID uuid.UUID `json:"organization_id"` 202 State string `json:"state"` 203 MfaSatisfied bool `json:"mfa_satisfied"` 204 CreatedAt time.Time `json:"created_at"` 205 LastSeenAt time.Time `json:"last_seen_at"` 206 IdleExpiresAt time.Time `json:"idle_expires_at"` 207 AbsoluteExpiresAt time.Time `json:"absolute_expires_at"` 208 RevokedAt *time.Time `json:"revoked_at"` 209 RotatedFrom *uuid.UUID `json:"rotated_from"` 210 IpAddress *string `json:"ip_address"` 211 UserAgent *string `json:"user_agent"` 212} 213 214type AwardIncumbentRole struct { 215 RecordTable string `json:"record_table"` 216 RecordID string `json:"record_id"` 217 LaborCategory string `json:"labor_category"` 218 RoleCount int32 `json:"role_count"` 219 Evidence string `json:"evidence"` 220 ClassifiedAt time.Time `json:"classified_at"` 221} 222 223type BenchImportLog struct { 224 ID uuid.UUID `json:"id"` 225 OrganizationID uuid.UUID `json:"organization_id"` 226 CandidateID *uuid.UUID `json:"candidate_id"` 227 Source string `json:"source"` 228 FileOrBatch string `json:"file_or_batch"` 229 LegalBasis string `json:"legal_basis"` 230 CollectedAt time.Time `json:"collected_at"` 231} 232 233type BidOutcome struct { 234 ID uuid.UUID `json:"id"` 235 OrganizationID uuid.UUID `json:"organization_id"` 236 OpportunityID *uuid.UUID `json:"opportunity_id"` 237 RequirementID *uuid.UUID `json:"requirement_id"` 238 SlateID *uuid.UUID `json:"slate_id"` 239 SubmittedAt *time.Time `json:"submitted_at"` 240 Result string `json:"result"` 241 AwardDate pgtype.Date `json:"award_date"` 242 AwardeeUei string `json:"awardee_uei"` 243 Notes string `json:"notes"` 244 CreatedAt time.Time `json:"created_at"` 245 UpdatedAt time.Time `json:"updated_at"` 246} 247 248type BlsWage struct { 249 SeriesID string `json:"series_id"` 250 OccupationCode string `json:"occupation_code"` 251 OccupationTitle string `json:"occupation_title"` 252 Role string `json:"role"` 253 Area string `json:"area"` 254 AreaName string `json:"area_name"` 255 Metric string `json:"metric"` 256 PeriodYear string `json:"period_year"` 257 Value *decimal.Decimal `json:"value"` 258 Raw []byte `json:"raw"` 259 SyncedAt time.Time `json:"synced_at"` 260} 261 262type Candidate struct { 263 ID uuid.UUID `json:"id"` 264 OrganizationID uuid.UUID `json:"organization_id"` 265 FullName string `json:"full_name"` 266 Email *string `json:"email"` 267 Headline *string `json:"headline"` 268 ClearanceLevel string `json:"clearance_level"` 269 ClearancePoly string `json:"clearance_poly"` 270 ClearanceStatus string `json:"clearance_status"` 271 ClearanceGrantedAt pgtype.Date `json:"clearance_granted_at"` 272 ClearanceExpiresAt pgtype.Date `json:"clearance_expires_at"` 273 ReinvestigationDueAt pgtype.Date `json:"reinvestigation_due_at"` 274 YearsExperience int32 `json:"years_experience"` 275 Location *string `json:"location"` 276 Remote bool `json:"remote"` 277 Relocatable bool `json:"relocatable"` 278 Available bool `json:"available"` 279 ResumeEmbedding *pgvector.Vector `json:"resume_embedding"` 280 SearchTsv interface{} `json:"search_tsv"` 281 CreatedAt time.Time `json:"created_at"` 282 UpdatedAt time.Time `json:"updated_at"` 283 DeletedAt *time.Time `json:"deleted_at"` 284 Source string `json:"source"` 285 ExternalID *string `json:"external_id"` 286 AnonymizedAt *time.Time `json:"anonymized_at"` 287 ClearanceProvenance string `json:"clearance_provenance"` 288 ClearanceVerifiedAt *time.Time `json:"clearance_verified_at"` 289 ClearanceCompartments []string `json:"clearance_compartments"` 290 SourceFirstTouch string `json:"source_first_touch"` 291 SourceLastTouch string `json:"source_last_touch"` 292 SourceDetail string `json:"source_detail"` 293 Provenance string `json:"provenance"` 294 OwnerUserID *uuid.UUID `json:"owner_user_id"` 295 MergedIntoID *uuid.UUID `json:"merged_into_id"` 296 CvEnrolled *bool `json:"cv_enrolled"` 297 CvEnrolledOn pgtype.Date `json:"cv_enrolled_on"` 298 AccessEndedOn pgtype.Date `json:"access_ended_on"` 299 LastAdjudicatedOn pgtype.Date `json:"last_adjudicated_on"` 300} 301 302type CandidateCertification struct { 303 OrganizationID uuid.UUID `json:"organization_id"` 304 CandidateID uuid.UUID `json:"candidate_id"` 305 Name string `json:"name"` 306} 307 308type CandidateCustomerExperience struct { 309 OrganizationID uuid.UUID `json:"organization_id"` 310 CandidateID uuid.UUID `json:"candidate_id"` 311 Agency string `json:"agency"` 312} 313 314type CandidateDocument struct { 315 OrganizationID uuid.UUID `json:"organization_id"` 316 ID uuid.UUID `json:"id"` 317 CandidateID uuid.UUID `json:"candidate_id"` 318 DocumentType string `json:"document_type"` 319 FileName string `json:"file_name"` 320 MediaType string `json:"media_type"` 321 StorageKey string `json:"storage_key"` 322 SizeBytes int64 `json:"size_bytes"` 323 Sha256 string `json:"sha256"` 324 UploadedByUserID *uuid.UUID `json:"uploaded_by_user_id"` 325 ExtractionStatus string `json:"extraction_status"` 326 ExtractionErrorCode string `json:"extraction_error_code"` 327 SupersedesDocumentID *uuid.UUID `json:"supersedes_document_id"` 328 IsCurrent bool `json:"is_current"` 329 CreatedAt time.Time `json:"created_at"` 330} 331 332type CandidateEvaluation struct { 333 OrganizationID uuid.UUID `json:"organization_id"` 334 CandidateID uuid.UUID `json:"candidate_id"` 335 RequirementID uuid.UUID `json:"requirement_id"` 336 TotalScore decimal.Decimal `json:"total_score"` 337 Band string `json:"band"` 338 ClearanceScore decimal.Decimal `json:"clearance_score"` 339 SkillsScore decimal.Decimal `json:"skills_score"` 340 CertsScore decimal.Decimal `json:"certs_score"` 341 CustomerScore decimal.Decimal `json:"customer_score"` 342 ExperienceScore decimal.Decimal `json:"experience_score"` 343 LocationScore decimal.Decimal `json:"location_score"` 344 Explanation string `json:"explanation"` 345 MatchedSkills []byte `json:"matched_skills"` 346 GapSummary []byte `json:"gap_summary"` 347 ModelVersion string `json:"model_version"` 348 EvaluatedBy *uuid.UUID `json:"evaluated_by"` 349 EvaluatedAt time.Time `json:"evaluated_at"` 350 UpdatedAt time.Time `json:"updated_at"` 351 WeightProfileVersion string `json:"weight_profile_version"` 352} 353 354type CandidateList struct { 355 OrganizationID uuid.UUID `json:"organization_id"` 356 ID uuid.UUID `json:"id"` 357 Name string `json:"name"` 358 Description string `json:"description"` 359 OwnerUserID uuid.UUID `json:"owner_user_id"` 360 Visibility string `json:"visibility"` 361 Purpose string `json:"purpose"` 362 Status string `json:"status"` 363 CreatedAt time.Time `json:"created_at"` 364 UpdatedAt time.Time `json:"updated_at"` 365} 366 367type CandidateListMember struct { 368 OrganizationID uuid.UUID `json:"organization_id"` 369 ListID uuid.UUID `json:"list_id"` 370 CandidateID uuid.UUID `json:"candidate_id"` 371 Note string `json:"note"` 372 AddedBy *uuid.UUID `json:"added_by"` 373 AddedAt time.Time `json:"added_at"` 374} 375 376type CandidateMerge struct { 377 OrganizationID uuid.UUID `json:"organization_id"` 378 ID uuid.UUID `json:"id"` 379 KeptID uuid.UUID `json:"kept_id"` 380 MergedID uuid.UUID `json:"merged_id"` 381 Moved []byte `json:"moved"` 382 Dropped []byte `json:"dropped"` 383 Reason string `json:"reason"` 384 MergedBy *uuid.UUID `json:"merged_by"` 385 CreatedAt time.Time `json:"created_at"` 386} 387 388type CandidateMissionTag struct { 389 OrganizationID uuid.UUID `json:"organization_id"` 390 CandidateID uuid.UUID `json:"candidate_id"` 391 MissionCode string `json:"mission_code"` 392 Mechanism string `json:"mechanism"` 393 Evidence string `json:"evidence"` 394} 395 396type CandidateSkill struct { 397 OrganizationID uuid.UUID `json:"organization_id"` 398 CandidateID uuid.UUID `json:"candidate_id"` 399 SkillID uuid.UUID `json:"skill_id"` 400} 401 402type CaptureGateDecision struct { 403 OrganizationID uuid.UUID `json:"organization_id"` 404 ID uuid.UUID `json:"id"` 405 OpportunityID uuid.UUID `json:"opportunity_id"` 406 Gate string `json:"gate"` 407 Decision string `json:"decision"` 408 DecidedBy *uuid.UUID `json:"decided_by"` 409 DecidedAt time.Time `json:"decided_at"` 410 Rationale string `json:"rationale"` 411 ReadinessScore pgtype.Numeric `json:"readiness_score"` 412 ReadinessBand *string `json:"readiness_band"` 413 WinProbability pgtype.Numeric `json:"win_probability"` 414 CreatedAt time.Time `json:"created_at"` 415} 416 417type ClearanceCompartment struct { 418 Code string `json:"code"` 419 Kind string `json:"kind"` 420 Label string `json:"label"` 421} 422 423type ClearanceLevel struct { 424 Code string `json:"code"` 425 Rank int32 `json:"rank"` 426 RequiresPolygraph bool `json:"requires_polygraph"` 427 Label string `json:"label"` 428} 429 430type ClearanceReciprocity struct { 431 HeldCode string `json:"held_code"` 432 RequiredCode string `json:"required_code"` 433 Satisfies bool `json:"satisfies"` 434 Source string `json:"source"` 435} 436 437type Client struct { 438 OrganizationID uuid.UUID `json:"organization_id"` 439 ID uuid.UUID `json:"id"` 440 Name string `json:"name"` 441 Uei string `json:"uei"` 442 Industry string `json:"industry"` 443 Website string `json:"website"` 444 Status string `json:"status"` 445 Notes string `json:"notes"` 446 CreatedBy *uuid.UUID `json:"created_by"` 447 CreatedAt time.Time `json:"created_at"` 448 UpdatedAt time.Time `json:"updated_at"` 449 OwnerUserID *uuid.UUID `json:"owner_user_id"` 450 OwnerSince *time.Time `json:"owner_since"` 451} 452 453type ClientContact struct { 454 OrganizationID uuid.UUID `json:"organization_id"` 455 ID uuid.UUID `json:"id"` 456 ClientID uuid.UUID `json:"client_id"` 457 FullName string `json:"full_name"` 458 Title string `json:"title"` 459 Email string `json:"email"` 460 Phone string `json:"phone"` 461 IsHiringManager bool `json:"is_hiring_manager"` 462 IsPrimary bool `json:"is_primary"` 463 Status string `json:"status"` 464 CreatedAt time.Time `json:"created_at"` 465 UpdatedAt time.Time `json:"updated_at"` 466} 467 468type ConnectorSyncState struct { 469 OrganizationID uuid.UUID `json:"organization_id"` 470 ConnectorName string `json:"connector_name"` 471 Watermark time.Time `json:"watermark"` 472 LastRunAt *time.Time `json:"last_run_at"` 473 RecordsSynced int64 `json:"records_synced"` 474} 475 476type CorpusChunk struct { 477 ID int64 `json:"id"` 478 DocumentID uuid.UUID `json:"document_id"` 479 PageNumber *int32 `json:"page_number"` 480 SectionLabel string `json:"section_label"` 481 TextContent string `json:"text_content"` 482 ContentHash string `json:"content_hash"` 483 Embedding interface{} `json:"embedding"` 484 ExtractionMethod string `json:"extraction_method"` 485 Confidence *float32 `json:"confidence"` 486 CreatedAt time.Time `json:"created_at"` 487 Provenance string `json:"provenance"` 488} 489 490type CorpusDocument struct { 491 ID uuid.UUID `json:"id"` 492 OpportunityRecordID uuid.UUID `json:"opportunity_record_id"` 493 ResourceID string `json:"resource_id"` 494 FileName string `json:"file_name"` 495 MediaType string `json:"media_type"` 496 SizeBytes *int64 `json:"size_bytes"` 497 Sha256 string `json:"sha256"` 498 SourceUrl string `json:"source_url"` 499 ExtractStatus string `json:"extract_status"` 500 ExtractError string `json:"extract_error"` 501 PageCount *int32 `json:"page_count"` 502 FetchedBytes *int64 `json:"fetched_bytes"` 503 FetchedAt *time.Time `json:"fetched_at"` 504 CreatedAt time.Time `json:"created_at"` 505 UpdatedAt time.Time `json:"updated_at"` 506 Provenance string `json:"provenance"` 507} 508 509type CurationProposal struct { 510 ID uuid.UUID `json:"id"` 511 Kind string `json:"kind"` 512 FromSkillID *uuid.UUID `json:"from_skill_id"` 513 ToSkillID *uuid.UUID `json:"to_skill_id"` 514 Relation *string `json:"relation"` 515 ProposedStrength *decimal.Decimal `json:"proposed_strength"` 516 EvidenceObservations int32 `json:"evidence_observations"` 517 EvidenceSuccesses int32 `json:"evidence_successes"` 518 ModelVersion string `json:"model_version"` 519 Status string `json:"status"` 520 Approver *uuid.UUID `json:"approver"` 521 ApprovedAt *time.Time `json:"approved_at"` 522 CreatedAt time.Time `json:"created_at"` 523} 524 525type DpBudgetLedger struct { 526 ID uuid.UUID `json:"id"` 527 ModelVersion string `json:"model_version"` 528 TenantID *uuid.UUID `json:"tenant_id"` 529 RdpOrders []byte `json:"rdp_orders"` 530 AccumulatedRdp decimal.Decimal `json:"accumulated_rdp"` 531 EpsilonAtDelta decimal.Decimal `json:"epsilon_at_delta"` 532 Delta decimal.Decimal `json:"delta"` 533 ContributingTenantCount int32 `json:"contributing_tenant_count"` 534 ReleasedAt time.Time `json:"released_at"` 535} 536 537type FederalMissionTag struct { 538 RecordTable string `json:"record_table"` 539 RecordID string `json:"record_id"` 540 MissionCode string `json:"mission_code"` 541 Mechanism string `json:"mechanism"` 542 Evidence string `json:"evidence"` 543 Confidence decimal.Decimal `json:"confidence"` 544 ClassifiedAt time.Time `json:"classified_at"` 545} 546 547type IngestManifest struct { 548 ID uuid.UUID `json:"id"` 549 Source string `json:"source"` 550 Url string `json:"url"` 551 License string `json:"license"` 552 FetchedAt time.Time `json:"fetched_at"` 553 RecordCount int32 `json:"record_count"` 554 ContentHash string `json:"content_hash"` 555 CreatedAt time.Time `json:"created_at"` 556} 557 558type Interview struct { 559 OrganizationID uuid.UUID `json:"organization_id"` 560 ID uuid.UUID `json:"id"` 561 ApplicationID uuid.UUID `json:"application_id"` 562 Round int32 `json:"round"` 563 Kind string `json:"kind"` 564 ScheduledAt *time.Time `json:"scheduled_at"` 565 CompletedAt *time.Time `json:"completed_at"` 566 Outcome string `json:"outcome"` 567 Interviewer string `json:"interviewer"` 568 Notes string `json:"notes"` 569 CreatedBy *uuid.UUID `json:"created_by"` 570 CreatedAt time.Time `json:"created_at"` 571 UpdatedAt time.Time `json:"updated_at"` 572} 573 574type InterviewOffer struct { 575 OrganizationID uuid.UUID `json:"organization_id"` 576 ID uuid.UUID `json:"id"` 577 ApplicationID uuid.UUID `json:"application_id"` 578 PublicToken string `json:"public_token"` 579 Kind string `json:"kind"` 580 Round int32 `json:"round"` 581 DurationMins int32 `json:"duration_mins"` 582 LocationText string `json:"location_text"` 583 Interviewer string `json:"interviewer"` 584 Message string `json:"message"` 585 Status string `json:"status"` 586 ExpiresAt time.Time `json:"expires_at"` 587 BookedSlotID *uuid.UUID `json:"booked_slot_id"` 588 InterviewID *uuid.UUID `json:"interview_id"` 589 CreatedBy *uuid.UUID `json:"created_by"` 590 CreatedAt time.Time `json:"created_at"` 591 UpdatedAt time.Time `json:"updated_at"` 592} 593 594type InterviewOfferSlot struct { 595 OrganizationID uuid.UUID `json:"organization_id"` 596 ID uuid.UUID `json:"id"` 597 OfferID uuid.UUID `json:"offer_id"` 598 StartsAt time.Time `json:"starts_at"` 599 EndsAt time.Time `json:"ends_at"` 600 Available bool `json:"available"` 601} 602 603type JobApplication struct { 604 OrganizationID uuid.UUID `json:"organization_id"` 605 ID uuid.UUID `json:"id"` 606 PostingID uuid.UUID `json:"posting_id"` 607 FullName string `json:"full_name"` 608 Email string `json:"email"` 609 Phone string `json:"phone"` 610 LocationText string `json:"location_text"` 611 CoverNote string `json:"cover_note"` 612 ClearanceSelfReported string `json:"clearance_self_reported"` 613 ResumeStorageKey string `json:"resume_storage_key"` 614 ResumeFileName string `json:"resume_file_name"` 615 ResumeMediaType string `json:"resume_media_type"` 616 ResumeSha256 string `json:"resume_sha256"` 617 Status string `json:"status"` 618 StatusReason string `json:"status_reason"` 619 ReviewedBy *uuid.UUID `json:"reviewed_by"` 620 ReviewedAt *time.Time `json:"reviewed_at"` 621 CandidateID *uuid.UUID `json:"candidate_id"` 622 Source string `json:"source"` 623 ConsentText string `json:"consent_text"` 624 ConsentedAt *time.Time `json:"consented_at"` 625 SubmittedIp *netip.Addr `json:"submitted_ip"` 626 CreatedAt time.Time `json:"created_at"` 627} 628 629type JobPosting struct { 630 OrganizationID uuid.UUID `json:"organization_id"` 631 ID uuid.UUID `json:"id"` 632 RequisitionID uuid.UUID `json:"requisition_id"` 633 PublicToken string `json:"public_token"` 634 Title string `json:"title"` 635 Summary string `json:"summary"` 636 Responsibilities string `json:"responsibilities"` 637 Qualifications string `json:"qualifications"` 638 LocationText string `json:"location_text"` 639 RemoteAllowed bool `json:"remote_allowed"` 640 EmploymentType string `json:"employment_type"` 641 ClearanceText string `json:"clearance_text"` 642 PayRangeText string `json:"pay_range_text"` 643 Status string `json:"status"` 644 PublishedAt *time.Time `json:"published_at"` 645 ClosesAt *time.Time `json:"closes_at"` 646 CreatedBy *uuid.UUID `json:"created_by"` 647 CreatedAt time.Time `json:"created_at"` 648 UpdatedAt time.Time `json:"updated_at"` 649} 650 651type KeyPersonnelCommitment struct { 652 OrganizationID uuid.UUID `json:"organization_id"` 653 ID uuid.UUID `json:"id"` 654 RequirementID uuid.UUID `json:"requirement_id"` 655 CandidateID *uuid.UUID `json:"candidate_id"` 656 TeamingPartnerID *uuid.UUID `json:"teaming_partner_id"` 657 PartnerPersonName string `json:"partner_person_name"` 658 RoleTitle string `json:"role_title"` 659 CommitmentType string `json:"commitment_type"` 660 Status string `json:"status"` 661 SignedOn pgtype.Date `json:"signed_on"` 662 ExpiresOn pgtype.Date `json:"expires_on"` 663 Notes string `json:"notes"` 664 CreatedBy *uuid.UUID `json:"created_by"` 665 CreatedAt time.Time `json:"created_at"` 666 UpdatedAt time.Time `json:"updated_at"` 667} 668 669type LoginAttempt struct { 670 ID int64 `json:"id"` 671 EmailNormalized string `json:"email_normalized"` 672 OrganizationID *uuid.UUID `json:"organization_id"` 673 IpAddress *string `json:"ip_address"` 674 Succeeded bool `json:"succeeded"` 675 Reason *string `json:"reason"` 676 CreatedAt time.Time `json:"created_at"` 677} 678 679type MailAccount struct { 680 OrganizationID uuid.UUID `json:"organization_id"` 681 UserID uuid.UUID `json:"user_id"` 682 ImapHost string `json:"imap_host"` 683 ImapPort int32 `json:"imap_port"` 684 ImapUsername string `json:"imap_username"` 685 Mailbox string `json:"mailbox"` 686 SyncSent bool `json:"sync_sent"` 687 Enabled bool `json:"enabled"` 688 VerifiedAt *time.Time `json:"verified_at"` 689 LastSyncAt *time.Time `json:"last_sync_at"` 690 LastError string `json:"last_error"` 691 LookbackDays int32 `json:"lookback_days"` 692 CreatedAt time.Time `json:"created_at"` 693 UpdatedAt time.Time `json:"updated_at"` 694} 695 696type Message struct { 697 OrganizationID uuid.UUID `json:"organization_id"` 698 ID uuid.UUID `json:"id"` 699 CandidateID *uuid.UUID `json:"candidate_id"` 700 ContactID *uuid.UUID `json:"contact_id"` 701 RequisitionID *uuid.UUID `json:"requisition_id"` 702 ApplicationID *uuid.UUID `json:"application_id"` 703 Channel string `json:"channel"` 704 Direction string `json:"direction"` 705 ToAddress string `json:"to_address"` 706 FromAddress string `json:"from_address"` 707 Subject string `json:"subject"` 708 Body string `json:"body"` 709 TemplateID *uuid.UUID `json:"template_id"` 710 SentByUserID *uuid.UUID `json:"sent_by_user_id"` 711 Status string `json:"status"` 712 ErrorText string `json:"error_text"` 713 CreatedAt time.Time `json:"created_at"` 714 SentAt *time.Time `json:"sent_at"` 715} 716 717type MessageTemplate struct { 718 OrganizationID uuid.UUID `json:"organization_id"` 719 ID uuid.UUID `json:"id"` 720 Name string `json:"name"` 721 Audience string `json:"audience"` 722 Subject string `json:"subject"` 723 Body string `json:"body"` 724 Status string `json:"status"` 725 CreatedBy *uuid.UUID `json:"created_by"` 726 CreatedAt time.Time `json:"created_at"` 727 UpdatedAt time.Time `json:"updated_at"` 728} 729 730type MfaRecoveryCode struct { 731 ID uuid.UUID `json:"id"` 732 UserID uuid.UUID `json:"user_id"` 733 OrganizationID uuid.UUID `json:"organization_id"` 734 CodeHash string `json:"code_hash"` 735 PepperVersion int32 `json:"pepper_version"` 736 LookupTag []byte `json:"lookup_tag"` 737 UsedAt *time.Time `json:"used_at"` 738 CreatedAt time.Time `json:"created_at"` 739} 740 741type MfaTotp struct { 742 UserID uuid.UUID `json:"user_id"` 743 OrganizationID uuid.UUID `json:"organization_id"` 744 SecretCiphertext []byte `json:"secret_ciphertext"` 745 SecretNonce []byte `json:"secret_nonce"` 746 KeyVersion int32 `json:"key_version"` 747 Status string `json:"status"` 748 LastUsedStep int64 `json:"last_used_step"` 749 CreatedAt time.Time `json:"created_at"` 750 ActivatedAt *time.Time `json:"activated_at"` 751} 752 753type MissionArea struct { 754 Code string `json:"code"` 755 Name string `json:"name"` 756 Description string `json:"description"` 757 SpineTerm *string `json:"spine_term"` 758 SortOrder int32 `json:"sort_order"` 759 CreatedAt time.Time `json:"created_at"` 760} 761 762type MissionSpine struct { 763 ID uuid.UUID `json:"id"` 764 Version string `json:"version"` 765 Term string `json:"term"` 766 CanonicalDefinition string `json:"canonical_definition"` 767 Authority string `json:"authority"` 768 SourceDoc string `json:"source_doc"` 769 SourceUrl string `json:"source_url"` 770 EffectiveDate pgtype.Date `json:"effective_date"` 771} 772 773type Offer struct { 774 OrganizationID uuid.UUID `json:"organization_id"` 775 ID uuid.UUID `json:"id"` 776 ApplicationID uuid.UUID `json:"application_id"` 777 Status string `json:"status"` 778 EmploymentType string `json:"employment_type"` 779 BillRate pgtype.Numeric `json:"bill_rate"` 780 PayRate pgtype.Numeric `json:"pay_rate"` 781 Salary pgtype.Numeric `json:"salary"` 782 FeePct pgtype.Numeric `json:"fee_pct"` 783 ExtendedAt time.Time `json:"extended_at"` 784 RespondedAt *time.Time `json:"responded_at"` 785 ExpiresAt *time.Time `json:"expires_at"` 786 DeclineReason string `json:"decline_reason"` 787 CreatedBy *uuid.UUID `json:"created_by"` 788 CreatedAt time.Time `json:"created_at"` 789 UpdatedAt time.Time `json:"updated_at"` 790 BurdenPct pgtype.Numeric `json:"burden_pct"` 791} 792 793type OntologyCrosswalk struct { 794 ID uuid.UUID `json:"id"` 795 FromSystem string `json:"from_system"` 796 FromCode string `json:"from_code"` 797 ToSystem string `json:"to_system"` 798 ToCode string `json:"to_code"` 799 Relation string `json:"relation"` 800 SourceName string `json:"source_name"` 801 SyncedAt time.Time `json:"synced_at"` 802} 803 804type OntologyTerm struct { 805 ID uuid.UUID `json:"id"` 806 SourceName string `json:"source_name"` 807 SourceRecordID string `json:"source_record_id"` 808 TermKind string `json:"term_kind"` 809 Term string `json:"term"` 810 Code string `json:"code"` 811 Category string `json:"category"` 812 Description string `json:"description"` 813 RawObjectKey string `json:"raw_object_key"` 814 RawSha256 string `json:"raw_sha256"` 815 FetchedAt time.Time `json:"fetched_at"` 816 SyncedAt time.Time `json:"synced_at"` 817} 818 819type Opportunity struct { 820 ID uuid.UUID `json:"id"` 821 OrganizationID uuid.UUID `json:"organization_id"` 822 Name string `json:"name"` 823 SolicitationNumber *string `json:"solicitation_number"` 824 CustomerAgency *string `json:"customer_agency"` 825 DueDate pgtype.Date `json:"due_date"` 826 Status string `json:"status"` 827 CreatedAt time.Time `json:"created_at"` 828 UpdatedAt time.Time `json:"updated_at"` 829 Value *decimal.Decimal `json:"value"` 830 ValueSource string `json:"value_source"` 831 FederalRef *string `json:"federal_ref"` 832} 833 834type OpportunityDocument struct { 835 OrganizationID uuid.UUID `json:"organization_id"` 836 ID uuid.UUID `json:"id"` 837 OpportunityID uuid.UUID `json:"opportunity_id"` 838 OpportunityVersionID *uuid.UUID `json:"opportunity_version_id"` 839 DocumentType string `json:"document_type"` 840 FileName string `json:"file_name"` 841 MediaType string `json:"media_type"` 842 StorageKey string `json:"storage_key"` 843 SizeBytes int64 `json:"size_bytes"` 844 Sha256 string `json:"sha256"` 845 SourceUrl string `json:"source_url"` 846 SourceType string `json:"source_type"` 847 UploadedByUserID *uuid.UUID `json:"uploaded_by_user_id"` 848 ExtractionStatus string `json:"extraction_status"` 849 ExtractionErrorCode string `json:"extraction_error_code"` 850 SupersedesDocumentID *uuid.UUID `json:"supersedes_document_id"` 851 IsCurrent bool `json:"is_current"` 852 CreatedAt time.Time `json:"created_at"` 853 Provenance string `json:"provenance"` 854} 855 856type OpportunityDocumentChunk struct { 857 OrganizationID uuid.UUID `json:"organization_id"` 858 ID uuid.UUID `json:"id"` 859 DocumentID uuid.UUID `json:"document_id"` 860 PageNumber *int32 `json:"page_number"` 861 SectionLabel string `json:"section_label"` 862 TextContent string `json:"text_content"` 863 ContentHash string `json:"content_hash"` 864 ExtractionMethod string `json:"extraction_method"` 865 Confidence float32 `json:"confidence"` 866 CreatedAt time.Time `json:"created_at"` 867 Provenance string `json:"provenance"` 868} 869 870type OpportunityRecord struct { 871 ID uuid.UUID `json:"id"` 872 SourceName string `json:"source_name"` 873 SourceRecordID string `json:"source_record_id"` 874 DedupeKey string `json:"dedupe_key"` 875 RecordKind string `json:"record_kind"` 876 Title string `json:"title"` 877 Agency string `json:"agency"` 878 SubAgency string `json:"sub_agency"` 879 Naics string `json:"naics"` 880 Psc string `json:"psc"` 881 PopCity string `json:"pop_city"` 882 PopState string `json:"pop_state"` 883 PopCountry string `json:"pop_country"` 884 PopZip string `json:"pop_zip"` 885 SetAside string `json:"set_aside"` 886 SetAsideCode string `json:"set_aside_code"` 887 ContractVehicle string `json:"contract_vehicle"` 888 EstimatedValue *decimal.Decimal `json:"estimated_value"` 889 ValueSource string `json:"value_source"` 890 IncumbentName string `json:"incumbent_name"` 891 IncumbentUei string `json:"incumbent_uei"` 892 PostedDate pgtype.Date `json:"posted_date"` 893 ResponseDeadline *time.Time `json:"response_deadline"` 894 AwardDate pgtype.Date `json:"award_date"` 895 EstimatedAwardDate pgtype.Date `json:"estimated_award_date"` 896 PopStartDate pgtype.Date `json:"pop_start_date"` 897 PopEndDate pgtype.Date `json:"pop_end_date"` 898 UiLink string `json:"ui_link"` 899 IsPlanning bool `json:"is_planning"` 900 RawObjectKey string `json:"raw_object_key"` 901 RawSha256 string `json:"raw_sha256"` 902 FetchedAt time.Time `json:"fetched_at"` 903 SyncedAt time.Time `json:"synced_at"` 904 Embedding *pgvector.Vector `json:"embedding"` 905 SearchTsv interface{} `json:"search_tsv"` 906 Provenance string `json:"provenance"` 907} 908 909type OpportunityScopeItem struct { 910 OrganizationID uuid.UUID `json:"organization_id"` 911 ID uuid.UUID `json:"id"` 912 OpportunityID uuid.UUID `json:"opportunity_id"` 913 ScopeType string `json:"scope_type"` 914 Title string `json:"title"` 915 Description string `json:"description"` 916 SourceDocumentID *uuid.UUID `json:"source_document_id"` 917 SourcePageNumber *int32 `json:"source_page_number"` 918 SourceSectionLabel string `json:"source_section_label"` 919 SourceQuoteHash string `json:"source_quote_hash"` 920 ExtractionMethod string `json:"extraction_method"` 921 ExtractionConfidence float32 `json:"extraction_confidence"` 922 ReviewStatus string `json:"review_status"` 923 ReviewedByUserID *uuid.UUID `json:"reviewed_by_user_id"` 924 ReviewedAt *time.Time `json:"reviewed_at"` 925 ParentScopeItemID *uuid.UUID `json:"parent_scope_item_id"` 926 DisplayOrder int32 `json:"display_order"` 927 CreatedAt time.Time `json:"created_at"` 928 UpdatedAt time.Time `json:"updated_at"` 929 Provenance string `json:"provenance"` 930} 931 932type OpportunityVersion struct { 933 OrganizationID uuid.UUID `json:"organization_id"` 934 ID uuid.UUID `json:"id"` 935 OpportunityID uuid.UUID `json:"opportunity_id"` 936 VersionNumber int32 `json:"version_number"` 937 AmendmentNumber string `json:"amendment_number"` 938 SourceVersionLabel string `json:"source_version_label"` 939 SourcePayloadHash string `json:"source_payload_hash"` 940 NormalizedPayload []byte `json:"normalized_payload"` 941 FetchedAt time.Time `json:"fetched_at"` 942 EffectiveAt *time.Time `json:"effective_at"` 943 SupersedesVersionID *uuid.UUID `json:"supersedes_version_id"` 944 IngestManifestID *uuid.UUID `json:"ingest_manifest_id"` 945 IsCurrent bool `json:"is_current"` 946 CreatedByUserID *uuid.UUID `json:"created_by_user_id"` 947 CreatedAt time.Time `json:"created_at"` 948} 949 950type OrgSecret struct { 951 OrganizationID uuid.UUID `json:"organization_id"` 952 Name string `json:"name"` 953 Ciphertext []byte `json:"ciphertext"` 954 Nonce []byte `json:"nonce"` 955 KeyVersion int32 `json:"key_version"` 956 CreatedAt time.Time `json:"created_at"` 957 UpdatedAt time.Time `json:"updated_at"` 958 UpdatedBy *uuid.UUID `json:"updated_by"` 959} 960 961type OrgSetting struct { 962 OrganizationID uuid.UUID `json:"organization_id"` 963 EmailDeliveryEnabled bool `json:"email_delivery_enabled"` 964 EmailFromAddress *string `json:"email_from_address"` 965 EmailFromName *string `json:"email_from_name"` 966 EmailReplyTo *string `json:"email_reply_to"` 967 SmtpHost *string `json:"smtp_host"` 968 SmtpPort *int32 `json:"smtp_port"` 969 SmtpUsername *string `json:"smtp_username"` 970 SmtpSecurity string `json:"smtp_security"` 971 SmtpVerifiedAt *time.Time `json:"smtp_verified_at"` 972 SmtpLastAttemptAt *time.Time `json:"smtp_last_attempt_at"` 973 SmtpLastError *string `json:"smtp_last_error"` 974 WorkVisibility string `json:"work_visibility"` 975 ShowActivityPresence bool `json:"show_activity_presence"` 976 ClaimRequired bool `json:"claim_required"` 977 ClaimExpiryHours int32 `json:"claim_expiry_hours"` 978 RateVisibility string `json:"rate_visibility"` 979 MarginVisibility string `json:"margin_visibility"` 980 ContactVisibility string `json:"contact_visibility"` 981 InviteExpiryHours int32 `json:"invite_expiry_hours"` 982 DefaultInviteRole string `json:"default_invite_role"` 983 UpdatedAt time.Time `json:"updated_at"` 984 UpdatedBy *uuid.UUID `json:"updated_by"` 985 StaffRecordScope string `json:"staff_record_scope"` 986 ManagerRecordScope string `json:"manager_record_scope"` 987 UnownedRecordsVisible bool `json:"unowned_records_visible"` 988 DefaultBurdenPct pgtype.Numeric `json:"default_burden_pct"` 989 AedtNoticeRequired bool `json:"aedt_notice_required"` 990} 991 992type Organization struct { 993 ID uuid.UUID `json:"id"` 994 Name string `json:"name"` 995 Slug string `json:"slug"` 996 Status string `json:"status"` 997 CreatedAt time.Time `json:"created_at"` 998 UpdatedAt time.Time `json:"updated_at"` 999 DisplayName *string `json:"display_name"` 1000 Logo []byte `json:"logo"` 1001 LogoMime *string `json:"logo_mime"` 1002 LogoUpdatedAt *time.Time `json:"logo_updated_at"` 1003 TimeZone string `json:"time_zone"` 1004} 1005 1006type OutcomeEvent struct { 1007 OrganizationID uuid.UUID `json:"organization_id"` 1008 ID uuid.UUID `json:"id"` 1009 Module string `json:"module"` 1010 SubjectType string `json:"subject_type"` 1011 SubjectID uuid.UUID `json:"subject_id"` 1012 EventType string `json:"event_type"` 1013 SignalValue decimal.Decimal `json:"signal_value"` 1014 ReasonCode string `json:"reason_code"` 1015 ActorID *uuid.UUID `json:"actor_id"` 1016 OccurredAt time.Time `json:"occurred_at"` 1017 Metadata []byte `json:"metadata"` 1018 CreatedAt time.Time `json:"created_at"` 1019} 1020 1021type Placement struct { 1022 OrganizationID uuid.UUID `json:"organization_id"` 1023 ID uuid.UUID `json:"id"` 1024 ApplicationID uuid.UUID `json:"application_id"` 1025 OfferID *uuid.UUID `json:"offer_id"` 1026 Status string `json:"status"` 1027 EmploymentType string `json:"employment_type"` 1028 StartDate pgtype.Date `json:"start_date"` 1029 EndDate pgtype.Date `json:"end_date"` 1030 BillRate pgtype.Numeric `json:"bill_rate"` 1031 PayRate pgtype.Numeric `json:"pay_rate"` 1032 Salary pgtype.Numeric `json:"salary"` 1033 FeeAmount pgtype.Numeric `json:"fee_amount"` 1034 GuaranteeDays int32 `json:"guarantee_days"` 1035 CreatedBy *uuid.UUID `json:"created_by"` 1036 CreatedAt time.Time `json:"created_at"` 1037 UpdatedAt time.Time `json:"updated_at"` 1038 BurdenPct pgtype.Numeric `json:"burden_pct"` 1039} 1040 1041type PolygraphType struct { 1042 Code string `json:"code"` 1043 Rank int32 `json:"rank"` 1044 Label string `json:"label"` 1045} 1046 1047type Proposal struct { 1048 OrganizationID uuid.UUID `json:"organization_id"` 1049 ID uuid.UUID `json:"id"` 1050 OpportunityID uuid.UUID `json:"opportunity_id"` 1051 Title string `json:"title"` 1052 Stage string `json:"stage"` 1053 Status string `json:"status"` 1054 ProposalOwnerUserID *uuid.UUID `json:"proposal_owner_user_id"` 1055 CaptureOwnerUserID *uuid.UUID `json:"capture_owner_user_id"` 1056 CustomerDeadline *time.Time `json:"customer_deadline"` 1057 InternalDeadline *time.Time `json:"internal_deadline"` 1058 SubmittedAt *time.Time `json:"submitted_at"` 1059 OutcomeRecordedAt *time.Time `json:"outcome_recorded_at"` 1060 CreatedAt time.Time `json:"created_at"` 1061 UpdatedAt time.Time `json:"updated_at"` 1062} 1063 1064type ProposalAttachment struct { 1065 OrganizationID uuid.UUID `json:"organization_id"` 1066 ID uuid.UUID `json:"id"` 1067 ProposalID uuid.UUID `json:"proposal_id"` 1068 AttachmentKind string `json:"attachment_kind"` 1069 Required bool `json:"required"` 1070 FileName string `json:"file_name"` 1071 ObjectKey string `json:"object_key"` 1072 ContentSha256 string `json:"content_sha256"` 1073 ByteSize int64 `json:"byte_size"` 1074 Status string `json:"status"` 1075 UploadedByUserID *uuid.UUID `json:"uploaded_by_user_id"` 1076 CreatedAt time.Time `json:"created_at"` 1077 UpdatedAt time.Time `json:"updated_at"` 1078} 1079 1080type ProposalComplianceItem struct { 1081 OrganizationID uuid.UUID `json:"organization_id"` 1082 ID uuid.UUID `json:"id"` 1083 ProposalID uuid.UUID `json:"proposal_id"` 1084 RequirementText string `json:"requirement_text"` 1085 SourceDocumentID *uuid.UUID `json:"source_document_id"` 1086 SourcePageNumber *int32 `json:"source_page_number"` 1087 SourceSectionLabel string `json:"source_section_label"` 1088 ResponseLocation string `json:"response_location"` 1089 OwnerUserID *uuid.UUID `json:"owner_user_id"` 1090 DueAt *time.Time `json:"due_at"` 1091 Required bool `json:"required"` 1092 Status string `json:"status"` 1093 EvidenceRef string `json:"evidence_ref"` 1094 ReviewerUserID *uuid.UUID `json:"reviewer_user_id"` 1095 CreatedAt time.Time `json:"created_at"` 1096 UpdatedAt time.Time `json:"updated_at"` 1097} 1098 1099type ProposalMilestone struct { 1100 OrganizationID uuid.UUID `json:"organization_id"` 1101 ID uuid.UUID `json:"id"` 1102 ProposalID uuid.UUID `json:"proposal_id"` 1103 Kind string `json:"kind"` 1104 DueAt *time.Time `json:"due_at"` 1105 CompletedAt *time.Time `json:"completed_at"` 1106 CreatedAt time.Time `json:"created_at"` 1107 UpdatedAt time.Time `json:"updated_at"` 1108} 1109 1110type ProposalReadinessSnapshot struct { 1111 OrganizationID uuid.UUID `json:"organization_id"` 1112 ID uuid.UUID `json:"id"` 1113 ProposalID uuid.UUID `json:"proposal_id"` 1114 Overall decimal.Decimal `json:"overall"` 1115 StaffingCoverage decimal.Decimal `json:"staffing_coverage"` 1116 ComplianceMatrix decimal.Decimal `json:"compliance_matrix"` 1117 RequiredSections decimal.Decimal `json:"required_sections"` 1118 ReviewAndApproval decimal.Decimal `json:"review_and_approval"` 1119 ScheduleHealth decimal.Decimal `json:"schedule_health"` 1120 RiskPosture decimal.Decimal `json:"risk_posture"` 1121 Blockers []byte `json:"blockers"` 1122 Drivers []byte `json:"drivers"` 1123 AlgorithmVersion string `json:"algorithm_version"` 1124 Stale bool `json:"stale"` 1125 CalculatedAt time.Time `json:"calculated_at"` 1126} 1127 1128type ProposalRisk struct { 1129 OrganizationID uuid.UUID `json:"organization_id"` 1130 ID uuid.UUID `json:"id"` 1131 ProposalID uuid.UUID `json:"proposal_id"` 1132 Title string `json:"title"` 1133 Likelihood string `json:"likelihood"` 1134 Impact string `json:"impact"` 1135 OwnerUserID *uuid.UUID `json:"owner_user_id"` 1136 Mitigation string `json:"mitigation"` 1137 TriggerCondition string `json:"trigger_condition"` 1138 Status string `json:"status"` 1139 RelatedScopeItemID *uuid.UUID `json:"related_scope_item_id"` 1140 CreatedAt time.Time `json:"created_at"` 1141 UpdatedAt time.Time `json:"updated_at"` 1142} 1143 1144type ProposalSection struct { 1145 OrganizationID uuid.UUID `json:"organization_id"` 1146 ID uuid.UUID `json:"id"` 1147 ProposalID uuid.UUID `json:"proposal_id"` 1148 SectionCode string `json:"section_code"` 1149 Title string `json:"title"` 1150 OwnerUserID *uuid.UUID `json:"owner_user_id"` 1151 Required bool `json:"required"` 1152 PageOrWordLimit string `json:"page_or_word_limit"` 1153 DueAt *time.Time `json:"due_at"` 1154 DraftStatus string `json:"draft_status"` 1155 ReviewStatus string `json:"review_status"` 1156 ApprovedByUserID *uuid.UUID `json:"approved_by_user_id"` 1157 ApprovedAt *time.Time `json:"approved_at"` 1158 CreatedAt time.Time `json:"created_at"` 1159 UpdatedAt time.Time `json:"updated_at"` 1160} 1161 1162type ProposalSectionVersion struct { 1163 OrganizationID uuid.UUID `json:"organization_id"` 1164 ID uuid.UUID `json:"id"` 1165 SectionID uuid.UUID `json:"section_id"` 1166 VersionNumber int32 `json:"version_number"` 1167 ContentRef string `json:"content_ref"` 1168 ContentSha256 string `json:"content_sha256"` 1169 AuthoredByUserID *uuid.UUID `json:"authored_by_user_id"` 1170 CreatedAt time.Time `json:"created_at"` 1171} 1172 1173type ProposalStaffingLink struct { 1174 OrganizationID uuid.UUID `json:"organization_id"` 1175 ID uuid.UUID `json:"id"` 1176 ProposalID uuid.UUID `json:"proposal_id"` 1177 RequirementID uuid.UUID `json:"requirement_id"` 1178 SlateID *uuid.UUID `json:"slate_id"` 1179 RequiredQuantity int32 `json:"required_quantity"` 1180 ApprovedCount int32 `json:"approved_count"` 1181 LaborCategory string `json:"labor_category"` 1182 PayRate pgtype.Numeric `json:"pay_rate"` 1183 BurdenPct pgtype.Numeric `json:"burden_pct"` 1184 BillRate pgtype.Numeric `json:"bill_rate"` 1185 WageFloorID *uuid.UUID `json:"wage_floor_id"` 1186 RateSource string `json:"rate_source"` 1187 RateVersion string `json:"rate_version"` 1188 PricedByUserID *uuid.UUID `json:"priced_by_user_id"` 1189 PricedAt *time.Time `json:"priced_at"` 1190 CreatedAt time.Time `json:"created_at"` 1191 UpdatedAt time.Time `json:"updated_at"` 1192} 1193 1194type ProposalTeamMember struct { 1195 OrganizationID uuid.UUID `json:"organization_id"` 1196 ID uuid.UUID `json:"id"` 1197 ProposalID uuid.UUID `json:"proposal_id"` 1198 UserID uuid.UUID `json:"user_id"` 1199 TeamRole string `json:"team_role"` 1200 Status string `json:"status"` 1201 CreatedAt time.Time `json:"created_at"` 1202 UpdatedAt time.Time `json:"updated_at"` 1203} 1204 1205type RecommendationRun struct { 1206 ID uuid.UUID `json:"id"` 1207 OrganizationID uuid.UUID `json:"organization_id"` 1208 View string `json:"view"` 1209 ScopeRef *uuid.UUID `json:"scope_ref"` 1210 ModelVersion string `json:"model_version"` 1211 Parameters []byte `json:"parameters"` 1212 CreatedBy *uuid.UUID `json:"created_by"` 1213 CreatedAt time.Time `json:"created_at"` 1214} 1215 1216type RecruiterActivity struct { 1217 OrganizationID uuid.UUID `json:"organization_id"` 1218 ID int64 `json:"id"` 1219 ActorUserID *uuid.UUID `json:"actor_user_id"` 1220 Kind string `json:"kind"` 1221 Direction string `json:"direction"` 1222 Outcome string `json:"outcome"` 1223 CandidateID *uuid.UUID `json:"candidate_id"` 1224 ContactID *uuid.UUID `json:"contact_id"` 1225 RequisitionID *uuid.UUID `json:"requisition_id"` 1226 ApplicationID *uuid.UUID `json:"application_id"` 1227 Body string `json:"body"` 1228 AutoCaptured bool `json:"auto_captured"` 1229 OccurredAt time.Time `json:"occurred_at"` 1230 CreatedAt time.Time `json:"created_at"` 1231 ActorName string `json:"actor_name"` 1232} 1233 1234type RecruitingGoal struct { 1235 OrganizationID uuid.UUID `json:"organization_id"` 1236 ID uuid.UUID `json:"id"` 1237 Scope string `json:"scope"` 1238 SubjectID *uuid.UUID `json:"subject_id"` 1239 Metric string `json:"metric"` 1240 PeriodStart pgtype.Date `json:"period_start"` 1241 PeriodDays int32 `json:"period_days"` 1242 Target decimal.Decimal `json:"target"` 1243 Note string `json:"note"` 1244 CreatedBy *uuid.UUID `json:"created_by"` 1245 CreatedAt time.Time `json:"created_at"` 1246 UpdatedAt time.Time `json:"updated_at"` 1247} 1248 1249type RequiredCertification struct { 1250 OrganizationID uuid.UUID `json:"organization_id"` 1251 RequirementID uuid.UUID `json:"requirement_id"` 1252 Name string `json:"name"` 1253} 1254 1255type RequiredSkill struct { 1256 OrganizationID uuid.UUID `json:"organization_id"` 1257 RequirementID uuid.UUID `json:"requirement_id"` 1258 SkillID uuid.UUID `json:"skill_id"` 1259 Mandatory bool `json:"mandatory"` 1260} 1261 1262type Requirement struct { 1263 ID uuid.UUID `json:"id"` 1264 OrganizationID uuid.UUID `json:"organization_id"` 1265 OpportunityID *uuid.UUID `json:"opportunity_id"` 1266 Title string `json:"title"` 1267 CustomerAgency *string `json:"customer_agency"` 1268 RequiredLevel string `json:"required_level"` 1269 RequiredPoly string `json:"required_poly"` 1270 RequiredYears int32 `json:"required_years"` 1271 WorkLocation *string `json:"work_location"` 1272 RemoteAllowed bool `json:"remote_allowed"` 1273 KeyPersonnel bool `json:"key_personnel"` 1274 CreatedAt time.Time `json:"created_at"` 1275 UpdatedAt time.Time `json:"updated_at"` 1276 DeletedAt *time.Time `json:"deleted_at"` 1277 LaborCategory *string `json:"labor_category"` 1278 Quantity int32 `json:"quantity"` 1279 RequiredCompartments []string `json:"required_compartments"` 1280} 1281 1282type RequirementDraft struct { 1283 OrganizationID uuid.UUID `json:"organization_id"` 1284 ID uuid.UUID `json:"id"` 1285 OpportunityID uuid.UUID `json:"opportunity_id"` 1286 SourceScopeItemID *uuid.UUID `json:"source_scope_item_id"` 1287 LaborCategory string `json:"labor_category"` 1288 Quantity int32 `json:"quantity"` 1289 ClearanceLevel string `json:"clearance_level"` 1290 Polygraph string `json:"polygraph"` 1291 Compartments []string `json:"compartments"` 1292 RequiredSkills []string `json:"required_skills"` 1293 MandatorySkillFlags []bool `json:"mandatory_skill_flags"` 1294 RequiredCertifications []string `json:"required_certifications"` 1295 MinimumYearsExperience int32 `json:"minimum_years_experience"` 1296 RequiredCustomerExperience []string `json:"required_customer_experience"` 1297 WorkLocation string `json:"work_location"` 1298 RemoteAllowed bool `json:"remote_allowed"` 1299 TravelPercent int32 `json:"travel_percent"` 1300 AvailabilityDate pgtype.Date `json:"availability_date"` 1301 EmploymentType string `json:"employment_type"` 1302 PayBandMin pgtype.Numeric `json:"pay_band_min"` 1303 PayBandMax pgtype.Numeric `json:"pay_band_max"` 1304 BillRateMin pgtype.Numeric `json:"bill_rate_min"` 1305 BillRateMax pgtype.Numeric `json:"bill_rate_max"` 1306 DerivationMethod string `json:"derivation_method"` 1307 DerivationConfidence float32 `json:"derivation_confidence"` 1308 ReviewStatus string `json:"review_status"` 1309 ReviewedByUserID *uuid.UUID `json:"reviewed_by_user_id"` 1310 ReviewedAt *time.Time `json:"reviewed_at"` 1311 ApprovedRequirementID *uuid.UUID `json:"approved_requirement_id"` 1312 CreatedAt time.Time `json:"created_at"` 1313 UpdatedAt time.Time `json:"updated_at"` 1314} 1315 1316type RequirementMissionTag struct { 1317 OrganizationID uuid.UUID `json:"organization_id"` 1318 RequirementID uuid.UUID `json:"requirement_id"` 1319 MissionCode string `json:"mission_code"` 1320 Mechanism string `json:"mechanism"` 1321 Evidence string `json:"evidence"` 1322} 1323 1324type Requisition struct { 1325 OrganizationID uuid.UUID `json:"organization_id"` 1326 ID uuid.UUID `json:"id"` 1327 ClientID *uuid.UUID `json:"client_id"` 1328 HiringManagerID *uuid.UUID `json:"hiring_manager_id"` 1329 OwnerUserID *uuid.UUID `json:"owner_user_id"` 1330 RequirementID *uuid.UUID `json:"requirement_id"` 1331 Title string `json:"title"` 1332 Description string `json:"description"` 1333 LaborCategory string `json:"labor_category"` 1334 Openings int32 `json:"openings"` 1335 Priority string `json:"priority"` 1336 EmploymentType string `json:"employment_type"` 1337 Status string `json:"status"` 1338 RequiredLevel string `json:"required_level"` 1339 RequiredPoly string `json:"required_poly"` 1340 WorkLocation string `json:"work_location"` 1341 RemoteAllowed bool `json:"remote_allowed"` 1342 BillRateMin pgtype.Numeric `json:"bill_rate_min"` 1343 BillRateMax pgtype.Numeric `json:"bill_rate_max"` 1344 PayRateMin pgtype.Numeric `json:"pay_rate_min"` 1345 PayRateMax pgtype.Numeric `json:"pay_rate_max"` 1346 SalaryMin pgtype.Numeric `json:"salary_min"` 1347 SalaryMax pgtype.Numeric `json:"salary_max"` 1348 OpenedAt time.Time `json:"opened_at"` 1349 TargetFillDate pgtype.Date `json:"target_fill_date"` 1350 ClosedAt *time.Time `json:"closed_at"` 1351 CreatedBy *uuid.UUID `json:"created_by"` 1352 CreatedAt time.Time `json:"created_at"` 1353 UpdatedAt time.Time `json:"updated_at"` 1354 DeletedAt *time.Time `json:"deleted_at"` 1355 HeldSeconds decimal.Decimal `json:"held_seconds"` 1356 HeldSince *time.Time `json:"held_since"` 1357 IntakeSource string `json:"intake_source"` 1358 VmsName string `json:"vms_name"` 1359 VmsRequisitionRef string `json:"vms_requisition_ref"` 1360 SubmissionDeadline *time.Time `json:"submission_deadline"` 1361 CompetingVendors *int32 `json:"competing_vendors"` 1362 MaxSubmissions *int32 `json:"max_submissions"` 1363} 1364 1365type RequisitionEvent struct { 1366 OrganizationID uuid.UUID `json:"organization_id"` 1367 ID uuid.UUID `json:"id"` 1368 RequisitionID uuid.UUID `json:"requisition_id"` 1369 FromStatus *string `json:"from_status"` 1370 ToStatus string `json:"to_status"` 1371 SecondsInFrom pgtype.Numeric `json:"seconds_in_from"` 1372 Note string `json:"note"` 1373 ActorUserID *uuid.UUID `json:"actor_user_id"` 1374 ActorName string `json:"actor_name"` 1375 OccurredAt time.Time `json:"occurred_at"` 1376} 1377 1378type SamOpportunity struct { 1379 NoticeID string `json:"notice_id"` 1380 Title string `json:"title"` 1381 SolicitationNumber string `json:"solicitation_number"` 1382 Department string `json:"department"` 1383 FullParentPath string `json:"full_parent_path"` 1384 SubAgency string `json:"sub_agency"` 1385 NaicsCode string `json:"naics_code"` 1386 PscCode string `json:"psc_code"` 1387 SetAsideCode string `json:"set_aside_code"` 1388 SetAside string `json:"set_aside"` 1389 NoticeType string `json:"notice_type"` 1390 BaseType string `json:"base_type"` 1391 PostedDate pgtype.Date `json:"posted_date"` 1392 ResponseDeadline *time.Time `json:"response_deadline"` 1393 Active bool `json:"active"` 1394 PopCity string `json:"pop_city"` 1395 PopState string `json:"pop_state"` 1396 PopZip string `json:"pop_zip"` 1397 UiLink string `json:"ui_link"` 1398 DescriptionUrl string `json:"description_url"` 1399 ResourceLinks []byte `json:"resource_links"` 1400 Poc []byte `json:"poc"` 1401 Raw []byte `json:"raw"` 1402 Source string `json:"source"` 1403 SyncedAt time.Time `json:"synced_at"` 1404 Provenance string `json:"provenance"` 1405} 1406 1407type SavedSearch struct { 1408 OrganizationID uuid.UUID `json:"organization_id"` 1409 ID uuid.UUID `json:"id"` 1410 Name string `json:"name"` 1411 OwnerUserID uuid.UUID `json:"owner_user_id"` 1412 Visibility string `json:"visibility"` 1413 Criteria []byte `json:"criteria"` 1414 Pinned bool `json:"pinned"` 1415 LastRunAt *time.Time `json:"last_run_at"` 1416 CreatedAt time.Time `json:"created_at"` 1417 UpdatedAt time.Time `json:"updated_at"` 1418} 1419 1420type Skill struct { 1421 ID uuid.UUID `json:"id"` 1422 Name string `json:"name"` 1423 Category *string `json:"category"` 1424 Embedding *pgvector.Vector `json:"embedding"` 1425 CreatedAt time.Time `json:"created_at"` 1426 Source string `json:"source"` 1427 SocCode string `json:"soc_code"` 1428} 1429 1430type SkillAlias struct { 1431 ID uuid.UUID `json:"id"` 1432 SkillID uuid.UUID `json:"skill_id"` 1433 AliasText string `json:"alias_text"` 1434 AliasType string `json:"alias_type"` 1435 Source string `json:"source"` 1436 Confidence decimal.Decimal `json:"confidence"` 1437 VerifiedAt *time.Time `json:"verified_at"` 1438 CreatedAt time.Time `json:"created_at"` 1439} 1440 1441type SkillRelationship struct { 1442 ID uuid.UUID `json:"id"` 1443 FromSkillID uuid.UUID `json:"from_skill_id"` 1444 ToSkillID uuid.UUID `json:"to_skill_id"` 1445 Relation string `json:"relation"` 1446 Strength decimal.Decimal `json:"strength"` 1447 Source string `json:"source"` 1448 VerifiedAt *time.Time `json:"verified_at"` 1449 CreatedAt time.Time `json:"created_at"` 1450 Verifier *uuid.UUID `json:"verifier"` 1451} 1452 1453type Slate struct { 1454 ID uuid.UUID `json:"id"` 1455 OrganizationID uuid.UUID `json:"organization_id"` 1456 RequirementID uuid.UUID `json:"requirement_id"` 1457 Name string `json:"name"` 1458 Status string `json:"status"` 1459 CreatedBy *uuid.UUID `json:"created_by"` 1460 CreatedAt time.Time `json:"created_at"` 1461 UpdatedAt time.Time `json:"updated_at"` 1462} 1463 1464type SlateMember struct { 1465 OrganizationID uuid.UUID `json:"organization_id"` 1466 SlateID uuid.UUID `json:"slate_id"` 1467 CandidateID uuid.UUID `json:"candidate_id"` 1468 TotalScore decimal.Decimal `json:"total_score"` 1469 Band string `json:"band"` 1470 ClearanceScore decimal.Decimal `json:"clearance_score"` 1471 SkillsScore decimal.Decimal `json:"skills_score"` 1472 CertsScore decimal.Decimal `json:"certs_score"` 1473 CustomerScore decimal.Decimal `json:"customer_score"` 1474 ExperienceScore decimal.Decimal `json:"experience_score"` 1475 LocationScore decimal.Decimal `json:"location_score"` 1476 Explanation string `json:"explanation"` 1477 Trace []byte `json:"trace"` 1478 GapSummary []byte `json:"gap_summary"` 1479 Decision string `json:"decision"` 1480 DecidedBy *uuid.UUID `json:"decided_by"` 1481 DecidedAt *time.Time `json:"decided_at"` 1482 Rank *int32 `json:"rank"` 1483 CreatedAt time.Time `json:"created_at"` 1484 ModelVersion *string `json:"model_version"` 1485 DecisionNote *string `json:"decision_note"` 1486 Status string `json:"status"` 1487 ApprovedByUserID *uuid.UUID `json:"approved_by_user_id"` 1488 ApprovedAt *time.Time `json:"approved_at"` 1489 WithdrawnByUserID *uuid.UUID `json:"withdrawn_by_user_id"` 1490 WithdrawnAt *time.Time `json:"withdrawn_at"` 1491 WithdrawalReason string `json:"withdrawal_reason"` 1492} 1493 1494type SolicitationExtraction struct { 1495 ID uuid.UUID `json:"id"` 1496 OpportunityRecordID uuid.UUID `json:"opportunity_record_id"` 1497 LaborCategory *string `json:"labor_category"` 1498 RequiredClearance *string `json:"required_clearance"` 1499 RequiredSkills []byte `json:"required_skills"` 1500 RequiredCertifications []byte `json:"required_certifications"`