• pie@programming.dev
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    You wouldn’t store this information on the same table (unless you’re using a wide row db like dynamo/Cassandra). In a SQL world, you’d store version information in a separate table - one table for the HEAD state and another for history.

    • learningduck@programming.dev
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year ago

      So, the history table have every column, but the user table has only user id and version, right?

      user_history table user table