Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pk_ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each vote record, auto-incrementing integer |
|
| TicketID | int | 4 | √ | null |
|
|
Ticket reference - Foreign key linking to CentralizedTicket.TicketID for the ticket being voted on |
|
| UserID | int | 4 | √ | null |
|
|
Voter user ID - Reference to user who cast the vote |
|
| CompanyID | int | 4 | √ | null |
|
|
Company reference - Reference to company for multi-tenant vote management |
|
| Votes | bit | 1 | √ | null |
|
|
Vote value - Boolean indicating positive (true) or negative (false) vote |
|
| VotedDate | datetime | 16,3 | √ | null |
|
|
Vote timestamp - When the vote was cast for chronological tracking |