| Table Name: | NRW_RuleEventInfo |
| Table Number: | 5426 |
| Group: | Configuration |
| Description: | Information about a rule event |
| 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_GeneratedEvents | CHAR | text | ALLOW_NULL | String of 'pipe' delimited checksums for the event | ||||
| 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 | ||||
| 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 | ||||||||||
| nrw_ruleevnt2N_Attachments | MTO | N_Attachments | n_attach2NRW_RuleEventInfo | For a rule event info instance of an attachment the parent attachment | event_on | N_ItemTypeId | N_ItemId | |||
| nrw_ruleevnt2N_Competitors | MTO | N_Competitors | n_compet2NRW_RuleEventInfo | For a rule event info instance of a competitor the parent competitor | event_on | N_ItemTypeId | N_ItemId | |||
| nrw_ruleevnt2N_ItemTypesEx | MTO | N_ItemTypesEx | n_xitmtyp2NRW_RuleEventInfo | For a rule event info instance of an ExtItemInst the ExtItemInst | event_on | N_ItemTypeId | N_ItemId | |||
| nrw_ruleevnt2N_Option | MTO | N_Option | n_optn2NRW_RuleEventInfo | For a rule event info instance of an option the parent option | event_on | N_ItemTypeId | N_ItemId | |||
| nrw_ruleevnt2N_Packages | MTO | N_Packages | n_pkg2NRW_RuleEventInfo | For a rule event info instance of a package the parent package | event_on | N_ItemTypeId | N_ItemId | |||
| nrw_ruleevnt2N_Product | MTO | N_Product | n_prod2NRW_RuleEventInfo | For a rule event info instance of a product the parent product | event_on | N_ItemTypeId | N_ItemId | |||
| nrw_ruleevnt2N_Templates | MTO | N_Templates | n_templ2NRW_RuleEventInfo | For a rule event info instance of a template the parent template | event_on | N_ItemTypeId | N_ItemId | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5426 | N_ItemId:N_ItemTypeId | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5426 | N_ItemId, N_ItemTypeId | nonclustered, unique located on PRIMARY |
| itid | N_ItemTypeId, N_ItemId | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| NRW_RuleEventInfo | |||