• 0 Posts
  • 15 Comments
Joined 6 months ago
cake
Cake day: January 14th, 2024

help-circle
  • ResoluteCatnap@lemmy.mltoLinkedinLunatics@sh.itjust.worksBelching
    link
    fedilink
    English
    arrow-up
    1
    ·
    edit-2
    2 days 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.


  • To that point a person table with a relationship table. So this way you can reference relationship between two or more persons within the relationship table and that could be joined to the person table if needed. I don’t think you’d really be able to keep it within one table while exploring multiple relationships unless you’re storing a list of ids that is interpreted outside of sql. Also a relationship table would allow exploring other types of relationships such as exes, love interests, coworkers, family, friends, etc










  • Yeah, it’s bad. Surprised they’re still serving that crap in their own bundle but i guess some things don’t change.

    Filezilla is no relation to mozilla. But yeah i moved away from it years ago. The general recommendation I’ve seen is “anything but filezilla”. Personally i use winscp for windows, and will have to figure out what to use when i switch my daily driver to Linux.





  • i once had a customer who wanted their fish “blackened”. Everyone else on staff had tried at some point and the customer always complained it was undercooked. So me being the new gal said id do it. I threw it in a pan and left it there for god knows how long. Then flipped it, left it there longer, and finally threw it into the back of our oven for another 15 minutes. It was literally charcoal when i was done. I was sure they would complain that it was overcooked but those fuckers loved it. They specifically requested me to cook their meal whenever they came in after that. I was just fucking with them the first time 🤷‍♀️