• deborah
    link
    English
    126 months ago

    If you’re using a new-to-you ORM, and you don’t ever check the docs to see the basic primary key syntax… it’s SQLAchemy, it’s well documented and there’s tons of prior art.

    Also I don’t understand their business case but if a user has a primary key, a unique user ID, and a unique customer ID, then all three of those uniquely identify the customer. (Weird, but there are some plausible explanations.) But then why would you need both the user ID and the customer ID in the subscription table is this some stripe thing I don’t understand or are they just bad at this?

    • @froztbyte
      link
      English
      136 months ago

      20 bucks the datastructure was designed for easiest access from the semantics of whatever du jour js lib they were using for the app

      • @froztbyte
        link
        English
        126 months ago

        “designed”, rather

        Even “derived from” feels too strong a statement. “Was the result of”?

        • @blakestaceyA
          link
          English
          115 months ago

          “Sediment precipitated from”?

      • Sailor Sega Saturn
        link
        English
        116 months ago

        20 bucks their database schema was copy pasted from chat-gpt.

    • @gianni@lemmy.ca
      link
      fedilink
      English
      105 months ago

      Yes, it’s some Stripe thing. Stripe requires you to create a customer to be able to vault payment methods and make charges. However it’s possible that not all users in their product require this functionality.

      • deborah
        link
        English
        85 months ago

        ah, thank you!