this post was submitted on 01 Jul 2024
316 points (91.8% liked)

LinkedinLunatics

3223 readers
2 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
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 4 points 1 month ago (1 children)

Shouldn't boyfriend be a reference to another table?

[–] [email protected] 5 points 1 month ago (1 children)

BF has no referential integrity

[–] [email protected] 2 points 1 month ago

That's (part of) why it should be a separate table to map the relation "Relationship". People can have more than one (polyamory, infidelity), and you could track fields like the start, end, status (e.g. flirting, dating, committed, engaged, married, ended) in there.