Groups
USERS
| Column Name | Data Type | Field Length | Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
ACCOUNT_ID | NUMBER | 22 | N | Foreign key referencing ACCOUNT-table | |
COMPANY | VARCHAR2 | 1020 | Y | ||
FIRST_NAME | VARCHAR2 | 240 | Y | ||
LAST_NAME | VARCHAR2 | 240 | Y | ||
ADDRESS1 | VARCHAR2 | 360 | Y | ||
ADDRESS2 | VARCHAR2 | 360 | Y | ||
CITY | VARCHAR2 | 160 | Y | ||
ZIP | VARCHAR2 | 160 | Y | ||
COUNTRY | VARCHAR2 | 160 | Y | ||
PHONE1 | VARCHAR2 | 80 | Y | ||
PHONE2 | VARCHAR2 | 80 | Y | ||
PHONE3 | VARCHAR2 | 80 | Y | ||
FAX | VARCHAR2 | 80 | Y | ||
VARCHAR2 | 480 | Y | |||
EMAIL2 | VARCHAR2 | 480 | Y | ||
BIRTHDAY | DATE | 7 | Y | ||
LAST_CHANGED_DATE | DATE | 7 | Y | ||
ADVERTISE_EMAIL | NUMBER | 22 | Y | ||
U_COMMENT | VARCHAR2 | 1020 | Y | ||
STATUS_ID | NUMBER | 22 | Y | ||
USERNAME | VARCHAR2 | 400 | Y | ||
PASSWORD | VARCHAR2 | 400 | Y | ||
QUESTION | VARCHAR2 | 4000 | Y | ||
ANSWER | VARCHAR2 | 4000 | Y | ||
STREET | VARCHAR2 | 1024 | Y | ||
STREET_NUMBER | VARCHAR2 | 48 | Y | ||
FLOOR | VARCHAR2 | 48 | Y | ||
FLOOR_UNIT | VARCHAR2 | 128 | Y | ||
PERSONAL_ID | VARCHAR2 | 200 | Y | ||
STATE_ID | NUMBER | 22 | Y | ||
ADDR_ID | VARCHAR2 | 200 | Y | ||
CONT_ID | VARCHAR2 | 160 | Y | ||
CREDIT_RATING | VARCHAR2 | 4 | Y | ||
CREDIT_RATING_DATE | DATE | 7 | Y | ||
CREDIT_SCORE | VARCHAR2 | 4 | Y | ||
CREDIT_SCORE_DATE | DATE | 7 | Y | ||
OVERRIDE_CREDIT_SCORE_UNTIL | DATE | 7 | Y | ||
GENDER | VARCHAR2 | 4 | Y | ||
CREDIT_LIMIT | NUMBER | 22 | Y | ||
LANGUAGE_CODE | VARCHAR2 | 40 | Y | ||
REG_STATUS | VARCHAR2 | 4 | Y | ||
ADDRESS_CHECK_DATE | DATE | 7 | Y | ||
PROVINCE | VARCHAR2 | 240 | Y | ||
ADDRESS_PROOF | NUMBER | 22 | Y | ||
COUNTY | VARCHAR2 | 200 | Y | ||
DISTRICT | VARCHAR2 | 200 | Y | ||
BUILDING | VARCHAR2 | 200 | Y | ||
LAST_NAME_PREFIX | VARCHAR2 | 160 | Y | ||
INITIALS | VARCHAR2 | 60 | Y | ||
TITLE | VARCHAR2 | 80 | Y | ||
BLACKLISTED | NUMBER | 22 | Y | ||
OLI_ID | VARCHAR2 | 200 | Y | ||
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 | ||
COMMUNICATION_TYPE | VARCHAR2 | 4 | Y | ||
ADVERTISE_SMS | NUMBER | 22 | Y | ||
COMPANY_SUB_ID | VARCHAR2 | 120 | Y | ||
SHIPPING_ADDRESS_ID | NUMBER | 22 | Y | ? | |
SHIPPING_ADDRESS_USER | VARCHAR2 | 4 | Y | ? | |
INSTALLATION_ADDRESS | VARCHAR2 | 4 | Y | ||
STREET_UNIT | VARCHAR2 | 48 | Y | ||
CONCURRENCY_KEY | NUMBER | 22 | Y | ||
ACCESS_LEVEL | NUMBER | 22 | Y | ||
VAT_NUMBER | VARCHAR2 | 400 | Y | ||
DIRECTION | VARCHAR2 | 40 | Y | ||
ZIP_EXT | VARCHAR2 | 40 | Y | ||
ADDRESS_STATE | VARCHAR2 | 40 | Y | ||
PO_BOX | VARCHAR2 | 160 | Y | ||
NATIONALITY | VARCHAR2 | 12 | Y | ||
| STREET_UNIT_TYPE | VARCHAR2 | 1000 BYTES | Y | With 9.9 | |
| STREET_TYPE | VARCHAR2 | 1000 BYTES | Y | With 9.9 | |
PASSWORD_PROFILE_KEY | VARCHAR2 | 100 | Y | With 9.9 - Support for changes to password encryption functionality | |
PASSWORD_SHORTENED | VARCHAR2 | 100 | Y | With 9.9 - Support for changes to password encryption functionality | |
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 |
Contains all Users