| 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) | |