This table holds reasons for creating to-do
items.
Column Descriptions:
| Name | Type | Description |
| TKLRREASON_ID | INTEGER NOT NULL | Generated unique key. |
| STORE_ID | INTEGER NOT NULL | The Store in which the tickler reason is defined.
Stores may establish their own tickler reasons. |
| SYSTEMDEFINED | SMALLINT NOT NULL DEFAULT 0 | Indicates if this tickler reason is used by
system defined tickler:
- 0 = No.
- 1 = Yes, this tickler reason is used by system defined
tickler.
|
| CODE | CHAR (30) NOT NULL | Code, consistent across stores, for reasons used
for creating ticklers. |
| TICKLEFREQUENCY | INTEGER NOT NULL DEFAULT 0 | How soon after an action is taken should ticklers
of this reason reappear in the tickler queue. Measured in
minutes |
| MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if this tickler reason has been marked
for deletion:
- 0 = No.
- 1 = Yes, this tickler reason has been marked for deletion.
|
| FIELD1 | VARCHAR (254) | Customizable |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| ASSIGNTOROLE | INTEGER | Role to assign tickler to. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | TKLRREASON_ID | Primary Key |
| I0000935 | CODE+STORE_ID | Unique Index |
| I0000943 | STORE_ID | Non-Unique Index |
| I0000955 | ASSIGNTOROLE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1209 | STORE_ID | STORE | STORE_ID | Cascade |
| F_1218 | ASSIGNTOROLE | ROLE | ROLE_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1199 | TKLRREASON_ID | TICKLER | TKLRREASON_ID | Cascade |
| F_1208 | TKLRREASON_ID | TKLRRSNDSC | TKLRREASON_ID | Cascade |