Table: dbo.Minimum_Wage
Columns
Name | Type | Constraints | Description
minimum_wage_KEY | int (4) | NOT NULL | Primary key for the Minimum_Wage table.
ste_state_code_KEY | nvarchar (4) | NOT NULL | State code for this entry.
local_identifier | nvarchar (20) | NOT NULL | Optional local identifier - used when local minimum wage is different than state.
minimum_wage | decimal (5, 2) | NOT NULL | Minimum wage for this state (or federal).
starting_effective_date | smalldatetime (4) | NOT NULL | Starting date this wage is in effect.
local_identifier_description | nvarchar (130) |  | Name of the locality defined by the local identifier.

Primary key
Name | Columns | Description
PK_Minimum_Wage | minimum_wage_KEY |
Unique constraints
Name | Columns | Description
UK_Minimum_Wage$ste_state_code_KEY$local_identifier$starting_effective_date | ste_state_code_KEY, local_identifier, starting_effective_date |

Foreign keys
Name | Columns | Referenced table | Description
FK_Minimum_Wage__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |