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?
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.
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?
20 bucks the datastructure was designed for easiest access from the semantics of whatever du jour js lib they were using for the app
20 bucks their database schema was copy pasted from chat-gpt.
“designed”, rather
Even “derived from” feels too strong a statement. “Was the result of”?
“Sediment precipitated from”?
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.
ah, thank you!