Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkStickyNoteID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each sticky note |
|
| fkSubTabID | int | 4 | √ | null |
|
|
Sub-tab reference - Links to the sub-tab or interface section where the note appears |
|
| linkID | int | 4 | √ | null |
|
|
Linked record ID - Identifier of the record that this sticky note is associated with |
|
| noteDesc | varchar | 500 | √ | null |
|
|
Note description - Text content of the sticky note |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the sticky note was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the sticky note |
|
| newNote | int | 4 | √ | null |
|
|
New note flag - Numeric indicator for new or unread sticky notes |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__stickyNote__25290593 | Primary key | Asc | pkStickyNoteID |
Relationships
Close relationships within degrees of separation
