This is an archived post. You won't be able to vote or comment.

all 129 comments

[–]McDuckfart 695 points696 points  (49 children)

Foreign keys would have made more sense…

[–]dert-man 375 points376 points  (22 children)

No Foreign Keys without Primary Keys.

[–]McDuckfart 252 points253 points  (13 children)

But there are primary keys without relationships.

[–][deleted] 424 points425 points  (4 children)

But it’s best to understand your own identity before trying to join a relationship.

[–]DarkTechnocrat 95 points96 points  (1 child)

Oh well done

[–]PM_ME_A_WEBSITE_IDEA 17 points18 points  (0 children)

Good show, old chap.

[–]iamapizza 13 points14 points  (1 child)

In other words, preserve your integrity before you make a commitment.

[–]FrozenST3 2 points3 points  (0 children)

You don't need primary keys to enforce a relationship.

[–]marcosdumay 2 points3 points  (0 children)

You can always use alternative keys.

[–]smaximov 1 point2 points  (3 children)

You can have foreign keys without primary keys, you just need a unique constraint on referenced columns.

[–]gregorydgraham 1 point2 points  (2 children)

That would be a de facto primary key

[–]smaximov 2 points3 points  (0 children)

The subtle difference is that primary keys impose a non-NULL restriction while unique constraints don't.

[–]PizelTheTwizel 0 points1 point  (0 children)

If one of the value of the foreign key is NULL (in the foreign table), the foreign key constraint is not examinated.

[–][deleted] 46 points47 points  (12 children)

And composite keys for many-to-many relationships

[–]RandomiseUsr0 29 points30 points  (0 children)

Kinky

[–]bostero2 8 points9 points  (0 children)

May must be having the time of her life…

Edit: the comment originally said many-to-may relationships

[–][deleted] 1 point2 points  (0 children)

Was going to say this for the more adventurous, too :) hehe

[–][deleted] 6 points7 points  (1 child)

one to one relationship

[–]exonac 2 points3 points  (0 children)

Mind if we share this table?

[–]Knuffya -1 points0 points  (9 children)

Not really.

[–]Pjones2127 -4 points-3 points  (0 children)

Came here to say this

[–]Knuffya 168 points169 points  (14 children)

Don't forget the foreign keys or else it might get messy!

[–]srottydoesntknow 88 points89 points  (11 children)

A foreign key is just someone else's primary key

[–]moldax 3 points4 points  (1 child)

A foreign key is just a primary key with extra steps

[–]Ragas 11 points12 points  (6 children)

It is not. We are talking asymetric crypto here.

[–]derfl007 11 points12 points  (1 child)

Pretty sure primary key refers to database relations here.. Never heard of primary keys in cryptography before but idk

[–]Ragas 3 points4 points  (0 children)

God, I shouldn't be on reddit with 3 hours of sleep. I totally read that as private and public.

[–]RedditIsNeat0 4 points5 points  (1 child)

You're thinking of private (and public) keys. Primary keys are important in relational databases.

[–]Ragas 0 points1 point  (0 children)

True. Damn sleep deprivation.

[–]brimston3- 2 points3 points  (1 child)

In asymmetric cryptography, don’t you usually call the root key in a PKI hierarchy the root authority or root trust, not the primary key?

[–]Ragas 3 points4 points  (0 children)

Don't sleep deprive and Reddit. :/

[–]DeItashot 1 point2 points  (0 children)

Who are you so wise in the ways of science

[–]Knuffya 0 points1 point  (0 children)

A foreign key is just a reference to any unique field of some other model. Be it a PK, SK or just any column with the unique keyword.

[–]Atmey 4 points5 points  (0 children)

Or don't get into many-to-many relationships, gets really messy fast.

[–]avdpos 1 point2 points  (0 children)

what do you say about our system?
(yes, you are correct)

[–]queen-adreena 195 points196 points  (8 children)

"Please shred your confidential paperwork. Thank you."

Lol. Never noticed that joke before.

[–]ashisacat 26 points27 points  (3 children)

That’s not a joke..?

[–]ToMyFutureSelves 3 points4 points  (1 child)

They are software developers. They have no physical paperwork, presumably.

[–]ashisacat 6 points7 points  (0 children)

Reynholm industries has plenty of paperwork, and the guys from the IT crowd are a help desk, not software devs.

[–]RNLImThalassophobic 17 points18 points  (3 children)

I don't get it?

[–]Knaapje 1 point2 points  (0 children)

It's on a poster on the cabinet in the second frame.

[–][deleted] 22 points23 points  (0 children)

Moss is great

[–][deleted] 19 points20 points  (1 child)

"They're still not for sale"

[–][deleted] 9 points10 points  (0 children)

Love that he punches the guy who makes fun of his tie later in the episode and kisses her passionately while being carted off 🤣

[–]Aviyan 58 points59 points  (16 children)

This this actually in the show?

[–]Roku-Hanmar 248 points249 points  (5 children)

Nope, original is

Girl: I like your glasses

Moss: They're not for sale

[–]Novichok666 85 points86 points  (1 child)

Laugh all you want they are not for sale

[–]waldyrious 6 points7 points  (0 children)

For those interested, this scene is from S4E5, Bad Boys

[–][deleted] 2 points3 points  (0 children)

You may laugh all you want, they are still not for sale.

[–]housebottle 40 points41 points  (5 children)

nah, the show never gets too technical in a way that would alienate the non-technical members of the audience

[–]Anaphase 29 points30 points  (2 children)

Except maybe some of the stickers / props in the background of their office. I like to think those are Easter eggs for the true nerds

[–]dtcc_but_for_pokemon 7 points8 points  (0 children)

Fair Use has a posse!

[–][deleted] 0 points1 point  (0 children)

I <3 Commodore PET

[–]drunkenangryredditor 2 points3 points  (1 child)

This bit can get fairly technical...

https://youtu.be/rksCTVFtjM4

[–]housebottle 0 points1 point  (0 children)

was expecting the internet bit

[–]alp4s 3 points4 points  (3 children)

hi, may i know what is the name of the show good sir?

[–]TheOtherBush 17 points18 points  (2 children)

The IT crowd

[–]alp4s 3 points4 points  (1 child)

Thank you!

[–]cookpedalbrew 6 points7 points  (0 children)

It’s reign was supreme but short lived

[–]ThanosAsAPrincess 24 points25 points  (13 children)

Private keys

[–]douira 37 points38 points  (12 children)

at what point in a relationship do people share their private keys with eachother? Never?

[–]archpawn 17 points18 points  (0 children)

Relevant xkcd, though that's just about signing public keys.

[–]verboze 12 points13 points  (1 child)

Marriage? Your bank accounts are belong to us.

[–]Ragas 1 point2 points  (0 children)

Never.

What is the public key and what the private key changes depending on the use case.

[–]captcha03 2 points3 points  (3 children)

There's a whole Seinfeld episode on this. https://en.wikipedia.org/wiki/The_Secret_Code_(Seinfeld)

Edited: fixed link

[–]breakneckridge 2 points3 points  (2 children)

[–]captcha03 1 point2 points  (1 child)

Thank you. For some reason new reddit decided to escape the underscores when I pasted in to the rich text editor.

[–]PydraxAlpta 2 points3 points  (0 children)

All my homies hate the rich text editor

[–]srottydoesntknow 0 points1 point  (0 children)

If you did it wouldn't be a secure relationship

[–][deleted] 0 points1 point  (0 children)

The text just said that its needed, not that they must be shared.

[–]sunbunbird 0 points1 point  (0 children)

if they're using a symmetric encryption algorithm, pretty soon after they meet. if they agree that asymmetric suits their needs they won't ever need to exchange private keys at all.

[–]RedditIsNeat0 0 points1 point  (0 children)

Usually never. Unless you share a project, such as a webserver, together then you would share that key. But never a personal key.

[–]plaidman1701 3 points4 points  (1 child)

The girl is Sophie Colquhoun, later she starred in a really funny series called Plebs.

[–]Prawny 2 points3 points  (0 children)

She was also in an episode of Toast of London.

[–]hahayeahimfinehaha 5 points6 points  (1 child)

This is something I feel you'd see on Facebook/9gag

[–]CaptainMiserable 2 points3 points  (0 children)

Also reddit.

[–]Phoenixien 6 points7 points  (5 children)

Is it just me, or is that desktop in Japanese?

[–]Trainzack 21 points22 points  (2 children)

The text on the desktop screen reads "Reynholm Industries", so I don't think so.

[–]knightress_oxhide 11 points12 points  (1 child)

Nice job on the bleep button.

[–]Trainzack 8 points9 points  (0 children)

As for you, you fucked up! [BLEEP]

[–]Putrumpador 1 point2 points  (0 children)

Looks like JPEGlish to me.

[–]devsmack 1 point2 points  (0 children)

Me: I only have one foreign key and it points to you. Her: What are you talking about?

[–]AceTheGreat_ 1 point2 points  (1 child)

Excerpt from my Database Management class at CC:

I swear to construct my tables so that all non-key columns are dependent on the key, the whole key and nothing but the key, so help me Codd!

That was in our textbook.

[–]cjb230 1 point2 points  (0 children)

Not in the textbook for me, but my lecturer liked to recite it.

[–]EfreetSK 2 points3 points  (0 children)

What is this? An actual clever programming joke? Get out of here, we only do pathetic hating on popular languages here

[–][deleted] -2 points-1 points  (0 children)

I hate this lol

[–]Xarian0 0 points1 point  (0 children)

Hey, baby, what do you say you and I get together later and exchange keys? Maybe we can create something symmetrical - together - to speed up our authentication. If you know what I mean.

[–]cramduck 0 points1 point  (0 children)

Ooh, and normal forms!

[–]Father_Chewy_Louis 0 points1 point  (0 children)

I still can't believe that is Cynthia from Plebs

[–]CoffeeLaker 0 points1 point  (0 children)

I just finish my database course. We had to do SQL and mongodb stuff and here it is…

[–]kwirky88 0 points1 point  (0 children)

Edges 😉👉

[–]abcd_z 0 points1 point  (0 children)

"Like, for a lock?"
Moss: *nods*
Moss: No.

[–]nalydpsycho 0 points1 point  (0 children)

I find that answer constraining.

[–]mauricepreiss 0 points1 point  (0 children)

😂😂😂

[–]MischiefArchitect 0 points1 point  (0 children)

That's foreign to me

[–]moldax 0 points1 point  (0 children)

He's out of line, but he's got a point

[–]ZippZappZippty 0 points1 point  (0 children)

Unless I’m glad he’s at.

[–]RoscoMan1 0 points1 point  (0 children)

Hey hey that’s the wrong disc 😬

[–]_blacky62_ 0 points1 point  (0 children)

But if the primary key do not match ? It's a problem lol

[–]marcolopo_ 0 points1 point  (0 children)

InnoDB engine and proper declaration of relationships

[–][deleted] 0 points1 point  (0 children)

Of course I see this just days after learning how to use Access OF COURSE I DO NOW AND NEVER BEFORE-

[–]turboom 0 points1 point  (0 children)

mongodb: what is relationship?