Universally Unique Record Identifiers / Attributes #5856
IsaacBoswall
started this conversation in
Chat
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi,
I'm new to SurrealDB, and am working on a project using SurrealDB Relations between records in different tables. There's a couple questions I have on how RecordIDs and querying accross tables works that was wondering if anyone could help me answer.
Is it possible to make it so that the record identifier (number after the table name in the RecordID, e.g.
:23f09y1342
) is unique across all tables in the database.This would be such that the existence of both
Car:490
andVan:490
would be impossible. Could you then use the only the record identifier to search for a specific record?Alternatively, if this is not possible, would it be possible to enforce uniqueness of a universal attribute called 'UUID' for example? How then would querying multiple tables for a specific UUID look? Would this be an inefficient way of querying?
Cheers,
Isaac
Beta Was this translation helpful? Give feedback.
All reactions