|
|
| Legend: |
| Primary key columns |
| Columns with indexes |
| Implied relationships |
| Excluded column relationships |
| < n > number of related tables |
|
|
| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ADDRESS_ID |
number |
0 |
|
|
|
|
|
| COMMON_PLACE_NAME |
varchar2 |
80 |
√ |
|
null |
|
|
| LONGITUDE |
varchar2 |
30 |
√ |
|
null |
|
|
| LATITUDE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_NUMBER |
varchar2 |
50 |
√ |
|
null |
|
|
| STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| ADDR_SC_ADDRESS_SUBTYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STATE_CD_STATE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DIRCT_CD_DIRECTION_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STREET_CD_STREET_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STREET_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| ZIP5 |
varchar2 |
30 |
√ |
|
null |
|
|
| ZIP4 |
number |
0 |
√ |
|
null |
|
|
| INTRSECT1_STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| INTRSECT1_DIR |
varchar2 |
30 |
√ |
|
null |
|
|
| INTRSECT2_DIR |
varchar2 |
30 |
√ |
|
null |
|
|
| UNITS1 |
varchar2 |
2 |
√ |
|
null |
|
|
| DISTANCE1 |
number |
10,2 |
√ |
|
null |
|
|
| INTRSECT1_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| CITY |
varchar2 |
40 |
√ |
|
null |
|
|
| DIRECT_SUFFIX |
varchar2 |
30 |
√ |
|
null |
|
|
| GEO_CITY |
varchar2 |
40 |
√ |
|
null |
|
|
| INTRSECT1_DIR_SUFFIX |
varchar2 |
30 |
√ |
|
null |
|
|
| INTRSECT1_STREET_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| VERIFY_STATUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| VERIFY_DATE |
date |
7 |
√ |
|
null |
|
|
| BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| SSTREET_NAME |
varchar2 |
4 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
AD.ADDRESS_ID,
ACN.COMMON_PLACE_NAME,
AD.LONGITUDE,
AD.LATITUDE,
AD.SUB_NUMBER,
AD.STREET_NUMBER,
-- AD.ADDR_CD_ADDRESS_TYPE_CODE,
AD.ADDR_SC_ADDRESS_SUBTYPE_CODE,
AD.STATE_CD_STATE_CODE,
AD.DIRCT_CD_DIRECTION_CODE,
AD.STREET_CD_STREET_TYPE_CODE,
AD.STREET_NAME,
AD.ZIP5,
AD.ZIP4,
AD.INTRSECT1_STREET_NUMBER,
AD.INTRSECT1_DIR,
AD.INTRSECT2_DIR,
AD.UNITS1,
AD.DISTANCE1,
AD.INTRSECT1_NAME,
AD.CITY,
AD.DIRECT_SUFFIX,
AD.GEO_CITY,
AD.INTRSECT1_DIR_SUFFIX,
AD.INTRSECT1_STREET_TYPE_CODE,
AD.VERIFY_STATUS_CODE,
AD.VERIFY_DATE,
AD.BEAT,
AD.SUB_BEAT,
AD.SSTREET_NAME
FROM ADDRESSES AD,
ADDRESS_COMMON_NAMES ACN
WHERE AD.ADDRESS_ID = ACN.ADDR_ADDRESS_ID (+)
Possibly Referenced Tables/Views:
