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 AedtCandidateNotice struct { 17 ID uuid.UUID `json:"id"` 18 OrganizationID uuid.UUID `json:"organization_id"` 19 CandidateID uuid.UUID `json:"candidate_id"` 20 NoticeVersion string `json:"notice_version"` 21 DataCategories []byte `json:"data_categories"` 22 RetentionDays int32 `json:"retention_days"` 23 DisclosedBy *uuid.UUID `json:"disclosed_by"` 24 DisclosedAt time.Time `json:"disclosed_at"` 25} 26 27type AedtInventory struct { 28 ID uuid.UUID `json:"id"` 29 OrganizationID uuid.UUID `json:"organization_id"` 30 ToolKey string `json:"tool_key"` 31 DisplayName string `json:"display_name"` 32 Purpose string `json:"purpose"` 33 ModelVersion *string `json:"model_version"` 34 Active bool `json:"active"` 35 CreatedAt time.Time `json:"created_at"` 36 UpdatedAt time.Time `json:"updated_at"` 37} 38 39type AedtModelVersion struct { 40 Version string `json:"version"` 41 Weights []byte `json:"weights"` 42 BandCuts []byte `json:"band_cuts"` 43 Notes *string `json:"notes"` 44 EffectiveFrom time.Time `json:"effective_from"` 45 CreatedAt time.Time `json:"created_at"` 46} 47 48type AiMemory struct { 49 ID uuid.UUID `json:"id"` 50 OrganizationID uuid.UUID `json:"organization_id"` 51 CandidateID *uuid.UUID `json:"candidate_id"` 52 Kind string `json:"kind"` 53 Content string `json:"content"` 54 Embedding *pgvector.Vector `json:"embedding"` 55 CreatedAt time.Time `json:"created_at"` 56 UpdatedAt time.Time `json:"updated_at"` 57} 58 59type AuditLog struct { 60 ID int64 `json:"id"` 61 OrganizationID *uuid.UUID `json:"organization_id"` 62 ActorUserID *uuid.UUID `json:"actor_user_id"` 63 Action string `json:"action"` 64 EntityType *string `json:"entity_type"` 65 EntityID *string `json:"entity_id"` 66 OldValues []byte `json:"old_values"` 67 NewValues []byte `json:"new_values"` 68 IpAddress *string `json:"ip_address"` 69 UserAgent *string `json:"user_agent"` 70 CreatedAt time.Time `json:"created_at"` 71} 72 73type AuthCredential struct { 74 UserID uuid.UUID `json:"user_id"` 75 OrganizationID uuid.UUID `json:"organization_id"` 76 EmailNormalized string `json:"email_normalized"` 77 PasswordHash string `json:"password_hash"` 78 PepperVersion int32 `json:"pepper_version"` 79 FailedStreak int32 `json:"failed_streak"` 80 LockedUntil *time.Time `json:"locked_until"` 81 PasswordChangedAt time.Time `json:"password_changed_at"` 82 CreatedAt time.Time `json:"created_at"` 83 UpdatedAt time.Time `json:"updated_at"` 84} 85 86type AuthSession struct { 87 ID uuid.UUID `json:"id"` 88 TokenHash []byte `json:"token_hash"` 89 UserID uuid.UUID `json:"user_id"` 90 OrganizationID uuid.UUID `json:"organization_id"` 91 State string `json:"state"` 92 MfaSatisfied bool `json:"mfa_satisfied"` 93 CreatedAt time.Time `json:"created_at"` 94 LastSeenAt time.Time `json:"last_seen_at"` 95 IdleExpiresAt time.Time `json:"idle_expires_at"` 96 AbsoluteExpiresAt time.Time `json:"absolute_expires_at"` 97 RevokedAt *time.Time `json:"revoked_at"` 98 RotatedFrom *uuid.UUID `json:"rotated_from"` 99 IpAddress *string `json:"ip_address"` 100 UserAgent *string `json:"user_agent"` 101} 102 103type BlsWage struct { 104 SeriesID string `json:"series_id"` 105 OccupationCode string `json:"occupation_code"` 106 OccupationTitle string `json:"occupation_title"` 107 Role string `json:"role"` 108 Area string `json:"area"` 109 AreaName string `json:"area_name"` 110 Metric string `json:"metric"` 111 PeriodYear string `json:"period_year"` 112 Value *decimal.Decimal `json:"value"` 113 Raw []byte `json:"raw"` 114 SyncedAt time.Time `json:"synced_at"` 115} 116 117type Candidate struct { 118 ID uuid.UUID `json:"id"` 119 OrganizationID uuid.UUID `json:"organization_id"` 120 FullName string `json:"full_name"` 121 Email *string `json:"email"` 122 Headline *string `json:"headline"` 123 ClearanceLevel string `json:"clearance_level"` 124 ClearancePoly string `json:"clearance_poly"` 125 ClearanceStatus string `json:"clearance_status"` 126 ClearanceGrantedAt pgtype.Date `json:"clearance_granted_at"` 127 ClearanceExpiresAt pgtype.Date `json:"clearance_expires_at"` 128 ReinvestigationDueAt pgtype.Date `json:"reinvestigation_due_at"` 129 YearsExperience int32 `json:"years_experience"` 130 Location *string `json:"location"` 131 Remote bool `json:"remote"` 132 Relocatable bool `json:"relocatable"` 133 Available bool `json:"available"` 134 ResumeEmbedding *pgvector.Vector `json:"resume_embedding"` 135 SearchTsv interface{} `json:"search_tsv"` 136 CreatedAt time.Time `json:"created_at"` 137 UpdatedAt time.Time `json:"updated_at"` 138 DeletedAt *time.Time `json:"deleted_at"` 139 Source string `json:"source"` 140 ExternalID *string `json:"external_id"` 141 AnonymizedAt *time.Time `json:"anonymized_at"` 142 ClearanceProvenance string `json:"clearance_provenance"` 143 ClearanceVerifiedAt *time.Time `json:"clearance_verified_at"` 144} 145 146type CandidateCertification struct { 147 OrganizationID uuid.UUID `json:"organization_id"` 148 CandidateID uuid.UUID `json:"candidate_id"` 149 Name string `json:"name"` 150} 151 152type CandidateCustomerExperience struct { 153 OrganizationID uuid.UUID `json:"organization_id"` 154 CandidateID uuid.UUID `json:"candidate_id"` 155 Agency string `json:"agency"` 156} 157 158type CandidateEvaluation struct { 159 OrganizationID uuid.UUID `json:"organization_id"` 160 CandidateID uuid.UUID `json:"candidate_id"` 161 RequirementID uuid.UUID `json:"requirement_id"` 162 TotalScore decimal.Decimal `json:"total_score"` 163 Band string `json:"band"` 164 ClearanceScore decimal.Decimal `json:"clearance_score"` 165 SkillsScore decimal.Decimal `json:"skills_score"` 166 CertsScore decimal.Decimal `json:"certs_score"` 167 CustomerScore decimal.Decimal `json:"customer_score"` 168 ExperienceScore decimal.Decimal `json:"experience_score"` 169 LocationScore decimal.Decimal `json:"location_score"` 170 Explanation string `json:"explanation"` 171 MatchedSkills []byte `json:"matched_skills"` 172 GapSummary []byte `json:"gap_summary"` 173 ModelVersion string `json:"model_version"` 174 EvaluatedBy *uuid.UUID `json:"evaluated_by"` 175 EvaluatedAt time.Time `json:"evaluated_at"` 176 UpdatedAt time.Time `json:"updated_at"` 177} 178 179type CandidateSkill struct { 180 OrganizationID uuid.UUID `json:"organization_id"` 181 CandidateID uuid.UUID `json:"candidate_id"` 182 SkillID uuid.UUID `json:"skill_id"` 183} 184 185type LoginAttempt struct { 186 ID int64 `json:"id"` 187 EmailNormalized string `json:"email_normalized"` 188 OrganizationID *uuid.UUID `json:"organization_id"` 189 IpAddress *string `json:"ip_address"` 190 Succeeded bool `json:"succeeded"` 191 Reason *string `json:"reason"` 192 CreatedAt time.Time `json:"created_at"` 193} 194 195type MfaRecoveryCode struct { 196 ID uuid.UUID `json:"id"` 197 UserID uuid.UUID `json:"user_id"` 198 OrganizationID uuid.UUID `json:"organization_id"` 199 CodeHash string `json:"code_hash"` 200 PepperVersion int32 `json:"pepper_version"` 201 LookupTag []byte `json:"lookup_tag"` 202 UsedAt *time.Time `json:"used_at"` 203 CreatedAt time.Time `json:"created_at"` 204} 205 206type MfaTotp struct { 207 UserID uuid.UUID `json:"user_id"` 208 OrganizationID uuid.UUID `json:"organization_id"` 209 SecretCiphertext []byte `json:"secret_ciphertext"` 210 SecretNonce []byte `json:"secret_nonce"` 211 KeyVersion int32 `json:"key_version"` 212 Status string `json:"status"` 213 LastUsedStep int64 `json:"last_used_step"` 214 CreatedAt time.Time `json:"created_at"` 215 ActivatedAt *time.Time `json:"activated_at"` 216} 217 218type Opportunity struct { 219 ID uuid.UUID `json:"id"` 220 OrganizationID uuid.UUID `json:"organization_id"` 221 Name string `json:"name"` 222 SolicitationNumber *string `json:"solicitation_number"` 223 CustomerAgency *string `json:"customer_agency"` 224 DueDate pgtype.Date `json:"due_date"` 225 Status string `json:"status"` 226 CreatedAt time.Time `json:"created_at"` 227 UpdatedAt time.Time `json:"updated_at"` 228 Value *decimal.Decimal `json:"value"` 229 ValueSource string `json:"value_source"` 230 FederalRef *string `json:"federal_ref"` 231} 232 233type OpportunityRecord struct { 234 ID uuid.UUID `json:"id"` 235 SourceName string `json:"source_name"` 236 SourceRecordID string `json:"source_record_id"` 237 DedupeKey string `json:"dedupe_key"` 238 RecordKind string `json:"record_kind"` 239 Title string `json:"title"` 240 Agency string `json:"agency"` 241 SubAgency string `json:"sub_agency"` 242 Naics string `json:"naics"` 243 Psc string `json:"psc"` 244 PopCity string `json:"pop_city"` 245 PopState string `json:"pop_state"` 246 PopCountry string `json:"pop_country"` 247 PopZip string `json:"pop_zip"` 248 SetAside string `json:"set_aside"` 249 SetAsideCode string `json:"set_aside_code"` 250 ContractVehicle string `json:"contract_vehicle"` 251 EstimatedValue *decimal.Decimal `json:"estimated_value"` 252 ValueSource string `json:"value_source"` 253 IncumbentName string `json:"incumbent_name"` 254 IncumbentUei string `json:"incumbent_uei"` 255 PostedDate pgtype.Date `json:"posted_date"` 256 ResponseDeadline *time.Time `json:"response_deadline"` 257 AwardDate pgtype.Date `json:"award_date"` 258 EstimatedAwardDate pgtype.Date `json:"estimated_award_date"` 259 PopStartDate pgtype.Date `json:"pop_start_date"` 260 PopEndDate pgtype.Date `json:"pop_end_date"` 261 UiLink string `json:"ui_link"` 262 IsPlanning bool `json:"is_planning"` 263 RawObjectKey string `json:"raw_object_key"` 264 RawSha256 string `json:"raw_sha256"` 265 FetchedAt time.Time `json:"fetched_at"` 266 SyncedAt time.Time `json:"synced_at"` 267} 268 269type Organization struct { 270 ID uuid.UUID `json:"id"` 271 Name string `json:"name"` 272 Slug string `json:"slug"` 273 Status string `json:"status"` 274 CreatedAt time.Time `json:"created_at"` 275 UpdatedAt time.Time `json:"updated_at"` 276} 277 278type RequiredCertification struct { 279 OrganizationID uuid.UUID `json:"organization_id"` 280 RequirementID uuid.UUID `json:"requirement_id"` 281 Name string `json:"name"` 282} 283 284type RequiredSkill struct { 285 OrganizationID uuid.UUID `json:"organization_id"` 286 RequirementID uuid.UUID `json:"requirement_id"` 287 SkillID uuid.UUID `json:"skill_id"` 288 Mandatory bool `json:"mandatory"` 289} 290 291type Requirement struct { 292 ID uuid.UUID `json:"id"` 293 OrganizationID uuid.UUID `json:"organization_id"` 294 OpportunityID *uuid.UUID `json:"opportunity_id"` 295 Title string `json:"title"` 296 CustomerAgency *string `json:"customer_agency"` 297 RequiredLevel string `json:"required_level"` 298 RequiredPoly string `json:"required_poly"` 299 RequiredYears int32 `json:"required_years"` 300 WorkLocation *string `json:"work_location"` 301 RemoteAllowed bool `json:"remote_allowed"` 302 KeyPersonnel bool `json:"key_personnel"` 303 CreatedAt time.Time `json:"created_at"` 304 UpdatedAt time.Time `json:"updated_at"` 305 DeletedAt *time.Time `json:"deleted_at"` 306 LaborCategory *string `json:"labor_category"` 307 Quantity int32 `json:"quantity"` 308} 309 310type SamOpportunity struct { 311 NoticeID string `json:"notice_id"` 312 Title string `json:"title"` 313 SolicitationNumber string `json:"solicitation_number"` 314 Department string `json:"department"` 315 FullParentPath string `json:"full_parent_path"` 316 SubAgency string `json:"sub_agency"` 317 NaicsCode string `json:"naics_code"` 318 PscCode string `json:"psc_code"` 319 SetAsideCode string `json:"set_aside_code"` 320 SetAside string `json:"set_aside"` 321 NoticeType string `json:"notice_type"` 322 BaseType string `json:"base_type"` 323 PostedDate pgtype.Date `json:"posted_date"` 324 ResponseDeadline *time.Time `json:"response_deadline"` 325 Active bool `json:"active"` 326 PopCity string `json:"pop_city"` 327 PopState string `json:"pop_state"` 328 PopZip string `json:"pop_zip"` 329 UiLink string `json:"ui_link"` 330 DescriptionUrl string `json:"description_url"` 331 ResourceLinks []byte `json:"resource_links"` 332 Poc []byte `json:"poc"` 333 Raw []byte `json:"raw"` 334 Source string `json:"source"` 335 SyncedAt time.Time `json:"synced_at"` 336} 337 338type Skill struct { 339 ID uuid.UUID `json:"id"` 340 Name string `json:"name"` 341 Category *string `json:"category"` 342 Embedding *pgvector.Vector `json:"embedding"` 343 CreatedAt time.Time `json:"created_at"` 344} 345 346type Slate struct { 347 ID uuid.UUID `json:"id"` 348 OrganizationID uuid.UUID `json:"organization_id"` 349 RequirementID uuid.UUID `json:"requirement_id"` 350 Name string `json:"name"` 351 Status string `json:"status"` 352 CreatedBy *uuid.UUID `json:"created_by"` 353 CreatedAt time.Time `json:"created_at"` 354 UpdatedAt time.Time `json:"updated_at"` 355} 356 357type SlateMember struct { 358 OrganizationID uuid.UUID `json:"organization_id"` 359 SlateID uuid.UUID `json:"slate_id"` 360 CandidateID uuid.UUID `json:"candidate_id"` 361 TotalScore decimal.Decimal `json:"total_score"` 362 Band string `json:"band"` 363 ClearanceScore decimal.Decimal `json:"clearance_score"` 364 SkillsScore decimal.Decimal `json:"skills_score"` 365 CertsScore decimal.Decimal `json:"certs_score"` 366 CustomerScore decimal.Decimal `json:"customer_score"` 367 ExperienceScore decimal.Decimal `json:"experience_score"` 368 LocationScore decimal.Decimal `json:"location_score"` 369 Explanation string `json:"explanation"` 370 Trace []byte `json:"trace"` 371 GapSummary []byte `json:"gap_summary"` 372 Decision string `json:"decision"` 373 DecidedBy *uuid.UUID `json:"decided_by"` 374 DecidedAt *time.Time `json:"decided_at"` 375 Rank *int32 `json:"rank"` 376 CreatedAt time.Time `json:"created_at"` 377 ModelVersion *string `json:"model_version"` 378 DecisionNote *string `json:"decision_note"` 379} 380 381type SourcingLog struct { 382 ID uuid.UUID `json:"id"` 383 OrganizationID uuid.UUID `json:"organization_id"` 384 CandidateID *uuid.UUID `json:"candidate_id"` 385 ExternalID string `json:"external_id"` 386 Source string `json:"source"` 387 Provider string `json:"provider"` 388 Query string `json:"query"` 389 LegalBasis string `json:"legal_basis"` 390 CollectedAt time.Time `json:"collected_at"` 391 CreatedAt time.Time `json:"created_at"` 392} 393 394type UsaspendingAward struct { 395 GeneratedInternalID string `json:"generated_internal_id"` 396 AwardID string `json:"award_id"` 397 RecipientName string `json:"recipient_name"` 398 RecipientUei string `json:"recipient_uei"` 399 RecipientID string `json:"recipient_id"` 400 AwardAmount *decimal.Decimal `json:"award_amount"` 401 AwardingAgency string `json:"awarding_agency"` 402 AwardingSubAgency string `json:"awarding_sub_agency"` 403 PopStartDate pgtype.Date `json:"pop_start_date"` 404 PopEndDate pgtype.Date `json:"pop_end_date"` 405 NaicsCode string `json:"naics_code"` 406 NaicsDescription string `json:"naics_description"` 407 Description string `json:"description"` 408 IsGalapagos bool `json:"is_galapagos"` 409 Raw []byte `json:"raw"` 410 Source string `json:"source"` 411 SyncedAt time.Time `json:"synced_at"` 412} 413 414type User struct { 415 ID uuid.UUID `json:"id"` 416 OrganizationID uuid.UUID `json:"organization_id"` 417 Email string `json:"email"` 418 FullName string `json:"full_name"` 419 Role string `json:"role"` 420 Status string `json:"status"` 421 LastLoginAt *time.Time `json:"last_login_at"` 422 CreatedAt time.Time `json:"created_at"` 423 UpdatedAt time.Time `json:"updated_at"` 424 MfaEnrolled bool `json:"mfa_enrolled"` 425} 426 427type UserInvite struct { 428 ID uuid.UUID `json:"id"` 429 OrganizationID uuid.UUID `json:"organization_id"` 430 EmailNormalized string `json:"email_normalized"` 431 InvitedUserID uuid.UUID `json:"invited_user_id"` 432 TokenHash []byte `json:"token_hash"` 433 Role string `json:"role"` 434 ExpiresAt time.Time `json:"expires_at"` 435 AcceptedAt *time.Time `json:"accepted_at"` 436 CreatedBy uuid.UUID `json:"created_by"` 437 CreatedAt time.Time `json:"created_at"` 438} 439