TKLRREASON

This table holds reasons for creating to-do items.

Column Descriptions:

NameTypeDescription
TKLRREASON_IDINTEGER NOT NULLGenerated unique key.
STORE_IDINTEGER NOT NULLThe Store in which the tickler reason is defined. Stores may establish their own tickler reasons.
SYSTEMDEFINEDSMALLINT NOT NULL DEFAULT 0Indicates if this tickler reason is used by system defined tickler:
  • 0 = No.
  • 1 = Yes, this tickler reason is used by system defined tickler.
CODECHAR (30) NOT NULLCode, consistent across stores, for reasons used for creating ticklers.
TICKLEFREQUENCYINTEGER NOT NULL DEFAULT 0How soon after an action is taken should ticklers of this reason reappear in the tickler queue. Measured in minutes
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this tickler reason has been marked for deletion:
  • 0 = No.
  • 1 = Yes, this tickler reason has been marked for deletion.
FIELD1VARCHAR (254)Customizable
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
ASSIGNTOROLEINTEGERRole to assign tickler to.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TKLRREASON_IDPrimary Key
I0000935CODE+STORE_IDUnique Index
I0000943STORE_IDNon-Unique Index
I0000955ASSIGNTOROLENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1209STORE_IDSTORESTORE_IDCascade
F_1218ASSIGNTOROLEROLEROLE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1199TKLRREASON_IDTICKLERTKLRREASON_IDCascade
F_1208TKLRREASON_IDTKLRRSNDSCTKLRREASON_IDCascade