Database Table OrgUnitBlogThread

[This is preliminary documentation and is subject to change.]

The OrgunitBlogThread holds data about relationships between orgunits and blogthreads

Fields
OrgUnitTypeVARCHAR(20)Reference to OrgUnit - part of primary keyOrgUnitCodeVARCHAR(20)Reference to OrgUnit - part of primary keyBlogThreadIdINTReference to BlogThread - part of primary keyOrgUnitTypeVARCHAR(20)Reference to OrgUnit - part of primary keyOrgUnitCodeVARCHAR(20)Reference to OrgUnit - part of primary keyBlogThreadIdINTReference to BlogThread - part of primary key

Field name

Type

Note

Description

OrgunitType

varchar(20)

Part of primary key and foreigh key to Orgunit

Along with orgunitCode foreign key to the organizational unit field the phrase is made available for.

OrgunitCode

varchar(20)

Part of primary key and foreigh key to Orgunit

Along with orgunitType foreign key to the organizational unit field the phrase is made available for.

ThreadId

int

Foreign key to the BlogThread

Link to the thread the entry is part of