Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / internal/platform/database/dbgen/models.go |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 9bde0f9a74b89d01980fa658e5253acda7528d0c |
| Branch | per-tenant-routing |
| Path or archive member | internal/platform/database/dbgen/models.go |
| Original SHA-256 | 9a46da0caf5a2dcb404ff1021f2501fc72adf1ddfebfb433d7231ed548411917 |
| Git blob SHA | a818b7dd695ed05f4f4f390c04ecffc281341f4b |
| Reading-copy SHA-256 | 9a46da0caf5a2dcb404ff1021f2501fc72adf1ddfebfb433d7231ed548411917 |
Every recorded occurrence
These 3 records contain identical original source bytes. Their paths and revisions remain part of the archive.
| Original record | Branch or archive | Revision / identifier | Original location |
|---|---|---|---|
| Janady13/missionmatch / internal/platform/database/dbgen/models.go | per-tenant-routing | 9bde0f9a74b89d01980fa658e5253acda7528d0c | Open original |
| Janady13/missionmatch / internal/platform/database/dbgen/models.go | deploy-and-ops | bdacd9d0b4d5998d25fc74bf4007f4c3ec538c7a | Open original |
| Janady13/missionmatch / internal/platform/database/dbgen/models.go | per-tenant-routing | 9bde0f9a74b89d01980fa658e5253acda7528d0c | Open original |
Recovered source transcript
Download complete source text ↓485 lines · 20.0 KB
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.31.1
package dbgen
import (
"time"
"github.com/google/uuid"
"github.com/jackc/pgx/v5/pgtype"
pgvector "github.com/pgvector/pgvector-go"
"github.com/shopspring/decimal"
)
type AedtCandidateNotice struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
CandidateID uuid.UUID `json:"candidate_id"`
NoticeVersion string `json:"notice_version"`
DataCategories []byte `json:"data_categories"`
RetentionDays int32 `json:"retention_days"`
DisclosedBy *uuid.UUID `json:"disclosed_by"`
DisclosedAt time.Time `json:"disclosed_at"`
}
type AedtInventory struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
ToolKey string `json:"tool_key"`
DisplayName string `json:"display_name"`
Purpose string `json:"purpose"`
ModelVersion *string `json:"model_version"`
Active bool `json:"active"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type AedtModelVersion struct {
Version string `json:"version"`
Weights []byte `json:"weights"`
BandCuts []byte `json:"band_cuts"`
Notes *string `json:"notes"`
EffectiveFrom time.Time `json:"effective_from"`
CreatedAt time.Time `json:"created_at"`
}
type AiMemory struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
CandidateID *uuid.UUID `json:"candidate_id"`
Kind string `json:"kind"`
Content string `json:"content"`
Embedding *pgvector.Vector `json:"embedding"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type AuditLog struct {
ID int64 `json:"id"`
OrganizationID *uuid.UUID `json:"organization_id"`
ActorUserID *uuid.UUID `json:"actor_user_id"`
Action string `json:"action"`
EntityType *string `json:"entity_type"`
EntityID *string `json:"entity_id"`
OldValues []byte `json:"old_values"`
NewValues []byte `json:"new_values"`
IpAddress *string `json:"ip_address"`
UserAgent *string `json:"user_agent"`
CreatedAt time.Time `json:"created_at"`
}
type AuthCredential struct {
UserID uuid.UUID `json:"user_id"`
OrganizationID uuid.UUID `json:"organization_id"`
EmailNormalized string `json:"email_normalized"`
PasswordHash string `json:"password_hash"`
PepperVersion int32 `json:"pepper_version"`
FailedStreak int32 `json:"failed_streak"`
LockedUntil *time.Time `json:"locked_until"`
PasswordChangedAt time.Time `json:"password_changed_at"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type AuthSession struct {
ID uuid.UUID `json:"id"`
TokenHash []byte `json:"token_hash"`
UserID uuid.UUID `json:"user_id"`
OrganizationID uuid.UUID `json:"organization_id"`
State string `json:"state"`
MfaSatisfied bool `json:"mfa_satisfied"`
CreatedAt time.Time `json:"created_at"`
LastSeenAt time.Time `json:"last_seen_at"`
IdleExpiresAt time.Time `json:"idle_expires_at"`
AbsoluteExpiresAt time.Time `json:"absolute_expires_at"`
RevokedAt *time.Time `json:"revoked_at"`
RotatedFrom *uuid.UUID `json:"rotated_from"`
IpAddress *string `json:"ip_address"`
UserAgent *string `json:"user_agent"`
}
type BlsWage struct {
SeriesID string `json:"series_id"`
OccupationCode string `json:"occupation_code"`
OccupationTitle string `json:"occupation_title"`
Role string `json:"role"`
Area string `json:"area"`
AreaName string `json:"area_name"`
Metric string `json:"metric"`
PeriodYear string `json:"period_year"`
Value *decimal.Decimal `json:"value"`
Raw []byte `json:"raw"`
SyncedAt time.Time `json:"synced_at"`
}
type Candidate struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
FullName string `json:"full_name"`
Email *string `json:"email"`
Headline *string `json:"headline"`
ClearanceLevel string `json:"clearance_level"`
ClearancePoly string `json:"clearance_poly"`
ClearanceStatus string `json:"clearance_status"`
ClearanceGrantedAt pgtype.Date `json:"clearance_granted_at"`
ClearanceExpiresAt pgtype.Date `json:"clearance_expires_at"`
ReinvestigationDueAt pgtype.Date `json:"reinvestigation_due_at"`
YearsExperience int32 `json:"years_experience"`
Location *string `json:"location"`
Remote bool `json:"remote"`
Relocatable bool `json:"relocatable"`
Available bool `json:"available"`
ResumeEmbedding *pgvector.Vector `json:"resume_embedding"`
SearchTsv interface{} `json:"search_tsv"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
DeletedAt *time.Time `json:"deleted_at"`
Source string `json:"source"`
ExternalID *string `json:"external_id"`
AnonymizedAt *time.Time `json:"anonymized_at"`
ClearanceProvenance string `json:"clearance_provenance"`
ClearanceVerifiedAt *time.Time `json:"clearance_verified_at"`
}
type CandidateCertification struct {
OrganizationID uuid.UUID `json:"organization_id"`
CandidateID uuid.UUID `json:"candidate_id"`
Name string `json:"name"`
}
type CandidateCustomerExperience struct {
OrganizationID uuid.UUID `json:"organization_id"`
CandidateID uuid.UUID `json:"candidate_id"`
Agency string `json:"agency"`
}
type CandidateEvaluation struct {
OrganizationID uuid.UUID `json:"organization_id"`
CandidateID uuid.UUID `json:"candidate_id"`
RequirementID uuid.UUID `json:"requirement_id"`
TotalScore decimal.Decimal `json:"total_score"`
Band string `json:"band"`
ClearanceScore decimal.Decimal `json:"clearance_score"`
SkillsScore decimal.Decimal `json:"skills_score"`
CertsScore decimal.Decimal `json:"certs_score"`
CustomerScore decimal.Decimal `json:"customer_score"`
ExperienceScore decimal.Decimal `json:"experience_score"`
LocationScore decimal.Decimal `json:"location_score"`
Explanation string `json:"explanation"`
MatchedSkills []byte `json:"matched_skills"`
GapSummary []byte `json:"gap_summary"`
ModelVersion string `json:"model_version"`
EvaluatedBy *uuid.UUID `json:"evaluated_by"`
EvaluatedAt time.Time `json:"evaluated_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type CandidateSkill struct {
OrganizationID uuid.UUID `json:"organization_id"`
CandidateID uuid.UUID `json:"candidate_id"`
SkillID uuid.UUID `json:"skill_id"`
}
type LoginAttempt struct {
ID int64 `json:"id"`
EmailNormalized string `json:"email_normalized"`
OrganizationID *uuid.UUID `json:"organization_id"`
IpAddress *string `json:"ip_address"`
Succeeded bool `json:"succeeded"`
Reason *string `json:"reason"`
CreatedAt time.Time `json:"created_at"`
}
type MfaRecoveryCode struct {
ID uuid.UUID `json:"id"`
UserID uuid.UUID `json:"user_id"`
OrganizationID uuid.UUID `json:"organization_id"`
CodeHash string `json:"code_hash"`
PepperVersion int32 `json:"pepper_version"`
LookupTag []byte `json:"lookup_tag"`
UsedAt *time.Time `json:"used_at"`
CreatedAt time.Time `json:"created_at"`
}
type MfaTotp struct {
UserID uuid.UUID `json:"user_id"`
OrganizationID uuid.UUID `json:"organization_id"`
SecretCiphertext []byte `json:"secret_ciphertext"`
SecretNonce []byte `json:"secret_nonce"`
KeyVersion int32 `json:"key_version"`
Status string `json:"status"`
LastUsedStep int64 `json:"last_used_step"`
CreatedAt time.Time `json:"created_at"`
ActivatedAt *time.Time `json:"activated_at"`
}
type Opportunity struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
Name string `json:"name"`
SolicitationNumber *string `json:"solicitation_number"`
CustomerAgency *string `json:"customer_agency"`
DueDate pgtype.Date `json:"due_date"`
Status string `json:"status"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
Value *decimal.Decimal `json:"value"`
ValueSource string `json:"value_source"`
FederalRef *string `json:"federal_ref"`
}
type OpportunityRecord struct {
ID uuid.UUID `json:"id"`
SourceName string `json:"source_name"`
SourceRecordID string `json:"source_record_id"`
DedupeKey string `json:"dedupe_key"`
RecordKind string `json:"record_kind"`
Title string `json:"title"`
Agency string `json:"agency"`
SubAgency string `json:"sub_agency"`
Naics string `json:"naics"`
Psc string `json:"psc"`
PopCity string `json:"pop_city"`
PopState string `json:"pop_state"`
PopCountry string `json:"pop_country"`
PopZip string `json:"pop_zip"`
SetAside string `json:"set_aside"`
SetAsideCode string `json:"set_aside_code"`
ContractVehicle string `json:"contract_vehicle"`
EstimatedValue *decimal.Decimal `json:"estimated_value"`
ValueSource string `json:"value_source"`
IncumbentName string `json:"incumbent_name"`
IncumbentUei string `json:"incumbent_uei"`
PostedDate pgtype.Date `json:"posted_date"`
ResponseDeadline *time.Time `json:"response_deadline"`
AwardDate pgtype.Date `json:"award_date"`
EstimatedAwardDate pgtype.Date `json:"estimated_award_date"`
PopStartDate pgtype.Date `json:"pop_start_date"`
PopEndDate pgtype.Date `json:"pop_end_date"`
UiLink string `json:"ui_link"`
IsPlanning bool `json:"is_planning"`
RawObjectKey string `json:"raw_object_key"`
RawSha256 string `json:"raw_sha256"`
FetchedAt time.Time `json:"fetched_at"`
SyncedAt time.Time `json:"synced_at"`
}
type Organization struct {
ID uuid.UUID `json:"id"`
Name string `json:"name"`
Slug string `json:"slug"`
Status string `json:"status"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type RecommendationRun struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
View string `json:"view"`
ScopeRef *uuid.UUID `json:"scope_ref"`
ModelVersion string `json:"model_version"`
Parameters []byte `json:"parameters"`
CreatedBy *uuid.UUID `json:"created_by"`
CreatedAt time.Time `json:"created_at"`
}
type RequiredCertification struct {
OrganizationID uuid.UUID `json:"organization_id"`
RequirementID uuid.UUID `json:"requirement_id"`
Name string `json:"name"`
}
type RequiredSkill struct {
OrganizationID uuid.UUID `json:"organization_id"`
RequirementID uuid.UUID `json:"requirement_id"`
SkillID uuid.UUID `json:"skill_id"`
Mandatory bool `json:"mandatory"`
}
type Requirement struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
OpportunityID *uuid.UUID `json:"opportunity_id"`
Title string `json:"title"`
CustomerAgency *string `json:"customer_agency"`
RequiredLevel string `json:"required_level"`
RequiredPoly string `json:"required_poly"`
RequiredYears int32 `json:"required_years"`
WorkLocation *string `json:"work_location"`
RemoteAllowed bool `json:"remote_allowed"`
KeyPersonnel bool `json:"key_personnel"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
DeletedAt *time.Time `json:"deleted_at"`
LaborCategory *string `json:"labor_category"`
Quantity int32 `json:"quantity"`
}
type SamOpportunity struct {
NoticeID string `json:"notice_id"`
Title string `json:"title"`
SolicitationNumber string `json:"solicitation_number"`
Department string `json:"department"`
FullParentPath string `json:"full_parent_path"`
SubAgency string `json:"sub_agency"`
NaicsCode string `json:"naics_code"`
PscCode string `json:"psc_code"`
SetAsideCode string `json:"set_aside_code"`
SetAside string `json:"set_aside"`
NoticeType string `json:"notice_type"`
BaseType string `json:"base_type"`
PostedDate pgtype.Date `json:"posted_date"`
ResponseDeadline *time.Time `json:"response_deadline"`
Active bool `json:"active"`
PopCity string `json:"pop_city"`
PopState string `json:"pop_state"`
PopZip string `json:"pop_zip"`
UiLink string `json:"ui_link"`
DescriptionUrl string `json:"description_url"`
ResourceLinks []byte `json:"resource_links"`
Poc []byte `json:"poc"`
Raw []byte `json:"raw"`
Source string `json:"source"`
SyncedAt time.Time `json:"synced_at"`
}
type Skill struct {
ID uuid.UUID `json:"id"`
Name string `json:"name"`
Category *string `json:"category"`
Embedding *pgvector.Vector `json:"embedding"`
CreatedAt time.Time `json:"created_at"`
}
type Slate struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
RequirementID uuid.UUID `json:"requirement_id"`
Name string `json:"name"`
Status string `json:"status"`
CreatedBy *uuid.UUID `json:"created_by"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type SlateMember struct {
OrganizationID uuid.UUID `json:"organization_id"`
SlateID uuid.UUID `json:"slate_id"`
CandidateID uuid.UUID `json:"candidate_id"`
TotalScore decimal.Decimal `json:"total_score"`
Band string `json:"band"`
ClearanceScore decimal.Decimal `json:"clearance_score"`
SkillsScore decimal.Decimal `json:"skills_score"`
CertsScore decimal.Decimal `json:"certs_score"`
CustomerScore decimal.Decimal `json:"customer_score"`
ExperienceScore decimal.Decimal `json:"experience_score"`
LocationScore decimal.Decimal `json:"location_score"`
Explanation string `json:"explanation"`
Trace []byte `json:"trace"`
GapSummary []byte `json:"gap_summary"`
Decision string `json:"decision"`
DecidedBy *uuid.UUID `json:"decided_by"`
DecidedAt *time.Time `json:"decided_at"`
Rank *int32 `json:"rank"`
CreatedAt time.Time `json:"created_at"`
ModelVersion *string `json:"model_version"`
DecisionNote *string `json:"decision_note"`
}
type SourcingLog struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
CandidateID *uuid.UUID `json:"candidate_id"`
ExternalID string `json:"external_id"`
Source string `json:"source"`
Provider string `json:"provider"`
Query string `json:"query"`
LegalBasis string `json:"legal_basis"`
CollectedAt time.Time `json:"collected_at"`
CreatedAt time.Time `json:"created_at"`
}
type StaffingRecommendation struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
RunID uuid.UUID `json:"run_id"`
RequirementID uuid.UUID `json:"requirement_id"`
CandidateID *uuid.UUID `json:"candidate_id"`
Action string `json:"action"`
Rank int32 `json:"rank"`
Confidence decimal.Decimal `json:"confidence"`
ValueScore *int64 `json:"value_score"`
Rationale string `json:"rationale"`
RationaleSource string `json:"rationale_source"`
Evidence []byte `json:"evidence"`
Status string `json:"status"`
DecidedBy *uuid.UUID `json:"decided_by"`
DecidedAt *time.Time `json:"decided_at"`
DecisionNote *string `json:"decision_note"`
CreatedAt time.Time `json:"created_at"`
}
type TenantDirectory struct {
OrganizationID uuid.UUID `json:"organization_id"`
DbName string `json:"db_name"`
DbHost string `json:"db_host"`
DbPort int32 `json:"db_port"`
ConnectionSecretRef string `json:"connection_secret_ref"`
Status string `json:"status"`
Cloud string `json:"cloud"`
Region string `json:"region"`
LastMigratedVersion *int64 `json:"last_migrated_version"`
LastMigratedAt *time.Time `json:"last_migrated_at"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type UsaspendingAward struct {
GeneratedInternalID string `json:"generated_internal_id"`
AwardID string `json:"award_id"`
RecipientName string `json:"recipient_name"`
RecipientUei string `json:"recipient_uei"`
RecipientID string `json:"recipient_id"`
AwardAmount *decimal.Decimal `json:"award_amount"`
AwardingAgency string `json:"awarding_agency"`
AwardingSubAgency string `json:"awarding_sub_agency"`
PopStartDate pgtype.Date `json:"pop_start_date"`
PopEndDate pgtype.Date `json:"pop_end_date"`
NaicsCode string `json:"naics_code"`
NaicsDescription string `json:"naics_description"`
Description string `json:"description"`
IsGalapagos bool `json:"is_galapagos"`
Raw []byte `json:"raw"`
Source string `json:"source"`
SyncedAt time.Time `json:"synced_at"`
}
type User struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
Email string `json:"email"`
FullName string `json:"full_name"`
Role string `json:"role"`
Status string `json:"status"`
LastLoginAt *time.Time `json:"last_login_at"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
MfaEnrolled bool `json:"mfa_enrolled"`
}
type UserInvite struct {
ID uuid.UUID `json:"id"`
OrganizationID uuid.UUID `json:"organization_id"`
EmailNormalized string `json:"email_normalized"`
InvitedUserID uuid.UUID `json:"invited_user_id"`
TokenHash []byte `json:"token_hash"`
Role string `json:"role"`
ExpiresAt time.Time `json:"expires_at"`
AcceptedAt *time.Time `json:"accepted_at"`
CreatedBy uuid.UUID `json:"created_by"`
CreatedAt time.Time `json:"created_at"`
}