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