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 answers
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in PROPERTIES
- The Selenium application properties folder holds two environment options. After running a test the environment setting changes to a previous setting
- Inconsistency in lazy variable initialization between static and instance properties in Swift
- How to convert from Java ASCII properties to UTF8 (Java 9) properties
- Conditional Property After Powershell Left Join
- Inheritance - is it possible to 'force' variable values relative to the derived class?
- How to use an imported Excel file inside Anylogic model
- TinyMCE custom toolbar button to set CSS property of selected text
- Missing Properties
- I am trying a display items (events) from db typescript nestjs using handlebars the events are an array of object. Properties of each object undefined
- How to transform a flat form-specific data-structure into a nested one?
- C# How do I Create and Reference Multiple Globally Accessible Objects?
- powershell array of object with dynamic properties outputs only properties from first element
- Swift protocol extensions and immutable properties
- Object property has different many string values
- I created a dice cube model using a tutorial and i would like to expoert the subdivision holes as properties to unity3d. how can i do it?
Related Questions in ENTITY
- Bidirectional @OnetoMany and @ManyToOne on Quarkus with Panache
- How to update Room database entry through UI?
- How to solve issues in NullPointerException in Spring boot Entity class
- Why hibernate make so much queries even while using DTO and FETCH TYPE LAZY?
- Animating Entity in VisionOS based on mouse gesture?
- Python: ContextManager for entity mutations?
- BERTModel for named entity transfer learning
- Typescript function to accept array or single instance of constructor and return list
- Spring JPA entity doesn't update when i use getReferenceId() in transactional function
- Using the same configuration for both ODataModelBuilder and Entity Framework Core
- How should i apply SOLID principles for an entity which have two types, one editable and the other uneditable
- Entity Framework: Error: Failed to load configuration from file [...]/appsettings.json; Unable to create a 'DbContext' of type
- How to differ two entities of UserDetails?
- In OOAD, how should i represent the property that the entity is shared with multiple users with different permissions?
- How to list a property of an entity in C# that is of list type in the front end?
Related Questions in CONCEPTUAL-MODEL
- An associative Entity with optional participation on one side and mandatory participation on the other
- Looking for feedback on Data Model
- VP ontoUML plugin: how-to add <<relator>> class to <<material>> relation
- Best way to store date in a CDM (Conceptual Data Model)?
- How to represent merchandise flavours (or product variants)?
- How to correctly show M:N relationship in conceptual data model?
- How do you represent different versions of the same entity type (class) in the same UML class diagram?
- Conceptual model Entity -relationship and physical model mysql workbench
- Comparing numbers with tolerance concept:
- Concept of comparing numbers with tolerance
- How does iterating over an array using a for loop REALLY work?
- Constraintless conceptual model of organization with constraints?
- Confusion regarding association relationship in UML
- Uml Class Diagram for Metro Railway
- How to normalize a recursive relationship? (Conceptual to logical)
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?
Popular Tags
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)
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.