{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
width
33%
USERS
Col#
Column Name
Data Type
Field Length
Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
ACCOUNT_ID
NUMBER
22
N
Foreign key referencing ACCOUNT-table
3
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
12
PHONE2
VARCHAR2
80
Y
Deprecated
13
PHONE3
VARCHAR2
80
Y
14
Deprecated
FAX
VARCHAR2
80
Y
Deprecated
15
EMAIL
VARCHAR2
480
Y
Deprecated
16
EMAIL2
VARCHAR2
480
Y
Deprecated
17
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
55
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
?
64
SHIPPING_ADDRESS_USER
VARCHAR2
4
Y
?
65
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
75
STREET_UNIT_TYPE
VARCHAR2
1000 BYTES
Y
With 9.9
76
STREET_TYPE
VARCHAR2
1000 BYTES
Y
With 9.9
77
PASSWORD_PROFILE_KEY
VARCHAR2
100
Y
With 9.9 - Support for changes to password encryption functionality78
PASSWORD_SHORTENED
VARCHAR2
100
Y
With 9.9 - Support for changes to password encryption functionality
79
PASSWORD_SALT
VARCHAR2
400
Y
With 9.9 - Support for random SALT generation in Core
PWD_VALIDATION_TOKEN
VARCHAR2
500 CHAR
With 10.3.1 in support of password validation token on the users object
PWD_VALIDATION_TOKEN_DATE
DATE
With 10.3.1 in support of password validation token on the users object