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%

RECHARGE_TICKET

Col #

Column NameData Type Not Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key2

BILLING_GROUP_ID

NUMBER

22

Y

 Reference to BILLING_GROUP
3

TICKET_VALUE

VARCHAR2

50

Y

  4

DATE_CREATED

DATE

7

Y

  5

RECHARGE_AMOUNT

NUMBER

22

Y

  6

NEXT_RECHARGE_DATE

DATE

7

Y

  
7

DAY_OF_MONTH

NUMBER

22

Y

  8

RECHARGE_TO_AMOUNT

NUMBER

22

Y

  9

RECHARGE_LIMIT

NUMBER

22

Y

  10

CODE

VARCHAR2

50

Y

  11

LAST_RECHARGE_DATE

DATE

7

Y

  12

LAST_CHANGED_DATE

DATE

7

Y

  13

LAST_RECHARGE_AMOUNT

NUMBER

22

Y

  14

ROAMING_END_DATE

DATE

7

Y

  15

REFERENCE

VARCHAR2

160

Y

  
16

FROM_DATE

DATE

7

Y

  
17

TO_DATE

DATE

7

Y

  
18

TRIES

NUMBER

22

Y

  19

SOURCE_OBJECT_ID

NUMBER

22

Y

 Reference to record in table named in column SOURCE_OBJECT_TABLE
20

SOURCE_OBJECT_TABLE

VARCHAR2

400

Y

 Table name21

CREDIT_CARD_EXPIRE_DATE

DATE

7

Y

  22

CARD_TYPE

VARCHAR2

200

Y

  23

LAST_DIGITS

VARCHAR2

40

Y

  
24

EXP_MONTH

VARCHAR2

8

Y

  25

EXP_YEAR

VARCHAR2

16

Y

  26

STATUS_ID

NUMBER

22

Y

  27

ACCOUNT_PAYMENT_TYPE_ID

NUMBER

22

Y

 Reference to ACCOUNT_PAYMENT_TYPE28

RECHARGE_STRATEGY_CODE

VARCHAR2

200

Y

  29

CURRENCY_CODE

VARCHAR2

12

Y

  30

RECHARGE_TICKET_TYPE_ID

NUMBER

22

Y

 Reference to RECHARGE_TICKET_TYPE 
META_DATAVARCHAR24000Y With v. 9.8
Column
width33%

Contains automatic top up information