DTW_BST_DIM_DATE


Description

Entry date dimension definition table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DATE_ID INT 10 null
DTW_BST_FACT_BALANCE.ENTRY_DATE_ID DTW_BST_FK_FACT_BALANCE_DATE R
DTW_BST_FACT_ENTRY.ENTRY_DATE_ID DTW_BST_FK_FACT_ENTRY_DATE R
DTW_BST_FACT_ENTRY.EVENT_DATE_ID DTW_BST_FK_FACT_EVENT_DATE R

Entry full date unique ID (year+month+day+hour).
YEAR INT 10 null

Date year number.
MONTH INT 10 null

Date month number
DAY INT 10 null

Date day number.
MONTH_NAME VARCHAR 10 null

Full month name.
DAY_OF_WEEK VARCHAR 10 null

Any one of the seven days in a week.
QUARTER INT 10 null

Quarter number (1, 2, 3).
SEMESTER INT 10 null

Semester number (1, 2).
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

Timestamp value to register a record creation time.
UPDATED_AT DATETIME 26 √ CURRENT_TIMESTAMP(6)

Timestamp value to register a record update time.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc DATE_ID

Relationships

Close relationships within degrees of separation