Table to store day information. Every day of the year for which Performance Data was loaded will have a row in this table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| day_id | integer | not null | Day identifier. |
| day_of_week | integer1 | not null | Day of week. Sun = 1, Mon = 2, Tue = 3, Wed = 4, Thu = 5, Fri = 6, Sat = 7 |
| day_of_month | integer1 | not null | Day of month. Range: 1 - 31 |
| day_of_year | smallint | not null | Day of year. Range: 1 - 366 |
| week_of_year | integer1 | not null | Week of year. Range: 0 - 52 |
| month_of_year | integer1 | not null | Month of Year. Range: 1 - 12 |
| quarter_of_year | integer1 | not null | Quarter of year. Range: 1 - 4 |
| current_year | smallint | not null | Year as in 2004. |
| current_date | nvarchar(11) | not null | Date without time as in 'yyyy-mm-dd'. Note this is not a date column. |
| current_date_int | integer | not null | The column stores time interval in seconds between 1st Jan 1970 and the current date. |
Product Name: Unicenter Network and System Management/System Performance
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| day_id | pd_val_10min | machine_id |
| day_id | pd_val_8hr | machine_id |
| day_id | pd_val_6hr | machine_id |
| day_id | pd_val_5min | machine_id |
| day_id | pd_val_4hr | machine_id |
| day_id | pd_val_1month | machine_id |
| day_id | pd_val_1min | machine_id |
| day_id | pd_val_1hr | machine_id |
| day_id | pd_val_1day | machine_id |
| day_id | pd_val_15min | machine_id |
| day_id | pd_val_12hr | machine_id |
| day_id | pd_val_3hr | machine_id |
| day_id | pd_val_30min | machine_id |
| day_id | pd_val_2hr | machine_id |
| day_id | pd_val_20min | machine_id |
| day_id | pd_val_1year | machine_id |
| day_id | pd_val_1week | machine_id |