/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.uvw_Resource ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]

This view augments information available in [[sprockit.Resource]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|[[sprockit.Resource|RL1]]  |**ResourceId**  |INT  |  |From [[sprockit.Resource]]  |
|  |**ProcessId**  |INT  |  |From [[sprockit.Resource]]  |
|  |**FqProcessName**  |NVARCHAR(392)  |The fully-qualified (three-part) name of the process indicated by [ProcessId].  |From [[sprockit.uvw_Process]]  |
|  |**IsInput**  |BIT  |  |From [[sprockit.Resource]]  |
|  |**DbName**  |NVARCHAR(128)  |  |From [[sprockit.Resource]]  |
|  |**SchemaName**  |NVARCHAR(128)  |  |From [[sprockit.Resource]]  |
|  |**ResourceName**  |NVARCHAR(128)  |  |From [[sprockit.Resource]]  |
|  |**FqResourceName**  |NVARCHAR(392)  |The fully-qualified (three-part) name of the resource.  |Combines [DbName], [SchemaName], [ResourceName]  |
|  |ResourceType  |VARCHAR(2)  |The object type of this resource.  |Object type values are as defined for ''sys.objects.[type]''.  |
|  |ObjectId  |INT  |The database-scoped object ID of this resource object.  |If applicable  |
|  |IsStoredQuery  |BIT  |Indicates whether the resource (in fact any object of this [ResourceType]) is a stored query.  |A stored query is a view or a user-defined function.  |
|  |IndexRebuildMode  |TINYINT  |From [[sprockit.Resource]] where specified, otherwise as indicated by Sprockit's ''[[sprockit.Property#DefaultIndexRebuildMode|DefaultIndexRebuildMode]]'' property.  |Present only in records with [IsInput] = 0 and [ResourceType] = 'U' or 'V'  |
|  |IndexRebuild Fragmentation Threshold  |TINYINT  |From [[sprockit.Resource]] where specified, otherwise as indicated by Sprockit's ''[[sprockit.Property#DefaultIndexRebuildFragmentationThreshold|DefaultIndexRebuild FragmentationThreshold]]'' property.  |Present only in records with [IsInput] = 0 and [ResourceType] = 'U' or 'V'  |
|  |**ResourceUid**  |INT  |Unique identifier for a resource object  |[Resource**Id**] identifies an object as an input or output of a specific process (indicated by [ProcessId]). [Resource**Uid**] uniquely identifies the underlying object; each occurrence in the view of a given combination of [DbName], [SchemaName] and [ResourceName] has a different [ResourceId] value but the same value of [ResourceUid].  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.4:Sprockit tables:Sprockit tables|Click here to view the data model diagram.]]
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|RL1  |ResourceId  |[[sprockit.Resource]]  |ResourceId  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|(None).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */