Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{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
width33%

TODO_TASK_CHANGES

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key2

TODO_TASK_ID

NUMBER

22

N

  3

CHANGE_DATE

DATE

7

Y

  
4

NEW_SUBJECT

VARCHAR2

50

Y

  5

NEW_TYPE_OF_TODO_TASK

NUMBER

22

Y

  6

NEW_ASSIGNED_TO_OPERATOR_ID

NUMBER

22

Y

  
7

NEW_CREATION_DATE

DATE

7

Y

  
8

NEW_SCHEDULED_END_TIME

DATE

7

Y

  
9

NEW_ACTUAL_END

DATE

7

Y

  
10

NEW_DESCRIPTION

VARCHAR2

1000

Y

  
11

NEW_TROUBLE_TICKET_ID

NUMBER

22

Y

  12

NEW_USERS_ID

NUMBER

22

Y

  13

NEW_RELATED_SERVICE_ID

NUMBER

22

Y

  
14

NEW_STATUS_ID

NUMBER

22

Y

  15

NEW_REMINDER_TIME

NUMBER

22

Y

  
16

NEW_TIMESTAMP_ALERT

DATE

7

Y

  
17

NEW_REFERENCE_ID

NUMBER

22

Y

  
18

NEW_CREATOR_ID

NUMBER

22

Y

  
19

NEW_STATUS_CHANGED_BY_ID

NUMBER

22

Y

  
20

NEW_CLOSING_COMMENT

VARCHAR2

4000

Y

  21

NEW_CONTACT_PHONE_NUMBER

VARCHAR2

20

Y

  22

NEW_CHANGED_BY_OPERATOR

NUMBER

22

Y

  
23

NEW_CATOGERY_ID

NUMBER

22

Y

  24

OLD_SUBJECT

VARCHAR2

50

Y

  25

OLD_TYPE_OF_TODO_TASK

NUMBER

22

Y

  
26

OLD_ASSIGNED_TO_OPERATOR_ID

NUMBER

22

Y

  
27

OLD_CREATION_DATE

DATE

7

Y

  
28

OLD_SCHEDULED_END_TIME

DATE

7

Y

  
29

OLD_ACTUAL_END

DATE

7

Y

  
30

OLD_DESCRIPTION

VARCHAR2

1000

Y

  31

OLD_TROUBLE_TICKET_ID

NUMBER

22

Y

  32

OLD_USERS_ID

NUMBER

22

Y

  
33

OLD_RELATED_SERVICE_ID

NUMBER

22

Y

  34

OLD_STATUS_ID

NUMBER

22

Y

  
35

OLD_REMINDER_TIME

NUMBER

22

Y

  
36

OLD_TIMESTAMP_ALERT

DATE

7

Y

  
37

OLD_REFERENCE_ID

NUMBER

22

Y

  
38

OLD_CREATOR_ID

NUMBER

22

Y

  
39

OLD_STATUS_CHANGED_BY_ID

NUMBER

22

Y

  40

OLD_CLOSING_COMMENT

VARCHAR2

4000

Y

  
41

OLD_CONTACT_PHONE_NUMBER

VARCHAR2

20

Y

  
42

OLD_CHANGED_BY_OPERATOR

NUMBER

22

Y

  43

OLD_CATOGERY_ID

NUMBER

22

Y

 Misspelled CATOGERY, should be CATEGORY
NEW_TODO_TASK_STEP_KEYVARCHAR250  Added with 10.3.1 to track to-do task progress through to-do task flow (see TODO_TASK).
NEW_RELATED_OBJECT_TYPEVARCHAR220  Same as above
NEW_RELATED_OBJECT_IDNUMBER   Same as above
OLD_TODO_TASK_STEP_KEYVARCHAR250  Same as above
OLD_RELATED_OBJECT_TYPEVARCHAR220  Same as above
OLD_RELATED_OBJECT_IDNUMBER   Same as above
Column
width33%