public.date
| Documentation | Tickit |
| Name | date |
| Module | Tickit diagram |
Each row represents a day in the calendar year.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | dateid | smallint | public.sales | Primary key, a unique ID value for each row. Each row represents a day in the calendar year | ||||
| Primary key, a unique ID value for each row. Each row represents a day in the calendar year References: public.sales |
||||||||
| 2 | caldate | date | Calendar date, such as 2008-06-24. | |||||
| Calendar date, such as 2008-06-24. |
||||||||
| 3 | day | character(3) | Day of week (short form), such as SA. | |||||
| Day of week (short form), such as SA. |
||||||||
| 4 | week | smallint | Week number, such as 26. | |||||
| Week number, such as 26. |
||||||||
| 5 | month | character(5) | Month name (short form), such as JUN. | |||||
| Month name (short form), such as JUN. |
||||||||
| 6 | qtr | character(5) | Quarter number (1 through 4). | |||||
| Quarter number (1 through 4). |
||||||||
| 7 | year | smallint | Four-digit year (2008). | |||||
| Four-digit year (2008). |
||||||||
| 8 | holiday | boolean | Default: false | Flag that denotes whether the day is a public holiday (U.S.). | ||||
| Flag that denotes whether the day is a public holiday (U.S.). Default: false |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| public.date | public.sales | public.date.dateid = public.sales.dateid | fk_date_sales | |
|
public.date.dateid = public.sales.dateid Name: fk_date_sales |
||||
| public.event | public.date | public.event.eventid = public.date.dateid | fk_date_event | |
|
public.event.eventid = public.date.dateid Name: fk_date_event |
||||
| public.listing | public.date | public.listing.dateid = public.date.dateid | fk_date_listing | |
|
public.listing.dateid = public.date.dateid Name: fk_date_listing |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| pk_date | dateid |
Uses
| Name |
|---|
|
public.date
|
Used by
| Name |
|---|
|
public.date
|
Exported: 2018-10-12 23:27, Last imported: 2018-10-01 10:44