Versions Compared

Version Old Version 2 New Version Current
Changes made by

Søren Duusgaard (Deactivated)

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%

BLACKLIST

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

ID

NUMBER

22

N

  
2

USER_ID

NUMBER

22

Y

  
3

STATUS_ID

NUMBER

22

Y

  
4

REASON

VARCHAR2

1024

Y

  
5

FROM_DATE

DATE

7

Y

  
6

TO_DATE

DATE

7

Y

  
7

FIRST_NAME

VARCHAR2

480

Y

  
8

LAST_NAME

VARCHAR2

480

Y

  
9

ADDRESS1

VARCHAR2

256

Y

  
10

ZIP

VARCHAR2

120

Y

  
11

FIXED_LINE_NUMBER

VARCHAR2

10

Y

  
12

MOBILE_NUMBER

VARCHAR2

80

Y

  
13

ACTIVE

NUMBER

22

Y

  
14

HITS

NUMBER

22

Y

  
15

EMAIL

VARCHAR2

128

Y

  
16

PERSONAL_ID

VARCHAR2

64

Y

  
17

SUBSCRIPTION_ID

NUMBER

22

Y

  
18

CREATE_DATE

DATE

7

Y

  
19

TYPE

VARCHAR2

1

Y

  
20

CODE

VARCHAR2

12

Y

  
21

PERSONAL_ID_TYPE

VARCHAR2

30

Y

  
22

COMMENTS

VARCHAR2

800

Y

  
23

DATE_OF_BIRTH

DATE

7

Y

  
24

STREET

VARCHAR2

256

Y

  
25

STREET_NUMBER

VARCHAR2

12

Y

  
26

FLOOR

VARCHAR2

80

Y

  
27

FLOOR_UNIT

VARCHAR2

32

Y

  
28

CITY

VARCHAR2

320

Y

  
29

COUNTRY

VARCHAR2

40

Y

  
30

REASON_ID

NUMBER

22

Y

  
31

BANK_NAME

VARCHAR2

240

Y

  
32

BANK_REG_NUMBER

VARCHAR2

240

Y

  
33

BANK_ACCOUNT_NUMBER

VARCHAR2

240

Y

  
34

BANK_BIC_CODE

VARCHAR2

80

Y

  
35

BANK_IBAN_CODE

VARCHAR2

140

Y

  
Column
width33%