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

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 name
21

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_TYPE
28

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
31

CA_AMOUNT_LIMIT

NUMBER

22

Y

  
32

CA_PERIOD

VARCHAR2

40

Y

  
33

CA_NICKNAME

VARCHAR2

120

Y

  
Column
width33%

Contains automatic top up information