|
|
| 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 |
| FIELD_CODE |
varchar2 |
8 |
√ |
|
null |
|
|
| IMPORT_COLUMN |
varchar2 |
64 |
√ |
|
null |
|
|
| DESTINATION_ID |
number |
0 |
|
|
|
|
|
| FILE_ID |
number |
0 |
|
|
|
|
|
| IMPORT_TABLE |
varchar2 |
64 |
√ |
|
null |
|
|
| IMPORT_PROCEDURE |
varchar2 |
64 |
√ |
|
null |
|
|
| IMPORT_ID |
number |
0 |
|
|
|
|
|
| FIELD_VALUE |
varchar2 |
2000 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
ir.FIELD_CODE
, ef.IMPORT_COLUMN
, impfl.destination_id
, impfl.file_id
, EF.IMPORT_TABLE
, ip.import_procedure
, ir.import_id
, ir.field_value
from export_field_destinations efd, export_fields ef, export_records er,
import_parameters ip, import_records ir, import_files impfl
where efd.destination_id = impfl.destination_id
and impfl.import_id = ir.import_id
and ef.field_id = efd.field_id
and er.record_id = ef.record_id
and impfl.file_id = er.file_id
and ip.import_column = ef.import_column
and ip.import_table = ef.import_table
and substr(ir.field_code,1,length(efd.field_code)) = efd.field_code
Possibly Referenced Tables/Views:
