This table holds reasons for creating to-do items.
Column Description(s):
Column Name | Column 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 |
Reserved for IBM internal use. |
ASSIGNTOROLE |
INTEGER |
Role to assign tickler to. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000935 |
CODE+STORE_ID |
Unique Index |
SQL050212031322370 |
TKLRREASON_ID |
Primary Key |
I0000943 |
STORE_ID |
Non-Unique Index |
I0000955 |
ASSIGNTOROLE |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1218 |
ASSIGNTOROLE |
ROLE |
ROLE_ID |
Cascade |
F_1209 |
STORE_ID |
STORE |
STORE_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1199 |
TKLRREASON_ID |
TICKLER |
TKLRREASON_ID |
Cascade |
F_1208 |
TKLRREASON_ID |
TKLRRSNDSC |
TKLRREASON_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.