Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DocumentType | Unknown | 0 | null |
|
|
Document type - Type of document being drafted |
||
| DraftContent | Unknown | 0 | null |
|
|
Draft content - Content of the draft document |
||
| DraftID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each draft entry |
|
| EntryType | varchar | 20 | √ | null |
|
|
Entry type - Type of entry this draft represents (Form, Document, etc.) |
|
| EntryID | int | 4 | √ | null |
|
|
Entry reference - ID of the entry this draft is associated with |
|
| Content | ntext | 1073741823 | √ | null |
|
|
Draft content - The actual draft content in text format |
|
| UserID | int | 4 | √ | null |
|
|
User reference - Links to AccessUser table for the draft creator |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the draft was created |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| ConnectionId | int | 4 | √ | null |
|
|
Connection ID - Connection identifier for session management |
|
| CreatedBy | Unknown | 0 | null |
|
|
Created by user - UserID of the person who created the draft |
||
| ExpirationDate | Unknown | 0 | null |
|
|
Expiration date - Date when the draft expires if not finalized |
||
| Unknown | 0 | null |
|
|
Shared flag - Boolean indicating if the draft is shared with other users |
|||
| LastModified | Unknown | 0 | null |
|
|
Last modified date - Date when the draft was last updated |
||
| ModifiedBy | Unknown | 0 | null |
|
|
Modified by user - UserID of the person who last modified the draft |
||
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update date - Date when the draft was last updated |
|
| SessionID | varchar | 50 | √ | null |
|
|
Session ID - User session identifier for draft tracking |
|
| ParentID | int | 4 | √ | null |
|
|
Parent draft reference - Links to parent draft for hierarchical drafts |
|
| Unknown | 0 | null |
|
|
Share permissions - Permissions for users who have access to the shared draft |
|||
| Status | Unknown | 0 | null |
|
|
Draft status - Current status of the draft (In Progress, Ready for Review, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Draft | Primary key | Asc | DraftID |
| IX_DraftEntry | Performance | Asc/Asc | EntryType + EntryID |
| IX_DraftUser | Performance | Asc | UserID |
Relationships
Close relationships within degrees of separation
