Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkQaNoteID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each quality assurance note |
|
| fkQaNoteCategoryID | int | 4 | √ | null |
|
|
Category reference - Links to QaNoteCategory table for the QA note classification |
|
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Reference to the specific field or data element being reviewed in the QA process |
|
| Notes | nvarchar | 1073741823 | √ | null |
|
|
QA notes content - Detailed quality assurance notes, observations, and review comments |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when the QA note was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who created this QA note |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when the QA note was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this QA note |
|
| Approved | bit | 1 | √ | null |
|
|
Approval status - Boolean flag indicating whether the QA note has been approved |
|
| fkReportID | int | 4 | √ | null |
|
|
Report reference - Links to associated report or documentation that this QA note relates to |
|
| ApprovedBy | int | 4 | √ | null |
|
|
Approver reference - Links to AccessUser table for the user who approved this QA note |
|
| DateApproved | smalldatetime | 16 | √ | null |
|
|
Approval timestamp - Date and time when the QA note was approved |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_QaNotes | Primary key | Asc | pkQaNoteID |
Relationships
Close relationships within degrees of separation
