SchemaSpy Analysis of R1224VIS.EDAPTER Generated by
SchemaSpy
Generated by SchemaSpy on Sun Aug 18 02:01 IST 2019
Database Type: Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
BOM_OPERATIONAL_ROUTINGS_BK 46 0
DEPT 3 0
EMPLOYEE 4 6
ETK_ADD_ATTRIBUTES 8 0
ETK_ARENA_DOC_PROC 3 36
ETK_ARENA_DOC_PROC_AUDIT 12 276
ETK_ARENA_DOC_PROC_AUDIT_BKP 11 0
ETK_BOM_ITEM 21 162
ETK_BOM_ITEMS_TEMP 21 12
ETK_DOC_VENDOR_PART 16 0
ETK_ITEM 35 154
ETK_ITEM_VENDOR_PART 12 0
MRP_SOURCING_RULES_INT 34 213
MRP_SR_RECEIPT_ORG_INT 32 213
MRP_SR_SOURCE_ORG_INT 38 436
STUDENT 5 4
SUPPLIER_REVIEW_CYCLE 79 175
T_ACTION_CODES 7 33
T_ACTION_CODES_API 4 0
T_ALT_OPERATION_RESOURCES 11 0
T_ALT_OPERATION_RESOURCES_API 11 0
T_API_ERROR_MESSAGES 11 3,066
T_ARENA_DOC_PROC_AUDIT 15 2,747
T_ARENA_WARNING_MESSAGES 6 2
T_ASL_API 1 1 18 0
T_ASL_PROPERTIES_API 1 4 0
T_ASN_TEMP 37 3
T_ATTRIBUTE_ERRORS 6 3,640
T_BATCH_EXPLODE_COND_NEW_BK 28 0
T_BATCH_EXPLODE_CONDITIONS_NEW 28 0
T_BOM_COPY_ATTR 8 23
T_BOM_COPY_CATS 9 47
T_BOM_COPY_ERRORS 6 482,878
T_BOM_COPY_HEADER 9 633
T_BOM_COPY_ITEMS 9 1,260
T_BOM_COPY_RESULTS_API 8 5,223
T_BOM_COPY_TEMP 36 7,079
T_BOM_COPY_WHERE_USED 13 8
T_BOM_DFF_DUMMY 3 0
T_BOM_EFFECTIVITY_TIME_FRAME 1 4
T_BOM_ITEM_PROPERTIES_API 2 4 345
T_BOM_ITEMS_API 1 1 37 357
T_BOM_OP_NETWORKS_API 17 129,921
T_BOM_OP_RESOURCES_API 1 21 27,697
T_BOM_OP_ROUTINGS_API 1 22 22,569
T_BOM_OP_SEQUENCES_API 1 1 22 51,223
T_BOM_PROPERTIES_API 1 4 34,715
T_BOMS_API 3 40 239
T_CDI_PARTY_ADDRESS 47 22,183
T_CDM_CREDIT_CARDS 68 190
T_CDM_CUST_ACCOUNTS 2 1 193 2
T_CDM_CUST_ACCT_SITE 3 1 184 2
T_CDM_CUST_ACCT_SITE_USES 1 125 2
T_CDM_CUST_CONTACT 3 102 2
T_CDM_CUST_PROFILE_AMOUNTS 39 16,159
T_CDM_INDUSTRIAL_CLASIFICATION 33 208
T_CDM_PARTY 9 125 2
T_CDM_PARTY_ACCT_TAX_DETAILS 1 6 0
T_CDM_PARTY_CREDIT_LIMITS 1 9 0
T_CDM_PARTY_FISCAL_DETAILS 1 8 0
T_CDM_PARTY_TAX_EXEMPTIONS 1 11 0
T_CDM_PARTY_TAX_REPORTINGS 1 8 0
T_CDM_PAYMENT_METHODS 32 115
T_CDM_RECEIPT_METHODS 34 89
T_CDM_RELATIONSHIPS 1 28 0
T_CDM_SFDC_DETAILS_V 11 view
T_CDM_SITE_LOC_GEO_CODE 2 6 0
T_CHILD_LOT_PROPERTIES_API 2 4 1,002
T_CHILD_LOTS_API 2 1 17 558
T_CHIP_MASTER_DETAILS 20 0
T_COMPLETION_SUBINV_DETAILS 5 0
T_CS_SUPPLIER_DATA_TEMP 27 0
T_CUSTOM_VALIDATION 6 0
T_DEBUG 3 114,672
T_DEMAND_DRILLDOWN_API 28 49,650
T_DFF_CONFIG 3 14
T_ECO_API 16 3,124
T_ECO_REVISIONS_API 6 2,896
T_ERP_ITEM_INFO_ALL 13 0
T_ERP_PLANT_CATEGORIES 2 0
T_ERP_SETUP 8 0
T_ERROR_DATA 5 0
T_ERROR_TYPES 5 39
T_EXPLODE_RESOURCES_NEW 16 0
T_EXPLODE_RESOURCES_NEW_BK 16 0
T_EXPLODE_RESOURCES_TEMP_NEW 16 0
T_EXPLODE_ROUTINGS_NEW 89 0
T_EXPLODE_ROUTINGS_NEW_BK 89 0
T_EXPLODE_ROUTINGS_TEMP_NEW 89 0
T_EXPLOSION_ERRORS 3 0
T_FACTORIES 6 89 201
T_FACTORIES_BAK_15042011 85 0
T_FACTORY_ALTERNATES 1 8 20
T_FACTORY_OSP_RESOURCES 11 0
T_FACTORY_PROPERTIES 1 4 0
T_FLEX_ACCOUNT_CLASSIF 3 12
T_FLEX_ATTRIBUTES 1 52 610
T_FLEX_CHILDREN_VALUE 3 6 0
T_FLEX_SEGMENTS 2 1 9 416
T_FLEX_STRUCTURES 9 75
T_FLEX_VALUE_HIERARCHY 1 1 10 234
T_FLEX_VALUE_QULALIFIERS 1 13 656
T_FLEX_VALUE_SETS 3 10 290
T_FLEX_VALUES 4 2 21 656
T_GLOBALSUPPLY_DIT_API 15 28
T_GLOBALSUPPLY_EPRISE_API 16 1,810
T_GLOBALSUPPLY_INV_API 15 1,412
T_GLOBALSUPPLY_WIP_API 15 547
T_GPS_ERRORS 10 71
T_GUI_TOKEN 7 0
T_HR_BUILDING 2 1 17 11
T_HR_BUILDING_HISTORY 1 18 36
T_HR_DEPARTMENT 1 1 7 28
T_HR_DEPARTMENT_HISTORY 2 8 82
T_HR_FLOOR 1 2 18 15
T_HR_FLOOR_HISTORY 1 19 44
T_HR_LOCATIONS 3 91 29
T_HR_LOCATIONS_HISTORY 3 92 50
T_HR_OFFICE 1 3 19 15
T_HR_OFFICE_HISTORY 1 1 20 44
T_INTERFACE_RESULTS_API 5 90,670
T_ITEM_ATTACHMENTS 1 8 23
T_ITEM_CATALOGS_API 1 9 301
T_ITEM_CATEGORIES_API 1 8 8,459
T_ITEM_COST_API 28 9,624
T_ITEM_COST_ELEMENT_API 16 3,444
T_ITEM_COST_REPORT_API 27 53
T_ITEM_COSTELEMENTS_REPORT_API 16 49
T_ITEM_CROSSREF_PROPERTIES_API 1 4 15
T_ITEM_CROSSREFERENCES_API 1 20 15,029
T_ITEM_CUS_PROPERTIES_API 2 4 32
T_ITEM_CUSTOMER_API 1 1 9 16
T_ITEM_DFF_DUMMY 3 0
T_ITEM_INFO 17 0
T_ITEM_INFO_ALL 15 0
T_ITEM_INFO_ALLA 15 0
T_ITEM_INFOA 16 0
T_ITEM_MASS_UPDATE 408 6,713
T_ITEM_PROPERTIES 3 0
T_ITEM_PROPERTIES_API 1 3 12,794
T_ITEM_PROPERTIES_API_TEST 4 480
T_ITEM_REVISION_PROPERTIES_API 3 0
T_ITEM_REVISIONS_API 9 871,203
T_ITEM_ROUTING_PROPERTIES 1 4 0
T_ITEM_ROUTING_PROPERTIES_API 5 0
T_ITEM_ROUTINGS 6 269
T_ITEM_ROUTINGS_API 9 2,754
T_ITEMS 1 8 227
T_ITEMS_API 13 73 681,165
T_JOBTYPE_ATTRIBUTES 1 7 27
T_LDM_LOCATIONS 1 79 2,435
T_LE_ERROR_CODES 4 150
T_LEDGERS 7 102
T_LOCATION_MDM_SEQUENCE 1 1
T_LOCATION_REQUEST_ID 1 1
T_LOG_DYN_SQL 4 0
T_LOT_ACTIONS 2 0
T_LOT_ATTRIBUTES 10 22
T_LOT_ERROR_HISTORY 18 1,401
T_LOT_ERROR_MGMT 36 0
T_LOT_ITEMS 4 37
T_LOT_ITEMS_API 1 9 577
T_LOT_ON_HOLD_SUPPLIES 154 0
T_LOT_PROPERTIES 3 299
T_LOT_PROPERTIES_API 3 303
T_LOT_PROPERTY_SOURCES 1 1 6 8,800
T_LOT_TYPES 1 13 24
T_LOTS 23 0
T_MANUFACTURER_PARTS_API 1 28 5,402
T_MASS_UPD_BOM_LEVELS 2 15
T_MASS_UPDATE_ATTR_CUST 19 191,500
T_MASS_UPDATE_BOM_LEVELS 2 0
T_MASS_UPDATE_BOMS_CUST 10 0
T_MASS_UPDATE_CATS_CUST 11 659
T_MASS_UPDATE_ERRORS 8 59,751
T_MASS_UPDATE_GBOM_CUST 10 507,460
T_MASS_UPDATE_HEADER_CUST 16 2,132
T_MASS_UPDATE_ITEMS_CUST 11 5,136
T_MASS_UPDATE_MCQUERIES_CUST 8 0
T_MASS_UPDATE_ORGS_CUST 8 3,282
T_MASS_UPDATE_RESULTS_CUST 11 321,263
T_MASS_UPDATE_SETUP 2 1
T_MASS_UPDATE_SETUP_CUST 3 142
T_MASS_UPDATE_WHERE_CUST 15 3
T_MMDS_ALT_OPERATION_RESOURCES 13 0
T_MMDS_ERRORS 3 0
T_MMDS_OPERATION_PROPERTIES 4 0
T_MMDS_OPERATION_RESOURCES 13 0
T_MMDS_ROUTING_OPERATIONS 1 20 0
T_MMDS_ROUTING_PROPERTIES 3 0
T_MMDS_ROUTINGS 1 37 0
T_MTL_TXN_LOTS 18 0
T_NEXT_OPERATION_V 23 view
T_NEXT_OPERATIONS 15 9,939
T_NEXT_OPERATIONS_API 16 23,096
T_OKI_POREC_WFID_TEMP 18 0
T_OM_OTD_REPORT_COMMENTS 8 0
T_OPERATION_PROPERTIES 3 843
T_OPERATION_PROPERTIES_API 3 1,728
T_OPERATION_RESOURCES 13 108
T_OPERATION_RESOURCES_API 14 2,042
T_OPERATION_RESOURCES_V 21 view
T_ORACLE_DEMAND_TYPES 3 10
T_ORACLE_JOBS 6 37
T_ORGANIZATION_OPERATIONS 3 0
T_OSP_RESOURCES_API 38 11
T_OVERRIDE_VALIDATION_TABLE 3 60
T_PARENT_LOT_PROPERTIES_API 1 3 3,228
T_PARENT_LOTS_API 3 64 576
T_PERIOD 1 0
T_PICKED_WAFER_ID 15 0
T_PLAN_BUCKETS 5 0
T_PLANT_ACTIONS 2 0
T_PLANT_BOM_LEVELS 2 0
T_PLANT_CATEGORIES 2 0
T_PLANT_CATEGORY_TREND_MV 15 0
T_PLANT_COMPONENT_DET_TMP 11 0
T_PLANT_COMPONENT_DETAILS 11 0
T_PLANT_DI_INV_CALCULATION 17 0
T_PLANT_EXCEPTION_DETAILS 23 0
T_PLANT_EXCEPTION_HISTORY 15 0
T_PLANT_EXPLODE_ROUTINGS 5 0
T_PLANT_EYE_ALL 23 0
T_PLANT_EYE_ALL_TEMP 23 0
T_PLANT_EYE_ALL_TEMPA 23 0
T_PLANT_EYE_DELAY_DET_TMP 42 0
T_PLANT_EYE_DELAY_DETAILS 42 0
T_PLANT_EYE_DETAILS 32 0
T_PLANT_EYE_DETAILS_TEMP 32 0
T_PLANT_EYE_DETAILS_TEMP1 32 0
T_PLANT_EYE_DETAILS_TEMP1A 32 0
T_PLANT_EYE_DETAILS_TEMPA 32 0
T_PLANT_EYE_HEADERS 14 0
T_PLANT_EYE_MONTH_DETAILS 23 0
T_PLANT_EYE_PO_DELAY_DET_TMP 32 0
T_PLANT_EYE_PO_DELAY_DETAILS 32 0
T_PLANT_EYE_PO_EXP_DET_TMP 22 0
T_PLANT_EYE_PO_EXP_DETAILS 22 0
T_PLANT_EYE_WEEK_DET_TMP 23 0
T_PLANT_EYE_WEEK_DETAILS 23 0
T_PLANT_HOUSE_NAMES 6 0
T_PLANT_MEASURES 5 0
T_PLANT_ORDER_TYPES 1 0
T_PLANT_PEGGING_DETAILS 42 0
T_PLANT_PEGGING_DETAILS_TEMP 42 0
T_PLANT_PEGGING_DETAILS_TEMPA 42 0
T_PLANT_PROJECTED_OUTS 10 0
T_PLANT_PROJECTED_OUTS_TMP 10 0
T_PLANT_PROPERTIES 2 0
T_PLANT_RESOURCE_AVAIL 8 0
T_PLANT_RESOURCE_AVAILA 8 0
T_PLANT_RESOURCE_DETAILS 35 0
T_PLANT_RESOURCE_DETAILS_TMP 35 0
T_PLANT_RESOURCE_REQUIREMENTS 60 0
T_PLANT_RESOURCE_REQUIREMENTSA 60 0
T_PLANT_RESOURCE_USED 35 0
T_PLANT_RESOURCE_USED_TMP 35 0
T_PLANT_SALES_ORDERS 5 0
T_PLANT_SUPPLY_RESOURCES 24 0
T_PLANT_TREND_DETAILS 23 0
T_PLANT_TREND_DETAILS_TEMP 23 0
T_PLANT_TREND_DETAILS_TEMPA 23 0
T_PLANT_WEEK_DATES 6 0
T_PREV_OPERATIONS 7 0
T_PREV_OPERATIONS_API 9 0
T_PRICING_API 1 9 0
T_PROPERTY_DESTINATIONS 6 428
T_PROPERTY_LOTS 1 5 17,600
T_PROPERTY_SOURCES 7 454
T_REASON_ACCOUNTS 7 0
T_RESOURCE_DEPARTMENT_API 19 12
T_RESOURCE_OVERHEAD_API 18 10
T_RESOURCE_PROPERTIES 4 0
T_RESOURCE_PROPERTIES_API 4 0
T_RESOURCE_RATE_API 18 37
T_RMA_STG_TRANSACTIONS 24 501
T_ROUTING_CMPL_PROPERTIES_API 7 19
T_ROUTING_FACTORY_SETUP 4 9
T_ROUTING_OPEARTIONS_TAB_LOV_V 12 view
T_ROUTING_OPERATIONS 21 899
T_ROUTING_OPERATIONS_API 21 6,814
T_ROUTING_OPERATIONS_V 25 view
T_ROUTING_PROPERTIES 3 0
T_ROUTING_PROPERTIES_API 3 0
T_ROUTINGS 24 293
T_ROUTINGS_API 27 2,749
T_ROUTINGS_V 23 view
T_RTG_STG_API 22 122
T_RTG_STG_DTL_API 27 687
T_SAP_DEMAND_ELEMENTS 1 3
T_SDM_AP_SUPPLIER_CONTACTS 53 5
T_SDM_AP_SUPPLIER_SITES_ALL 165 3
T_SDM_AP_SUPPLIERS 181 4
T_SDM_EXTPMT_METHODS_ATTR 2 44 579
T_SDM_ORGANIZATION_PROFILE 1 39 1,188
T_SDM_PARTY_SITES 1 2 21 2,655
T_SDM_TAX_FISCAL_CLASS 2 19 0
T_SDM_TAX_REPORTING_CODES 2 20 0
T_SDM_VENDOR_CONTACT_POINTS 1 21 0
T_SDM_VENDOR_CONTACTS 1 43 5,646
T_SDM_VENDOR_PRODUCTS_SERVICES 1 15 0
T_SDM_VENDOR_SITE_RELATIONS 2 23 2,250
T_SDM_VENDOR_SITES 5 2 108 2,729
T_SDM_VENDOR_TAX_REGISTRATIONS 2 31 0
T_SDM_VENDORS 11 80 2,471
T_SEGMENT_QUALIFIER_ATTRIBUTES 1 6 420
T_SELECTED_LOT_WAFER_ID 9 0
T_SETUP 8 0
T_SFDC_PRODUCT_INFORMATION_API 1 8 2
T_SITE_MAINTENANCE 6 30
T_STATE_STEP_MAPPINGS 1 4 4
T_STD_OPERATION_RESOURCES 29 0
T_STD_OPERATIONS 34 0
T_SUPPLIER_OPERATION_MAPPING 20 0
T_SUPPLY_DRILLDOWN_API 12 24,304
T_SUPPLY_DRILLDOWN_API_V 17 view
T_SUPPLY_DRILLDOWN_DIT_API 14 26
T_SUPPLY_DRILLDOWN_INV_API 15 925
T_SUPPLY_DRILLDOWN_INV_API_V 17 view
T_SUPPLY_DRILLDOWN_WIP_API 20 475
T_SUPPLY_DRILLDOWN_WIP_API_V 22 view
T_SUPPLYDEMAND_DATA_API 11 24,304
T_SUPPLYDEMAND_KEYS_API 11 23,839
T_SUPPLYDEMAND_MAIN_V 16 view
T_TAB_COLUMNS 3 645
T_TEMP_SQL 2 0
T_TLS_ADJPLN_DATES 2 0
T_TLS_ALLOCATED_LOTS_API 22 0
T_TLS_ALLOCATED_LOTS_API_TEMP 25 0
T_TLS_EXCEPTIONS 18 0
T_TLS_OSP_BOM_LEVELS 2 0
T_TLS_OSP_PURCHASE_ORDERS 6 0
T_TLS_PO_DETAILS 3 0
T_TLS_POP_IM_DATA 20 0
T_TLS_PRICES 6 0
T_TLS_PROD_PLAN_HEADERS 8 0
T_TLS_PROD_PLAN_LINES 51 0
T_TLS_PROPERTIES 23 0
T_TLS_SETUP 10 0
T_TLS_TRANSACTION_DETAILS 41 0
T_TLS_TRANSACTION_TYPES 4 0
T_TLS_WAFER_ID_API 3 0
T_TLS_WAFER_ID_API_TEMP 5 0
T_TPM_BOM_COPY_COMPS_TEMP 57 36,062
T_TPM_BOM_COPY_CROSSREFS 11 0
T_TPM_BOM_COPY_SUBS_TEMP 9 970
T_TPM_BOM_COPY_TEMP 36 14,678
T_TPM_LOOKUP_VALUES 34 18
T_TPM_STANDARD_CONFIG 6 47
T_TR_SUPPLIER_DATA_TEMP 27 0
T_UPDATE_LINE_STATUS 2 0
T_VALIDATE_RESOURCES 6 0
T_VALUE_ID 1 1
T_VENDOR_PARTS_API 1 1 28 6,328
T_VENDOR_PARTS_PROPERTIES_API 1 4 11,955
T_WAFER_ID 19 0
T_WSH_MAILS 13 0
T_WSM_WIP_TEMP 68 0
TEST_A 5 0
TEST_B 5 0
TEST_C 5 0
TEST_V 1 view
VW_ETK_BOM_ITEMS 28 view
VW_ETK_BOM_ITEMS_P 22 view
VW_ETK_BOMS 34 view
VW_ETK_ITEM_PROPERTIES 3 view
VW_ETK_ITEM_VENDOR_PARTS 24 view
VW_HR_LOCATIONS_APP_HIST 5 view
XX_DEMO_SUPPLIER_DATA_TEMP 33 0
XX_ERROR_MESSAGES 8 0
XX_LOCTTRXN 13 0
XX_LOT_TXN_DETAILS 12 0
XX_LOTTRXN 15 0
XX_ORDER_LOT_DETAILS 26 0
XX_PICK_RECORD_TEMP 8 0
XX_PICKORDER_LOT_DETAILS 35 0
XX_RESERV_ITEMLOTS 7 0
XX_SERIAL_NUMBER 27 0
XX_SHIPPING_PROCESS 20 0
XX_T_PICK_DETAILS 34 0
XX_T_XXSHIPCONFIRM 15 0
XX_WSH_DOC_NUM 2 0
XXARENA_MFG_SUP 30 view
XXMSC_CROSS_REFERENCES 6 0
XXMSC_INVENTORY_LEAD_TIME 11 0
XXMSC_SUPPLIES 190 0
XXT_GL_INTERFACE 139 12
           
369 Tables     8,446 4,042,835  
18 Views     334