Id

INT

Primary Key

Internal unique id

CreatedDateTime

DATETIME

Date and time reference was created

CreatedBy

INT

Reference to Employee: id of user who created the reference

UpdatedDateTime

DATETIME

Date and time reference was updeated

UpdatedBy

INT

Reference to Employee: id of user who updated the reference

DeletedDateTime

DATETIME

Date and time the reference was deleted

DeletedBy

INT

Reference to Employee: id of user who deleted the reference

DateFrom

DATETIME

The date the reference becomes valid.

DateTo

DATETIME

The date the reference is no longer valid.

RefType

INT

Foreign key to DocRefType

Type of document reference

RefStatus

INT

Foreign key to DocRefStatus

NB: currently not used

ReleasedForSurvey

BIT

Whether or not the document reference is released for survey

Title

VARCHAR(2000)

Title of document reference

Description

VARCHAR(MAX)

Description of document reference

ContentType

INT

Foreign key to DocRefContentType

Reference to DocRefContentType: type of document the reference references. 1: Physical (specify Location) 2: Online document outside the database (specify URL) 3: Upload document (stored in database - specify DocumentId)

Location

VARCHAR(1000)

Location of physical document (used only when ContentType=1)

Url

varchar(1000)

Url to the document referenced (used only when ContentType = 2)

Documentid

int

Foreign key to Document

Tabel Document contains the (binary) content of uploaded document (used only when ContentType = 3)

ReplacesId

INT

Reference to DocRef (self-reference)

This docref replaces earlier version with this id

ReplacedById

INT

Reference to DocRef (self reference)

This docref is replaced by later version with this id