Versions Compared

Old Version 6

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version Current

changes.mady.by.user Anders Nordbjærg (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section


Column
width33%

Groups



Column
width33%

USERS

1 2 3121314151617 55 64 6575

Col #

Column NameData TypeField LengthNull?Data Def.Comments

ID

NUMBER

22

N


Primary key

ACCOUNT_ID

NUMBER

22

N


Foreign key referencing ACCOUNT-table

COMPANY

VARCHAR2

1020

Y

  

4



FIRST_NAME

VARCHAR2

240

Y

  

5



LAST_NAME

VARCHAR2

240

Y

  

6



ADDRESS1

VARCHAR2

360

Y

  

7



ADDRESS2

VARCHAR2

360

Y

  

8



CITY

VARCHAR2

160

Y

  

9



ZIP

VARCHAR2

160

Y

  

10



COUNTRY

VARCHAR2

160

Y

  

11



PHONE1

VARCHAR2

80

Y

  
 Deprecated

PHONE2

VARCHAR2

80

Y

  
 Deprecated

PHONE3

VARCHAR2

80

Y

  
 Deprecated

FAX

VARCHAR2

80

Y

  
 Deprecated

EMAIL

VARCHAR2

480

Y

  
 Deprecated

EMAIL2

VARCHAR2

480

Y

  
 Deprecated

BIRTHDAY

DATE

7

Y

  

18



LAST_CHANGED_DATE

DATE

7

Y

  

19



ADVERTISE_EMAIL

NUMBER

22

Y

  

20



U_COMMENT

VARCHAR2

1020

Y

  

21



STATUS_ID

NUMBER

22

Y

  

22



USERNAME

VARCHAR2

400

Y

  

23



PASSWORD

VARCHAR2

400

Y

  

24



QUESTION

VARCHAR2

4000

Y

  

25



ANSWER

VARCHAR2

4000

Y

  

26



STREET

VARCHAR2

1024

Y

  

27



STREET_NUMBER

VARCHAR2

48

Y

  

28



FLOOR

VARCHAR2

48

Y

  

29



FLOOR_UNIT

VARCHAR2

128

Y

  

30



PERSONAL_ID

VARCHAR2

200

Y

  

31



STATE_ID

NUMBER

22

Y

  

32



ADDR_ID

VARCHAR2

200

Y

  

33



CONT_ID

VARCHAR2

160

Y

  

34



CREDIT_RATING

VARCHAR2

4

Y

  

35



CREDIT_RATING_DATE

DATE

7

Y

  

36



CREDIT_SCORE

VARCHAR2

4

Y

  

37



CREDIT_SCORE_DATE

DATE

7

Y

  

38



OVERRIDE_CREDIT_SCORE_UNTIL

DATE

7

Y

  

39



GENDER

VARCHAR2

4

Y

  

40



CREDIT_LIMIT

NUMBER

22

Y

  

41



LANGUAGE_CODE

VARCHAR2

40

Y

  

42



REG_STATUS

VARCHAR2

4

Y

  

43



ADDRESS_CHECK_DATE

DATE

7

Y

  

44



PROVINCE

VARCHAR2

240

Y

  

45



ADDRESS_PROOF

NUMBER

22

Y

  

46



COUNTY

VARCHAR2

200

Y

  

47



DISTRICT

VARCHAR2

200

Y

  

48



BUILDING

VARCHAR2

200

Y

  

49



LAST_NAME_PREFIX

VARCHAR2

160

Y

  

50



INITIALS

VARCHAR2

60

Y

  

51



TITLE

VARCHAR2

80

Y

  

52



BLACKLISTED

NUMBER

22

Y

  

53



OLI_ID

VARCHAR2

200

Y

  

54



BRAND_ID

NUMBER

22

Y


Foreign key referencing BRAND-table

PERSONAL_ID_EXPIRY_DATE

DATE

7

Y

  

56



PERSONAL_ID_TYPE

VARCHAR2

120

Y

  

57



ADVERTISING

VARCHAR2

4

Y

  

58



ADVERTISING_CUSTOMER_DATA

VARCHAR2

4

Y

  

59



ADVERTISING_USAGE_DATA

VARCHAR2

4

Y

  

60



COMMUNICATION_TYPE

VARCHAR2

4

Y

  

61



ADVERTISE_SMS

NUMBER

22

Y

  

62



COMPANY_SUB_ID

VARCHAR2

120

Y

  

63



SHIPPING_ADDRESS_ID

NUMBER

22

Y


?

SHIPPING_ADDRESS_USER

VARCHAR2

4

Y


?

INSTALLATION_ADDRESS

VARCHAR2

4

Y

  

66



STREET_UNIT

VARCHAR2

48

Y

  

67



CONCURRENCY_KEY

NUMBER

22

Y

  

68



ACCESS_LEVEL

NUMBER

22

Y

  

69



VAT_NUMBER

VARCHAR2

400

Y

  

70



DIRECTION

VARCHAR2

40

Y

  

71



ZIP_EXT

VARCHAR2

40

Y

  

72



ADDRESS_STATE

VARCHAR2

40

Y

  

73



PO_BOX

VARCHAR2

160

Y

  

74



NATIONALITY

VARCHAR2

12

Y

  



STREET_UNIT_TYPEVARCHAR21000 BYTESY 
With 9.976
STREET_TYPEVARCHAR21000 BYTESY 
With 9.977

PASSWORD_PROFILE_KEY

VARCHAR2100Y 
With 9.9 - Support for changes to password encryption functionality78

PASSWORD_SHORTENED

VARCHAR2100Y 
With 9.9 - Support for changes to password encryption functionality79

PASSWORD_SALT

VARCHAR2400Y 
With 9.9 - Support for random SALT generation in Core
PWD_VALIDATION_TOKENVARCHAR2500 CHAR

With 10.3.1 in support of password validation token on the users object
PWD_VALIDATION_TOKEN_DATEDATE


With 10.3.1 in support of password validation token on the users object



Column
width33%

Contains all Users


...