Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ActivityID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each activity note record |
|
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation date - Timestamp when the note was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the note |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Timestamp of the most recent note update |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the note |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| UserID | int | 4 | √ | null |
|
|
User reference - Links to AccessUser table for the note author |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ActivityNotes | Primary key | Asc | ActivityID |
Relationships
Close relationships within degrees of separation
