{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
TODO_TASK
Col #
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key2
SUBJECT
VARCHAR2
50
Y
3
TYPE_OF_TODO_TASK
NUMBER
22
Y
4
ASSIGNED_TO_OPERATOR_ID
NUMBER
22
Y
5
CREATION_DATE
DATE
7
Y
6
SCHEDULED_END_TIME
DATE
7
Y
7
ACTUAL_END
DATE
7
Y
8
DESCRIPTION
VARCHAR2
1000
Y
9
TROUBLE_TICKET_ID
NUMBER
22
Y
10
USERS_ID
NUMBER
22
Y
11
RELATED_SERVICE_ID
NUMBER
22
Y
12
STATUS_ID
NUMBER
22
Y
13
REMINDER_TIME
NUMBER
22
Y
14
TIMESTAMP_ALERT
DATE
7
Y
15
REFERENCE_ID
NUMBER
22
Y
16
CREATOR_ID
NUMBER
22
Y
17
STATUS_CHANGED_BY_ID
NUMBER
22
Y
18
CLOSING_COMMENT
VARCHAR2
4000
Y
19
CONTACT_PHONE_NUMBER
VARCHAR2
20
Y
20
CATEGORY_ID
NUMBER
22
Y
21
CHANGED_BY_OPERATOR
NUMBER
22
Y
TODO_TASK_STEP_KEY
VARCHAR2
50
Added with 10.3.1 to track progress through the to-do task flow (see also TODO_TASK_CHANGES)