What's the best relational database model for Nostr? Just event and tag tables or tags as JSON objects inside the events table? Or maybe best to use a native array column for tags?

Does the randomness of the hex keys (event id, pubkey) affect the indexing performance?