JobPosts
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SalaryMin | money | yes | ||
| SalaryMax | money | yes | ||
| Guid | uniqueidentifier | Default = (newid()) | ||
| PostedByID | int | |||
| PostedOn | datetime | Default = getutcdate() | ||
| ShowMyInfo | bit | Default = 0 | ||
| Approved | bit | Default = 0 | ||
| HideCompanyInfo | bit | Default = 0 | ||
| Title | nvarchar(510) | yes | ||
| Description | ntext | yes | ||
| CompanyName | nvarchar(510) | yes | ||
| Division | nvarchar(300) | yes | ||
| City | nvarchar(100) | yes | ||
| State | nvarchar(4) | yes | ||
| Country | nvarchar(6) | yes | ||
| nvarchar(510) | yes | |||
| URL | nvarchar(2048) | yes | ||
| AdditionalInfo | nvarchar(2048) | yes | ||
| County | nvarchar(100) | yes | ||
| ApprovedDate | datetime | yes | ||
| UpdateDate | datetime | yes | Default = getutcdate() | |
| CreateDate | datetime | yes | Default = getutcdate() |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ProfessionCodeID | int | ProfessionCodes.ID | ||
| JobBoardID | int | JobBoards.ID | ||
| ApprovedID | int | yes | ClientUsers.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_JobPosts_3 | PostedOn | |||
| IX_JobPosts_4 | City | |||
| IX_JobPosts_5 | State | |||
| IX_JobPosts_6 | Country | |||
| IX_JobPosts_7 | Title | |||
| IX_JobPosts_8 | CompanyName | |||
| IX_JobPosts_9 | PostedByID | |||
| IX_JobPosts_JobBoardID | JobBoardID | |||
| IX_JobPosts_ProfessionCodeID | ProfessionCodeID | |||
| PK_JobPosts | ID | yes | yes | yes |