Table: dbo.Minimum_Wage
Columns
NameTypeConstraintsDescription
minimum_wage_KEYint (4)NOT NULLPrimary key for the Minimum_Wage table.
ste_state_code_KEYnvarchar (4)NOT NULLState code for this entry.
local_identifiernvarchar (20)NOT NULLOptional local identifier - used when local minimum wage is different than state.
minimum_wagedecimal (5, 2)NOT NULLMinimum wage for this state (or federal).
starting_effective_datesmalldatetime (4)NOT NULLStarting date this wage is in effect.
local_identifier_descriptionnvarchar (130)Name of the locality defined by the local identifier.
Primary key
NameColumnsDescription
PK_Minimum_Wageminimum_wage_KEY
Unique constraints
NameColumnsDescription
UK_Minimum_Wage$ste_state_code_KEY$local_identifier$starting_effective_dateste_state_code_KEY, local_identifier, starting_effective_date
Foreign keys
NameColumnsReferenced tableDescription
FK_Minimum_Wage__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram