| SchemaSpy Analysis of odyssey_test._watiam | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Feb 19 10:32 EST 2014 | |
| Database Type: PostgreSQL - 9.2.4 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| check_duplicate_hr_id | 2 | view | HR IDs which occur more than once in the Extract | ||
| check_duplicate_ts_id | 2 | view | TS IDs which occur more than once in the Extract | ||
| check_duplicate_uw_id | 2 | view | UW IDs which occur more than once in the Extract | ||
| watiam_dept_name | 1 | 3 | 395,219 | ||
| watiam_dept_num | 1 | 3 | 103,547 | ||
| watiam_entry | 7 | 20 | 395,220 | Information from one line of the WatIAM Extract | |
| watiam_hr_id | 1 | 3 | 105,849 | ||
| watiam_office | 1 | 3 | 18,819 | ||
| watiam_phone | 1 | 3 | 117,907 | ||
| watiam_ts_id | 1 | 3 | 220 | ||
| watiam_uw_id | 1 | 3 | 364,258 | ||
| 8 Tables | 41 | 1,501,039 | |||
| 3 Views | 6 |