JobBoards
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| RequiresApproval | bit | Default = 0 | ||
| Guid | uniqueidentifier | Default = (newid()) | ||
| JobBoardName | nvarchar(510) | yes | ||
| LegendText | nvarchar(510) | yes | ||
| SearchLinkText | nvarchar(300) | yes | ||
| SearchLegendText | nvarchar(510) | yes | ||
| PostLinkText | nvarchar(300) | yes | ||
| PostLegendText | nvarchar(510) | yes | ||
| PostJobLegend | nvarchar(510) | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SiteContentID | int | SiteContent.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_JobBoards_1 | JobBoardName | |||
| IX_JobBoards_GUID | Guid | |||
| IX_JobBoards_SiteContentID | SiteContentID | |||
| PK_JobBoards | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| JobPosts | JobBoardID |