| 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 |
| 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 | | |
|
|
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 |