Versions Compared

Old Version 1

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard

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%

PROVISIONING_ORDER

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

ID

NUMBER

22

N

 Primary key
2

CODE

VARCHAR2

128

Y

  
3

SERVICE_ID

NUMBER

22

Y

  
4

INSTALLATION_ID

NUMBER

22

Y

  
5

PROVISIONING_TASK_ID

NUMBER

22

Y

  
6

PROVISIONING_ERROR_ID

NUMBER

22

Y

  
7

CANCEL_PROVISIONING_ORDER_ID

NUMBER

22

Y

  
8

DEPEND_PROVISIONING_ORDER_ID

NUMBER

22

Y

  
9

WORKFLOW_ID

NUMBER

22

Y

  
10

STATUS_ID

NUMBER

22

Y

  
11

CREATE_DATE

DATE

7

Y

  
12

ORDER_REFERENCE

VARCHAR2

128

Y

  
13

EXTERNAL_ORDER_REFERENCE

VARCHAR2

128

Y

  
14

EXTERNAL_ORDER_STATUS

VARCHAR2

128

Y

  
15

START_DATE

DATE

7

Y

  
16

END_DATE

DATE

7

Y

  
17

START_DATE_OLD

DATE

7

Y

  
18

END_DATE_OLD

DATE

7

Y

  
19

ERROR_CODE

VARCHAR2

48

Y

  
20

RECEIPT_MAIL_DATE

DATE

7

Y

  
21

CONFIRM_MAIL_DATE

DATE

7

Y

  
22

COMPLETE_MAIL_DATE

DATE

7

Y

  
23

ERROR_MAIL_DATE

DATE

7

Y

  
24

REQUEST_DATE

DATE

7

Y

  
25

CONFIRMED_REQUEST_DATE

DATE

7

Y

  
26

SENT_DATE

DATE

7

Y

  
27

COMPLETE_DATE

DATE

7

Y

  
28

CHECK_DATE

DATE

7

Y

  
29

COMMENTS

VARCHAR2

4000

Y

  
30

TRIES

NUMBER

22

Y

  
31

MANUAL_HANDLED

NUMBER

22

Y

  
32

INSTALLATION_REFERENCE

VARCHAR2

128

Y

  
33

CONFIRM_DATE

DATE

7

Y

  
Column
width33%

...