321
Belching (sopuli.xyz)
you are viewing a single comment's thread
view the rest of the comments
[-] olafurp@lemmy.world 1 points 3 months ago

That structure doesn't handle polyamorous and cheating relationships very well. It should probably have and (select top 1 1 from dbo.relationships r where r.partner_a != GIRLS.id or r.partner_b != GIRLS.id) which would handle also LGBT+ relationships or relationships that are better represented as a graph.

[-] drathvedro@lemm.ee 1 points 3 months ago

The relationships table should also have enum for relationship type. It might be friends, family, platonic relations etc. Also might want to check sex_drive to handle ace gals and something to do with kinsey scale not to bother lesbians.

this post was submitted on 01 Jul 2024
321 points (91.9% liked)

LinkedinLunatics

3346 readers
30 users here now

A place to post ridiculous posts from linkedIn.com

(Full transparency.. a mod for this sub happens to work there.. but that doesn't influence his moderation or laughter at a lot of posts.)

founded 1 year ago
MODERATORS