LinkedinLunatics

3549 readers

23 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

csm10495@sh.itjust.works

330

Belching (sopuli.xyz)

submitted 4 months ago by crmsnbleyd@sopuli.xyz to c/linkedinlunatics@sh.itjust.works

79 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] ResoluteCatnap@lemmy.ml 2 points 4 months ago* (last edited 4 months ago)

I think wed just need the following

rel.id (primary key)
rel.user_id (foreign key to person.id)
rel.user_id2 (foreign key to person.id)
rel.type (type of relationship)
rel.start (non null)
rel.end

From there you don't need a rel.status because you're not updating this rel.id entry except for the rel.end. if they started dating again later it would be a whole new entry, and then you could query their entire dating history to see if they keep coming back to the same person, dating around, playing the field, etc. Separately there could be a friendship relationship that is tracked so you could if they ended being friends after a breakup.