The ARF_TIME_WEEK table stores the week part of an instant. There is one row for each week of each year of interest for reporting.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | varchar | 40 | No | Identifier; primary key. |
YEAR_ID | varchar | 40 | No | Foreign key to ARF_TIME_YEAR.ID column. |
WEEK_OF_YEAR | tinyint | No | Integer between 1 and 53, the number of the week within the year. | |
WEEK_TIMESTAMP | timestamp | No | A timestamp representing the beginning of the week. |