Versions Compared

Old Version 2

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version 3

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

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 key
2

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
Column
width33%

...