Skip to content
Snippets Groups Projects
Closed Add Foreign Key to Block in Identity Table for Timestamp Retrieval
  • View options
  • Add Foreign Key to Block in Identity Table for Timestamp Retrieval

    • View options
  • Closed created by poka

    Add a foreign key link to the block in the "identity" table. This modification will allow us to fetch the timestamp efficiently with a single query, eliminating the need to duplicate timestamp information across various tables corresponding to each event in the block. This enhancement is aimed at optimizing the data structure in the "identity" table, reducing data redundancy and improving the efficiency of our database queries.

    Edited by poka

    Activity

    • All activity
    • Comments only
    • History only
    • Newest first
    • Oldest first