Versions Compared

Old Version 2

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

Saved on

compared with

New Version 3

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

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%

SUBSCRIPTION

Col #

Column NameData TypeField LengthNot Null?Data Def.Comments

1

ID

NUMBER

22

N

 Primary key

2

ACCOUNT_ID

NUMBER

22

Y

 Foreign key referencing ACCOUNT.ID

3

CUSTOMER_TYPE

VARCHAR2

50

200

Y

  

4

OWNER_ID

NUMBER

22

Y

 Foreign key referencing USERS.ID

5

START_DATE

DATE

7

Y

  

6

END_DATE

DATE

7

Y

  

7

BLOCKED

NUMBER

22

Y

  

8

FOREIGN_CALLS

NUMBER

22

Y

  

9

PHONEBOOK_ENTRY

NUMBER

22

Y

  

10

LAST_CHANGED_DATE

DATE

7

Y

  

11

LAST_WARNING_DATE

DATE

7

Y

  

12

CANCEL_DATE

DATE

7

Y

  

13

ESTABLISH_DATE

DATE

7

Y

  

14

STATUS_ID

NUMBER

22

Y

 Foreign key referencing STATUS.ID

15

PRODUCT_ID

NUMBER

22

Y

 Foreign key referencing PRODUCT.ID

16

CURRENT_BALANCE

NUMBER

22

Y

  

17

ALERT_GROUP_ID

NUMBER

22

Y

 Foreign key referencing ALERT_GROUP.ID

18

USAGE_CONTROL_ENABLED

NUMBER

22

Y

  

19

USAGE_CONTROL_LAST_DATE

DATE

7

Y

  

20

NEG_BALANCE_DAYS

NUMBER

22

Y

  

21

BILLING_GROUP_ID

NUMBER

22

Y

 DEPRECATED!

22

MAX_USAGE_VALUE

NUMBER

22

Y

  

23

SALES_REP

VARCHAR2

50

200

Y

  

24

SALES_STORE

VARCHAR2

40

160

Y

  

25

SOLN_ROW_ID

VARCHAR2

40

160

Y

 DEPRECATED!

26

ASSET_ID

VARCHAR2

20

80

Y

 DEPRECATED!

27

ACC_ID

VARCHAR2

20

80

Y

 DEPRECATED!

28

ENTERED_BY

VARCHAR2

40

160

Y

  

29

USAGE_CONTROL_MINIMUM_ENABLED

NUMBER

22

Y

  

30

USAGE_CONTROL_MINIMUM_DATE

DATE

7

Y

  

31

BONUS_USAGE

NUMBER

22

Y

  

32

BONUS_VALUE

NUMBER

22

Y

  

33

SHIPPING_USER_ID

NUMBER

22

Y

  

34

LAST_BALANCE_UPDATE

DATE

7

Y

  32

35

BRAND_ID

NUMBER

22

Y

 Foreign key referencing BRAND.ID33

36

PARENT_ID

NUMBER

22

Y

  34

37

ORDER_ID

VARCHAR2

25

100

Y

  35

38

CONCURRENCY_KEY

NUMBER

22

Y

  36

39

NON_REFUNDABLE_BALANCE

NUMBER

22

Y

  37

40

NON_REFUNDABLE_BALANCE_DATE

DATE

7

Y

  38

41

CHURN_STATUS

NUMBER

22

Y

  39

CA_NICKNAME

VARCHAR2

200

Y

  
Column
width33%

Contains all Subscriptions/SIMs