Database Table BlogEntry2

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

The BlogEntry2 table holds blog entries for threads and users.

Fields
UserIdINTReference to Employee: id of the user who created the entry or was the last to update it.UserIdINTReference to Employee: id of the user who created the entry or was the last to update it.

Field name

Type

Note

Description

Id

INT

Primary Key

Internal unique id

ThreadId

INT

Foreign key to the BlogThread

Reference to BlogThread (identies the thread the entry is part of)

Userid

int

Foreign key to employee

Link to the user who created the entry or was the last to update it.

CreatedDateTime

DATETIME

Date/time the entry was created

UpdatedDateTime

DATETIME

Date/time for latest update of entry

BlogText

TEXT

The text of the blog entry.