The ARF_TIME_DAY table is used to store the day part of an instant. There is one row for each day in one year.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | varchar | 40 | No | Identifier; primary key. |
WEEK_ID | varchar | 40 | No | Foreign key to ARF_TIME_WEEK.ID column. |
MONTH_ID | varchar | 40 | No | Foreign key to ARF_TIME_MONTH.ID column. |
DOW_ID | varchar | 40 | No | Foreign key to ARF_CAL_DOW.ID column. |
DAY_TIMESTAMP | timestamp | No | Timestamp representing the beginning of the day. | |
DAY_OF_WEEK | tinyint | No | Integer between 1 and 7, the number of the day within the week. | |
DAY_OF_MONTH | tinyint | No | Integer between 1 and 31, the number of the day within the month. | |
DAY_OF_YEAR | smallint | No | Integer between 1 and 366, the number of the day within the year. |