| Table Name: | N_Attachments |
| Table Number: | 5403 |
| Group: | Configuration |
| Description: | Holds references to documents or other files that are to be associated with products, options, packages, competitors, and templates in ClearConfigurator |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| N_Description | CHAR | varchar | 80 | ALLOW_NULL | Description of the attachment | |||
| N_EffectiveDate | CLK_TIME | datetime | ALLOW_NULL | First date on which the attachment should be used | ||||
| N_ExpirationDate | CLK_TIME | datetime | ALLOW_NULL | Last date on which the attachment should be used | ||||
| N_ItemId | LONG | int | DIRECT, ALLOW_NULL | Reference to an item defined in another table and cross-referenced with the item type. It indicates the item to which the attachment belongs | ||||
| N_ItemTypeId | LONG | int | DIRECT, ALLOW_NULL | Item type from N_ItemType table. It is used in conjunction with the N_ItemId field to identify to the item to which the attachment belongs | ||||
| N_Keywords | CHAR | varchar | 255 | ALLOW_NULL | Reserved; future | |||
| N_LocalPath | CHAR | varchar | 255 | ALLOW_NULL | Path to the attachment on the local machine if applicable | |||
| N_ModificationDate | CLK_TIME | datetime | ALLOW_NULL | Last date and time at which the attachment was modified | ||||
| N_RemoteDataSourceId | LONG | int | DIRECT, ALLOW_NULL | Reserved; future | ||||
| N_RemotePath | CHAR | varchar | 255 | ALLOW_NULL | Path to the attachment on remote machine if applicable | |||
| objid | LONG | int | 3 | DIRECT | Internal record number |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| n_attach2N_Functions | OTM | N_Functions | n_functn2N_Attachments | Functions for the attachment | function_for | N_ItemTypeId | N_ItemId | |||
| n_attach2N_Properties | OTM | N_Properties | n_propts2N_Attachments | Properties for the attachment | extension_of | N_ItemTypeId | N_ItemId | |||
| n_attach2NRW_RuleEventInfo | OTM | NRW_RuleEventInfo | nrw_ruleevnt2N_Attachments | Rule event information for the attachment | event_on | N_ItemTypeId | N_ItemId | |||
| n_attach2NRW_RuleInstances | OTM | NRW_RuleInstances | nrw_ruleinst2N_Attachments | Rule instance information for the attachment | ruleinst_for | N_ItemTypeId | N_ItemId | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5403 | N_ItemId:N_ItemTypeId:N_Description | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5403 | N_ItemId, N_ItemTypeId, N_Description | nonclustered, unique located on PRIMARY |
| itid | N_ItemTypeId, N_ItemId | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| rdsid | N_RemoteDataSourceId | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|
| N_Attachments | |||