Changes between Version 12 and Version 13 of ConceptualModel
- Timestamp:
- 05/03/26 20:15:46 (23 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ConceptualModel
v12 v13 12 12 * {{{username}}} – natural key, must be unique, but can change in the future. 13 13 * {{{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. 15 15 [[BR]] 16 16 '''[[span(style=color: #E30B5C, Attributes: )]]''' … … 22 22 * {{{email}}} – text, required. Must be unique; email format validation. 23 23 * {{{created_at}}} – datetime, required. Automatically set when the account is created. 24 * {{{password_hash}}} - text, required 24 25 [[BR]] 25 26 ---- … … 114 115 * {{{email}}} – text, optional. Must be valid email format; must be unique. 115 116 * {{{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 117 118 [[BR]] 118 119 ----
