Groups
ADDRESS
Col # | Column Name | Data Type | Field Length | Null? | Data Def. | Comments |
---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | Primary key | |
2 | CODE | VARCHAR2 | 128 | Y | ||
3 | COMPANY | VARCHAR2 | 1020 | Y | ||
4 | FIRST_NAME | VARCHAR2 | 240 | Y | ||
5 | LAST_NAME | VARCHAR2 | 240 | Y | ||
6 | CITY | VARCHAR2 | 128 | Y | ||
7 | ZIP | VARCHAR2 | 128 | Y | ||
8 | PHONE | VARCHAR2 | 128 | Y | ||
9 | FAX | VARCHAR2 | 128 | Y | ||
10 | VARCHAR2 | 512 | Y | |||
11 | STREET | VARCHAR2 | 1024 | Y | ||
12 | STREET_NUMBER | VARCHAR2 | 48 | Y | ||
13 | STREET_UNIT | VARCHAR2 | 48 | Y | ||
14 | FLOOR | VARCHAR2 | 48 | Y | ||
15 | FLOOR_UNIT | VARCHAR2 | 128 | Y | ||
16 | COUNTY | VARCHAR2 | 128 | Y | ||
17 | COUNTRY | VARCHAR2 | 128 | Y | ||
18 | STREET_CODE | VARCHAR2 | 128 | Y | ||
19 | ADDRESS_CODE | VARCHAR2 | 128 | Y | ||
20 | CO | VARCHAR2 | 255 | Y | ||
21 | STATUS_ID | NUMBER | 22 | Y | ||
22 | ADDRESS_CHECK_DATE | DATE | 7 | Y | ||
23 | ADDRESS_PROOF | NUMBER | 22 | Y | ||
24 | COORDINATE_X | VARCHAR2 | 128 | Y | ||
25 | COORDINATE_Y | VARCHAR2 | 128 | Y | ||
26 | COMMENTS | VARCHAR2 | 4000 | Y | ||
27 | DIRECTION | VARCHAR2 | 40 | Y | ||
28 | ZIP_EXT | VARCHAR2 | 40 | Y | ||
29 | ADDRESS_STATE | VARCHAR2 | 40 | Y | ||
30 | STREET_UNIT_TYPE | VARCHAR2 | 1000 BYTE | Y | With 9.9 | |
31 | STREET_TYPE | VARCHAR2 | 1000 BYTE | Y | With 9.9 | |
32 | BUILDING | VARCHAR2 | 1000 BYTE | Y | With 9.9 |