Live analytics
Circle Edges
Social graph overlap and reveal state between user pairs.
Table metadata
Rows: 115Page: 2 / 2Page size: 100Mode: read-write
Columns
| name | type | primary_key | not_null | default_value |
|---|---|---|---|---|
| user_a | TEXT | 1 | 1 | — |
| user_b | TEXT | 2 | 1 | — |
| overlap_count | INTEGER | 0 | 1 | 0 |
| mutual_reveal | INTEGER | 0 | 1 | 0 |
| sticky_revealed | INTEGER | 0 | 1 | 0 |
| updated_at | INTEGER | 0 | 1 | — |
| became_circle_at | INTEGER | 0 | 0 | — |
| user_a_revealed | INTEGER | 0 | 1 | 0 |
| user_b_revealed | INTEGER | 0 | 1 | 0 |
| user_a_muted_b | INTEGER | 0 | 1 | 0 |
| user_b_muted_a | INTEGER | 0 | 1 | 0 |
| user_a_blocked_b | INTEGER | 0 | 1 | 0 |
| user_b_blocked_a | INTEGER | 0 | 1 | 0 |
| removed_by | TEXT | 0 | 0 | — |
Rows
Manage rows
Create, edit, and delete live rows directly from the SQLite database.
| __rowid__ | user_a | user_b | overlap_count | mutual_reveal | sticky_revealed | updated_at | became_circle_at | user_a_revealed | user_b_revealed | user_a_muted_b | user_b_muted_a | user_a_blocked_b | user_b_blocked_a | removed_by | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_c86e3e6d | 1 | 0 | 0 | 1776541824144 | — | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 46 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_e9fe7bcb | 1 | 0 | 0 | 1776541824144 | — | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 9 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_45ccf88e | 3 | 0 | 0 | 1776541824143 | 1776541816311 | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 29 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_6eed9d58 | 3 | 0 | 0 | 1776541824143 | 1776541820851 | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 37 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_8e7c1964 | 2 | 0 | 0 | 1776541824143 | 1776541824143 | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 19 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_d59b5cc6 | 2 | 0 | 0 | 1776541820851 | 1776541820851 | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 30 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_8d3fa4a5 | 2 | 0 | 0 | 1776541820851 | 1776541820851 | 1 | 0 | 0 | 0 | 0 | 0 | — | |
| 36 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_55e9ff0a | 1 | 0 | 0 | 1776541820851 | — | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 35 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_171221e9 | 1 | 0 | 0 | 1776541820850 | — | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 21 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_e33b96ab | 2 | 0 | 0 | 1776541816312 | 1776541816312 | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 10 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_536b9bd1 | 2 | 0 | 0 | 1776541816311 | 1776541816311 | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 23 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_1cf16fdc | 1 | 0 | 0 | 1776541816311 | — | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 6 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_1e4ee893 | 1 | 0 | 0 | 1776541770203 | — | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 8 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_3f0423ad | 1 | 0 | 0 | 1776541770203 | — | 0 | 0 | 0 | 0 | 0 | 0 | — | |
| 18 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | bot_b5909a7b | 1 | 0 | 0 | 1776541770203 | — | 0 | 0 | 0 | 0 | 0 | 0 | — |