Versions Compared

Old Version 3

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

Saved on

compared with

New Version 4

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

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
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

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

ID

NUMBER

22

N

 Primary key
2

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

  
Column
width33%

...