func ExpectOne[Tany](ret []T, errerror) (T,error)

func GenLockID(namestring)int64

func IncrementExecutionCount(opts *TxOptions)

func IsForeignKeyViolation(errerror, foreignKeyConstraints ...ForeignKeyConstraint)bool

func IsQueryCanceledError(errerror)bool

func IsSerializedError(errerror)bool

func IsUniqueViolation(errerror, uniqueConstraints ...UniqueConstraint)bool

func IsWorkspaceAgentLogsLimitError(errerror)bool

func ReadModifyUpdate(dbStore, f func(txStore)error,)error

func WithSerialRetryCount(countint) func(*sqlQuerier)

type APIKey struct {IDstring `db:"id" json:"id"`// hashed_secret contains a SHA256 hash of the key secret. This is considered a secret and MUST NOT be returned from the API as it is used for API key encryption in app proxying code.HashedSecret    []byte      `db:"hashed_secret" json:"hashed_secret"`UserIDuuid.UUID   `db:"user_id" json:"user_id"`LastUsedtime.Time   `db:"last_used" json:"last_used"`ExpiresAttime.Time   `db:"expires_at" json:"expires_at"`CreatedAttime.Time   `db:"created_at" json:"created_at"`UpdatedAttime.Time   `db:"updated_at" json:"updated_at"`LoginTypeLoginType   `db:"login_type" json:"login_type"`LifetimeSecondsint64       `db:"lifetime_seconds" json:"lifetime_seconds"`IPAddresspqtype.Inet `db:"ip_address" json:"ip_address"`ScopeAPIKeyScope `db:"scope" json:"scope"`TokenNamestring      `db:"token_name" json:"token_name"`}

func (APIKey)RBACObject¶

func (kAPIKey) RBACObject()rbac.Object

type APIKeyScopestring

funcAllAPIKeyScopeValues¶

func AllAPIKeyScopeValues() []APIKeyScope

func (*APIKeyScope)Scan¶

func (e *APIKeyScope) Scan(src interface{})error

func (APIKeyScope)ToRBAC¶

func (sAPIKeyScope) ToRBAC()rbac.ScopeName

func (APIKeyScope)Valid¶

func (eAPIKeyScope) Valid()bool

type AcquireNotificationMessagesParams struct {NotifierIDuuid.UUID `db:"notifier_id" json:"notifier_id"`LeaseSecondsint32     `db:"lease_seconds" json:"lease_seconds"`MaxAttemptCountint32     `db:"max_attempt_count" json:"max_attempt_count"`Countint32     `db:"count" json:"count"`}

type AcquireNotificationMessagesRow struct {IDuuid.UUID          `db:"id" json:"id"`Payloadjson.RawMessage    `db:"payload" json:"payload"`MethodNotificationMethod `db:"method" json:"method"`AttemptCountint32              `db:"attempt_count" json:"attempt_count"`QueuedSecondsfloat64            `db:"queued_seconds" json:"queued_seconds"`TemplateIDuuid.UUID          `db:"template_id" json:"template_id"`TitleTemplatestring             `db:"title_template" json:"title_template"`BodyTemplatestring             `db:"body_template" json:"body_template"`Disabledbool               `db:"disabled" json:"disabled"`}

type AcquireProvisionerJobParams struct {StartedAtsql.NullTime      `db:"started_at" json:"started_at"`WorkerIDuuid.NullUUID     `db:"worker_id" json:"worker_id"`OrganizationIDuuid.UUID         `db:"organization_id" json:"organization_id"`Types           []ProvisionerType `db:"types" json:"types"`ProvisionerTagsjson.RawMessage   `db:"provisioner_tags" json:"provisioner_tags"`}

type Actions []policy.Action

func (*Actions)Scan¶

func (a *Actions) Scan(src interface{})error

func (*Actions)Value¶

func (a *Actions) Value() (driver.Value,error)

type ActivityBumpWorkspaceParams struct {NextAutostarttime.Time `db:"next_autostart" json:"next_autostart"`WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`}

type AgentIDNamePair struct {IDuuid.UUID `db:"id" json:"id"`Namestring    `db:"name" json:"name"`}

func (*AgentIDNamePair)Scan¶added inv2.18.0

func (p *AgentIDNamePair) Scan(src interface{})error

func (AgentIDNamePair)Value¶added inv2.18.0

func (pAgentIDNamePair) Value() (driver.Value,error)

type AgentKeyScopeEnumstring

funcAllAgentKeyScopeEnumValues¶added inv2.22.0

func AllAgentKeyScopeEnumValues() []AgentKeyScopeEnum

func (*AgentKeyScopeEnum)Scan¶added inv2.22.0

func (e *AgentKeyScopeEnum) Scan(src interface{})error

func (AgentKeyScopeEnum)Valid¶added inv2.22.0

func (eAgentKeyScopeEnum) Valid()bool

type AppSharingLevelstring

funcAllAppSharingLevelValues¶

func AllAppSharingLevelValues() []AppSharingLevel

func (*AppSharingLevel)Scan¶

func (e *AppSharingLevel) Scan(src interface{})error

func (AppSharingLevel)Valid¶

func (eAppSharingLevel) Valid()bool

type ArchiveUnusedTemplateVersionsParams struct {UpdatedAttime.Time                `db:"updated_at" json:"updated_at"`TemplateIDuuid.UUID                `db:"template_id" json:"template_id"`TemplateVersionIDuuid.UUID                `db:"template_version_id" json:"template_version_id"`JobStatusNullProvisionerJobStatus `db:"job_status" json:"job_status"`}

type AuditActionstring

funcAllAuditActionValues¶

func AllAuditActionValues() []AuditAction

func (*AuditAction)Scan¶

func (e *AuditAction) Scan(src interface{})error

func (AuditAction)Valid¶

func (eAuditAction) Valid()bool

type AuditLog struct {IDuuid.UUID       `db:"id" json:"id"`Timetime.Time       `db:"time" json:"time"`UserIDuuid.UUID       `db:"user_id" json:"user_id"`OrganizationIDuuid.UUID       `db:"organization_id" json:"organization_id"`Ippqtype.Inet     `db:"ip" json:"ip"`UserAgentsql.NullString  `db:"user_agent" json:"user_agent"`ResourceTypeResourceType    `db:"resource_type" json:"resource_type"`ResourceIDuuid.UUID       `db:"resource_id" json:"resource_id"`ResourceTargetstring          `db:"resource_target" json:"resource_target"`ActionAuditAction     `db:"action" json:"action"`Diffjson.RawMessage `db:"diff" json:"diff"`StatusCodeint32           `db:"status_code" json:"status_code"`AdditionalFieldsjson.RawMessage `db:"additional_fields" json:"additional_fields"`RequestIDuuid.UUID       `db:"request_id" json:"request_id"`ResourceIconstring          `db:"resource_icon" json:"resource_icon"`}

func (AuditLog)RBACObject¶added inv2.14.0

func (wAuditLog) RBACObject()rbac.Object

type AuditOAuthConvertState struct {CreatedAttime.Time `db:"created_at" json:"created_at"`// The time at which the state string expires, a merge request times out if the user does not perform it quick enough.ExpiresAttime.Time `db:"expires_at" json:"expires_at"`FromLoginTypeLoginType `db:"from_login_type" json:"from_login_type"`// The login type the user is converting to. Should be github or oidc.ToLoginTypeLoginType `db:"to_login_type" json:"to_login_type"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type AuditableGroup struct {GroupMembers []GroupMemberTable `json:"members"`}

type AuditableOrganizationMember struct {OrganizationMemberUsernamestring `json:"username"`}

type AutomaticUpdatesstring

funcAllAutomaticUpdatesValues¶added inv2.3.0

func AllAutomaticUpdatesValues() []AutomaticUpdates

func (*AutomaticUpdates)Scan¶added inv2.3.0

func (e *AutomaticUpdates) Scan(src interface{})error

func (AutomaticUpdates)Valid¶added inv2.3.0

func (eAutomaticUpdates) Valid()bool

type BatchUpdateWorkspaceLastUsedAtParams struct {LastUsedAttime.Time   `db:"last_used_at" json:"last_used_at"`IDs        []uuid.UUID `db:"ids" json:"ids"`}

type BatchUpdateWorkspaceNextStartAtParams struct {IDs          []uuid.UUID `db:"ids" json:"ids"`NextStartAts []time.Time `db:"next_start_ats" json:"next_start_ats"`}

type BuildReasonstring

funcAllBuildReasonValues¶

func AllBuildReasonValues() []BuildReason

func (*BuildReason)Scan¶

func (e *BuildReason) Scan(src interface{})error

func (BuildReason)Valid¶

func (eBuildReason) Valid()bool

type BulkMarkNotificationMessagesFailedParams struct {MaxAttemptsint32                       `db:"max_attempts" json:"max_attempts"`RetryIntervalint32                       `db:"retry_interval" json:"retry_interval"`IDs           []uuid.UUID                 `db:"ids" json:"ids"`FailedAts     []time.Time                 `db:"failed_ats" json:"failed_ats"`Statuses      []NotificationMessageStatus `db:"statuses" json:"statuses"`StatusReasons []string                    `db:"status_reasons" json:"status_reasons"`}

type BulkMarkNotificationMessagesSentParams struct {IDs     []uuid.UUID `db:"ids" json:"ids"`SentAts []time.Time `db:"sent_ats" json:"sent_ats"`}

type Chat struct {IDuuid.UUID `db:"id" json:"id"`OwnerIDuuid.UUID `db:"owner_id" json:"owner_id"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`Titlestring    `db:"title" json:"title"`}

func (Chat)RBACObject¶added inv2.23.0

func (cChat) RBACObject()rbac.Object

type ChatMessage struct {IDint64           `db:"id" json:"id"`ChatIDuuid.UUID       `db:"chat_id" json:"chat_id"`CreatedAttime.Time       `db:"created_at" json:"created_at"`Modelstring          `db:"model" json:"model"`Providerstring          `db:"provider" json:"provider"`Contentjson.RawMessage `db:"content" json:"content"`}

type ClaimPrebuiltWorkspaceParams struct {NewUserIDuuid.UUID `db:"new_user_id" json:"new_user_id"`NewNamestring    `db:"new_name" json:"new_name"`PresetIDuuid.UUID `db:"preset_id" json:"preset_id"`}

type ClaimPrebuiltWorkspaceRow struct {IDuuid.UUID `db:"id" json:"id"`Namestring    `db:"name" json:"name"`}

type ConnectorCreator interface {driver.DriverConnector(namestring) (driver.Connector,error)}

type CountInProgressPrebuildsRow struct {TemplateIDuuid.UUID           `db:"template_id" json:"template_id"`TemplateVersionIDuuid.UUID           `db:"template_version_id" json:"template_version_id"`TransitionWorkspaceTransition `db:"transition" json:"transition"`Countint32               `db:"count" json:"count"`PresetIDuuid.NullUUID       `db:"preset_id" json:"preset_id"`}

type CryptoKey struct {FeatureCryptoKeyFeature `db:"feature" json:"feature"`Sequenceint32            `db:"sequence" json:"sequence"`Secretsql.NullString   `db:"secret" json:"secret"`SecretKeyIDsql.NullString   `db:"secret_key_id" json:"secret_key_id"`StartsAttime.Time        `db:"starts_at" json:"starts_at"`DeletesAtsql.NullTime     `db:"deletes_at" json:"deletes_at"`}

func (CryptoKey)CanSign¶added inv2.17.0

func (kCryptoKey) CanSign(nowtime.Time)bool

func (CryptoKey)CanVerify¶added inv2.17.0

func (kCryptoKey) CanVerify(nowtime.Time)bool

func (CryptoKey)DecodeString¶added inv2.17.0

func (kCryptoKey) DecodeString() ([]byte,error)

func (CryptoKey)ExpiresAt¶added inv2.16.0

func (kCryptoKey) ExpiresAt(keyDurationtime.Duration)time.Time

type CryptoKeyFeaturestring

funcAllCryptoKeyFeatureValues¶added inv2.16.0

func AllCryptoKeyFeatureValues() []CryptoKeyFeature

func (*CryptoKeyFeature)Scan¶added inv2.16.0

func (e *CryptoKeyFeature) Scan(src interface{})error

func (CryptoKeyFeature)Valid¶added inv2.16.0

func (eCryptoKeyFeature) Valid()bool

type CustomRole struct {Namestring                `db:"name" json:"name"`DisplayNamestring                `db:"display_name" json:"display_name"`SitePermissionsCustomRolePermissions `db:"site_permissions" json:"site_permissions"`OrgPermissionsCustomRolePermissions `db:"org_permissions" json:"org_permissions"`UserPermissionsCustomRolePermissions `db:"user_permissions" json:"user_permissions"`CreatedAttime.Time             `db:"created_at" json:"created_at"`UpdatedAttime.Time             `db:"updated_at" json:"updated_at"`// Roles can optionally be scoped to an organizationOrganizationIDuuid.NullUUID `db:"organization_id" json:"organization_id"`// Custom roles ID is used purely for auditing purposes. Name is a better unique identifier.IDuuid.UUID `db:"id" json:"id"`}

func (CustomRole)RoleIdentifier¶added inv2.13.0

func (rCustomRole) RoleIdentifier()rbac.RoleIdentifier

type CustomRolePermission struct {Negatebool          `json:"negate"`ResourceTypestring        `json:"resource_type"`Actionpolicy.Action `json:"action"`}

func (CustomRolePermission)String¶added inv2.13.0

func (aCustomRolePermission) String()string

type CustomRolePermissions []CustomRolePermission

func (*CustomRolePermissions)Scan¶added inv2.13.0

func (a *CustomRolePermissions) Scan(src interface{})error

func (CustomRolePermissions)Value¶added inv2.13.0

func (aCustomRolePermissions) Value() (driver.Value,error)

type CustomRolesParams struct {LookupRoles     []NameOrganizationPair `db:"lookup_roles" json:"lookup_roles"`ExcludeOrgRolesbool                   `db:"exclude_org_roles" json:"exclude_org_roles"`OrganizationIDuuid.UUID              `db:"organization_id" json:"organization_id"`}

type DBCryptKey struct {// An integer used to identify the key.Numberint32 `db:"number" json:"number"`// If the key is active, the digest of the active key.ActiveKeyDigestsql.NullString `db:"active_key_digest" json:"active_key_digest"`// If the key has been revoked, the digest of the revoked key.RevokedKeyDigestsql.NullString `db:"revoked_key_digest" json:"revoked_key_digest"`// The time at which the key was created.CreatedAtsql.NullTime `db:"created_at" json:"created_at"`// The time at which the key was revoked.RevokedAtsql.NullTime `db:"revoked_at" json:"revoked_at"`// A column used to test the encryption.Teststring `db:"test" json:"test"`}

type DBTX interface {ExecContext(context.Context,string, ...interface{}) (sql.Result,error)PrepareContext(context.Context,string) (*sql.Stmt,error)QueryContext(context.Context,string, ...interface{}) (*sql.Rows,error)QueryRowContext(context.Context,string, ...interface{}) *sql.RowSelectContext(ctxcontext.Context, dest interface{}, querystring, args ...interface{})errorGetContext(ctxcontext.Context, dest interface{}, querystring, args ...interface{})error}

type DeleteAllTailnetClientSubscriptionsParams struct {ClientIDuuid.UUID `db:"client_id" json:"client_id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteAllTailnetTunnelsParams struct {CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`SrcIDuuid.UUID `db:"src_id" json:"src_id"`}

type DeleteCryptoKeyParams struct {FeatureCryptoKeyFeature `db:"feature" json:"feature"`Sequenceint32            `db:"sequence" json:"sequence"`}

type DeleteCustomRoleParams struct {Namestring        `db:"name" json:"name"`OrganizationIDuuid.NullUUID `db:"organization_id" json:"organization_id"`}

type DeleteExternalAuthLinkParams struct {ProviderIDstring    `db:"provider_id" json:"provider_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type DeleteGroupMemberFromGroupParams struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`GroupIDuuid.UUID `db:"group_id" json:"group_id"`}

type DeleteOAuth2ProviderAppCodesByAppAndUserIDParams struct {AppIDuuid.UUID `db:"app_id" json:"app_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type DeleteOAuth2ProviderAppTokensByAppAndUserIDParams struct {AppIDuuid.UUID `db:"app_id" json:"app_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type DeleteOrganizationMemberParams struct {OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type DeleteTailnetAgentParams struct {IDuuid.UUID `db:"id" json:"id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteTailnetAgentRow struct {IDuuid.UUID `db:"id" json:"id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteTailnetClientParams struct {IDuuid.UUID `db:"id" json:"id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteTailnetClientRow struct {IDuuid.UUID `db:"id" json:"id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteTailnetClientSubscriptionParams struct {ClientIDuuid.UUID `db:"client_id" json:"client_id"`AgentIDuuid.UUID `db:"agent_id" json:"agent_id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteTailnetPeerParams struct {IDuuid.UUID `db:"id" json:"id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteTailnetPeerRow struct {IDuuid.UUID `db:"id" json:"id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`}

type DeleteTailnetTunnelParams struct {CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`SrcIDuuid.UUID `db:"src_id" json:"src_id"`DstIDuuid.UUID `db:"dst_id" json:"dst_id"`}

type DeleteTailnetTunnelRow struct {CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`SrcIDuuid.UUID `db:"src_id" json:"src_id"`DstIDuuid.UUID `db:"dst_id" json:"dst_id"`}

type DeleteWebpushSubscriptionByUserIDAndEndpointParams struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`Endpointstring    `db:"endpoint" json:"endpoint"`}

type DeleteWorkspaceAgentPortShareParams struct {WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`AgentNamestring    `db:"agent_name" json:"agent_name"`Portint32     `db:"port" json:"port"`}

type DialerConnector interface {driver.ConnectorDialer(dialerpq.Dialer)}

type DisplayAppstring

funcAllDisplayAppValues¶added inv2.1.5

func AllDisplayAppValues() []DisplayApp

func (*DisplayApp)Scan¶added inv2.1.5

func (e *DisplayApp) Scan(src interface{})error

func (DisplayApp)Valid¶added inv2.1.5

func (eDisplayApp) Valid()bool

type EnqueueNotificationMessageParams struct {IDuuid.UUID          `db:"id" json:"id"`NotificationTemplateIDuuid.UUID          `db:"notification_template_id" json:"notification_template_id"`UserIDuuid.UUID          `db:"user_id" json:"user_id"`MethodNotificationMethod `db:"method" json:"method"`Payloadjson.RawMessage    `db:"payload" json:"payload"`Targets                []uuid.UUID        `db:"targets" json:"targets"`CreatedBystring             `db:"created_by" json:"created_by"`CreatedAttime.Time          `db:"created_at" json:"created_at"`}

type ExternalAuthLink struct {ProviderIDstring    `db:"provider_id" json:"provider_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`OAuthAccessTokenstring    `db:"oauth_access_token" json:"oauth_access_token"`OAuthRefreshTokenstring    `db:"oauth_refresh_token" json:"oauth_refresh_token"`OAuthExpirytime.Time `db:"oauth_expiry" json:"oauth_expiry"`// The ID of the key used to encrypt the OAuth access token. If this is NULL, the access token is not encryptedOAuthAccessTokenKeyIDsql.NullString `db:"oauth_access_token_key_id" json:"oauth_access_token_key_id"`// The ID of the key used to encrypt the OAuth refresh token. If this is NULL, the refresh token is not encryptedOAuthRefreshTokenKeyIDsql.NullString        `db:"oauth_refresh_token_key_id" json:"oauth_refresh_token_key_id"`OAuthExtrapqtype.NullRawMessage `db:"oauth_extra" json:"oauth_extra"`}

func (ExternalAuthLink)OAuthToken¶added inv2.8.0

func (uExternalAuthLink) OAuthToken() *oauth2.Token

func (ExternalAuthLink)RBACObject¶added inv2.2.1

func (uExternalAuthLink) RBACObject()rbac.Object

type ExternalAuthProvider struct {IDstring `json:"id"`Optionalbool   `json:"optional,omitempty"`}

type FetchNewMessageMetadataParams struct {NotificationTemplateIDuuid.UUID `db:"notification_template_id" json:"notification_template_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type FetchNewMessageMetadataRow struct {NotificationNamestring                 `db:"notification_name" json:"notification_name"`NotificationTemplateIDuuid.UUID              `db:"notification_template_id" json:"notification_template_id"`Actions                []byte                 `db:"actions" json:"actions"`CustomMethodNullNotificationMethod `db:"custom_method" json:"custom_method"`UserIDuuid.UUID              `db:"user_id" json:"user_id"`UserEmailstring                 `db:"user_email" json:"user_email"`UserNamestring                 `db:"user_name" json:"user_name"`UserUsernamestring                 `db:"user_username" json:"user_username"`}

type File struct {Hashstring    `db:"hash" json:"hash"`CreatedAttime.Time `db:"created_at" json:"created_at"`CreatedByuuid.UUID `db:"created_by" json:"created_by"`Mimetypestring    `db:"mimetype" json:"mimetype"`Data      []byte    `db:"data" json:"data"`IDuuid.UUID `db:"id" json:"id"`}

func (File)RBACObject¶

func (fFile) RBACObject()rbac.Object

type ForeignKeyConstraintstring

const (ForeignKeyAPIKeysUserIDUUIDForeignKeyConstraint = "api_keys_user_id_uuid_fkey"// ALTER TABLE ONLY api_keys ADD CONSTRAINT api_keys_user_id_uuid_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyChatMessagesChatIDForeignKeyConstraint = "chat_messages_chat_id_fkey"// ALTER TABLE ONLY chat_messages ADD CONSTRAINT chat_messages_chat_id_fkey FOREIGN KEY (chat_id) REFERENCES chats(id) ON DELETE CASCADE;ForeignKeyChatsOwnerIDForeignKeyConstraint = "chats_owner_id_fkey"// ALTER TABLE ONLY chats ADD CONSTRAINT chats_owner_id_fkey FOREIGN KEY (owner_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyCryptoKeysSecretKeyIDForeignKeyConstraint = "crypto_keys_secret_key_id_fkey"// ALTER TABLE ONLY crypto_keys ADD CONSTRAINT crypto_keys_secret_key_id_fkey FOREIGN KEY (secret_key_id) REFERENCES dbcrypt_keys(active_key_digest);ForeignKeyGitAuthLinksOauthAccessTokenKeyIDForeignKeyConstraint = "git_auth_links_oauth_access_token_key_id_fkey"// ALTER TABLE ONLY external_auth_links ADD CONSTRAINT git_auth_links_oauth_access_token_key_id_fkey FOREIGN KEY (oauth_access_token_key_id) REFERENCES dbcrypt_keys(active_key_digest);ForeignKeyGitAuthLinksOauthRefreshTokenKeyIDForeignKeyConstraint = "git_auth_links_oauth_refresh_token_key_id_fkey"// ALTER TABLE ONLY external_auth_links ADD CONSTRAINT git_auth_links_oauth_refresh_token_key_id_fkey FOREIGN KEY (oauth_refresh_token_key_id) REFERENCES dbcrypt_keys(active_key_digest);ForeignKeyGitSSHKeysUserIDForeignKeyConstraint = "gitsshkeys_user_id_fkey"// ALTER TABLE ONLY gitsshkeys ADD CONSTRAINT gitsshkeys_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);ForeignKeyGroupMembersGroupIDForeignKeyConstraint = "group_members_group_id_fkey"// ALTER TABLE ONLY group_members ADD CONSTRAINT group_members_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(id) ON DELETE CASCADE;ForeignKeyGroupMembersUserIDForeignKeyConstraint = "group_members_user_id_fkey"// ALTER TABLE ONLY group_members ADD CONSTRAINT group_members_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyGroupsOrganizationIDForeignKeyConstraint = "groups_organization_id_fkey"// ALTER TABLE ONLY groups ADD CONSTRAINT groups_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE CASCADE;ForeignKeyInboxNotificationsTemplateIDForeignKeyConstraint = "inbox_notifications_template_id_fkey"// ALTER TABLE ONLY inbox_notifications ADD CONSTRAINT inbox_notifications_template_id_fkey FOREIGN KEY (template_id) REFERENCES notification_templates(id) ON DELETE CASCADE;ForeignKeyInboxNotificationsUserIDForeignKeyConstraint = "inbox_notifications_user_id_fkey"// ALTER TABLE ONLY inbox_notifications ADD CONSTRAINT inbox_notifications_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyJfrogXrayScansAgentIDForeignKeyConstraint = "jfrog_xray_scans_agent_id_fkey"// ALTER TABLE ONLY jfrog_xray_scans ADD CONSTRAINT jfrog_xray_scans_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyJfrogXrayScansWorkspaceIDForeignKeyConstraint = "jfrog_xray_scans_workspace_id_fkey"// ALTER TABLE ONLY jfrog_xray_scans ADD CONSTRAINT jfrog_xray_scans_workspace_id_fkey FOREIGN KEY (workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE;ForeignKeyNotificationMessagesNotificationTemplateIDForeignKeyConstraint = "notification_messages_notification_template_id_fkey"// ALTER TABLE ONLY notification_messages ADD CONSTRAINT notification_messages_notification_template_id_fkey FOREIGN KEY (notification_template_id) REFERENCES notification_templates(id) ON DELETE CASCADE;ForeignKeyNotificationMessagesUserIDForeignKeyConstraint = "notification_messages_user_id_fkey"// ALTER TABLE ONLY notification_messages ADD CONSTRAINT notification_messages_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyNotificationPreferencesNotificationTemplateIDForeignKeyConstraint = "notification_preferences_notification_template_id_fkey"// ALTER TABLE ONLY notification_preferences ADD CONSTRAINT notification_preferences_notification_template_id_fkey FOREIGN KEY (notification_template_id) REFERENCES notification_templates(id) ON DELETE CASCADE;ForeignKeyNotificationPreferencesUserIDForeignKeyConstraint = "notification_preferences_user_id_fkey"// ALTER TABLE ONLY notification_preferences ADD CONSTRAINT notification_preferences_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyOauth2ProviderAppCodesAppIDForeignKeyConstraint = "oauth2_provider_app_codes_app_id_fkey"// ALTER TABLE ONLY oauth2_provider_app_codes ADD CONSTRAINT oauth2_provider_app_codes_app_id_fkey FOREIGN KEY (app_id) REFERENCES oauth2_provider_apps(id) ON DELETE CASCADE;ForeignKeyOauth2ProviderAppCodesUserIDForeignKeyConstraint = "oauth2_provider_app_codes_user_id_fkey"// ALTER TABLE ONLY oauth2_provider_app_codes ADD CONSTRAINT oauth2_provider_app_codes_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyOauth2ProviderAppSecretsAppIDForeignKeyConstraint = "oauth2_provider_app_secrets_app_id_fkey"// ALTER TABLE ONLY oauth2_provider_app_secrets ADD CONSTRAINT oauth2_provider_app_secrets_app_id_fkey FOREIGN KEY (app_id) REFERENCES oauth2_provider_apps(id) ON DELETE CASCADE;ForeignKeyOauth2ProviderAppTokensAPIKeyIDForeignKeyConstraint = "oauth2_provider_app_tokens_api_key_id_fkey"// ALTER TABLE ONLY oauth2_provider_app_tokens ADD CONSTRAINT oauth2_provider_app_tokens_api_key_id_fkey FOREIGN KEY (api_key_id) REFERENCES api_keys(id) ON DELETE CASCADE;ForeignKeyOauth2ProviderAppTokensAppSecretIDForeignKeyConstraint = "oauth2_provider_app_tokens_app_secret_id_fkey"// ALTER TABLE ONLY oauth2_provider_app_tokens ADD CONSTRAINT oauth2_provider_app_tokens_app_secret_id_fkey FOREIGN KEY (app_secret_id) REFERENCES oauth2_provider_app_secrets(id) ON DELETE CASCADE;ForeignKeyOrganizationMembersOrganizationIDUUIDForeignKeyConstraint = "organization_members_organization_id_uuid_fkey"// ALTER TABLE ONLY organization_members ADD CONSTRAINT organization_members_organization_id_uuid_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE CASCADE;ForeignKeyOrganizationMembersUserIDUUIDForeignKeyConstraint = "organization_members_user_id_uuid_fkey"// ALTER TABLE ONLY organization_members ADD CONSTRAINT organization_members_user_id_uuid_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyParameterSchemasJobIDForeignKeyConstraint = "parameter_schemas_job_id_fkey"// ALTER TABLE ONLY parameter_schemas ADD CONSTRAINT parameter_schemas_job_id_fkey FOREIGN KEY (job_id) REFERENCES provisioner_jobs(id) ON DELETE CASCADE;ForeignKeyProvisionerDaemonsKeyIDForeignKeyConstraint = "provisioner_daemons_key_id_fkey"// ALTER TABLE ONLY provisioner_daemons ADD CONSTRAINT provisioner_daemons_key_id_fkey FOREIGN KEY (key_id) REFERENCES provisioner_keys(id) ON DELETE CASCADE;ForeignKeyProvisionerDaemonsOrganizationIDForeignKeyConstraint = "provisioner_daemons_organization_id_fkey"// ALTER TABLE ONLY provisioner_daemons ADD CONSTRAINT provisioner_daemons_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE CASCADE;ForeignKeyProvisionerJobLogsJobIDForeignKeyConstraint = "provisioner_job_logs_job_id_fkey"// ALTER TABLE ONLY provisioner_job_logs ADD CONSTRAINT provisioner_job_logs_job_id_fkey FOREIGN KEY (job_id) REFERENCES provisioner_jobs(id) ON DELETE CASCADE;ForeignKeyProvisionerJobTimingsJobIDForeignKeyConstraint = "provisioner_job_timings_job_id_fkey"// ALTER TABLE ONLY provisioner_job_timings ADD CONSTRAINT provisioner_job_timings_job_id_fkey FOREIGN KEY (job_id) REFERENCES provisioner_jobs(id) ON DELETE CASCADE;ForeignKeyProvisionerJobsOrganizationIDForeignKeyConstraint = "provisioner_jobs_organization_id_fkey"// ALTER TABLE ONLY provisioner_jobs ADD CONSTRAINT provisioner_jobs_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE CASCADE;ForeignKeyProvisionerKeysOrganizationIDForeignKeyConstraint = "provisioner_keys_organization_id_fkey"// ALTER TABLE ONLY provisioner_keys ADD CONSTRAINT provisioner_keys_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE CASCADE;ForeignKeyTailnetAgentsCoordinatorIDForeignKeyConstraint = "tailnet_agents_coordinator_id_fkey"// ALTER TABLE ONLY tailnet_agents ADD CONSTRAINT tailnet_agents_coordinator_id_fkey FOREIGN KEY (coordinator_id) REFERENCES tailnet_coordinators(id) ON DELETE CASCADE;ForeignKeyTailnetClientSubscriptionsCoordinatorIDForeignKeyConstraint = "tailnet_client_subscriptions_coordinator_id_fkey"// ALTER TABLE ONLY tailnet_client_subscriptions ADD CONSTRAINT tailnet_client_subscriptions_coordinator_id_fkey FOREIGN KEY (coordinator_id) REFERENCES tailnet_coordinators(id) ON DELETE CASCADE;ForeignKeyTailnetClientsCoordinatorIDForeignKeyConstraint = "tailnet_clients_coordinator_id_fkey"// ALTER TABLE ONLY tailnet_clients ADD CONSTRAINT tailnet_clients_coordinator_id_fkey FOREIGN KEY (coordinator_id) REFERENCES tailnet_coordinators(id) ON DELETE CASCADE;ForeignKeyTailnetPeersCoordinatorIDForeignKeyConstraint = "tailnet_peers_coordinator_id_fkey"// ALTER TABLE ONLY tailnet_peers ADD CONSTRAINT tailnet_peers_coordinator_id_fkey FOREIGN KEY (coordinator_id) REFERENCES tailnet_coordinators(id) ON DELETE CASCADE;ForeignKeyTailnetTunnelsCoordinatorIDForeignKeyConstraint = "tailnet_tunnels_coordinator_id_fkey"// ALTER TABLE ONLY tailnet_tunnels ADD CONSTRAINT tailnet_tunnels_coordinator_id_fkey FOREIGN KEY (coordinator_id) REFERENCES tailnet_coordinators(id) ON DELETE CASCADE;ForeignKeyTemplateVersionParametersTemplateVersionIDForeignKeyConstraint = "template_version_parameters_template_version_id_fkey"// ALTER TABLE ONLY template_version_parameters ADD CONSTRAINT template_version_parameters_template_version_id_fkey FOREIGN KEY (template_version_id) REFERENCES template_versions(id) ON DELETE CASCADE;ForeignKeyTemplateVersionPresetParametTemplateVersionPresetIDForeignKeyConstraint = "template_version_preset_paramet_template_version_preset_id_fkey"// ALTER TABLE ONLY template_version_preset_parameters ADD CONSTRAINT template_version_preset_paramet_template_version_preset_id_fkey FOREIGN KEY (template_version_preset_id) REFERENCES template_version_presets(id) ON DELETE CASCADE;ForeignKeyTemplateVersionPresetsTemplateVersionIDForeignKeyConstraint = "template_version_presets_template_version_id_fkey"// ALTER TABLE ONLY template_version_presets ADD CONSTRAINT template_version_presets_template_version_id_fkey FOREIGN KEY (template_version_id) REFERENCES template_versions(id) ON DELETE CASCADE;ForeignKeyTemplateVersionTerraformValuesCachedModuleFilesForeignKeyConstraint = "template_version_terraform_values_cached_module_files_fkey"// ALTER TABLE ONLY template_version_terraform_values ADD CONSTRAINT template_version_terraform_values_cached_module_files_fkey FOREIGN KEY (cached_module_files) REFERENCES files(id);ForeignKeyTemplateVersionTerraformValuesTemplateVersionIDForeignKeyConstraint = "template_version_terraform_values_template_version_id_fkey"// ALTER TABLE ONLY template_version_terraform_values ADD CONSTRAINT template_version_terraform_values_template_version_id_fkey FOREIGN KEY (template_version_id) REFERENCES template_versions(id) ON DELETE CASCADE;ForeignKeyTemplateVersionVariablesTemplateVersionIDForeignKeyConstraint = "template_version_variables_template_version_id_fkey"// ALTER TABLE ONLY template_version_variables ADD CONSTRAINT template_version_variables_template_version_id_fkey FOREIGN KEY (template_version_id) REFERENCES template_versions(id) ON DELETE CASCADE;ForeignKeyTemplateVersionWorkspaceTagsTemplateVersionIDForeignKeyConstraint = "template_version_workspace_tags_template_version_id_fkey"// ALTER TABLE ONLY template_version_workspace_tags ADD CONSTRAINT template_version_workspace_tags_template_version_id_fkey FOREIGN KEY (template_version_id) REFERENCES template_versions(id) ON DELETE CASCADE;ForeignKeyTemplateVersionsCreatedByForeignKeyConstraint = "template_versions_created_by_fkey"// ALTER TABLE ONLY template_versions ADD CONSTRAINT template_versions_created_by_fkey FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE RESTRICT;ForeignKeyTemplateVersionsOrganizationIDForeignKeyConstraint = "template_versions_organization_id_fkey"// ALTER TABLE ONLY template_versions ADD CONSTRAINT template_versions_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE CASCADE;ForeignKeyTemplateVersionsTemplateIDForeignKeyConstraint = "template_versions_template_id_fkey"// ALTER TABLE ONLY template_versions ADD CONSTRAINT template_versions_template_id_fkey FOREIGN KEY (template_id) REFERENCES templates(id) ON DELETE CASCADE;ForeignKeyTemplatesCreatedByForeignKeyConstraint = "templates_created_by_fkey"// ALTER TABLE ONLY templates ADD CONSTRAINT templates_created_by_fkey FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE RESTRICT;ForeignKeyTemplatesOrganizationIDForeignKeyConstraint = "templates_organization_id_fkey"// ALTER TABLE ONLY templates ADD CONSTRAINT templates_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE CASCADE;ForeignKeyUserConfigsUserIDForeignKeyConstraint = "user_configs_user_id_fkey"// ALTER TABLE ONLY user_configs ADD CONSTRAINT user_configs_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyUserDeletedUserIDForeignKeyConstraint = "user_deleted_user_id_fkey"// ALTER TABLE ONLY user_deleted ADD CONSTRAINT user_deleted_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);ForeignKeyUserLinksOauthAccessTokenKeyIDForeignKeyConstraint = "user_links_oauth_access_token_key_id_fkey"// ALTER TABLE ONLY user_links ADD CONSTRAINT user_links_oauth_access_token_key_id_fkey FOREIGN KEY (oauth_access_token_key_id) REFERENCES dbcrypt_keys(active_key_digest);ForeignKeyUserLinksOauthRefreshTokenKeyIDForeignKeyConstraint = "user_links_oauth_refresh_token_key_id_fkey"// ALTER TABLE ONLY user_links ADD CONSTRAINT user_links_oauth_refresh_token_key_id_fkey FOREIGN KEY (oauth_refresh_token_key_id) REFERENCES dbcrypt_keys(active_key_digest);ForeignKeyUserLinksUserIDForeignKeyConstraint = "user_links_user_id_fkey"// ALTER TABLE ONLY user_links ADD CONSTRAINT user_links_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyUserStatusChangesUserIDForeignKeyConstraint = "user_status_changes_user_id_fkey"// ALTER TABLE ONLY user_status_changes ADD CONSTRAINT user_status_changes_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);ForeignKeyWebpushSubscriptionsUserIDForeignKeyConstraint = "webpush_subscriptions_user_id_fkey"// ALTER TABLE ONLY webpush_subscriptions ADD CONSTRAINT webpush_subscriptions_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentDevcontainersWorkspaceAgentIDForeignKeyConstraint = "workspace_agent_devcontainers_workspace_agent_id_fkey"// ALTER TABLE ONLY workspace_agent_devcontainers ADD CONSTRAINT workspace_agent_devcontainers_workspace_agent_id_fkey FOREIGN KEY (workspace_agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentLogSourcesWorkspaceAgentIDForeignKeyConstraint = "workspace_agent_log_sources_workspace_agent_id_fkey"// ALTER TABLE ONLY workspace_agent_log_sources ADD CONSTRAINT workspace_agent_log_sources_workspace_agent_id_fkey FOREIGN KEY (workspace_agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentMemoryResourceMonitorsAgentIDForeignKeyConstraint = "workspace_agent_memory_resource_monitors_agent_id_fkey"// ALTER TABLE ONLY workspace_agent_memory_resource_monitors ADD CONSTRAINT workspace_agent_memory_resource_monitors_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentMetadataWorkspaceAgentIDForeignKeyConstraint = "workspace_agent_metadata_workspace_agent_id_fkey"// ALTER TABLE ONLY workspace_agent_metadata ADD CONSTRAINT workspace_agent_metadata_workspace_agent_id_fkey FOREIGN KEY (workspace_agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentPortShareWorkspaceIDForeignKeyConstraint = "workspace_agent_port_share_workspace_id_fkey"// ALTER TABLE ONLY workspace_agent_port_share ADD CONSTRAINT workspace_agent_port_share_workspace_id_fkey FOREIGN KEY (workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentScriptTimingsScriptIDForeignKeyConstraint = "workspace_agent_script_timings_script_id_fkey"// ALTER TABLE ONLY workspace_agent_script_timings ADD CONSTRAINT workspace_agent_script_timings_script_id_fkey FOREIGN KEY (script_id) REFERENCES workspace_agent_scripts(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentScriptsWorkspaceAgentIDForeignKeyConstraint = "workspace_agent_scripts_workspace_agent_id_fkey"// ALTER TABLE ONLY workspace_agent_scripts ADD CONSTRAINT workspace_agent_scripts_workspace_agent_id_fkey FOREIGN KEY (workspace_agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentStartupLogsAgentIDForeignKeyConstraint = "workspace_agent_startup_logs_agent_id_fkey"// ALTER TABLE ONLY workspace_agent_logs ADD CONSTRAINT workspace_agent_startup_logs_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentVolumeResourceMonitorsAgentIDForeignKeyConstraint = "workspace_agent_volume_resource_monitors_agent_id_fkey"// ALTER TABLE ONLY workspace_agent_volume_resource_monitors ADD CONSTRAINT workspace_agent_volume_resource_monitors_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentsParentIDForeignKeyConstraint = "workspace_agents_parent_id_fkey"// ALTER TABLE ONLY workspace_agents ADD CONSTRAINT workspace_agents_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAgentsResourceIDForeignKeyConstraint = "workspace_agents_resource_id_fkey"// ALTER TABLE ONLY workspace_agents ADD CONSTRAINT workspace_agents_resource_id_fkey FOREIGN KEY (resource_id) REFERENCES workspace_resources(id) ON DELETE CASCADE;ForeignKeyWorkspaceAppAuditSessionsAgentIDForeignKeyConstraint = "workspace_app_audit_sessions_agent_id_fkey"// ALTER TABLE ONLY workspace_app_audit_sessions ADD CONSTRAINT workspace_app_audit_sessions_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceAppStatsAgentIDForeignKeyConstraint = "workspace_app_stats_agent_id_fkey"// ALTER TABLE ONLY workspace_app_stats ADD CONSTRAINT workspace_app_stats_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id);ForeignKeyWorkspaceAppStatsUserIDForeignKeyConstraint = "workspace_app_stats_user_id_fkey"// ALTER TABLE ONLY workspace_app_stats ADD CONSTRAINT workspace_app_stats_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);ForeignKeyWorkspaceAppStatsWorkspaceIDForeignKeyConstraint = "workspace_app_stats_workspace_id_fkey"// ALTER TABLE ONLY workspace_app_stats ADD CONSTRAINT workspace_app_stats_workspace_id_fkey FOREIGN KEY (workspace_id) REFERENCES workspaces(id);ForeignKeyWorkspaceAppStatusesAgentIDForeignKeyConstraint = "workspace_app_statuses_agent_id_fkey"// ALTER TABLE ONLY workspace_app_statuses ADD CONSTRAINT workspace_app_statuses_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id);ForeignKeyWorkspaceAppStatusesAppIDForeignKeyConstraint = "workspace_app_statuses_app_id_fkey"// ALTER TABLE ONLY workspace_app_statuses ADD CONSTRAINT workspace_app_statuses_app_id_fkey FOREIGN KEY (app_id) REFERENCES workspace_apps(id);ForeignKeyWorkspaceAppStatusesWorkspaceIDForeignKeyConstraint = "workspace_app_statuses_workspace_id_fkey"// ALTER TABLE ONLY workspace_app_statuses ADD CONSTRAINT workspace_app_statuses_workspace_id_fkey FOREIGN KEY (workspace_id) REFERENCES workspaces(id);ForeignKeyWorkspaceAppsAgentIDForeignKeyConstraint = "workspace_apps_agent_id_fkey"// ALTER TABLE ONLY workspace_apps ADD CONSTRAINT workspace_apps_agent_id_fkey FOREIGN KEY (agent_id) REFERENCES workspace_agents(id) ON DELETE CASCADE;ForeignKeyWorkspaceBuildParametersWorkspaceBuildIDForeignKeyConstraint = "workspace_build_parameters_workspace_build_id_fkey"// ALTER TABLE ONLY workspace_build_parameters ADD CONSTRAINT workspace_build_parameters_workspace_build_id_fkey FOREIGN KEY (workspace_build_id) REFERENCES workspace_builds(id) ON DELETE CASCADE;ForeignKeyWorkspaceBuildsJobIDForeignKeyConstraint = "workspace_builds_job_id_fkey"// ALTER TABLE ONLY workspace_builds ADD CONSTRAINT workspace_builds_job_id_fkey FOREIGN KEY (job_id) REFERENCES provisioner_jobs(id) ON DELETE CASCADE;ForeignKeyWorkspaceBuildsTemplateVersionIDForeignKeyConstraint = "workspace_builds_template_version_id_fkey"// ALTER TABLE ONLY workspace_builds ADD CONSTRAINT workspace_builds_template_version_id_fkey FOREIGN KEY (template_version_id) REFERENCES template_versions(id) ON DELETE CASCADE;ForeignKeyWorkspaceBuildsTemplateVersionPresetIDForeignKeyConstraint = "workspace_builds_template_version_preset_id_fkey"// ALTER TABLE ONLY workspace_builds ADD CONSTRAINT workspace_builds_template_version_preset_id_fkey FOREIGN KEY (template_version_preset_id) REFERENCES template_version_presets(id) ON DELETE SET NULL;ForeignKeyWorkspaceBuildsWorkspaceIDForeignKeyConstraint = "workspace_builds_workspace_id_fkey"// ALTER TABLE ONLY workspace_builds ADD CONSTRAINT workspace_builds_workspace_id_fkey FOREIGN KEY (workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE;ForeignKeyWorkspaceModulesJobIDForeignKeyConstraint = "workspace_modules_job_id_fkey"// ALTER TABLE ONLY workspace_modules ADD CONSTRAINT workspace_modules_job_id_fkey FOREIGN KEY (job_id) REFERENCES provisioner_jobs(id) ON DELETE CASCADE;ForeignKeyWorkspaceResourceMetadataWorkspaceResourceIDForeignKeyConstraint = "workspace_resource_metadata_workspace_resource_id_fkey"// ALTER TABLE ONLY workspace_resource_metadata ADD CONSTRAINT workspace_resource_metadata_workspace_resource_id_fkey FOREIGN KEY (workspace_resource_id) REFERENCES workspace_resources(id) ON DELETE CASCADE;ForeignKeyWorkspaceResourcesJobIDForeignKeyConstraint = "workspace_resources_job_id_fkey"// ALTER TABLE ONLY workspace_resources ADD CONSTRAINT workspace_resources_job_id_fkey FOREIGN KEY (job_id) REFERENCES provisioner_jobs(id) ON DELETE CASCADE;ForeignKeyWorkspacesOrganizationIDForeignKeyConstraint = "workspaces_organization_id_fkey"// ALTER TABLE ONLY workspaces ADD CONSTRAINT workspaces_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organizations(id) ON DELETE RESTRICT;ForeignKeyWorkspacesOwnerIDForeignKeyConstraint = "workspaces_owner_id_fkey"// ALTER TABLE ONLY workspaces ADD CONSTRAINT workspaces_owner_id_fkey FOREIGN KEY (owner_id) REFERENCES users(id) ON DELETE RESTRICT;ForeignKeyWorkspacesTemplateIDForeignKeyConstraint = "workspaces_template_id_fkey"// ALTER TABLE ONLY workspaces ADD CONSTRAINT workspaces_template_id_fkey FOREIGN KEY (template_id) REFERENCES templates(id) ON DELETE RESTRICT;)

ForeignKeyConstraint enums.

type GetAPIKeyByNameParams struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`TokenNamestring    `db:"token_name" json:"token_name"`}

type GetAPIKeysByUserIDParams struct {LoginTypeLoginType `db:"login_type" json:"login_type"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type GetAuditLogsOffsetParams struct {ResourceTypestring    `db:"resource_type" json:"resource_type"`ResourceIDuuid.UUID `db:"resource_id" json:"resource_id"`OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`ResourceTargetstring    `db:"resource_target" json:"resource_target"`Actionstring    `db:"action" json:"action"`UserIDuuid.UUID `db:"user_id" json:"user_id"`Usernamestring    `db:"username" json:"username"`Emailstring    `db:"email" json:"email"`DateFromtime.Time `db:"date_from" json:"date_from"`DateTotime.Time `db:"date_to" json:"date_to"`BuildReasonstring    `db:"build_reason" json:"build_reason"`RequestIDuuid.UUID `db:"request_id" json:"request_id"`OffsetOptint32     `db:"offset_opt" json:"offset_opt"`LimitOptint32     `db:"limit_opt" json:"limit_opt"`}

type GetAuditLogsOffsetRow struct {AuditLogAuditLog       `db:"audit_log" json:"audit_log"`UserUsernamesql.NullString `db:"user_username" json:"user_username"`UserNamesql.NullString `db:"user_name" json:"user_name"`UserEmailsql.NullString `db:"user_email" json:"user_email"`UserCreatedAtsql.NullTime   `db:"user_created_at" json:"user_created_at"`UserUpdatedAtsql.NullTime   `db:"user_updated_at" json:"user_updated_at"`UserLastSeenAtsql.NullTime   `db:"user_last_seen_at" json:"user_last_seen_at"`UserStatusNullUserStatus `db:"user_status" json:"user_status"`UserLoginTypeNullLoginType  `db:"user_login_type" json:"user_login_type"`UserRolespq.StringArray `db:"user_roles" json:"user_roles"`UserAvatarUrlsql.NullString `db:"user_avatar_url" json:"user_avatar_url"`UserDeletedsql.NullBool   `db:"user_deleted" json:"user_deleted"`UserQuietHoursSchedulesql.NullString `db:"user_quiet_hours_schedule" json:"user_quiet_hours_schedule"`OrganizationNamestring         `db:"organization_name" json:"organization_name"`OrganizationDisplayNamestring         `db:"organization_display_name" json:"organization_display_name"`OrganizationIconstring         `db:"organization_icon" json:"organization_icon"`Countint64          `db:"count" json:"count"`}

func (GetAuditLogsOffsetRow)RBACObject¶added inv2.14.0

func (wGetAuditLogsOffsetRow) RBACObject()rbac.Object

type GetAuthorizationUserRolesRow struct {IDuuid.UUID  `db:"id" json:"id"`Usernamestring     `db:"username" json:"username"`StatusUserStatus `db:"status" json:"status"`Emailstring     `db:"email" json:"email"`Roles    []string   `db:"roles" json:"roles"`Groups   []string   `db:"groups" json:"groups"`}

func (GetAuthorizationUserRolesRow)RoleNames¶added inv2.13.0

func (rGetAuthorizationUserRolesRow) RoleNames() ([]rbac.RoleIdentifier,error)

type GetCryptoKeyByFeatureAndSequenceParams struct {FeatureCryptoKeyFeature `db:"feature" json:"feature"`Sequenceint32            `db:"sequence" json:"sequence"`}

type GetDefaultProxyConfigRow struct {DisplayNamestring `db:"display_name" json:"display_name"`IconUrlstring `db:"icon_url" json:"icon_url"`}

type GetDeploymentDAUsRow struct {Datetime.Time `db:"date" json:"date"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type GetDeploymentWorkspaceAgentStatsRow struct {WorkspaceRxBytesint64   `db:"workspace_rx_bytes" json:"workspace_rx_bytes"`WorkspaceTxBytesint64   `db:"workspace_tx_bytes" json:"workspace_tx_bytes"`WorkspaceConnectionLatency50float64 `db:"workspace_connection_latency_50" json:"workspace_connection_latency_50"`WorkspaceConnectionLatency95float64 `db:"workspace_connection_latency_95" json:"workspace_connection_latency_95"`SessionCountVSCodeint64   `db:"session_count_vscode" json:"session_count_vscode"`SessionCountSSHint64   `db:"session_count_ssh" json:"session_count_ssh"`SessionCountJetBrainsint64   `db:"session_count_jetbrains" json:"session_count_jetbrains"`SessionCountReconnectingPTYint64   `db:"session_count_reconnecting_pty" json:"session_count_reconnecting_pty"`}

type GetDeploymentWorkspaceAgentUsageStatsRow struct {WorkspaceRxBytesint64   `db:"workspace_rx_bytes" json:"workspace_rx_bytes"`WorkspaceTxBytesint64   `db:"workspace_tx_bytes" json:"workspace_tx_bytes"`WorkspaceConnectionLatency50float64 `db:"workspace_connection_latency_50" json:"workspace_connection_latency_50"`WorkspaceConnectionLatency95float64 `db:"workspace_connection_latency_95" json:"workspace_connection_latency_95"`SessionCountVSCodeint64   `db:"session_count_vscode" json:"session_count_vscode"`SessionCountSSHint64   `db:"session_count_ssh" json:"session_count_ssh"`SessionCountJetBrainsint64   `db:"session_count_jetbrains" json:"session_count_jetbrains"`SessionCountReconnectingPTYint64   `db:"session_count_reconnecting_pty" json:"session_count_reconnecting_pty"`}

type GetDeploymentWorkspaceStatsRow struct {PendingWorkspacesint64 `db:"pending_workspaces" json:"pending_workspaces"`BuildingWorkspacesint64 `db:"building_workspaces" json:"building_workspaces"`RunningWorkspacesint64 `db:"running_workspaces" json:"running_workspaces"`FailedWorkspacesint64 `db:"failed_workspaces" json:"failed_workspaces"`StoppedWorkspacesint64 `db:"stopped_workspaces" json:"stopped_workspaces"`}

type GetEligibleProvisionerDaemonsByProvisionerJobIDsRow struct {JobIDuuid.UUID         `db:"job_id" json:"job_id"`ProvisionerDaemonProvisionerDaemon `db:"provisioner_daemon" json:"provisioner_daemon"`}

func (GetEligibleProvisionerDaemonsByProvisionerJobIDsRow)RBACObject¶added inv2.18.1

func (pGetEligibleProvisionerDaemonsByProvisionerJobIDsRow) RBACObject()rbac.Object

type GetExternalAuthLinkParams struct {ProviderIDstring    `db:"provider_id" json:"provider_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type GetFailedWorkspaceBuildsByTemplateIDParams struct {TemplateIDuuid.UUID `db:"template_id" json:"template_id"`Sincetime.Time `db:"since" json:"since"`}

type GetFailedWorkspaceBuildsByTemplateIDRow struct {TemplateVersionNamestring    `db:"template_version_name" json:"template_version_name"`WorkspaceOwnerUsernamestring    `db:"workspace_owner_username" json:"workspace_owner_username"`WorkspaceNamestring    `db:"workspace_name" json:"workspace_name"`WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`WorkspaceBuildNumberint32     `db:"workspace_build_number" json:"workspace_build_number"`}

type GetFileByHashAndCreatorParams struct {Hashstring    `db:"hash" json:"hash"`CreatedByuuid.UUID `db:"created_by" json:"created_by"`}

type GetFileTemplatesRow struct {FileIDuuid.UUID   `db:"file_id" json:"file_id"`FileCreatedByuuid.UUID   `db:"file_created_by" json:"file_created_by"`TemplateIDuuid.UUID   `db:"template_id" json:"template_id"`TemplateOrganizationIDuuid.UUID   `db:"template_organization_id" json:"template_organization_id"`TemplateCreatedByuuid.UUID   `db:"template_created_by" json:"template_created_by"`UserACLTemplateACL `db:"user_acl" json:"user_acl"`GroupACLTemplateACL `db:"group_acl" json:"group_acl"`}

func (GetFileTemplatesRow)RBACObject¶

func (tGetFileTemplatesRow) RBACObject()rbac.Object

type GetFilteredInboxNotificationsByUserIDParams struct {UserIDuuid.UUID                   `db:"user_id" json:"user_id"`Templates    []uuid.UUID                 `db:"templates" json:"templates"`Targets      []uuid.UUID                 `db:"targets" json:"targets"`ReadStatusInboxNotificationReadStatus `db:"read_status" json:"read_status"`CreatedAtOpttime.Time                   `db:"created_at_opt" json:"created_at_opt"`LimitOptint32                       `db:"limit_opt" json:"limit_opt"`}

type GetGroupByOrgAndNameParams struct {OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`Namestring    `db:"name" json:"name"`}

type GetGroupMembersByGroupIDParams struct {GroupIDuuid.UUID `db:"group_id" json:"group_id"`IncludeSystembool      `db:"include_system" json:"include_system"`}

type GetGroupMembersCountByGroupIDParams struct {GroupIDuuid.UUID `db:"group_id" json:"group_id"`IncludeSystembool      `db:"include_system" json:"include_system"`}

type GetGroupsParams struct {OrganizationIDuuid.UUID   `db:"organization_id" json:"organization_id"`HasMemberIDuuid.UUID   `db:"has_member_id" json:"has_member_id"`GroupNames     []string    `db:"group_names" json:"group_names"`GroupIds       []uuid.UUID `db:"group_ids" json:"group_ids"`}

type GetGroupsRow struct {GroupGroup  `db:"group" json:"group"`OrganizationNamestring `db:"organization_name" json:"organization_name"`OrganizationDisplayNamestring `db:"organization_display_name" json:"organization_display_name"`}

func (GetGroupsRow)RBACObject¶added inv2.15.0

func (gGetGroupsRow) RBACObject()rbac.Object

type GetInboxNotificationsByUserIDParams struct {UserIDuuid.UUID                   `db:"user_id" json:"user_id"`ReadStatusInboxNotificationReadStatus `db:"read_status" json:"read_status"`CreatedAtOpttime.Time                   `db:"created_at_opt" json:"created_at_opt"`LimitOptint32                       `db:"limit_opt" json:"limit_opt"`}

type GetNotificationMessagesByStatusParams struct {StatusNotificationMessageStatus `db:"status" json:"status"`Limitint32                     `db:"limit" json:"limit"`}

type GetOAuth2ProviderAppsByUserIDRow struct {TokenCountint64             `db:"token_count" json:"token_count"`OAuth2ProviderAppOAuth2ProviderApp `db:"oauth2_provider_app" json:"oauth2_provider_app"`}

func (GetOAuth2ProviderAppsByUserIDRow)RBACObject¶added inv2.9.0

func (aGetOAuth2ProviderAppsByUserIDRow) RBACObject()rbac.Object

type GetOrganizationByNameParams struct {Deletedbool   `db:"deleted" json:"deleted"`Namestring `db:"name" json:"name"`}

type GetOrganizationIDsByMemberIDsRow struct {UserIDuuid.UUID   `db:"user_id" json:"user_id"`OrganizationIDs []uuid.UUID `db:"organization_IDs" json:"organization_IDs"`}

func (GetOrganizationIDsByMemberIDsRow)RBACObject¶

func (mGetOrganizationIDsByMemberIDsRow) RBACObject()rbac.Object

type GetOrganizationResourceCountByIDRow struct {WorkspaceCountint64 `db:"workspace_count" json:"workspace_count"`GroupCountint64 `db:"group_count" json:"group_count"`TemplateCountint64 `db:"template_count" json:"template_count"`MemberCountint64 `db:"member_count" json:"member_count"`ProvisionerKeyCountint64 `db:"provisioner_key_count" json:"provisioner_key_count"`}

type GetOrganizationsByUserIDParams struct {UserIDuuid.UUID    `db:"user_id" json:"user_id"`Deletedsql.NullBool `db:"deleted" json:"deleted"`}

type GetOrganizationsParams struct {Deletedbool        `db:"deleted" json:"deleted"`IDs     []uuid.UUID `db:"ids" json:"ids"`Namestring      `db:"name" json:"name"`}

type GetPrebuildMetricsRow struct {TemplateNamestring `db:"template_name" json:"template_name"`PresetNamestring `db:"preset_name" json:"preset_name"`OrganizationNamestring `db:"organization_name" json:"organization_name"`CreatedCountint64  `db:"created_count" json:"created_count"`FailedCountint64  `db:"failed_count" json:"failed_count"`ClaimedCountint64  `db:"claimed_count" json:"claimed_count"`}

type GetPresetByIDRow struct {IDuuid.UUID      `db:"id" json:"id"`TemplateVersionIDuuid.UUID      `db:"template_version_id" json:"template_version_id"`Namestring         `db:"name" json:"name"`CreatedAttime.Time      `db:"created_at" json:"created_at"`DesiredInstancessql.NullInt32  `db:"desired_instances" json:"desired_instances"`InvalidateAfterSecssql.NullInt32  `db:"invalidate_after_secs" json:"invalidate_after_secs"`PrebuildStatusPrebuildStatus `db:"prebuild_status" json:"prebuild_status"`TemplateIDuuid.NullUUID  `db:"template_id" json:"template_id"`OrganizationIDuuid.UUID      `db:"organization_id" json:"organization_id"`}

type GetPresetsAtFailureLimitRow struct {TemplateVersionIDuuid.UUID `db:"template_version_id" json:"template_version_id"`PresetIDuuid.UUID `db:"preset_id" json:"preset_id"`}

type GetPresetsBackoffRow struct {TemplateVersionIDuuid.UUID `db:"template_version_id" json:"template_version_id"`PresetIDuuid.UUID `db:"preset_id" json:"preset_id"`NumFailedint32     `db:"num_failed" json:"num_failed"`LastBuildAttime.Time `db:"last_build_at" json:"last_build_at"`}

type GetPreviousTemplateVersionParams struct {OrganizationIDuuid.UUID     `db:"organization_id" json:"organization_id"`Namestring        `db:"name" json:"name"`TemplateIDuuid.NullUUID `db:"template_id" json:"template_id"`}

type GetProvisionerDaemonsByOrganizationParams struct {OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`WantTagsStringMap `db:"want_tags" json:"want_tags"`}

type GetProvisionerDaemonsWithStatusByOrganizationParams struct {StaleIntervalMSint64         `db:"stale_interval_ms" json:"stale_interval_ms"`OrganizationIDuuid.UUID     `db:"organization_id" json:"organization_id"`IDs             []uuid.UUID   `db:"ids" json:"ids"`TagsStringMap     `db:"tags" json:"tags"`Limitsql.NullInt32 `db:"limit" json:"limit"`}

type GetProvisionerDaemonsWithStatusByOrganizationRow struct {ProvisionerDaemonProvisionerDaemon        `db:"provisioner_daemon" json:"provisioner_daemon"`StatusProvisionerDaemonStatus  `db:"status" json:"status"`KeyNamestring                   `db:"key_name" json:"key_name"`CurrentJobIDuuid.NullUUID            `db:"current_job_id" json:"current_job_id"`CurrentJobStatusNullProvisionerJobStatus `db:"current_job_status" json:"current_job_status"`PreviousJobIDuuid.NullUUID            `db:"previous_job_id" json:"previous_job_id"`PreviousJobStatusNullProvisionerJobStatus `db:"previous_job_status" json:"previous_job_status"`CurrentJobTemplateNamestring                   `db:"current_job_template_name" json:"current_job_template_name"`CurrentJobTemplateDisplayNamestring                   `db:"current_job_template_display_name" json:"current_job_template_display_name"`CurrentJobTemplateIconstring                   `db:"current_job_template_icon" json:"current_job_template_icon"`PreviousJobTemplateNamestring                   `db:"previous_job_template_name" json:"previous_job_template_name"`PreviousJobTemplateDisplayNamestring                   `db:"previous_job_template_display_name" json:"previous_job_template_display_name"`PreviousJobTemplateIconstring                   `db:"previous_job_template_icon" json:"previous_job_template_icon"`}

func (GetProvisionerDaemonsWithStatusByOrganizationRow)RBACObject¶added inv2.19.0

func (pGetProvisionerDaemonsWithStatusByOrganizationRow) RBACObject()rbac.Object

type GetProvisionerJobsByIDsWithQueuePositionRow struct {IDuuid.UUID      `db:"id" json:"id"`CreatedAttime.Time      `db:"created_at" json:"created_at"`ProvisionerJobProvisionerJob `db:"provisioner_job" json:"provisioner_job"`QueuePositionint64          `db:"queue_position" json:"queue_position"`QueueSizeint64          `db:"queue_size" json:"queue_size"`}

type GetProvisionerJobsByOrganizationAndStatusWithQueuePositionAndProvisionerParams struct {OrganizationIDuuid.UUID              `db:"organization_id" json:"organization_id"`IDs            []uuid.UUID            `db:"ids" json:"ids"`Status         []ProvisionerJobStatus `db:"status" json:"status"`TagsStringMap              `db:"tags" json:"tags"`Limitsql.NullInt32          `db:"limit" json:"limit"`}

type GetProvisionerJobsByOrganizationAndStatusWithQueuePositionAndProvisionerRow struct {ProvisionerJobProvisionerJob `db:"provisioner_job" json:"provisioner_job"`QueuePositionint64          `db:"queue_position" json:"queue_position"`QueueSizeint64          `db:"queue_size" json:"queue_size"`AvailableWorkers    []uuid.UUID    `db:"available_workers" json:"available_workers"`TemplateVersionNamestring         `db:"template_version_name" json:"template_version_name"`TemplateIDuuid.NullUUID  `db:"template_id" json:"template_id"`TemplateNamestring         `db:"template_name" json:"template_name"`TemplateDisplayNamestring         `db:"template_display_name" json:"template_display_name"`TemplateIconstring         `db:"template_icon" json:"template_icon"`WorkspaceIDuuid.NullUUID  `db:"workspace_id" json:"workspace_id"`WorkspaceNamestring         `db:"workspace_name" json:"workspace_name"`WorkerNamestring         `db:"worker_name" json:"worker_name"`}

func (GetProvisionerJobsByOrganizationAndStatusWithQueuePositionAndProvisionerRow)RBACObject¶added inv2.19.0

func (rGetProvisionerJobsByOrganizationAndStatusWithQueuePositionAndProvisionerRow) RBACObject()rbac.Object

type GetProvisionerJobsToBeReapedParams struct {PendingSincetime.Time `db:"pending_since" json:"pending_since"`HungSincetime.Time `db:"hung_since" json:"hung_since"`MaxJobsint32     `db:"max_jobs" json:"max_jobs"`}

type GetProvisionerKeyByNameParams struct {OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`Namestring    `db:"name" json:"name"`}

type GetProvisionerLogsAfterIDParams struct {JobIDuuid.UUID `db:"job_id" json:"job_id"`CreatedAfterint64     `db:"created_after" json:"created_after"`}

type GetQuotaAllowanceForUserParams struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`}

type GetQuotaConsumedForUserParams struct {OwnerIDuuid.UUID `db:"owner_id" json:"owner_id"`OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`}

type GetRunningPrebuiltWorkspacesRow struct {IDuuid.UUID     `db:"id" json:"id"`Namestring        `db:"name" json:"name"`TemplateIDuuid.UUID     `db:"template_id" json:"template_id"`TemplateVersionIDuuid.UUID     `db:"template_version_id" json:"template_version_id"`CurrentPresetIDuuid.NullUUID `db:"current_preset_id" json:"current_preset_id"`Readybool          `db:"ready" json:"ready"`CreatedAttime.Time     `db:"created_at" json:"created_at"`}

type GetTailnetTunnelPeerBindingsRow struct {PeerIDuuid.UUID     `db:"peer_id" json:"peer_id"`CoordinatorIDuuid.UUID     `db:"coordinator_id" json:"coordinator_id"`UpdatedAttime.Time     `db:"updated_at" json:"updated_at"`Node          []byte        `db:"node" json:"node"`StatusTailnetStatus `db:"status" json:"status"`}

type GetTailnetTunnelPeerIDsRow struct {PeerIDuuid.UUID `db:"peer_id" json:"peer_id"`CoordinatorIDuuid.UUID `db:"coordinator_id" json:"coordinator_id"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`}

type GetTemplateAppInsightsByTemplateParams struct {StartTimetime.Time `db:"start_time" json:"start_time"`EndTimetime.Time `db:"end_time" json:"end_time"`}

type GetTemplateAppInsightsByTemplateRow struct {TemplateIDuuid.UUID `db:"template_id" json:"template_id"`SlugOrPortstring    `db:"slug_or_port" json:"slug_or_port"`DisplayNamestring    `db:"display_name" json:"display_name"`ActiveUsersint64     `db:"active_users" json:"active_users"`UsageSecondsint64     `db:"usage_seconds" json:"usage_seconds"`}

type GetTemplateAppInsightsParams struct {TemplateIDs []uuid.UUID `db:"template_ids" json:"template_ids"`StartTimetime.Time   `db:"start_time" json:"start_time"`EndTimetime.Time   `db:"end_time" json:"end_time"`}

type GetTemplateAppInsightsRow struct {TemplateIDs  []uuid.UUID `db:"template_ids" json:"template_ids"`ActiveUsersint64       `db:"active_users" json:"active_users"`Slugstring      `db:"slug" json:"slug"`DisplayNamestring      `db:"display_name" json:"display_name"`Iconstring      `db:"icon" json:"icon"`UsageSecondsint64       `db:"usage_seconds" json:"usage_seconds"`TimesUsedint64       `db:"times_used" json:"times_used"`}

type GetTemplateAverageBuildTimeParams struct {TemplateIDuuid.NullUUID `db:"template_id" json:"template_id"`StartTimesql.NullTime  `db:"start_time" json:"start_time"`}

type GetTemplateAverageBuildTimeRow struct {Start50float64 `db:"start_50" json:"start_50"`Stop50float64 `db:"stop_50" json:"stop_50"`Delete50float64 `db:"delete_50" json:"delete_50"`Start95float64 `db:"start_95" json:"start_95"`Stop95float64 `db:"stop_95" json:"stop_95"`Delete95float64 `db:"delete_95" json:"delete_95"`}

type GetTemplateByOrganizationAndNameParams struct {OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`Deletedbool      `db:"deleted" json:"deleted"`Namestring    `db:"name" json:"name"`}

type GetTemplateDAUsParams struct {TemplateIDuuid.UUID `db:"template_id" json:"template_id"`TzOffsetint32     `db:"tz_offset" json:"tz_offset"`}

type GetTemplateDAUsRow struct {Datetime.Time `db:"date" json:"date"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type GetTemplateInsightsByIntervalParams struct {TemplateIDs  []uuid.UUID `db:"template_ids" json:"template_ids"`IntervalDaysint32       `db:"interval_days" json:"interval_days"`EndTimetime.Time   `db:"end_time" json:"end_time"`StartTimetime.Time   `db:"start_time" json:"start_time"`}

type GetTemplateInsightsByIntervalRow struct {StartTimetime.Time   `db:"start_time" json:"start_time"`EndTimetime.Time   `db:"end_time" json:"end_time"`TemplateIDs []uuid.UUID `db:"template_ids" json:"template_ids"`ActiveUsersint64       `db:"active_users" json:"active_users"`}

type GetTemplateInsightsByTemplateParams struct {StartTimetime.Time `db:"start_time" json:"start_time"`EndTimetime.Time `db:"end_time" json:"end_time"`}

type GetTemplateInsightsByTemplateRow struct {TemplateIDuuid.UUID `db:"template_id" json:"template_id"`ActiveUsersint64     `db:"active_users" json:"active_users"`UsageVscodeSecondsint64     `db:"usage_vscode_seconds" json:"usage_vscode_seconds"`UsageJetbrainsSecondsint64     `db:"usage_jetbrains_seconds" json:"usage_jetbrains_seconds"`UsageReconnectingPtySecondsint64     `db:"usage_reconnecting_pty_seconds" json:"usage_reconnecting_pty_seconds"`UsageSshSecondsint64     `db:"usage_ssh_seconds" json:"usage_ssh_seconds"`}

type GetTemplateInsightsParams struct {StartTimetime.Time   `db:"start_time" json:"start_time"`EndTimetime.Time   `db:"end_time" json:"end_time"`TemplateIDs []uuid.UUID `db:"template_ids" json:"template_ids"`}

type GetTemplateInsightsRow struct {TemplateIDs                 []uuid.UUID `db:"template_ids" json:"template_ids"`SshTemplateIds              []uuid.UUID `db:"ssh_template_ids" json:"ssh_template_ids"`SftpTemplateIds             []uuid.UUID `db:"sftp_template_ids" json:"sftp_template_ids"`ReconnectingPtyTemplateIds  []uuid.UUID `db:"reconnecting_pty_template_ids" json:"reconnecting_pty_template_ids"`VscodeTemplateIds           []uuid.UUID `db:"vscode_template_ids" json:"vscode_template_ids"`JetbrainsTemplateIds        []uuid.UUID `db:"jetbrains_template_ids" json:"jetbrains_template_ids"`ActiveUsersint64       `db:"active_users" json:"active_users"`UsageTotalSecondsint64       `db:"usage_total_seconds" json:"usage_total_seconds"`UsageSshSecondsint64       `db:"usage_ssh_seconds" json:"usage_ssh_seconds"`UsageSftpSecondsint64       `db:"usage_sftp_seconds" json:"usage_sftp_seconds"`UsageReconnectingPtySecondsint64       `db:"usage_reconnecting_pty_seconds" json:"usage_reconnecting_pty_seconds"`UsageVscodeSecondsint64       `db:"usage_vscode_seconds" json:"usage_vscode_seconds"`UsageJetbrainsSecondsint64       `db:"usage_jetbrains_seconds" json:"usage_jetbrains_seconds"`}

type GetTemplateParameterInsightsParams struct {StartTimetime.Time   `db:"start_time" json:"start_time"`EndTimetime.Time   `db:"end_time" json:"end_time"`TemplateIDs []uuid.UUID `db:"template_ids" json:"template_ids"`}

type GetTemplateParameterInsightsRow struct {Numint64           `db:"num" json:"num"`TemplateIDs []uuid.UUID     `db:"template_ids" json:"template_ids"`Namestring          `db:"name" json:"name"`Typestring          `db:"type" json:"type"`DisplayNamestring          `db:"display_name" json:"display_name"`Descriptionstring          `db:"description" json:"description"`Optionsjson.RawMessage `db:"options" json:"options"`Valuestring          `db:"value" json:"value"`Countint64           `db:"count" json:"count"`}

type GetTemplatePresetsWithPrebuildsRow struct {TemplateIDuuid.UUID      `db:"template_id" json:"template_id"`TemplateNamestring         `db:"template_name" json:"template_name"`OrganizationIDuuid.UUID      `db:"organization_id" json:"organization_id"`OrganizationNamestring         `db:"organization_name" json:"organization_name"`TemplateVersionIDuuid.UUID      `db:"template_version_id" json:"template_version_id"`TemplateVersionNamestring         `db:"template_version_name" json:"template_version_name"`UsingActiveVersionbool           `db:"using_active_version" json:"using_active_version"`IDuuid.UUID      `db:"id" json:"id"`Namestring         `db:"name" json:"name"`DesiredInstancessql.NullInt32  `db:"desired_instances" json:"desired_instances"`Ttlsql.NullInt32  `db:"ttl" json:"ttl"`PrebuildStatusPrebuildStatus `db:"prebuild_status" json:"prebuild_status"`Deletedbool           `db:"deleted" json:"deleted"`Deprecatedbool           `db:"deprecated" json:"deprecated"`}

type GetTemplateUsageStatsParams struct {StartTimetime.Time   `db:"start_time" json:"start_time"`EndTimetime.Time   `db:"end_time" json:"end_time"`TemplateIDs []uuid.UUID `db:"template_ids" json:"template_ids"`}

type GetTemplateVersionByTemplateIDAndNameParams struct {TemplateIDuuid.NullUUID `db:"template_id" json:"template_id"`Namestring        `db:"name" json:"name"`}

type GetTemplateVersionsByTemplateIDParams struct {TemplateIDuuid.UUID    `db:"template_id" json:"template_id"`Archivedsql.NullBool `db:"archived" json:"archived"`AfterIDuuid.UUID    `db:"after_id" json:"after_id"`OffsetOptint32        `db:"offset_opt" json:"offset_opt"`LimitOptint32        `db:"limit_opt" json:"limit_opt"`}

type GetTemplatesWithFilterParams struct {Deletedbool         `db:"deleted" json:"deleted"`OrganizationIDuuid.UUID    `db:"organization_id" json:"organization_id"`ExactNamestring       `db:"exact_name" json:"exact_name"`FuzzyNamestring       `db:"fuzzy_name" json:"fuzzy_name"`IDs            []uuid.UUID  `db:"ids" json:"ids"`Deprecatedsql.NullBool `db:"deprecated" json:"deprecated"`}

type GetUserActivityInsightsParams struct {StartTimetime.Time   `db:"start_time" json:"start_time"`EndTimetime.Time   `db:"end_time" json:"end_time"`TemplateIDs []uuid.UUID `db:"template_ids" json:"template_ids"`}

type GetUserActivityInsightsRow struct {UserIDuuid.UUID   `db:"user_id" json:"user_id"`Usernamestring      `db:"username" json:"username"`AvatarURLstring      `db:"avatar_url" json:"avatar_url"`TemplateIDs  []uuid.UUID `db:"template_ids" json:"template_ids"`UsageSecondsint64       `db:"usage_seconds" json:"usage_seconds"`}

type GetUserByEmailOrUsernameParams struct {Usernamestring `db:"username" json:"username"`Emailstring `db:"email" json:"email"`}

type GetUserLatencyInsightsParams struct {StartTimetime.Time   `db:"start_time" json:"start_time"`EndTimetime.Time   `db:"end_time" json:"end_time"`TemplateIDs []uuid.UUID `db:"template_ids" json:"template_ids"`}

type GetUserLatencyInsightsRow struct {UserIDuuid.UUID   `db:"user_id" json:"user_id"`Usernamestring      `db:"username" json:"username"`AvatarURLstring      `db:"avatar_url" json:"avatar_url"`TemplateIDs                  []uuid.UUID `db:"template_ids" json:"template_ids"`WorkspaceConnectionLatency50float64     `db:"workspace_connection_latency_50" json:"workspace_connection_latency_50"`WorkspaceConnectionLatency95float64     `db:"workspace_connection_latency_95" json:"workspace_connection_latency_95"`}

type GetUserLinkByUserIDLoginTypeParams struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`LoginTypeLoginType `db:"login_type" json:"login_type"`}

type GetUserStatusCountsParams struct {StartTimetime.Time `db:"start_time" json:"start_time"`EndTimetime.Time `db:"end_time" json:"end_time"`Intervalint32     `db:"interval" json:"interval"`}

type GetUserStatusCountsRow struct {Datetime.Time  `db:"date" json:"date"`StatusUserStatus `db:"status" json:"status"`Countint64      `db:"count" json:"count"`}

type GetUserWorkspaceBuildParametersParams struct {OwnerIDuuid.UUID `db:"owner_id" json:"owner_id"`TemplateIDuuid.UUID `db:"template_id" json:"template_id"`}

type GetUserWorkspaceBuildParametersRow struct {Namestring `db:"name" json:"name"`Valuestring `db:"value" json:"value"`}

type GetUsersParams struct {AfterIDuuid.UUID    `db:"after_id" json:"after_id"`Searchstring       `db:"search" json:"search"`Status          []UserStatus `db:"status" json:"status"`RbacRole        []string     `db:"rbac_role" json:"rbac_role"`LastSeenBeforetime.Time    `db:"last_seen_before" json:"last_seen_before"`LastSeenAftertime.Time    `db:"last_seen_after" json:"last_seen_after"`CreatedBeforetime.Time    `db:"created_before" json:"created_before"`CreatedAftertime.Time    `db:"created_after" json:"created_after"`IncludeSystembool         `db:"include_system" json:"include_system"`GithubComUserIDint64        `db:"github_com_user_id" json:"github_com_user_id"`LoginType       []LoginType  `db:"login_type" json:"login_type"`OffsetOptint32        `db:"offset_opt" json:"offset_opt"`LimitOptint32        `db:"limit_opt" json:"limit_opt"`}

type GetUsersRow struct {IDuuid.UUID      `db:"id" json:"id"`Emailstring         `db:"email" json:"email"`Usernamestring         `db:"username" json:"username"`HashedPassword           []byte         `db:"hashed_password" json:"hashed_password"`CreatedAttime.Time      `db:"created_at" json:"created_at"`UpdatedAttime.Time      `db:"updated_at" json:"updated_at"`StatusUserStatus     `db:"status" json:"status"`RBACRolespq.StringArray `db:"rbac_roles" json:"rbac_roles"`LoginTypeLoginType      `db:"login_type" json:"login_type"`AvatarURLstring         `db:"avatar_url" json:"avatar_url"`Deletedbool           `db:"deleted" json:"deleted"`LastSeenAttime.Time      `db:"last_seen_at" json:"last_seen_at"`QuietHoursSchedulestring         `db:"quiet_hours_schedule" json:"quiet_hours_schedule"`Namestring         `db:"name" json:"name"`GithubComUserIDsql.NullInt64  `db:"github_com_user_id" json:"github_com_user_id"`HashedOneTimePasscode    []byte         `db:"hashed_one_time_passcode" json:"hashed_one_time_passcode"`OneTimePasscodeExpiresAtsql.NullTime   `db:"one_time_passcode_expires_at" json:"one_time_passcode_expires_at"`IsSystembool           `db:"is_system" json:"is_system"`Countint64          `db:"count" json:"count"`}

func (GetUsersRow)RBACObject¶

func (uGetUsersRow) RBACObject()rbac.Object

type GetWebpushVAPIDKeysRow struct {VapidPublicKeystring `db:"vapid_public_key" json:"vapid_public_key"`VapidPrivateKeystring `db:"vapid_private_key" json:"vapid_private_key"`}

type GetWorkspaceAgentAndLatestBuildByAuthTokenRow struct {WorkspaceTableWorkspaceTable `db:"workspace_table" json:"workspace_table"`WorkspaceAgentWorkspaceAgent `db:"workspace_agent" json:"workspace_agent"`WorkspaceBuildWorkspaceBuild `db:"workspace_build" json:"workspace_build"`}

type GetWorkspaceAgentLifecycleStateByIDRow struct {LifecycleStateWorkspaceAgentLifecycleState `db:"lifecycle_state" json:"lifecycle_state"`StartedAtsql.NullTime                 `db:"started_at" json:"started_at"`ReadyAtsql.NullTime                 `db:"ready_at" json:"ready_at"`}

type GetWorkspaceAgentLogsAfterParams struct {AgentIDuuid.UUID `db:"agent_id" json:"agent_id"`CreatedAfterint64     `db:"created_after" json:"created_after"`}

type GetWorkspaceAgentMetadataParams struct {WorkspaceAgentIDuuid.UUID `db:"workspace_agent_id" json:"workspace_agent_id"`Keys             []string  `db:"keys" json:"keys"`}

type GetWorkspaceAgentPortShareParams struct {WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`AgentNamestring    `db:"agent_name" json:"agent_name"`Portint32     `db:"port" json:"port"`}

type GetWorkspaceAgentScriptTimingsByBuildIDRow struct {ScriptIDuuid.UUID                        `db:"script_id" json:"script_id"`StartedAttime.Time                        `db:"started_at" json:"started_at"`EndedAttime.Time                        `db:"ended_at" json:"ended_at"`ExitCodeint32                            `db:"exit_code" json:"exit_code"`StageWorkspaceAgentScriptTimingStage  `db:"stage" json:"stage"`StatusWorkspaceAgentScriptTimingStatus `db:"status" json:"status"`DisplayNamestring                           `db:"display_name" json:"display_name"`WorkspaceAgentIDuuid.UUID                        `db:"workspace_agent_id" json:"workspace_agent_id"`WorkspaceAgentNamestring                           `db:"workspace_agent_name" json:"workspace_agent_name"`}

type GetWorkspaceAgentStatsAndLabelsRow struct {Usernamestring  `db:"username" json:"username"`AgentNamestring  `db:"agent_name" json:"agent_name"`WorkspaceNamestring  `db:"workspace_name" json:"workspace_name"`RxBytesint64   `db:"rx_bytes" json:"rx_bytes"`TxBytesint64   `db:"tx_bytes" json:"tx_bytes"`SessionCountVSCodeint64   `db:"session_count_vscode" json:"session_count_vscode"`SessionCountSSHint64   `db:"session_count_ssh" json:"session_count_ssh"`SessionCountJetBrainsint64   `db:"session_count_jetbrains" json:"session_count_jetbrains"`SessionCountReconnectingPTYint64   `db:"session_count_reconnecting_pty" json:"session_count_reconnecting_pty"`ConnectionCountint64   `db:"connection_count" json:"connection_count"`ConnectionMedianLatencyMSfloat64 `db:"connection_median_latency_ms" json:"connection_median_latency_ms"`}

type GetWorkspaceAgentStatsRow struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`AgentIDuuid.UUID `db:"agent_id" json:"agent_id"`WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`TemplateIDuuid.UUID `db:"template_id" json:"template_id"`AggregatedFromtime.Time `db:"aggregated_from" json:"aggregated_from"`WorkspaceRxBytesint64     `db:"workspace_rx_bytes" json:"workspace_rx_bytes"`WorkspaceTxBytesint64     `db:"workspace_tx_bytes" json:"workspace_tx_bytes"`WorkspaceConnectionLatency50float64   `db:"workspace_connection_latency_50" json:"workspace_connection_latency_50"`WorkspaceConnectionLatency95float64   `db:"workspace_connection_latency_95" json:"workspace_connection_latency_95"`AgentID_2uuid.UUID `db:"agent_id_2" json:"agent_id_2"`SessionCountVSCodeint64     `db:"session_count_vscode" json:"session_count_vscode"`SessionCountSSHint64     `db:"session_count_ssh" json:"session_count_ssh"`SessionCountJetBrainsint64     `db:"session_count_jetbrains" json:"session_count_jetbrains"`SessionCountReconnectingPTYint64     `db:"session_count_reconnecting_pty" json:"session_count_reconnecting_pty"`}

type GetWorkspaceAgentUsageStatsAndLabelsRow struct {Usernamestring  `db:"username" json:"username"`AgentNamestring  `db:"agent_name" json:"agent_name"`WorkspaceNamestring  `db:"workspace_name" json:"workspace_name"`RxBytesint64   `db:"rx_bytes" json:"rx_bytes"`TxBytesint64   `db:"tx_bytes" json:"tx_bytes"`SessionCountVSCodeint64   `db:"session_count_vscode" json:"session_count_vscode"`SessionCountSSHint64   `db:"session_count_ssh" json:"session_count_ssh"`SessionCountJetBrainsint64   `db:"session_count_jetbrains" json:"session_count_jetbrains"`SessionCountReconnectingPTYint64   `db:"session_count_reconnecting_pty" json:"session_count_reconnecting_pty"`ConnectionCountint64   `db:"connection_count" json:"connection_count"`ConnectionMedianLatencyMSfloat64 `db:"connection_median_latency_ms" json:"connection_median_latency_ms"`}

type GetWorkspaceAgentUsageStatsRow struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`AgentIDuuid.UUID `db:"agent_id" json:"agent_id"`WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`TemplateIDuuid.UUID `db:"template_id" json:"template_id"`AggregatedFromtime.Time `db:"aggregated_from" json:"aggregated_from"`WorkspaceRxBytesint64     `db:"workspace_rx_bytes" json:"workspace_rx_bytes"`WorkspaceTxBytesint64     `db:"workspace_tx_bytes" json:"workspace_tx_bytes"`WorkspaceConnectionLatency50float64   `db:"workspace_connection_latency_50" json:"workspace_connection_latency_50"`WorkspaceConnectionLatency95float64   `db:"workspace_connection_latency_95" json:"workspace_connection_latency_95"`AgentID_2uuid.UUID `db:"agent_id_2" json:"agent_id_2"`SessionCountVSCodeint64     `db:"session_count_vscode" json:"session_count_vscode"`SessionCountSSHint64     `db:"session_count_ssh" json:"session_count_ssh"`SessionCountJetBrainsint64     `db:"session_count_jetbrains" json:"session_count_jetbrains"`SessionCountReconnectingPTYint64     `db:"session_count_reconnecting_pty" json:"session_count_reconnecting_pty"`}

type GetWorkspaceAgentsByWorkspaceAndBuildNumberParams struct {WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`BuildNumberint32     `db:"build_number" json:"build_number"`}

type GetWorkspaceAppByAgentIDAndSlugParams struct {AgentIDuuid.UUID `db:"agent_id" json:"agent_id"`Slugstring    `db:"slug" json:"slug"`}

type GetWorkspaceBuildByWorkspaceIDAndBuildNumberParams struct {WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`BuildNumberint32     `db:"build_number" json:"build_number"`}

type GetWorkspaceBuildStatsByTemplatesRow struct {TemplateIDuuid.UUID `db:"template_id" json:"template_id"`TemplateNamestring    `db:"template_name" json:"template_name"`TemplateDisplayNamestring    `db:"template_display_name" json:"template_display_name"`TemplateOrganizationIDuuid.UUID `db:"template_organization_id" json:"template_organization_id"`TotalBuildsint64     `db:"total_builds" json:"total_builds"`FailedBuildsint64     `db:"failed_builds" json:"failed_builds"`}

type GetWorkspaceBuildsByWorkspaceIDParams struct {WorkspaceIDuuid.UUID `db:"workspace_id" json:"workspace_id"`Sincetime.Time `db:"since" json:"since"`AfterIDuuid.UUID `db:"after_id" json:"after_id"`OffsetOptint32     `db:"offset_opt" json:"offset_opt"`LimitOptint32     `db:"limit_opt" json:"limit_opt"`}

type GetWorkspaceByOwnerIDAndNameParams struct {OwnerIDuuid.UUID `db:"owner_id" json:"owner_id"`Deletedbool      `db:"deleted" json:"deleted"`Namestring    `db:"name" json:"name"`}

type GetWorkspaceProxyByHostnameParams struct {Hostnamestring `db:"hostname" json:"hostname"`AllowAccessUrlbool   `db:"allow_access_url" json:"allow_access_url"`AllowWildcardHostnamebool   `db:"allow_wildcard_hostname" json:"allow_wildcard_hostname"`}

type GetWorkspaceUniqueOwnerCountByTemplateIDsRow struct {TemplateIDuuid.UUID `db:"template_id" json:"template_id"`UniqueOwnersSumint64     `db:"unique_owners_sum" json:"unique_owners_sum"`}

type GetWorkspacesAndAgentsByOwnerIDRow struct {IDuuid.UUID            `db:"id" json:"id"`Namestring               `db:"name" json:"name"`JobStatusProvisionerJobStatus `db:"job_status" json:"job_status"`TransitionWorkspaceTransition  `db:"transition" json:"transition"`Agents     []AgentIDNamePair    `db:"agents" json:"agents"`}

type GetWorkspacesEligibleForTransitionRow struct {IDuuid.UUID `db:"id" json:"id"`Namestring    `db:"name" json:"name"`}

type GetWorkspacesParams struct {ParamNames                            []string     `db:"param_names" json:"param_names"`ParamValues                           []string     `db:"param_values" json:"param_values"`Deletedbool         `db:"deleted" json:"deleted"`Statusstring       `db:"status" json:"status"`OwnerIDuuid.UUID    `db:"owner_id" json:"owner_id"`OrganizationIDuuid.UUID    `db:"organization_id" json:"organization_id"`HasParam                              []string     `db:"has_param" json:"has_param"`OwnerUsernamestring       `db:"owner_username" json:"owner_username"`TemplateNamestring       `db:"template_name" json:"template_name"`TemplateIDs                           []uuid.UUID  `db:"template_ids" json:"template_ids"`WorkspaceIds                          []uuid.UUID  `db:"workspace_ids" json:"workspace_ids"`Namestring       `db:"name" json:"name"`HasAgentstring       `db:"has_agent" json:"has_agent"`AgentInactiveDisconnectTimeoutSecondsint64        `db:"agent_inactive_disconnect_timeout_seconds" json:"agent_inactive_disconnect_timeout_seconds"`Dormantbool         `db:"dormant" json:"dormant"`LastUsedBeforetime.Time    `db:"last_used_before" json:"last_used_before"`LastUsedAftertime.Time    `db:"last_used_after" json:"last_used_after"`UsingActivesql.NullBool `db:"using_active" json:"using_active"`RequesterIDuuid.UUID    `db:"requester_id" json:"requester_id"`Offsetint32        `db:"offset_" json:"offset_"`Limitint32        `db:"limit_" json:"limit_"`WithSummarybool         `db:"with_summary" json:"with_summary"`}

type GetWorkspacesRow struct {IDuuid.UUID            `db:"id" json:"id"`CreatedAttime.Time            `db:"created_at" json:"created_at"`UpdatedAttime.Time            `db:"updated_at" json:"updated_at"`OwnerIDuuid.UUID            `db:"owner_id" json:"owner_id"`OrganizationIDuuid.UUID            `db:"organization_id" json:"organization_id"`TemplateIDuuid.UUID            `db:"template_id" json:"template_id"`Deletedbool                 `db:"deleted" json:"deleted"`Namestring               `db:"name" json:"name"`AutostartSchedulesql.NullString       `db:"autostart_schedule" json:"autostart_schedule"`Ttlsql.NullInt64        `db:"ttl" json:"ttl"`LastUsedAttime.Time            `db:"last_used_at" json:"last_used_at"`DormantAtsql.NullTime         `db:"dormant_at" json:"dormant_at"`DeletingAtsql.NullTime         `db:"deleting_at" json:"deleting_at"`AutomaticUpdatesAutomaticUpdates     `db:"automatic_updates" json:"automatic_updates"`Favoritebool                 `db:"favorite" json:"favorite"`NextStartAtsql.NullTime         `db:"next_start_at" json:"next_start_at"`OwnerAvatarUrlstring               `db:"owner_avatar_url" json:"owner_avatar_url"`OwnerUsernamestring               `db:"owner_username" json:"owner_username"`OwnerNamestring               `db:"owner_name" json:"owner_name"`OrganizationNamestring               `db:"organization_name" json:"organization_name"`OrganizationDisplayNamestring               `db:"organization_display_name" json:"organization_display_name"`OrganizationIconstring               `db:"organization_icon" json:"organization_icon"`OrganizationDescriptionstring               `db:"organization_description" json:"organization_description"`TemplateNamestring               `db:"template_name" json:"template_name"`TemplateDisplayNamestring               `db:"template_display_name" json:"template_display_name"`TemplateIconstring               `db:"template_icon" json:"template_icon"`TemplateDescriptionstring               `db:"template_description" json:"template_description"`TemplateVersionIDuuid.UUID            `db:"template_version_id" json:"template_version_id"`TemplateVersionNamesql.NullString       `db:"template_version_name" json:"template_version_name"`LatestBuildCompletedAtsql.NullTime         `db:"latest_build_completed_at" json:"latest_build_completed_at"`LatestBuildCanceledAtsql.NullTime         `db:"latest_build_canceled_at" json:"latest_build_canceled_at"`LatestBuildErrorsql.NullString       `db:"latest_build_error" json:"latest_build_error"`LatestBuildTransitionWorkspaceTransition  `db:"latest_build_transition" json:"latest_build_transition"`LatestBuildStatusProvisionerJobStatus `db:"latest_build_status" json:"latest_build_status"`Countint64                `db:"count" json:"count"`}

type GitSSHKey struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`PrivateKeystring    `db:"private_key" json:"private_key"`PublicKeystring    `db:"public_key" json:"public_key"`}

func (GitSSHKey)RBACObject¶

func (uGitSSHKey) RBACObject()rbac.Object

type Group struct {IDuuid.UUID `db:"id" json:"id"`Namestring    `db:"name" json:"name"`OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`AvatarURLstring    `db:"avatar_url" json:"avatar_url"`QuotaAllowanceint32     `db:"quota_allowance" json:"quota_allowance"`// Display name is a custom, human-friendly group name that user can set. This is not required to be unique and can be the empty string.DisplayNamestring `db:"display_name" json:"display_name"`// Source indicates how the group was created. It can be created by a user manually, or through some system process like OIDC group sync.SourceGroupSource `db:"source" json:"source"`}

func (Group)Auditable¶

func (gGroup) Auditable(members []GroupMember)AuditableGroup

Auditable returns an object that can be used in audit logs.Covers both group and group member changes.

func (Group)IsEveryone¶

func (gGroup) IsEveryone()bool

func (Group)RBACObject¶

func (gGroup) RBACObject()rbac.Object

type GroupMember struct {UserIDuuid.UUID     `db:"user_id" json:"user_id"`UserEmailstring        `db:"user_email" json:"user_email"`UserUsernamestring        `db:"user_username" json:"user_username"`UserHashedPassword     []byte        `db:"user_hashed_password" json:"user_hashed_password"`UserCreatedAttime.Time     `db:"user_created_at" json:"user_created_at"`UserUpdatedAttime.Time     `db:"user_updated_at" json:"user_updated_at"`UserStatusUserStatus    `db:"user_status" json:"user_status"`UserRbacRoles          []string      `db:"user_rbac_roles" json:"user_rbac_roles"`UserLoginTypeLoginType     `db:"user_login_type" json:"user_login_type"`UserAvatarUrlstring        `db:"user_avatar_url" json:"user_avatar_url"`UserDeletedbool          `db:"user_deleted" json:"user_deleted"`UserLastSeenAttime.Time     `db:"user_last_seen_at" json:"user_last_seen_at"`UserQuietHoursSchedulestring        `db:"user_quiet_hours_schedule" json:"user_quiet_hours_schedule"`UserNamestring        `db:"user_name" json:"user_name"`UserGithubComUserIDsql.NullInt64 `db:"user_github_com_user_id" json:"user_github_com_user_id"`UserIsSystembool          `db:"user_is_system" json:"user_is_system"`OrganizationIDuuid.UUID     `db:"organization_id" json:"organization_id"`GroupNamestring        `db:"group_name" json:"group_name"`GroupIDuuid.UUID     `db:"group_id" json:"group_id"`}

func (GroupMember)RBACObject¶added inv2.15.0

func (gmGroupMember) RBACObject()rbac.Object

type GroupMemberTable struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`GroupIDuuid.UUID `db:"group_id" json:"group_id"`}

type GroupSourcestring

funcAllGroupSourceValues¶

func AllGroupSourceValues() []GroupSource

func (*GroupSource)Scan¶

func (e *GroupSource) Scan(src interface{})error

func (GroupSource)Valid¶

func (eGroupSource) Valid()bool

type HealthSettings struct {IDuuid.UUID `db:"id" json:"id"`DismissedHealthchecks []string  `db:"dismissed_healthchecks" json:"dismissed_healthchecks"`}

type InboxNotification struct {IDuuid.UUID       `db:"id" json:"id"`UserIDuuid.UUID       `db:"user_id" json:"user_id"`TemplateIDuuid.UUID       `db:"template_id" json:"template_id"`Targets    []uuid.UUID     `db:"targets" json:"targets"`Titlestring          `db:"title" json:"title"`Contentstring          `db:"content" json:"content"`Iconstring          `db:"icon" json:"icon"`Actionsjson.RawMessage `db:"actions" json:"actions"`ReadAtsql.NullTime    `db:"read_at" json:"read_at"`CreatedAttime.Time       `db:"created_at" json:"created_at"`}

func (InboxNotification)RBACObject¶added inv2.21.0

func (iInboxNotification) RBACObject()rbac.Object

type InboxNotificationReadStatusstring

funcAllInboxNotificationReadStatusValues¶added inv2.21.0

func AllInboxNotificationReadStatusValues() []InboxNotificationReadStatus

func (*InboxNotificationReadStatus)Scan¶added inv2.21.0

func (e *InboxNotificationReadStatus) Scan(src interface{})error

func (InboxNotificationReadStatus)Valid¶added inv2.21.0

func (eInboxNotificationReadStatus) Valid()bool

type InsertAPIKeyParams struct {IDstring      `db:"id" json:"id"`LifetimeSecondsint64       `db:"lifetime_seconds" json:"lifetime_seconds"`HashedSecret    []byte      `db:"hashed_secret" json:"hashed_secret"`IPAddresspqtype.Inet `db:"ip_address" json:"ip_address"`UserIDuuid.UUID   `db:"user_id" json:"user_id"`LastUsedtime.Time   `db:"last_used" json:"last_used"`ExpiresAttime.Time   `db:"expires_at" json:"expires_at"`CreatedAttime.Time   `db:"created_at" json:"created_at"`UpdatedAttime.Time   `db:"updated_at" json:"updated_at"`LoginTypeLoginType   `db:"login_type" json:"login_type"`ScopeAPIKeyScope `db:"scope" json:"scope"`TokenNamestring      `db:"token_name" json:"token_name"`}

type InsertAuditLogParams struct {IDuuid.UUID       `db:"id" json:"id"`Timetime.Time       `db:"time" json:"time"`UserIDuuid.UUID       `db:"user_id" json:"user_id"`OrganizationIDuuid.UUID       `db:"organization_id" json:"organization_id"`Ippqtype.Inet     `db:"ip" json:"ip"`UserAgentsql.NullString  `db:"user_agent" json:"user_agent"`ResourceTypeResourceType    `db:"resource_type" json:"resource_type"`ResourceIDuuid.UUID       `db:"resource_id" json:"resource_id"`ResourceTargetstring          `db:"resource_target" json:"resource_target"`ActionAuditAction     `db:"action" json:"action"`Diffjson.RawMessage `db:"diff" json:"diff"`StatusCodeint32           `db:"status_code" json:"status_code"`AdditionalFieldsjson.RawMessage `db:"additional_fields" json:"additional_fields"`RequestIDuuid.UUID       `db:"request_id" json:"request_id"`ResourceIconstring          `db:"resource_icon" json:"resource_icon"`}

type InsertChatMessagesParams struct {ChatIDuuid.UUID       `db:"chat_id" json:"chat_id"`CreatedAttime.Time       `db:"created_at" json:"created_at"`Modelstring          `db:"model" json:"model"`Providerstring          `db:"provider" json:"provider"`Contentjson.RawMessage `db:"content" json:"content"`}

type InsertChatParams struct {OwnerIDuuid.UUID `db:"owner_id" json:"owner_id"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`Titlestring    `db:"title" json:"title"`}

type InsertCryptoKeyParams struct {FeatureCryptoKeyFeature `db:"feature" json:"feature"`Sequenceint32            `db:"sequence" json:"sequence"`Secretsql.NullString   `db:"secret" json:"secret"`StartsAttime.Time        `db:"starts_at" json:"starts_at"`SecretKeyIDsql.NullString   `db:"secret_key_id" json:"secret_key_id"`}

type InsertCustomRoleParams struct {Namestring                `db:"name" json:"name"`DisplayNamestring                `db:"display_name" json:"display_name"`OrganizationIDuuid.NullUUID         `db:"organization_id" json:"organization_id"`SitePermissionsCustomRolePermissions `db:"site_permissions" json:"site_permissions"`OrgPermissionsCustomRolePermissions `db:"org_permissions" json:"org_permissions"`UserPermissionsCustomRolePermissions `db:"user_permissions" json:"user_permissions"`}

type InsertDBCryptKeyParams struct {Numberint32  `db:"number" json:"number"`ActiveKeyDigeststring `db:"active_key_digest" json:"active_key_digest"`Teststring `db:"test" json:"test"`}

type InsertExternalAuthLinkParams struct {ProviderIDstring                `db:"provider_id" json:"provider_id"`UserIDuuid.UUID             `db:"user_id" json:"user_id"`CreatedAttime.Time             `db:"created_at" json:"created_at"`UpdatedAttime.Time             `db:"updated_at" json:"updated_at"`OAuthAccessTokenstring                `db:"oauth_access_token" json:"oauth_access_token"`OAuthAccessTokenKeyIDsql.NullString        `db:"oauth_access_token_key_id" json:"oauth_access_token_key_id"`OAuthRefreshTokenstring                `db:"oauth_refresh_token" json:"oauth_refresh_token"`OAuthRefreshTokenKeyIDsql.NullString        `db:"oauth_refresh_token_key_id" json:"oauth_refresh_token_key_id"`OAuthExpirytime.Time             `db:"oauth_expiry" json:"oauth_expiry"`OAuthExtrapqtype.NullRawMessage `db:"oauth_extra" json:"oauth_extra"`}

type InsertFileParams struct {IDuuid.UUID `db:"id" json:"id"`Hashstring    `db:"hash" json:"hash"`CreatedAttime.Time `db:"created_at" json:"created_at"`CreatedByuuid.UUID `db:"created_by" json:"created_by"`Mimetypestring    `db:"mimetype" json:"mimetype"`Data      []byte    `db:"data" json:"data"`}

type InsertGitSSHKeyParams struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`PrivateKeystring    `db:"private_key" json:"private_key"`PublicKeystring    `db:"public_key" json:"public_key"`}

type InsertGroupMemberParams struct {UserIDuuid.UUID `db:"user_id" json:"user_id"`GroupIDuuid.UUID `db:"group_id" json:"group_id"`}

type InsertGroupParams struct {IDuuid.UUID `db:"id" json:"id"`Namestring    `db:"name" json:"name"`DisplayNamestring    `db:"display_name" json:"display_name"`OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`AvatarURLstring    `db:"avatar_url" json:"avatar_url"`QuotaAllowanceint32     `db:"quota_allowance" json:"quota_allowance"`}

type InsertInboxNotificationParams struct {IDuuid.UUID       `db:"id" json:"id"`UserIDuuid.UUID       `db:"user_id" json:"user_id"`TemplateIDuuid.UUID       `db:"template_id" json:"template_id"`Targets    []uuid.UUID     `db:"targets" json:"targets"`Titlestring          `db:"title" json:"title"`Contentstring          `db:"content" json:"content"`Iconstring          `db:"icon" json:"icon"`Actionsjson.RawMessage `db:"actions" json:"actions"`CreatedAttime.Time       `db:"created_at" json:"created_at"`}

type InsertLicenseParams struct {UploadedAttime.Time `db:"uploaded_at" json:"uploaded_at"`JWTstring    `db:"jwt" json:"jwt"`Exptime.Time `db:"exp" json:"exp"`UUIDuuid.UUID `db:"uuid" json:"uuid"`}

type InsertMemoryResourceMonitorParams struct {AgentIDuuid.UUID                  `db:"agent_id" json:"agent_id"`Enabledbool                       `db:"enabled" json:"enabled"`StateWorkspaceAgentMonitorState `db:"state" json:"state"`Thresholdint32                      `db:"threshold" json:"threshold"`CreatedAttime.Time                  `db:"created_at" json:"created_at"`UpdatedAttime.Time                  `db:"updated_at" json:"updated_at"`DebouncedUntiltime.Time                  `db:"debounced_until" json:"debounced_until"`}

type InsertMissingGroupsParams struct {OrganizationIDuuid.UUID   `db:"organization_id" json:"organization_id"`SourceGroupSource `db:"source" json:"source"`GroupNames     []string    `db:"group_names" json:"group_names"`}

type InsertOAuth2ProviderAppCodeParams struct {IDuuid.UUID `db:"id" json:"id"`CreatedAttime.Time `db:"created_at" json:"created_at"`ExpiresAttime.Time `db:"expires_at" json:"expires_at"`SecretPrefix []byte    `db:"secret_prefix" json:"secret_prefix"`HashedSecret []byte    `db:"hashed_secret" json:"hashed_secret"`AppIDuuid.UUID `db:"app_id" json:"app_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`}

type InsertOAuth2ProviderAppParams struct {IDuuid.UUID `db:"id" json:"id"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`Namestring    `db:"name" json:"name"`Iconstring    `db:"icon" json:"icon"`CallbackURLstring    `db:"callback_url" json:"callback_url"`}

type InsertOAuth2ProviderAppSecretParams struct {IDuuid.UUID `db:"id" json:"id"`CreatedAttime.Time `db:"created_at" json:"created_at"`SecretPrefix  []byte    `db:"secret_prefix" json:"secret_prefix"`HashedSecret  []byte    `db:"hashed_secret" json:"hashed_secret"`DisplaySecretstring    `db:"display_secret" json:"display_secret"`AppIDuuid.UUID `db:"app_id" json:"app_id"`}

type InsertOAuth2ProviderAppTokenParams struct {IDuuid.UUID `db:"id" json:"id"`CreatedAttime.Time `db:"created_at" json:"created_at"`ExpiresAttime.Time `db:"expires_at" json:"expires_at"`HashPrefix  []byte    `db:"hash_prefix" json:"hash_prefix"`RefreshHash []byte    `db:"refresh_hash" json:"refresh_hash"`AppSecretIDuuid.UUID `db:"app_secret_id" json:"app_secret_id"`APIKeyIDstring    `db:"api_key_id" json:"api_key_id"`}

type InsertOrganizationMemberParams struct {OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`UserIDuuid.UUID `db:"user_id" json:"user_id"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`Roles          []string  `db:"roles" json:"roles"`}

type InsertOrganizationParams struct {IDuuid.UUID `db:"id" json:"id"`Namestring    `db:"name" json:"name"`DisplayNamestring    `db:"display_name" json:"display_name"`Descriptionstring    `db:"description" json:"description"`Iconstring    `db:"icon" json:"icon"`CreatedAttime.Time `db:"created_at" json:"created_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`}

type InsertPresetParametersParams struct {TemplateVersionPresetIDuuid.UUID `db:"template_version_preset_id" json:"template_version_preset_id"`Names                   []string  `db:"names" json:"names"`Values                  []string  `db:"values" json:"values"`}

type InsertPresetParams struct {IDuuid.UUID     `db:"id" json:"id"`TemplateVersionIDuuid.UUID     `db:"template_version_id" json:"template_version_id"`Namestring        `db:"name" json:"name"`CreatedAttime.Time     `db:"created_at" json:"created_at"`DesiredInstancessql.NullInt32 `db:"desired_instances" json:"desired_instances"`InvalidateAfterSecssql.NullInt32 `db:"invalidate_after_secs" json:"invalidate_after_secs"`}

type InsertProvisionerJobLogsParams struct {JobIDuuid.UUID   `db:"job_id" json:"job_id"`CreatedAt []time.Time `db:"created_at" json:"created_at"`Source    []LogSource `db:"source" json:"source"`Level     []LogLevel  `db:"level" json:"level"`Stage     []string    `db:"stage" json:"stage"`Output    []string    `db:"output" json:"output"`}

type InsertProvisionerJobParams struct {IDuuid.UUID                `db:"id" json:"id"`CreatedAttime.Time                `db:"created_at" json:"created_at"`UpdatedAttime.Time                `db:"updated_at" json:"updated_at"`OrganizationIDuuid.UUID                `db:"organization_id" json:"organization_id"`InitiatorIDuuid.UUID                `db:"initiator_id" json:"initiator_id"`ProvisionerProvisionerType          `db:"provisioner" json:"provisioner"`StorageMethodProvisionerStorageMethod `db:"storage_method" json:"storage_method"`FileIDuuid.UUID                `db:"file_id" json:"file_id"`TypeProvisionerJobType       `db:"type" json:"type"`Inputjson.RawMessage          `db:"input" json:"input"`TagsStringMap                `db:"tags" json:"tags"`TraceMetadatapqtype.NullRawMessage    `db:"trace_metadata" json:"trace_metadata"`}

type InsertProvisionerJobTimingsParams struct {JobIDuuid.UUID                   `db:"job_id" json:"job_id"`StartedAt []time.Time                 `db:"started_at" json:"started_at"`EndedAt   []time.Time                 `db:"ended_at" json:"ended_at"`Stage     []ProvisionerJobTimingStage `db:"stage" json:"stage"`Source    []string                    `db:"source" json:"source"`Action    []string                    `db:"action" json:"action"`Resource  []string                    `db:"resource" json:"resource"`}

type InsertProvisionerKeyParams struct {IDuuid.UUID `db:"id" json:"id"`CreatedAttime.Time `db:"created_at" json:"created_at"`OrganizationIDuuid.UUID `db:"organization_id" json:"organization_id"`HashedSecret   []byte    `db:"hashed_secret" json:"hashed_secret"`TagsStringMap `db:"tags" json:"tags"`Namestring    `db:"name" json:"name"`}

type InsertReplicaParams struct {IDuuid.UUID `db:"id" json:"id"`CreatedAttime.Time `db:"created_at" json:"created_at"`StartedAttime.Time `db:"started_at" json:"started_at"`UpdatedAttime.Time `db:"updated_at" json:"updated_at"`Hostnamestring    `db:"hostname" json:"hostname"`RegionIDint32     `db:"region_id" json:"region_id"`RelayAddressstring    `db:"relay_address" json:"relay_address"`Versionstring    `db:"version" json:"version"`DatabaseLatencyint32     `db:"database_latency" json:"database_latency"`Primarybool      `db:"primary" json:"primary"`}

type InsertTelemetryItemIfNotExistsParams struct {Keystring `db:"key" json:"key"`Valuestring `db:"value" json:"value"`}

type InsertTemplateParams struct {IDuuid.UUID       `db:"id" json:"id"`CreatedAttime.Time       `db:"created_at" json:"created_at"`UpdatedAttime.Time       `db:"updated_at" json:"updated_at"`OrganizationIDuuid.UUID       `db:"organization_id" json:"organization_id"`Namestring          `db:"name" json:"name"`ProvisionerProvisionerType `db:"provisioner" json:"provisioner"`ActiveVersionIDuuid.UUID       `db:"active_version_id" json:"active_version_id"`Descriptionstring          `db:"description" json:"description"`CreatedByuuid.UUID       `db:"created_by" json:"created_by"`Iconstring          `db:"icon" json:"icon"`UserACLTemplateACL     `db:"user_acl" json:"user_acl"`GroupACLTemplateACL     `db:"group_acl" json:"group_acl"`DisplayNamestring          `db:"display_name" json:"display_name"`AllowUserCancelWorkspaceJobsbool            `db:"allow_user_cancel_workspace_jobs" json:"allow_user_cancel_workspace_jobs"`MaxPortSharingLevelAppSharingLevel `db:"max_port_sharing_level" json:"max_port_sharing_level"`}

type InsertTemplateVersionParameterParams struct {TemplateVersionIDuuid.UUID       `db:"template_version_id" json:"template_version_id"`Namestring          `db:"name" json:"name"`Descriptionstring          `db:"description" json:"description"`Typestring          `db:"type" json:"type"`Mutablebool            `db:"mutable" json:"mutable"`DefaultValuestring          `db:"default_value" json:"default_value"`Iconstring          `db:"icon" json:"icon"`Optionsjson.RawMessage `db:"options" json:"options"`ValidationRegexstring          `db:"validation_regex" json:"validation_regex"`ValidationMinsql.NullInt32   `db:"validation_min" json:"validation_min"`ValidationMaxsql.NullInt32   `db:"validation_max" json:"validation_max"`ValidationErrorstring          `db:"validation_error" json:"validation_error"`ValidationMonotonicstring          `db:"validation_monotonic" json:"validation_monotonic"`Requiredbool            `db:"required" json:"required"`DisplayNamestring          `db:"display_name" json:"display_name"`DisplayOrderint32           `db:"display_order" json:"display_order"`Ephemeralbool            `db:"ephemeral" json:"ephemeral"`}

type InsertTemplateVersionParams struct {IDuuid.UUID      `db:"id" json:"id"`TemplateIDuuid.NullUUID  `db:"template_id" json:"template_id"`OrganizationIDuuid.UUID      `db:"organization_id" json:"organization_id"`CreatedAttime.Time      `db:"created_at" json:"created_at"`UpdatedAttime.Time      `db:"updated_at" json:"updated_at"`Namestring         `db:"name" json:"name"`Messagestring         `db:"message" json:"message"`Readmestring         `db:"readme" json:"readme"`JobIDuuid.UUID      `db:"job_id" json:"job_id"`CreatedByuuid.UUID      `db:"created_by" json:"created_by"`SourceExampleIDsql.NullString `db:"source_example_id" json:"source_example_id"`}

type InsertTemplateVersionTerraformValuesByJobIDParams struct {JobIDuuid.UUID       `db:"job_id" json:"job_id"`CachedPlanjson.RawMessage `db:"cached_plan" json:"cached_plan"`CachedModuleFilesuuid.NullUUID   `db:"cached_module_files" json:"cached_module_files"`UpdatedAttime.Time       `db:"updated_at" json:"updated_at"`ProvisionerdVersionstring          `db:"provisionerd_version" json:"provisionerd_version"`}