Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pk_ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each ticket follow relationship, auto-incrementing integer |
|
| TicketID | int | 4 | √ | null |
|
|
Ticket reference - Foreign key linking to CentralizedTicket.TicketID for the ticket being followed |
|
| UserID | int | 4 | √ | null |
|
|
Follower user ID - Reference to user who is following this ticket |
|
| CompanyID | int | 4 | √ | null |
|
|
Company reference - Reference to company for multi-tenant follow management |
|
| varchar | 100 | √ | null |
|
|
Notification email - Email address for sending follow notifications |
||
| FollowedDate | datetime | 16,3 | √ | null |
|
|
Follow start timestamp - When the user started following this ticket |
|
| FollowedBy | int | 4 | √ | null |
|
|
Follow initiator - User ID who initiated the follow relationship |
|
| UnFollowedDate | datetime | 16,3 | √ | null |
|
|
Unfollow timestamp - When the user stopped following this ticket |
|
| UnFollowedBy | int | 4 | √ | null |
|
|
Unfollow initiator - User ID who removed the follow relationship |