Changes between Version 11 and Version 12 of ConceptualModel

Timestamp:

01/28/26 00:04:08 (12 days ago)

Author:

231035

Comment:

--

ConceptualModel

@@ -43 +43 @@
 [[BR]]
 '''[[span(style=color: #E30B5C, Attributes: )]]'''
-* No additional attributes beyond those of User.
+* {{{is_blocked}}} – boolean, required. Indicates whether the client account is currently blocked.Default value is FALSE.
+* {{{blocked_at}}} – datetime, optional. Records the timestamp when the client was blocked.
+* {{{blocked_reason}}} – text, optional. Stores the reason for blocking the client.
+* {{{blocked_by}}} – numeric, optional. Identifies the administrator who blocked the client.
 [[BR]]
 ----
@@ -206 +209 @@
 * {{{user_id}}} – numeric, required. Foreign key to User.user_id (recipient).
 * {{{is_read}}} – boolean, required. Defaults to FALSE; becomes TRUE when viewed.
+----
+{{{vet_clinic_applications}}}
+[[BR]]
+Represents the application a veterinary clinic submits before being approved to operate in the system.Keeping applications in a separate table supports an approval workflow without overloading the main {{{vet_clinics}}} entity.
+[[BR]]
+'''[[span(style=color: #E30B5C, Candidate keys: )]]'''
+* {{{application_id}}} – surrogate numeric identifier (chosen primary key).
+* {{{clinic_id}}} – unique natural identifier per clinic; one clinic can have at most one application record (as enforced by UNIQUE).
+* {{{application_id}}} is chosen as PK because it is stable and independent of workflow or business changes; {{{clinic_id}}} remains a unique alternate key for enforcing one-application-per-clinic in this design.
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+* {{{application_id}}} – numeric, required. Auto-generated positive integer; primary key.
+* {{{clinic_id}}} – numeric, required. Unique; identifies the clinic that submitted the application.
+* {{{name}}} – text, required. Clinic name as submitted; max length ~120.
+* {{{email}}} – text, optional. Contact email as submitted; max length ~254; email format validation.
+* {{{phone}}} – text, optional. Contact phone number as submitted; max length ~40.
+* {{{city}}} – text, required. City of the clinic; max length ~80.
+* {{{address}}} – text, required. Street address; max length ~200.
+* {{{submitted_at}}} – datetime, required. Timestamp when the application was submitted; defaults to NOW().
+* {{{status}}} – text, required. Workflow state; defaults to 'PENDING'. Allowed values: 'PENDING', 'APPROVED', 'DENIED'.
+* {{{reviewed_at}}} – datetime, optional. When the application was reviewed (approved/denied).
+* {{{reviewed_by}}} – numeric, optional. Admin who reviewed the application; can be NULL if reviewer is removed.
+* {{{denial_reason}}} – text, optional. Explanation recorded only when status is 'DENIED'.
+----
+{{{favorite_listings}}}
+[[BR]]
+Represents a many-to-many relationship between clients and listings, capturing which listings a client has marked as “favorite”. 
+[[BR]]
+'''[[span(style=color: #E30B5C, Candidate keys: )]]'''
+* {{{(client_id, listing_id)}}} – composite natural key (chosen primary key).
+The composite key is chosen as PK because a favorite is uniquely defined by “which client favorited which listing” and no additional surrogate identifier is needed.
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+* {{{client_id}}} – numeric, required. Identifies the client who favorites the listing.
+* {{{listing_id}}} – numeric, required. Identifies the favorited listing.
 === RELATIONS ===
 [[BR]]