Date_dim - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: Date_dim

Columns

PKNameData TypeNULLAutoDefaultCommentFK

DateIDBigInt

Primary internal key unique identifier for date records.
DateDate Date in YYYY-MM-DD format.
YearNChar(4)

Help query all water allocations per a calander year. E.g., how many water allocations files in Utah per year since 1850

Indexes

(none)


Foreign Keys

(none)


Triggers

(none)


Used in Diagrams

Diagram Name
1_WaterAllocations
2_SiteSpecificAmounts
3_AggregatedAmounts
4_RegulatoryInfo