How does the relation_tuple table work in SpiceDB ...
# spicedb
t
is there some documentation of the relation_tuple table ? the most interesting part for me is the deleted transaction column. https://cdn.discordapp.com/attachments/844600078948630559/1201504154976256010/image.png?ex=65ca0ef1&is=65b799f1&hm=862d3666f465cdfb1017ff0e445388d32a2105872084449a2057c374ce1ea20b&
v
it's an implementation detail. What specifically would you like to know?
t
what the values mean sometimes there is stuff in there like 59. sometimes its a long number like 9223372036854775807 does it indicate when it really is deleted ? i really just wanna know what it means :p
v
9223372036854775807 is MaxInt, and it means not deleted
anything that is not 9223372036854775807 means that's the revision at which it was deleted
t
does the mysql table relation_tuple always reflect the current state of the reltions ?
v
it should yeah
but it will also show past state of relations
think of that table of the history of changes