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%

Image Modified

A_NUMBER

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

ID

NUMBER

22

N

 'Primary' key2

STATUS

NUMBER

22

Y

 

Status of the number, 0-active, 1-in use, 2-reserved, 3-rest period, 4-barred, 5-exported, 100-reserved for anumber sequence

3

ASSIGNED_TO_SERVICE_ID

NUMBER

22

Y

 

Service to which the number belongs

4

CREATE_DATE

DATE

7

Y

 Date of creating number
5

RESERV_TO_DATE

DATE

7

Y

 Date to which to reserve number
6

A_NUMBER

VARCHAR2

100

Y

 Mobile number7

COMMENTS

VARCHAR2

1000

Y

 

Add. comments

8

GROUP_ID

NUMBER

22

Y

 

References ANUMBER_GROUP-table

9

USERCLIENT

VARCHAR2

100

Y

 ?
10

OPERATOR_ID

NUMBER

22

Y

 

Network operator creating the number

11

RS_EXCHANGE_ID

NUMBER

22

Y

 ?12

BRAND_ID

NUMBER

22

Y

 

References BRAND-table

Column
width33%

Contains all MSISDNs

...