Ticket (v2)
A ticket within a board, ordered by sorting then start date descending
Change Note: added background_color, board is referenced by id (board_id)
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | ticket id (primary key) |
| 1 | title | string | ticket title |
| 2 | who | string | who created the ticket |
| 3 | state | string | current state (references TicketState.name) |
| 4 | board_id | int | id of the board this ticket belongs to (references TicketBoard.id) |
| 5 | start_dt | datetime | creation timestamp |
| 6 | end_dt | datetime | resolution timestamp, empty if unresolved |
| 7 | archived | int | 0=active, 1=archived |
| 8 | sorting | int | sort order within state (lower = higher priority) |
| 9 | description | string | ticket description text |
| 10 | background_color | string | card background color (hex or CSS name), empty = default |