Changes between Version 12 and Version 13 of ConceptualModel


Ignore:
Timestamp:
05/03/26 20:15:46 (23 hours ago)
Author:
231035
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ConceptualModel

    v12 v13  
    1212* {{{username}}} – natural key, must be unique, but can change in the future.
    1313* {{{email}}} – also unique, but might change and can be reused if a user is deleted.
    14 {{{user_id}}} is chosen as PK because it is stable, short, and independent of business rules.
     14{{{user_id}}} is chosen as PK because it is stable, short and independent of business rules.
    1515[[BR]]
    1616'''[[span(style=color: #E30B5C, Attributes: )]]'''
     
    2222* {{{email}}} – text, required. Must be unique; email format validation.
    2323* {{{created_at}}} – datetime, required. Automatically set when the account is created.
     24* {{{password_hash}}} - text, required
    2425[[BR]]
    2526----
     
    114115* {{{email}}} – text, optional. Must be valid email format; must be unique.
    115116* {{{phone}}} – text, optional. May require a specific phone-number format.
    116 * {{{approved_by}}} - text, which admin approved to have that clinic as a part of the app
     117
    117118[[BR]]
    118119----