Table: Valid_Date
The Valid_Date table holds all of the dates between 1900-01-01 and 2079-01-01 inclusive. Having these dates makes it convenient to join against for generating ranges.
Tags: read-only

Content of first 30 of 65380 rows:
1900-01-01T00:00:001
1900-01-02T00:00:002
1900-01-03T00:00:003
1900-01-04T00:00:004
1900-01-05T00:00:005
1900-01-06T00:00:006
1900-01-07T00:00:007
1900-01-08T00:00:008
1900-01-09T00:00:009
1900-01-10T00:00:0010
1900-01-11T00:00:0011
1900-01-12T00:00:0012
1900-01-13T00:00:0013
1900-01-14T00:00:0014
1900-01-15T00:00:0015
1900-01-16T00:00:0016
1900-01-17T00:00:0017
1900-01-18T00:00:0018
1900-01-19T00:00:0019
1900-01-20T00:00:0020
1900-01-21T00:00:0021
1900-01-22T00:00:0022
1900-01-23T00:00:0023
1900-01-24T00:00:0024
1900-01-25T00:00:0025
1900-01-26T00:00:0026
1900-01-27T00:00:0027
1900-01-28T00:00:0028
1900-01-29T00:00:0029
1900-01-30T00:00:0030
Columns
NameTypeConstraintsDescription
valid_datesmalldatetimeNOT NULLHolds a date without a time set (stored as midnight.)
valid_date_KEYintNOT NULLKey for backwards compatibility. Should be the number of days since 1989-12-31.
Primary key
NameColumnsDescription
PK_Valid_Date$valid_datevalid_dateCLUSTERED

Schema diagram