Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| month_date | date | 13 | √ | null |
|
|
A date representing the first day of the month |
|
| month | float8 | 17,17 | √ | null |
|
|
The ordinal number of the month in the year. Eg. January = 1, February = 2, March = 3, etc. |
|
| quarter | float8 | 17,17 | √ | null |
|
|
The quarter number that the month falls in. Jan-Mar = 1, Apr-June = 2, Jul-Sept = 3, Oct-Dec = 4 |
|
| year | float8 | 17,17 | √ | null |
|
|
The calendar year |
|
| month_string | text | 2147483647 | √ | null |
|
|
A human readable version of the month in YYYY-MM format |
|
| quarter_string | text | 2147483647 | √ | null |
|
|
A human readable version of the quarter that the month is in, in YYYY-Q format |
Relationships
Close relationships within degrees of separation
