/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */ ====== sprockit.Resource ====== ~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ] Each row in this table represents a //resource// used or produced by a Sprockit-managed [[sprockit.Process|process]]. Resources can be //inputs// to or //outputs// of a process, as indicated by the [IsInput] field. **Example** A process reads data from a staging table and two dimension tables, then uses that data to produces a fact table. The staging and dimension tables are the process's //inputs//, while the fact table is its //output//. A process can have any number of input or output resources, but an object can be an output resource of no more than **one** process. Approaches to resource configuration are described in [[..:Configuring processes]]. /* 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 ^ |PK |__**ResourceId**__ |INT |Unique identifier for the resource. |IDENTITY | |[[sprockit.Process|FK1]] |**ProcessId** |INT |Identifies the process which which this resource is associated. | | | |**IsInput** |BIT |Indicates whether the resource is an input to or an output of the process indicated by [ProcessId]. |''1'' if the resource is an input to the process; ''0'' if the resource is an output of the process. | | |**DbName** |NVARCHAR(128) |The name of the database in which the resource object is found. | | | |**SchemaName** |NVARCHAR(128) |The name of the database schema in which the resource object is found. | | | |**ResourceName** |NVARCHAR(128) |The schema-scoped name of the resource object. | | | |IndexRebuildMode |TINYINT |Required index maintenance behaviour specific to this resource (overrides Sprockit's ''[[sprockit.Property#DefaultIndexRebuildMode|DefaultIndexRebuildMode]]'' property). |Affects output resources only (values specified for input resources have no effect). This field is optional -- a value is only required if you wish to override the configured default behaviour. | | |IndexRebuild Fragmentation Threshold |TINYINT |The minimum level of fragmentation that will trigger index maintenance, specific to this resource (overrides Sprockit's ''[[sprockit.Property#DefaultIndexRebuildFragmentationThreshold|DefaultIndexRebuild FragmentationThreshold]]'' property). |Affects output resources only (values specified for input resources have no effect). This field is optional -- a value is only required if you wish to override the configured default behaviour. | /* 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.5: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) ^ |FK1 |ProcessId |[[sprockit.Process]] |ProcessId | ==== References to this table from others ==== ^Relationship ^Attributes \\ (in referencing table) ^Referenced attributes \\ (in this table) ^ |[[sprockit.IndexMaintenanceTask]].RL2 |ResourceId |ResourceId | |[[sprockit.uvw_Resource]].RL1 |ResourceId |ResourceId | /* 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 */