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