Should the bcrypt hash be stored in the main User's table or in its own table?

Question

From what I've read, the hash generated by bcrypt should be stored as type CHAR(60).

Now, should those bcrypt hashes be stored in the main User table together with the user's UserID and Username, or should it be stored in its own table with 2 columns (UserID, BcryptHash)?

Proper normalization says that it should be stored in the User table. — Sammitch
– Sammitch, Commented Mar 27, 2013 at 15:16

000 · Accepted Answer · 2013-03-27 15:09:26Z

2

It's fine to store it in the User table. It doesn't really matter. For simplicity I would store it in User.

answered Mar 27, 2013 at 15:09

000

27.3k10 gold badges74 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ProgrammerGirl Over a year ago

@phpNoOb: Not sure why you're giving him a hard time, his answer is correct, as corroborated by Sammitch in the comments above. It's short, but it's the answer I was looking for, and it's correct, so writing it as an answer will make it easier to find for those having the same question in the future. Thanks joeframbach!

paladinux · Accepted Answer · 2013-03-27 15:18:21Z

By your preference I think, for 1st normal form is a repeat of item; about this concept you can use only a field, but (if i must to do that) I prefer 2 columns. paladinux

Collectives™ on Stack Overflow

Should the bcrypt hash be stored in the main User's table or in its own table?

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related