Versions Compared

Old Version 6

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

Saved on

compared with

New Version 7

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

Column
width33%

USERS

12481011151718202122242529313234353638394142434546484950525355565758596164666768717374

Col #

Column NameData TypeField LengthNull?Data Def.Comments

ID

NUMBER

22

N

 Primary key

ACCOUNT_ID

NUMBER

22

N

 Foreign key referencing ACCOUNT-table

3

COMPANY

VARCHAR2

1020

Y

  

FIRST_NAME

VARCHAR2

240

Y

  

5

LAST_NAME

VARCHAR2

240

Y

  

6

ADDRESS1

VARCHAR2

360

Y

  

7

ADDRESS2

VARCHAR2

360

Y

  

CITY

VARCHAR2

160

Y

  

9

ZIP

VARCHAR2

160

Y

  

COUNTRY

VARCHAR2

160

Y

  

PHONE1

VARCHAR2

80

Y

  

12

PHONE2

VARCHAR2

80

Y

  

13

PHONE3

VARCHAR2

80

Y

  

14

FAX

VARCHAR2

80

Y

  

EMAIL

VARCHAR2

480

Y

  

16

EMAIL2

VARCHAR2

480

Y

  

BIRTHDAY

DATE

7

Y

  

LAST_CHANGED_DATE

DATE

7

Y

  

19

ADVERTISE_EMAIL

NUMBER

22

Y

  

U_COMMENT

VARCHAR2

1020

Y

  

STATUS_ID

NUMBER

22

Y

  

USERNAME

VARCHAR2

400

Y

  

23

PASSWORD

VARCHAR2

400

Y

  

QUESTION

VARCHAR2

4000

Y

  

ANSWER

VARCHAR2

4000

Y

  

26

STREET

VARCHAR2

1024

Y

  

27

STREET_NUMBER

VARCHAR2

48

Y

  

28

FLOOR

VARCHAR2

48

Y

  

FLOOR_UNIT

VARCHAR2

128

Y

  

30

PERSONAL_ID

VARCHAR2

200

Y

  

STATE_ID

NUMBER

22

Y

  

ADDR_ID

VARCHAR2

200

Y

  

33

CONT_ID

VARCHAR2

160

Y

  

CREDIT_RATING

VARCHAR2

4

Y

  

CREDIT_RATING_DATE

DATE

7

Y

  

CREDIT_SCORE

VARCHAR2

4

Y

  

37

CREDIT_SCORE_DATE

DATE

7

Y

  

OVERRIDE_CREDIT_SCORE_UNTIL

DATE

7

Y

  

GENDER

VARCHAR2

4

Y

  

40

CREDIT_LIMIT

NUMBER

22

Y

  

LANGUAGE_CODE

VARCHAR2

40

Y

  

REG_STATUS

VARCHAR2

4

Y

  

ADDRESS_CHECK_DATE

DATE

7

Y

  

44

PROVINCE

VARCHAR2

240

Y

  

ADDRESS_PROOF

NUMBER

22

Y

  

COUNTY

VARCHAR2

200

Y

  

47

DISTRICT

VARCHAR2

200

Y

  

BUILDING

VARCHAR2

200

Y

  

LAST_NAME_PREFIX

VARCHAR2

160

Y

  

INITIALS

VARCHAR2

60

Y

  

51

TITLE

VARCHAR2

80

Y

  

BLACKLISTED

NUMBER

22

Y

  

OLI_ID

VARCHAR2

200

Y

  

54

BRAND_ID

NUMBER

22

Y

 Foreign key referencing BRAND-table

PERSONAL_ID_EXPIRY_DATE

DATE

7

Y

  

PERSONAL_ID_TYPE

VARCHAR2

120

Y

  

ADVERTISING

VARCHAR2

4

Y

  

ADVERTISING_CUSTOMER_DATA

VARCHAR2

4

Y

  

ADVERTISING_USAGE_DATA

VARCHAR2

4

Y

  

60

COMMUNICATION_TYPE

VARCHAR2

4

Y

  

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

 ?

65

INSTALLATION_ADDRESS

VARCHAR2

4

Y

  

STREET_UNIT

VARCHAR2

48

Y

  

CONCURRENCY_KEY

NUMBER

22

Y

  

ACCESS_LEVEL

NUMBER

22

Y

  

69

VAT_NUMBER

VARCHAR2

400

Y

  

70

DIRECTION

VARCHAR2

40

Y

  

ZIP_EXT

VARCHAR2

40

Y

  

72

ADDRESS_STATE

VARCHAR2

40

Y

  

PO_BOX

VARCHAR2

160

Y

  

NATIONALITY

VARCHAR2

12

Y

  75
STREET_UNIT_TYPEVARCHAR21000 BYTESY With 9.9
76STREET_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 functionality
79

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