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 "time" 9 10 "github.com/google/uuid" 11 "github.com/jackc/pgx/v5/pgtype" 12 pgvector "github.com/pgvector/pgvector-go" 13 "github.com/shopspring/decimal" 14) 15 16type AedtCalibrationBin struct { 17 ModelKey string `json:"model_key"` 18 Version int32 `json:"version"` 19 BinIndex int32 `json:"bin_index"` 20 BinLo decimal.Decimal `json:"bin_lo"` 21 BinHi decimal.Decimal `json:"bin_hi"` 22 EmpiricalRate decimal.Decimal `json:"empirical_rate"` 23} 24 25type AedtCandidateNotice struct { 26 ID uuid.UUID `json:"id"` 27 OrganizationID uuid.UUID `json:"organization_id"` 28 CandidateID uuid.UUID `json:"candidate_id"` 29 NoticeVersion string `json:"notice_version"` 30 DataCategories []byte `json:"data_categories"` 31 RetentionDays int32 `json:"retention_days"` 32 DisclosedBy *uuid.UUID `json:"disclosed_by"` 33 DisclosedAt time.Time `json:"disclosed_at"` 34} 35 36type AedtInventory struct { 37 ID uuid.UUID `json:"id"` 38 OrganizationID uuid.UUID `json:"organization_id"` 39 ToolKey string `json:"tool_key"` 40 DisplayName string `json:"display_name"` 41 Purpose string `json:"purpose"` 42 ModelVersion *string `json:"model_version"` 43 Active bool `json:"active"` 44 CreatedAt time.Time `json:"created_at"` 45 UpdatedAt time.Time `json:"updated_at"` 46} 47 48type AedtLearnedModel struct { 49 ModelKey string `json:"model_key"` 50 Version int32 `json:"version"` 51 Family string `json:"family"` 52 OutputKind string `json:"output_kind"` 53 FeatureSpec []byte `json:"feature_spec"` 54 EffectiveFrom time.Time `json:"effective_from"` 55 Champion bool `json:"champion"` 56 Notes string `json:"notes"` 57} 58 59type AedtModelCoefficient struct { 60 ModelKey string `json:"model_key"` 61 Version int32 `json:"version"` 62 FeatureName string `json:"feature_name"` 63 Coefficient decimal.Decimal `json:"coefficient"` 64} 65 66type AedtModelVersion struct { 67 Version string `json:"version"` 68 Weights []byte `json:"weights"` 69 BandCuts []byte `json:"band_cuts"` 70 Notes *string `json:"notes"` 71 EffectiveFrom time.Time `json:"effective_from"` 72 CreatedAt time.Time `json:"created_at"` 73} 74 75type AiMemory struct { 76 ID uuid.UUID `json:"id"` 77 OrganizationID uuid.UUID `json:"organization_id"` 78 CandidateID *uuid.UUID `json:"candidate_id"` 79 Kind string `json:"kind"` 80 Content string `json:"content"` 81 Embedding *pgvector.Vector `json:"embedding"` 82 CreatedAt time.Time `json:"created_at"` 83 UpdatedAt time.Time `json:"updated_at"` 84} 85 86type AioeRun struct { 87 ID uuid.UUID `json:"id"` 88 RanAt time.Time `json:"ran_at"` 89 AsOf time.Time `json:"as_of"` 90 WindowDays int32 `json:"window_days"` 91 OrgsScanned int32 `json:"orgs_scanned"` 92 OutcomesSeen int32 `json:"outcomes_seen"` 93 ProfilesUpdated int32 `json:"profiles_updated"` 94 TriggeredBy string `json:"triggered_by"` 95} 96 97type AioeWeightAdjustment struct { 98 OrganizationID uuid.UUID `json:"organization_id"` 99 ID uuid.UUID `json:"id"` 100 ProfileID uuid.UUID `json:"profile_id"` 101 ProducedVersion int32 `json:"produced_version"` 102 Dimension string `json:"dimension"` 103 OldValue decimal.Decimal `json:"old_value"` 104 NewValue decimal.Decimal `json:"new_value"` 105 WindowStart time.Time `json:"window_start"` 106 WindowEnd time.Time `json:"window_end"` 107 OutcomesUsed int32 `json:"outcomes_used"` 108 Rationale string `json:"rationale"` 109 CreatedAt time.Time `json:"created_at"` 110} 111 112type AioeWeightProfile struct { 113 OrganizationID uuid.UUID `json:"organization_id"` 114 ID uuid.UUID `json:"id"` 115 ProfileVersion int32 `json:"profile_version"` 116 DimensionWeights []byte `json:"dimension_weights"` 117 Status string `json:"status"` 118 CreatedAt time.Time `json:"created_at"` 119} 120 121type Alert struct { 122 ID uuid.UUID `json:"id"` 123 OrganizationID uuid.UUID `json:"organization_id"` 124 AlertType string `json:"alert_type"` 125 Severity string `json:"severity"` 126 SubjectType string `json:"subject_type"` 127 SubjectID *uuid.UUID `json:"subject_id"` 128 Title string `json:"title"` 129 Detail string `json:"detail"` 130 DedupeKey string `json:"dedupe_key"` 131 Status string `json:"status"` 132 CreatedAt time.Time `json:"created_at"` 133 UpdatedAt time.Time `json:"updated_at"` 134} 135 136type Application struct { 137 OrganizationID uuid.UUID `json:"organization_id"` 138 ID uuid.UUID `json:"id"` 139 RequisitionID uuid.UUID `json:"requisition_id"` 140 CandidateID uuid.UUID `json:"candidate_id"` 141 Stage string `json:"stage"` 142 StageChangedAt time.Time `json:"stage_changed_at"` 143 DispositionReason *string `json:"disposition_reason"` 144 SourceFirstTouch string `json:"source_first_touch"` 145 SourceLastTouch string `json:"source_last_touch"` 146 OwnerUserID *uuid.UUID `json:"owner_user_id"` 147 CreatedBy *uuid.UUID `json:"created_by"` 148 CreatedAt time.Time `json:"created_at"` 149 UpdatedAt time.Time `json:"updated_at"` 150} 151 152type ApplicationStageEvent struct { 153 OrganizationID uuid.UUID `json:"organization_id"` 154 ID int64 `json:"id"` 155 ApplicationID uuid.UUID `json:"application_id"` 156 FromStage *string `json:"from_stage"` 157 ToStage string `json:"to_stage"` 158 Reason string `json:"reason"` 159 ActorUserID *uuid.UUID `json:"actor_user_id"` 160 OccurredAt time.Time `json:"occurred_at"` 161 CreatedAt time.Time `json:"created_at"` 162} 163 164type AuditLog struct { 165 ID int64 `json:"id"` 166 OrganizationID *uuid.UUID `json:"organization_id"` 167 ActorUserID *uuid.UUID `json:"actor_user_id"` 168 Action string `json:"action"` 169 EntityType *string `json:"entity_type"` 170 EntityID *string `json:"entity_id"` 171 OldValues []byte `json:"old_values"` 172 NewValues []byte `json:"new_values"` 173 IpAddress *string `json:"ip_address"` 174 UserAgent *string `json:"user_agent"` 175 CreatedAt time.Time `json:"created_at"` 176} 177 178type AuthCredential struct { 179 UserID uuid.UUID `json:"user_id"` 180 OrganizationID uuid.UUID `json:"organization_id"` 181 EmailNormalized string `json:"email_normalized"` 182 PasswordHash string `json:"password_hash"` 183 PepperVersion int32 `json:"pepper_version"` 184 FailedStreak int32 `json:"failed_streak"` 185 LockedUntil *time.Time `json:"locked_until"` 186 PasswordChangedAt time.Time `json:"password_changed_at"` 187 CreatedAt time.Time `json:"created_at"` 188 UpdatedAt time.Time `json:"updated_at"` 189} 190 191type AuthSession struct { 192 ID uuid.UUID `json:"id"` 193 TokenHash []byte `json:"token_hash"` 194 UserID uuid.UUID `json:"user_id"` 195 OrganizationID uuid.UUID `json:"organization_id"` 196 State string `json:"state"` 197 MfaSatisfied bool `json:"mfa_satisfied"` 198 CreatedAt time.Time `json:"created_at"` 199 LastSeenAt time.Time `json:"last_seen_at"` 200 IdleExpiresAt time.Time `json:"idle_expires_at"` 201 AbsoluteExpiresAt time.Time `json:"absolute_expires_at"` 202 RevokedAt *time.Time `json:"revoked_at"` 203 RotatedFrom *uuid.UUID `json:"rotated_from"` 204 IpAddress *string `json:"ip_address"` 205 UserAgent *string `json:"user_agent"` 206} 207 208type AwardIncumbentRole struct { 209 RecordTable string `json:"record_table"` 210 RecordID string `json:"record_id"` 211 LaborCategory string `json:"labor_category"` 212 RoleCount int32 `json:"role_count"` 213 Evidence string `json:"evidence"` 214 ClassifiedAt time.Time `json:"classified_at"` 215} 216 217type BenchImportLog struct { 218 ID uuid.UUID `json:"id"` 219 OrganizationID uuid.UUID `json:"organization_id"` 220 CandidateID *uuid.UUID `json:"candidate_id"` 221 Source string `json:"source"` 222 FileOrBatch string `json:"file_or_batch"` 223 LegalBasis string `json:"legal_basis"` 224 CollectedAt time.Time `json:"collected_at"` 225} 226 227type BidOutcome struct { 228 ID uuid.UUID `json:"id"` 229 OrganizationID uuid.UUID `json:"organization_id"` 230 OpportunityID *uuid.UUID `json:"opportunity_id"` 231 RequirementID *uuid.UUID `json:"requirement_id"` 232 SlateID *uuid.UUID `json:"slate_id"` 233 SubmittedAt *time.Time `json:"submitted_at"` 234 Result string `json:"result"` 235 AwardDate pgtype.Date `json:"award_date"` 236 AwardeeUei string `json:"awardee_uei"` 237 Notes string `json:"notes"` 238 CreatedAt time.Time `json:"created_at"` 239 UpdatedAt time.Time `json:"updated_at"` 240} 241 242type BlsWage struct { 243 SeriesID string `json:"series_id"` 244 OccupationCode string `json:"occupation_code"` 245 OccupationTitle string `json:"occupation_title"` 246 Role string `json:"role"` 247 Area string `json:"area"` 248 AreaName string `json:"area_name"` 249 Metric string `json:"metric"` 250 PeriodYear string `json:"period_year"` 251 Value *decimal.Decimal `json:"value"` 252 Raw []byte `json:"raw"` 253 SyncedAt time.Time `json:"synced_at"` 254} 255 256type Candidate struct { 257 ID uuid.UUID `json:"id"` 258 OrganizationID uuid.UUID `json:"organization_id"` 259 FullName string `json:"full_name"` 260 Email *string `json:"email"` 261 Headline *string `json:"headline"` 262 ClearanceLevel string `json:"clearance_level"` 263 ClearancePoly string `json:"clearance_poly"` 264 ClearanceStatus string `json:"clearance_status"` 265 ClearanceGrantedAt pgtype.Date `json:"clearance_granted_at"` 266 ClearanceExpiresAt pgtype.Date `json:"clearance_expires_at"` 267 ReinvestigationDueAt pgtype.Date `json:"reinvestigation_due_at"` 268 YearsExperience int32 `json:"years_experience"` 269 Location *string `json:"location"` 270 Remote bool `json:"remote"` 271 Relocatable bool `json:"relocatable"` 272 Available bool `json:"available"` 273 ResumeEmbedding *pgvector.Vector `json:"resume_embedding"` 274 SearchTsv interface{} `json:"search_tsv"` 275 CreatedAt time.Time `json:"created_at"` 276 UpdatedAt time.Time `json:"updated_at"` 277 DeletedAt *time.Time `json:"deleted_at"` 278 Source string `json:"source"` 279 ExternalID *string `json:"external_id"` 280 AnonymizedAt *time.Time `json:"anonymized_at"` 281 ClearanceProvenance string `json:"clearance_provenance"` 282 ClearanceVerifiedAt *time.Time `json:"clearance_verified_at"` 283 ClearanceCompartments []string `json:"clearance_compartments"` 284 SourceFirstTouch string `json:"source_first_touch"` 285 SourceLastTouch string `json:"source_last_touch"` 286 SourceDetail string `json:"source_detail"` 287} 288 289type CandidateCertification struct { 290 OrganizationID uuid.UUID `json:"organization_id"` 291 CandidateID uuid.UUID `json:"candidate_id"` 292 Name string `json:"name"` 293} 294 295type CandidateCustomerExperience struct { 296 OrganizationID uuid.UUID `json:"organization_id"` 297 CandidateID uuid.UUID `json:"candidate_id"` 298 Agency string `json:"agency"` 299} 300 301type CandidateEvaluation struct { 302 OrganizationID uuid.UUID `json:"organization_id"` 303 CandidateID uuid.UUID `json:"candidate_id"` 304 RequirementID uuid.UUID `json:"requirement_id"` 305 TotalScore decimal.Decimal `json:"total_score"` 306 Band string `json:"band"` 307 ClearanceScore decimal.Decimal `json:"clearance_score"` 308 SkillsScore decimal.Decimal `json:"skills_score"` 309 CertsScore decimal.Decimal `json:"certs_score"` 310 CustomerScore decimal.Decimal `json:"customer_score"` 311 ExperienceScore decimal.Decimal `json:"experience_score"` 312 LocationScore decimal.Decimal `json:"location_score"` 313 Explanation string `json:"explanation"` 314 MatchedSkills []byte `json:"matched_skills"` 315 GapSummary []byte `json:"gap_summary"` 316 ModelVersion string `json:"model_version"` 317 EvaluatedBy *uuid.UUID `json:"evaluated_by"` 318 EvaluatedAt time.Time `json:"evaluated_at"` 319 UpdatedAt time.Time `json:"updated_at"` 320 WeightProfileVersion string `json:"weight_profile_version"` 321} 322 323type CandidateMissionTag struct { 324 OrganizationID uuid.UUID `json:"organization_id"` 325 CandidateID uuid.UUID `json:"candidate_id"` 326 MissionCode string `json:"mission_code"` 327 Mechanism string `json:"mechanism"` 328 Evidence string `json:"evidence"` 329} 330 331type CandidateSkill struct { 332 OrganizationID uuid.UUID `json:"organization_id"` 333 CandidateID uuid.UUID `json:"candidate_id"` 334 SkillID uuid.UUID `json:"skill_id"` 335} 336 337type ClearanceCompartment struct { 338 Code string `json:"code"` 339 Kind string `json:"kind"` 340 Label string `json:"label"` 341} 342 343type ClearanceLevel struct { 344 Code string `json:"code"` 345 Rank int32 `json:"rank"` 346 RequiresPolygraph bool `json:"requires_polygraph"` 347 Label string `json:"label"` 348} 349 350type ClearanceReciprocity struct { 351 HeldCode string `json:"held_code"` 352 RequiredCode string `json:"required_code"` 353 Satisfies bool `json:"satisfies"` 354 Source string `json:"source"` 355} 356 357type Client struct { 358 OrganizationID uuid.UUID `json:"organization_id"` 359 ID uuid.UUID `json:"id"` 360 Name string `json:"name"` 361 Uei string `json:"uei"` 362 Industry string `json:"industry"` 363 Website string `json:"website"` 364 Status string `json:"status"` 365 Notes string `json:"notes"` 366 CreatedBy *uuid.UUID `json:"created_by"` 367 CreatedAt time.Time `json:"created_at"` 368 UpdatedAt time.Time `json:"updated_at"` 369} 370 371type ClientContact struct { 372 OrganizationID uuid.UUID `json:"organization_id"` 373 ID uuid.UUID `json:"id"` 374 ClientID uuid.UUID `json:"client_id"` 375 FullName string `json:"full_name"` 376 Title string `json:"title"` 377 Email string `json:"email"` 378 Phone string `json:"phone"` 379 IsHiringManager bool `json:"is_hiring_manager"` 380 IsPrimary bool `json:"is_primary"` 381 Status string `json:"status"` 382 CreatedAt time.Time `json:"created_at"` 383 UpdatedAt time.Time `json:"updated_at"` 384} 385 386type ConnectorSyncState struct { 387 OrganizationID uuid.UUID `json:"organization_id"` 388 ConnectorName string `json:"connector_name"` 389 Watermark time.Time `json:"watermark"` 390 LastRunAt *time.Time `json:"last_run_at"` 391 RecordsSynced int64 `json:"records_synced"` 392} 393 394type CurationProposal struct { 395 ID uuid.UUID `json:"id"` 396 Kind string `json:"kind"` 397 FromSkillID *uuid.UUID `json:"from_skill_id"` 398 ToSkillID *uuid.UUID `json:"to_skill_id"` 399 Relation *string `json:"relation"` 400 ProposedStrength *decimal.Decimal `json:"proposed_strength"` 401 EvidenceObservations int32 `json:"evidence_observations"` 402 EvidenceSuccesses int32 `json:"evidence_successes"` 403 ModelVersion string `json:"model_version"` 404 Status string `json:"status"` 405 Approver *uuid.UUID `json:"approver"` 406 ApprovedAt *time.Time `json:"approved_at"` 407 CreatedAt time.Time `json:"created_at"` 408} 409 410type DpBudgetLedger struct { 411 ID uuid.UUID `json:"id"` 412 ModelVersion string `json:"model_version"` 413 TenantID *uuid.UUID `json:"tenant_id"` 414 RdpOrders []byte `json:"rdp_orders"` 415 AccumulatedRdp decimal.Decimal `json:"accumulated_rdp"` 416 EpsilonAtDelta decimal.Decimal `json:"epsilon_at_delta"` 417 Delta decimal.Decimal `json:"delta"` 418 ContributingTenantCount int32 `json:"contributing_tenant_count"` 419 ReleasedAt time.Time `json:"released_at"` 420} 421 422type FederalMissionTag struct { 423 RecordTable string `json:"record_table"` 424 RecordID string `json:"record_id"` 425 MissionCode string `json:"mission_code"` 426 Mechanism string `json:"mechanism"` 427 Evidence string `json:"evidence"` 428 Confidence decimal.Decimal `json:"confidence"` 429 ClassifiedAt time.Time `json:"classified_at"` 430} 431 432type Interview struct { 433 OrganizationID uuid.UUID `json:"organization_id"` 434 ID uuid.UUID `json:"id"` 435 ApplicationID uuid.UUID `json:"application_id"` 436 Round int32 `json:"round"` 437 Kind string `json:"kind"` 438 ScheduledAt *time.Time `json:"scheduled_at"` 439 CompletedAt *time.Time `json:"completed_at"` 440 Outcome string `json:"outcome"` 441 Interviewer string `json:"interviewer"` 442 Notes string `json:"notes"` 443 CreatedBy *uuid.UUID `json:"created_by"` 444 CreatedAt time.Time `json:"created_at"` 445 UpdatedAt time.Time `json:"updated_at"` 446} 447 448type LoginAttempt struct { 449 ID int64 `json:"id"` 450 EmailNormalized string `json:"email_normalized"` 451 OrganizationID *uuid.UUID `json:"organization_id"` 452 IpAddress *string `json:"ip_address"` 453 Succeeded bool `json:"succeeded"` 454 Reason *string `json:"reason"` 455 CreatedAt time.Time `json:"created_at"` 456} 457 458type MfaRecoveryCode struct { 459 ID uuid.UUID `json:"id"` 460 UserID uuid.UUID `json:"user_id"` 461 OrganizationID uuid.UUID `json:"organization_id"` 462 CodeHash string `json:"code_hash"` 463 PepperVersion int32 `json:"pepper_version"` 464 LookupTag []byte `json:"lookup_tag"` 465 UsedAt *time.Time `json:"used_at"` 466 CreatedAt time.Time `json:"created_at"` 467} 468 469type MfaTotp struct { 470 UserID uuid.UUID `json:"user_id"` 471 OrganizationID uuid.UUID `json:"organization_id"` 472 SecretCiphertext []byte `json:"secret_ciphertext"` 473 SecretNonce []byte `json:"secret_nonce"` 474 KeyVersion int32 `json:"key_version"` 475 Status string `json:"status"` 476 LastUsedStep int64 `json:"last_used_step"` 477 CreatedAt time.Time `json:"created_at"` 478 ActivatedAt *time.Time `json:"activated_at"` 479} 480 481type MissionArea struct { 482 Code string `json:"code"` 483 Name string `json:"name"` 484 Description string `json:"description"` 485 SpineTerm *string `json:"spine_term"` 486 SortOrder int32 `json:"sort_order"` 487 CreatedAt time.Time `json:"created_at"` 488} 489 490type MissionSpine struct { 491 ID uuid.UUID `json:"id"` 492 Version string `json:"version"` 493 Term string `json:"term"` 494 CanonicalDefinition string `json:"canonical_definition"` 495 Authority string `json:"authority"` 496 SourceDoc string `json:"source_doc"` 497 SourceUrl string `json:"source_url"` 498 EffectiveDate pgtype.Date `json:"effective_date"` 499} 500 501type Offer struct { 502 OrganizationID uuid.UUID `json:"organization_id"` 503 ID uuid.UUID `json:"id"` 504 ApplicationID uuid.UUID `json:"application_id"` 505 Status string `json:"status"` 506 EmploymentType string `json:"employment_type"` 507 BillRate pgtype.Numeric `json:"bill_rate"` 508 PayRate pgtype.Numeric `json:"pay_rate"` 509 Salary pgtype.Numeric `json:"salary"` 510 FeePct pgtype.Numeric `json:"fee_pct"` 511 ExtendedAt time.Time `json:"extended_at"` 512 RespondedAt *time.Time `json:"responded_at"` 513 ExpiresAt *time.Time `json:"expires_at"` 514 DeclineReason string `json:"decline_reason"` 515 CreatedBy *uuid.UUID `json:"created_by"` 516 CreatedAt time.Time `json:"created_at"` 517 UpdatedAt time.Time `json:"updated_at"` 518} 519 520type OntologyCrosswalk struct { 521 ID uuid.UUID `json:"id"` 522 FromSystem string `json:"from_system"` 523 FromCode string `json:"from_code"` 524 ToSystem string `json:"to_system"` 525 ToCode string `json:"to_code"` 526 Relation string `json:"relation"` 527 SourceName string `json:"source_name"` 528 SyncedAt time.Time `json:"synced_at"` 529} 530 531type OntologyTerm struct { 532 ID uuid.UUID `json:"id"` 533 SourceName string `json:"source_name"` 534 SourceRecordID string `json:"source_record_id"` 535 TermKind string `json:"term_kind"` 536 Term string `json:"term"` 537 Code string `json:"code"` 538 Category string `json:"category"` 539 Description string `json:"description"` 540 RawObjectKey string `json:"raw_object_key"` 541 RawSha256 string `json:"raw_sha256"` 542 FetchedAt time.Time `json:"fetched_at"` 543 SyncedAt time.Time `json:"synced_at"` 544} 545 546type Opportunity struct { 547 ID uuid.UUID `json:"id"` 548 OrganizationID uuid.UUID `json:"organization_id"` 549 Name string `json:"name"` 550 SolicitationNumber *string `json:"solicitation_number"` 551 CustomerAgency *string `json:"customer_agency"` 552 DueDate pgtype.Date `json:"due_date"` 553 Status string `json:"status"` 554 CreatedAt time.Time `json:"created_at"` 555 UpdatedAt time.Time `json:"updated_at"` 556 Value *decimal.Decimal `json:"value"` 557 ValueSource string `json:"value_source"` 558 FederalRef *string `json:"federal_ref"` 559} 560 561type OpportunityRecord struct { 562 ID uuid.UUID `json:"id"` 563 SourceName string `json:"source_name"` 564 SourceRecordID string `json:"source_record_id"` 565 DedupeKey string `json:"dedupe_key"` 566 RecordKind string `json:"record_kind"` 567 Title string `json:"title"` 568 Agency string `json:"agency"` 569 SubAgency string `json:"sub_agency"` 570 Naics string `json:"naics"` 571 Psc string `json:"psc"` 572 PopCity string `json:"pop_city"` 573 PopState string `json:"pop_state"` 574 PopCountry string `json:"pop_country"` 575 PopZip string `json:"pop_zip"` 576 SetAside string `json:"set_aside"` 577 SetAsideCode string `json:"set_aside_code"` 578 ContractVehicle string `json:"contract_vehicle"` 579 EstimatedValue *decimal.Decimal `json:"estimated_value"` 580 ValueSource string `json:"value_source"` 581 IncumbentName string `json:"incumbent_name"` 582 IncumbentUei string `json:"incumbent_uei"` 583 PostedDate pgtype.Date `json:"posted_date"` 584 ResponseDeadline *time.Time `json:"response_deadline"` 585 AwardDate pgtype.Date `json:"award_date"` 586 EstimatedAwardDate pgtype.Date `json:"estimated_award_date"` 587 PopStartDate pgtype.Date `json:"pop_start_date"` 588 PopEndDate pgtype.Date `json:"pop_end_date"` 589 UiLink string `json:"ui_link"` 590 IsPlanning bool `json:"is_planning"` 591 RawObjectKey string `json:"raw_object_key"` 592 RawSha256 string `json:"raw_sha256"` 593 FetchedAt time.Time `json:"fetched_at"` 594 SyncedAt time.Time `json:"synced_at"` 595} 596 597type Organization struct { 598 ID uuid.UUID `json:"id"` 599 Name string `json:"name"` 600 Slug string `json:"slug"` 601 Status string `json:"status"` 602 CreatedAt time.Time `json:"created_at"` 603 UpdatedAt time.Time `json:"updated_at"` 604 DisplayName *string `json:"display_name"` 605 Logo []byte `json:"logo"` 606 LogoMime *string `json:"logo_mime"` 607 LogoUpdatedAt *time.Time `json:"logo_updated_at"` 608} 609 610type OutcomeEvent struct { 611 OrganizationID uuid.UUID `json:"organization_id"` 612 ID uuid.UUID `json:"id"` 613 Module string `json:"module"` 614 SubjectType string `json:"subject_type"` 615 SubjectID uuid.UUID `json:"subject_id"` 616 EventType string `json:"event_type"` 617 SignalValue decimal.Decimal `json:"signal_value"` 618 ReasonCode string `json:"reason_code"` 619 ActorID *uuid.UUID `json:"actor_id"` 620 OccurredAt time.Time `json:"occurred_at"` 621 Metadata []byte `json:"metadata"` 622 CreatedAt time.Time `json:"created_at"` 623} 624 625type Placement struct { 626 OrganizationID uuid.UUID `json:"organization_id"` 627 ID uuid.UUID `json:"id"` 628 ApplicationID uuid.UUID `json:"application_id"` 629 OfferID *uuid.UUID `json:"offer_id"` 630 Status string `json:"status"` 631 EmploymentType string `json:"employment_type"` 632 StartDate pgtype.Date `json:"start_date"` 633 EndDate pgtype.Date `json:"end_date"` 634 BillRate pgtype.Numeric `json:"bill_rate"` 635 PayRate pgtype.Numeric `json:"pay_rate"` 636 Salary pgtype.Numeric `json:"salary"` 637 FeeAmount pgtype.Numeric `json:"fee_amount"` 638 GuaranteeDays int32 `json:"guarantee_days"` 639 CreatedBy *uuid.UUID `json:"created_by"` 640 CreatedAt time.Time `json:"created_at"` 641 UpdatedAt time.Time `json:"updated_at"` 642} 643 644type PolygraphType struct { 645 Code string `json:"code"` 646 Rank int32 `json:"rank"` 647 Label string `json:"label"` 648} 649 650type RecommendationRun struct { 651 ID uuid.UUID `json:"id"` 652 OrganizationID uuid.UUID `json:"organization_id"` 653 View string `json:"view"` 654 ScopeRef *uuid.UUID `json:"scope_ref"` 655 ModelVersion string `json:"model_version"` 656 Parameters []byte `json:"parameters"` 657 CreatedBy *uuid.UUID `json:"created_by"` 658 CreatedAt time.Time `json:"created_at"` 659} 660 661type RecruiterActivity struct { 662 OrganizationID uuid.UUID `json:"organization_id"` 663 ID int64 `json:"id"` 664 ActorUserID uuid.UUID `json:"actor_user_id"` 665 Kind string `json:"kind"` 666 Direction string `json:"direction"` 667 Outcome string `json:"outcome"` 668 CandidateID *uuid.UUID `json:"candidate_id"` 669 ContactID *uuid.UUID `json:"contact_id"` 670 RequisitionID *uuid.UUID `json:"requisition_id"` 671 ApplicationID *uuid.UUID `json:"application_id"` 672 Body string `json:"body"` 673 AutoCaptured bool `json:"auto_captured"` 674 OccurredAt time.Time `json:"occurred_at"` 675 CreatedAt time.Time `json:"created_at"` 676} 677 678type RequiredCertification struct { 679 OrganizationID uuid.UUID `json:"organization_id"` 680 RequirementID uuid.UUID `json:"requirement_id"` 681 Name string `json:"name"` 682} 683 684type RequiredSkill struct { 685 OrganizationID uuid.UUID `json:"organization_id"` 686 RequirementID uuid.UUID `json:"requirement_id"` 687 SkillID uuid.UUID `json:"skill_id"` 688 Mandatory bool `json:"mandatory"` 689} 690 691type Requirement struct { 692 ID uuid.UUID `json:"id"` 693 OrganizationID uuid.UUID `json:"organization_id"` 694 OpportunityID *uuid.UUID `json:"opportunity_id"` 695 Title string `json:"title"` 696 CustomerAgency *string `json:"customer_agency"` 697 RequiredLevel string `json:"required_level"` 698 RequiredPoly string `json:"required_poly"` 699 RequiredYears int32 `json:"required_years"` 700 WorkLocation *string `json:"work_location"` 701 RemoteAllowed bool `json:"remote_allowed"` 702 KeyPersonnel bool `json:"key_personnel"` 703 CreatedAt time.Time `json:"created_at"` 704 UpdatedAt time.Time `json:"updated_at"` 705 DeletedAt *time.Time `json:"deleted_at"` 706 LaborCategory *string `json:"labor_category"` 707 Quantity int32 `json:"quantity"` 708 RequiredCompartments []string `json:"required_compartments"` 709} 710 711type RequirementMissionTag struct { 712 OrganizationID uuid.UUID `json:"organization_id"` 713 RequirementID uuid.UUID `json:"requirement_id"` 714 MissionCode string `json:"mission_code"` 715 Mechanism string `json:"mechanism"` 716 Evidence string `json:"evidence"` 717} 718 719type Requisition struct { 720 OrganizationID uuid.UUID `json:"organization_id"` 721 ID uuid.UUID `json:"id"` 722 ClientID *uuid.UUID `json:"client_id"` 723 HiringManagerID *uuid.UUID `json:"hiring_manager_id"` 724 OwnerUserID *uuid.UUID `json:"owner_user_id"` 725 RequirementID *uuid.UUID `json:"requirement_id"` 726 Title string `json:"title"` 727 Description string `json:"description"` 728 LaborCategory string `json:"labor_category"` 729 Openings int32 `json:"openings"` 730 Priority string `json:"priority"` 731 EmploymentType string `json:"employment_type"` 732 Status string `json:"status"` 733 RequiredLevel string `json:"required_level"` 734 RequiredPoly string `json:"required_poly"` 735 WorkLocation string `json:"work_location"` 736 RemoteAllowed bool `json:"remote_allowed"` 737 BillRateMin pgtype.Numeric `json:"bill_rate_min"` 738 BillRateMax pgtype.Numeric `json:"bill_rate_max"` 739 PayRateMin pgtype.Numeric `json:"pay_rate_min"` 740 PayRateMax pgtype.Numeric `json:"pay_rate_max"` 741 SalaryMin pgtype.Numeric `json:"salary_min"` 742 SalaryMax pgtype.Numeric `json:"salary_max"` 743 OpenedAt time.Time `json:"opened_at"` 744 TargetFillDate pgtype.Date `json:"target_fill_date"` 745 ClosedAt *time.Time `json:"closed_at"` 746 HeldDays int32 `json:"held_days"` 747 CreatedBy *uuid.UUID `json:"created_by"` 748 CreatedAt time.Time `json:"created_at"` 749 UpdatedAt time.Time `json:"updated_at"` 750 DeletedAt *time.Time `json:"deleted_at"` 751} 752 753type SamOpportunity struct { 754 NoticeID string `json:"notice_id"` 755 Title string `json:"title"` 756 SolicitationNumber string `json:"solicitation_number"` 757 Department string `json:"department"` 758 FullParentPath string `json:"full_parent_path"` 759 SubAgency string `json:"sub_agency"` 760 NaicsCode string `json:"naics_code"` 761 PscCode string `json:"psc_code"` 762 SetAsideCode string `json:"set_aside_code"` 763 SetAside string `json:"set_aside"` 764 NoticeType string `json:"notice_type"` 765 BaseType string `json:"base_type"` 766 PostedDate pgtype.Date `json:"posted_date"` 767 ResponseDeadline *time.Time `json:"response_deadline"` 768 Active bool `json:"active"` 769 PopCity string `json:"pop_city"` 770 PopState string `json:"pop_state"` 771 PopZip string `json:"pop_zip"` 772 UiLink string `json:"ui_link"` 773 DescriptionUrl string `json:"description_url"` 774 ResourceLinks []byte `json:"resource_links"` 775 Poc []byte `json:"poc"` 776 Raw []byte `json:"raw"` 777 Source string `json:"source"` 778 SyncedAt time.Time `json:"synced_at"` 779} 780 781type Skill struct { 782 ID uuid.UUID `json:"id"` 783 Name string `json:"name"` 784 Category *string `json:"category"` 785 Embedding *pgvector.Vector `json:"embedding"` 786 CreatedAt time.Time `json:"created_at"` 787 Source string `json:"source"` 788 SocCode string `json:"soc_code"` 789} 790 791type SkillAlias struct { 792 ID uuid.UUID `json:"id"` 793 SkillID uuid.UUID `json:"skill_id"` 794 AliasText string `json:"alias_text"` 795 AliasType string `json:"alias_type"` 796 Source string `json:"source"` 797 Confidence decimal.Decimal `json:"confidence"` 798 VerifiedAt *time.Time `json:"verified_at"` 799 CreatedAt time.Time `json:"created_at"` 800} 801 802type SkillRelationship struct { 803 ID uuid.UUID `json:"id"` 804 FromSkillID uuid.UUID `json:"from_skill_id"` 805 ToSkillID uuid.UUID `json:"to_skill_id"` 806 Relation string `json:"relation"` 807 Strength decimal.Decimal `json:"strength"` 808 Source string `json:"source"` 809 VerifiedAt *time.Time `json:"verified_at"` 810 CreatedAt time.Time `json:"created_at"` 811 Verifier *uuid.UUID `json:"verifier"` 812} 813 814type Slate struct { 815 ID uuid.UUID `json:"id"` 816 OrganizationID uuid.UUID `json:"organization_id"` 817 RequirementID uuid.UUID `json:"requirement_id"` 818 Name string `json:"name"` 819 Status string `json:"status"` 820 CreatedBy *uuid.UUID `json:"created_by"` 821 CreatedAt time.Time `json:"created_at"` 822 UpdatedAt time.Time `json:"updated_at"` 823} 824 825type SlateMember struct { 826 OrganizationID uuid.UUID `json:"organization_id"` 827 SlateID uuid.UUID `json:"slate_id"` 828 CandidateID uuid.UUID `json:"candidate_id"` 829 TotalScore decimal.Decimal `json:"total_score"` 830 Band string `json:"band"` 831 ClearanceScore decimal.Decimal `json:"clearance_score"` 832 SkillsScore decimal.Decimal `json:"skills_score"` 833 CertsScore decimal.Decimal `json:"certs_score"` 834 CustomerScore decimal.Decimal `json:"customer_score"` 835 ExperienceScore decimal.Decimal `json:"experience_score"` 836 LocationScore decimal.Decimal `json:"location_score"` 837 Explanation string `json:"explanation"` 838 Trace []byte `json:"trace"` 839 GapSummary []byte `json:"gap_summary"` 840 Decision string `json:"decision"` 841 DecidedBy *uuid.UUID `json:"decided_by"` 842 DecidedAt *time.Time `json:"decided_at"` 843 Rank *int32 `json:"rank"` 844 CreatedAt time.Time `json:"created_at"` 845 ModelVersion *string `json:"model_version"` 846 DecisionNote *string `json:"decision_note"` 847} 848 849type SourcingLog struct { 850 ID uuid.UUID `json:"id"` 851 OrganizationID uuid.UUID `json:"organization_id"` 852 CandidateID *uuid.UUID `json:"candidate_id"` 853 ExternalID string `json:"external_id"` 854 Source string `json:"source"` 855 Provider string `json:"provider"` 856 Query string `json:"query"` 857 LegalBasis string `json:"legal_basis"` 858 CollectedAt time.Time `json:"collected_at"` 859 CreatedAt time.Time `json:"created_at"` 860} 861 862type StaffingRecommendation struct { 863 ID uuid.UUID `json:"id"` 864 OrganizationID uuid.UUID `json:"organization_id"` 865 RunID uuid.UUID `json:"run_id"` 866 RequirementID uuid.UUID `json:"requirement_id"` 867 CandidateID *uuid.UUID `json:"candidate_id"` 868 Action string `json:"action"` 869 Rank int32 `json:"rank"` 870 Confidence decimal.Decimal `json:"confidence"` 871 ValueScore *int64 `json:"value_score"` 872 Rationale string `json:"rationale"` 873 RationaleSource string `json:"rationale_source"` 874 Evidence []byte `json:"evidence"` 875 Status string `json:"status"` 876 DecidedBy *uuid.UUID `json:"decided_by"` 877 DecidedAt *time.Time `json:"decided_at"` 878 DecisionNote *string `json:"decision_note"` 879 CreatedAt time.Time `json:"created_at"` 880} 881 882type StaffingVendor struct { 883 OrganizationID uuid.UUID `json:"organization_id"` 884 ID uuid.UUID `json:"id"` 885 Name string `json:"name"` 886 Uei string `json:"uei"` 887 VendorType string `json:"vendor_type"` 888 CreatedAt time.Time `json:"created_at"` 889 UpdatedAt time.Time `json:"updated_at"` 890} 891 892type Task struct { 893 OrganizationID uuid.UUID `json:"organization_id"` 894 ID uuid.UUID `json:"id"` 895 AssignedTo uuid.UUID `json:"assigned_to"` 896 Title string `json:"title"` 897 Detail string `json:"detail"` 898 Status string `json:"status"` 899 Priority string `json:"priority"` 900 DueAt *time.Time `json:"due_at"` 901 CompletedAt *time.Time `json:"completed_at"` 902 CandidateID *uuid.UUID `json:"candidate_id"` 903 ContactID *uuid.UUID `json:"contact_id"` 904 RequisitionID *uuid.UUID `json:"requisition_id"` 905 ApplicationID *uuid.UUID `json:"application_id"` 906 CreatedBy *uuid.UUID `json:"created_by"` 907 CreatedAt time.Time `json:"created_at"` 908 UpdatedAt time.Time `json:"updated_at"` 909} 910 911type TeachingSignalAggregate struct { 912 ID uuid.UUID `json:"id"` 913 TenantID *uuid.UUID `json:"tenant_id"` 914 DpApplied bool `json:"dp_applied"` 915 Pattern string `json:"pattern"` 916 Band string `json:"band"` 917 Outcome string `json:"outcome"` 918 ModelVersion string `json:"model_version"` 919 Observations int32 `json:"observations"` 920 Successes int32 `json:"successes"` 921 WindowStart pgtype.Date `json:"window_start"` 922 WindowEnd pgtype.Date `json:"window_end"` 923 CreatedAt time.Time `json:"created_at"` 924} 925 926type TermExpansion struct { 927 ID uuid.UUID `json:"id"` 928 OrganizationID *uuid.UUID `json:"organization_id"` 929 Alias string `json:"alias"` 930 Expansion string `json:"expansion"` 931 CreatedBy *uuid.UUID `json:"created_by"` 932 CreatedAt time.Time `json:"created_at"` 933} 934 935type UsaspendingAward struct { 936 GeneratedInternalID string `json:"generated_internal_id"` 937 AwardID string `json:"award_id"` 938 RecipientName string `json:"recipient_name"` 939 RecipientUei string `json:"recipient_uei"` 940 RecipientID string `json:"recipient_id"` 941 AwardAmount *decimal.Decimal `json:"award_amount"` 942 AwardingAgency string `json:"awarding_agency"` 943 AwardingSubAgency string `json:"awarding_sub_agency"` 944 PopStartDate pgtype.Date `json:"pop_start_date"` 945 PopEndDate pgtype.Date `json:"pop_end_date"` 946 NaicsCode string `json:"naics_code"` 947 NaicsDescription string `json:"naics_description"` 948 Description string `json:"description"` 949 IsGalapagos bool `json:"is_galapagos"` 950 Raw []byte `json:"raw"` 951 Source string `json:"source"` 952 SyncedAt time.Time `json:"synced_at"` 953} 954 955type User struct { 956 ID uuid.UUID `json:"id"` 957 OrganizationID uuid.UUID `json:"organization_id"` 958 Email string `json:"email"` 959 FullName string `json:"full_name"` 960 Role string `json:"role"` 961 Status string `json:"status"` 962 LastLoginAt *time.Time `json:"last_login_at"` 963 CreatedAt time.Time `json:"created_at"` 964 UpdatedAt time.Time `json:"updated_at"` 965 MfaEnrolled bool `json:"mfa_enrolled"` 966} 967 968type UserInvite struct { 969 ID uuid.UUID `json:"id"` 970 OrganizationID uuid.UUID `json:"organization_id"` 971 EmailNormalized string `json:"email_normalized"` 972 InvitedUserID uuid.UUID `json:"invited_user_id"` 973 TokenHash []byte `json:"token_hash"` 974 Role string `json:"role"` 975 ExpiresAt time.Time `json:"expires_at"` 976 AcceptedAt *time.Time `json:"accepted_at"` 977 CreatedBy uuid.UUID `json:"created_by"` 978 CreatedAt time.Time `json:"created_at"` 979} 980 981type VendorSubmission struct { 982 OrganizationID uuid.UUID `json:"organization_id"` 983 VendorID uuid.UUID `json:"vendor_id"` 984 CandidateID uuid.UUID `json:"candidate_id"` 985 RequirementID uuid.UUID `json:"requirement_id"` 986 SubmittedAt time.Time `json:"submitted_at"` 987 DecidedAt *time.Time `json:"decided_at"` 988 Status string `json:"status"` 989 CreatedAt time.Time `json:"created_at"` 990} 991