Groups
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 | ||
12 | PHONE2 | VARCHAR2 | 80 | Y | ||
13 | PHONE3 | VARCHAR2 | 80 | Y | ||
14 | FAX | VARCHAR2 | 80 | Y | ||
15 | VARCHAR2 | 480 | Y | |||
16 | EMAIL2 | VARCHAR2 | 480 | Y | ||
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 functionality | |
| 78 | 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 |
Contains all Users