Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| sequence | BIGINT UNSIGNED | 20 | √ | null |
|
|
|||||
| uuid | CHAR | 36 | null |
|
|
||||||
| batch_id | CHAR | 36 | null |
|
|
||||||
| family_hash | VARCHAR | 255 | √ | null |
|
|
|||||
| should_display_on_index | BIT | 1 | 1 |
|
|
||||||
| type | VARCHAR | 20 | null |
|
|
||||||
| content | LONGTEXT | 2147483647 | null |
|
|
||||||
| created_at | DATETIME | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | sequence |
| telescope_entries_batch_id_index | Performance | Asc | batch_id |
| telescope_entries_created_at_index | Performance | Asc | created_at |
| telescope_entries_family_hash_index | Performance | Asc | family_hash |
| telescope_entries_type_should_display_on_index_index | Performance | Asc/Asc | type + should_display_on_index |
| telescope_entries_uuid_unique | Must be unique | Asc | uuid |
Relationships
Close relationships within degrees of separation
