| SchemaSpy Analysis of BDNA_PUBLISH.dboBDNA_Normalize_pbulish_ERD SQL Server | Generated by SchemaSpy |
| Generated by SchemaSpy on Thu Oct 04 14:29 PDT 2012 | |
| Database Type: Microsoft SQL Server - 10.50.1617 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Comments |
|---|---|---|---|---|
| bdna_logger_tb | 4 | Logging table for Normalize task | ||
| CAT_CPU_PRODUCT | 1 | 6 | CPU information table | |
| CAT_HARDWARE_LIFECYCLE | 1 | 9 | Hardware lifecylce table | |
| CAT_HARDWARE_MODEL | 2 | 3 | 48 | Hardware model information table |
| CAT_HARDWARE_PRODUCT | 2 | 2 | 5 | Hardware information table |
| CAT_HW_MODEL_PROFILE | 4 | 15 | Hardware model profile information table | |
| CAT_MANUFACTURER | 7 | 16 | Manufacturer information table | |
| CAT_SOFTWARE | 4 | 2 | 10 | Software information table |
| CAT_SOFTWARE_EDITION | 1 | 2 | 5 | Software Edition information table |
| CAT_SOFTWARE_LIFECYCLE | 1 | 9 | Software lifecylce table | |
| CAT_SOFTWARE_RELEASE | 3 | 5 | 18 | Software release information table |
| CAT_SOFTWARE_VERSION | 1 | 2 | 7 | Software Version table with patch level info |
| CAT_SUPPORT_POLICY | 1 | 1 | 4 | Support Policy information table |
| CAT_SUPPORT_STAGE | 1 | 1 | 5 | Support stage information table |
| CAT_SW_REL_PLATFORM | 1 | 5 | Software release platform information table | |
| CAT_SW_REL_SUPP_STAGE | 2 | 8 | Release Support stage information table | |
| CAT_SW_VERSION_GROUP | 2 | 1 | 4 | Software Version Group table |
| CAT_TAXONOMY | 5 | 6 | Taxonomy table | |
| CAT_TECHNOPEDIA_VERSIONS | 7 | Technopedia versions table | ||
| DISC_ALL_OS | 27 | 5 | 35 | Has Discovered Operating Systems information |
| DISC_CDROMS | 3 | 10 | Has Discovered CD ROMs information | |
| DISC_COMPUTERSYSTEM | 3 | 5 | 8 | Has Discovered Computer Systems information |
| DISC_CONSOLE_USAGE_MAXGROUP | 9 | Has Discovered Console usage information | ||
| DISC_CONSOLE_USER | 11 | Has Discovered Console user information | ||
| DISC_CPUS | 3 | 16 | Has Discovered CPU information | |
| DISC_CS_CAT_MAP | 5 | 10 | Has Discovered Computer system to Catalog Mappping information | |
| DISC_DISK_PARTITIONS | 3 | 11 | Has Discovered Disk Partiions information | |
| DISC_GUID | 4 | Has Discovered GUID information | ||
| DISC_HDDS | 3 | 16 | Has Discovered Hard Disc information | |
| DISC_HOSTS | 15 | 2 | 8 | Has Discovered Hosts information |
| DISC_LOGICAL_DISKS | 3 | 17 | Has Discovered Logical Disks information | |
| DISC_OS_CAT_MAP | 2 | 10 | Has Discovered Operating system to Catalog Mappping information | |
| DISC_VIDEO_CONTROLLERS | 3 | 18 | Has Discovered Video Controllers information | |
| DISC_WINDOWS_MONITORS | 3 | 20 | Has Discovered Windows Monitors information | |
| DISC_WINDOWS_NICS | 3 | 24 | Has Discovered Network Interface Cards information | |
| DISC_WINDOWS_SERVICES | 3 | 12 | Has Discovered Windows Services information | |
| MATCH_ALL_ADDREMOVE | 2 | 9 | Has Matched AddRemove information | |
| MATCH_ALL_EXE | 2 | 14 | Has Matched Exe information | |
| MATCH_HOST_HW_PROD_MODEL | 2 | 59 | Has Matched Host-Hardware Model information | |
| MATCH_HOST_SW_PROD | 5 | 32 | Has Matched Host-Software information | |
| MATCH_HOST_SW_PROD_DET | 5 | 24 | Has Matched Host-Software detailed information | |
| MATCH_INVENTORY | 12 | 6 | Has Inventory information | |
| MATCH_SOFTWARE_METERING | 5 | 22 | Has Matched Software Metering information | |
| MATCH_STATS | 11 | Has Matched statistics information for Addremove/Exe information | ||
| MATCH_TASK_DET | 11 | 1 | 10 | Has Normalize task details information |
| 45 Tables | 617 | |||
| 0 Views | 0 |