Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
エントリID (UUIDv7) |
||||
| team_goal_id | CHAR | 36 | null |
|
|
チーム目標ID |
||||
| delta_value | DOUBLE | 22 | null |
|
|
差分値 |
||||
| note | VARCHAR | 100 | √ | null |
|
|
メモ |
|||
| recorded_at | DATE | 10 | null |
|
|
記録日 |
||||
| created_at | BIGINT UNSIGNED | 20 | null |
|
|
作成日時（UNIX秒） |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_team_goal_actual_entries_goal_id | Performance | Asc | team_goal_id |
| idx_team_goal_actual_entries_recorded_at | Performance | Asc/Desc | team_goal_id + recorded_at |
Relationships
Close relationships within degrees of separation
