Open topic with navigation

JobBoards (4.0SP4)

Primary Key
Primary Key Field Type

ID

int
Foreign Key Fields
Foreign Key Field Type Null Notes Description

SiteContentID

int

false

Fields
Field Field Type Null Notes Description

RequiresApproval

bit

false

0

Guid

uniqueidentifier

false

(newid())

JobBoardName

nvarchar(510)

true

LegendText

nvarchar(510)

true

SearchLinkText

nvarchar(300)

true

SearchLegendText

nvarchar(510)

true

PostLinkText

nvarchar(300)

true

PostLegendText

nvarchar(510)

true

PostJobLegend

nvarchar(510)

true

Indexes
Index Name Field(s) Unique Primary Clustered

IX_JobBoards_1

JobBoardName

False

False

False

IX_JobBoards_GUID

Guid

False

False

False

IX_JobBoards_SiteContentID

SiteContentID

False

False

False

PK_JobBoards

ID

True

True

True
Referenced by
Referenced by Field

JobPosts

JobBoardID