BLACKLIST
Groups
BLACKLIST
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | ||
2 | USER_ID | NUMBER | 22 | Y | ||
3 | STATUS_ID | NUMBER | 22 | Y | ||
4 | REASON | VARCHAR2 | 1024 | Y | ||
5 | FROM_DATE | DATE | 7 | Y | ||
6 | TO_DATE | DATE | 7 | Y | ||
7 | FIRST_NAME | VARCHAR2 | 480 | Y | ||
8 | LAST_NAME | VARCHAR2 | 480 | Y | ||
9 | ADDRESS1 | VARCHAR2 | 256 | Y | ||
10 | ZIP | VARCHAR2 | 120 | Y | ||
11 | FIXED_LINE_NUMBER | VARCHAR2 | 10 | Y | ||
12 | MOBILE_NUMBER | VARCHAR2 | 80 | Y | ||
13 | ACTIVE | NUMBER | 22 | Y | ||
14 | HITS | NUMBER | 22 | Y | ||
15 | VARCHAR2 | 128 | Y | |||
16 | PERSONAL_ID | VARCHAR2 | 64 | Y | ||
17 | SUBSCRIPTION_ID | NUMBER | 22 | Y | ||
18 | CREATE_DATE | DATE | 7 | Y | ||
19 | TYPE | VARCHAR2 | 1 | Y | ||
20 | CODE | VARCHAR2 | 12 | Y | ||
21 | PERSONAL_ID_TYPE | VARCHAR2 | 30 | Y | ||
22 | COMMENTS | VARCHAR2 | 800 | Y | ||
23 | DATE_OF_BIRTH | DATE | 7 | Y | ||
24 | STREET | VARCHAR2 | 256 | Y | ||
25 | STREET_NUMBER | VARCHAR2 | 12 | Y | ||
26 | FLOOR | VARCHAR2 | 80 | Y | ||
27 | FLOOR_UNIT | VARCHAR2 | 32 | Y | ||
28 | CITY | VARCHAR2 | 320 | Y | ||
29 | COUNTRY | VARCHAR2 | 40 | Y | ||
30 | REASON_ID | NUMBER | 22 | Y | ||
31 | BANK_NAME | VARCHAR2 | 240 | Y | ||
32 | BANK_REG_NUMBER | VARCHAR2 | 240 | Y | ||
33 | BANK_ACCOUNT_NUMBER | VARCHAR2 | 240 | Y | ||
34 | BANK_BIC_CODE | VARCHAR2 | 80 | Y | ||
35 | BANK_IBAN_CODE | VARCHAR2 | 140 | Y |