rca_document

Stores information about the review document and supporting documents for a review instance.

Field name (Key)

Field data type

Purpose

id (PRI)

varchar(255)

The document identifier.

name

varchar(255)

The file name of the document.

contentType

varchar(255)

The content type of the document.

type

varchar(255)

The document type. Possible values for this column are REF and DOCUMENT. Review documents are a value of DOCUMENT.

Use REF for public URLs and DOCUMENT for supporting documents hosted in review zone. Supporting document can be a reference to any public URL or a document hosted in review zone.

uri

varchar(255)

The URI of the document.

description

varchar(255)

The description of the document.

reviewContext (MUL)

varchar(255)

The foreign key to parent record in review context table.

documentNo

int(11)

The index used to access a list of documents. The field is a generated value used for internal purposes.

// Ethnio survey code removed