I'm currently making a conceptual model for a project and one of my entities happens to be a USER. It's key is a userID, and the properties include firstName, lastName, emailAdr, and userName. A user will have a password after the project is implemented which makes me wonder if I should add it as a property... or would that jeopardize confidentiality?
SQL Conceptual Modelling - Can a password be a property of an entity?
78 Views Asked by AlexT At
2
There are 2 best solutions below
Related Questions in SQL
- Can MVC.NET prevent SQL-injection at razor or controller level?
- SQL server not returning all rows
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Creating a parametrized field name for a SELECT clause
- Combine two rows based on common ID
- Column displays each count
- Slick query for one to optional one (zero or one) relationship
- Aggregate and count in PostgreSQL
- MAX and GROUP BY - SQL
- SQL statement for a tricky 2 table query
- How to create nested selects with sql?
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Best Practice for adding columns to a Table in Oracle database
- SQL FIFO STACK using two tables
- SQL Query - Order by String (which contains number and chars)
Related Questions in PROPERTIES
- What is best way to check if any of the property of object is null or empty?
- How to get a certain element in a list of lists?
- Setting controller property from inside a component
- Properties and pointers
- Properties file exclude multiple paths
- Cached properties for classes
- Can I read or update dynamically the multiple Mule app properties without reloading or restarting?
- can es6 class have public properties as well as functions?
- How to set a lot a class properties from an object with the same property names?
- Connecting to Superclass Properties with Storyboards
- XAML Dependency Property vs Regular Properties
- How to create an variable property based on the other property in the class
- read multiple values from a property file using bash shell script
- Pentaho 5.3 - How to read a property in PRPT files
- Java - Check properties file at compile time
Related Questions in ENTITY
- JPA, Hibernate can I do composite primary key which one element is foreign kay @OneToMany?
- PostGreSQL - Entity insert - Dduplicate key value violates unique constraint
- Return more that one entity in RESTful response?
- Zf2 entity create a custom filters
- Missing Foreign Keys when mapping Child Entities from JSON / How to generate them?
- Find where row value is inside a list
- Specify entity name while generating from existing database table symfony2
- Symfony update managed Entity elsewhere
- Doctrine persist entity with inverse relation not work
- Symfony 2 value on Enitty field
- Symfony2 - Find by a parent property object
- Create random falling objects in unity C#
- Multiple behaviours for single entity
- Java Jpa Query searching an Entityes Related By Id
- Check if my query not return entity
Related Questions in CONCEPTUAL-MODEL
- Is there an absolute model answer for Entity-Relationship diagram?
- Tool for EER Modeling
- Double line coming from an Entity
- Conceptual to relational mappings
- Best way to store date in a CDM (Conceptual Data Model)?
- How to normalize a recursive relationship? (Conceptual to logical)
- Entities for conceptual design
- UML class diagram conceptual schema
- Conceptual model with a constraint
- Concept of comparing numbers with tolerance
- How to represent merchandise flavours (or product variants)?
- Conceptual model Entity -relationship and physical model mysql workbench
- SQL Conceptual Modelling - Can a password be a property of an entity?
- How te create suggestions in database?
- How to model the price (clean or dirty) of a financial instrument?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Conceptually you have to keep a password for the user so it makes sense to store it in the user entity.
However, as pointed out by @stepio, when you look at how you will implement that, keeping a hash (in fact, a strong secure hash) is a good way to store it so it is not exposed if compromised.
On another side if you use an ORM that instantiates the entity from the table ,for example, and you have some concern about the hash traveling through out the application you may choose to put the real hash in a separate table, and keep a reference to it in the user's table. Something like a Unix shadow password.