Changes between Version 8 and Version 9 of ERModel

Timestamp:

08/23/26 15:59:23 (3 weeks ago)

Author:

213257

Comment:

--

ERModel

@@ -114 +114 @@
  * status (VARCHAR(32), required) - Current state of the inquiry. Allowed values: "New", "Replied", "Closed". Default: "New". 
  * created_at (TIMESTAMP, required) - Automatically set to current timestamp when inquiry is submitted. Used for sorting.
+ * response (TEXT, optional) - The agent reply text to the client inquiry. After being filled in the status of the inquiry changes to "Replied".
+ * responded_at (TIMESTAMP, optional) - Timestamp of when the agent submitted the response.
+
 
 **Appointment**
@@ -147 +150 @@
  * Participation: Partial on both sides.
 
-* Has (Building-Floor)
- * The Has relationship represents floors contained within buildings. Each floor belongs to exactly one building, while buildings contain multiple floors.
+* Contains (Building-Floor)
+ * The Contains relationship represents floors contained within buildings. Each floor belongs to exactly one building, while buildings contain multiple floors.
  * Cardinality: One-to-Many (1:N)
  * Participation: Total on Floor side because every floor needs a building, partial on Building side buildings under construction may lack final floor definitions.
 
-* Has (Unit-Floor)
- * The Has relationship represents units contained within floors. Each unit is on exactly one floor (in most real world scenarios the unit can span multiple floors but it has a door on one floor only), while floors contain multiple units.
+* LocatedOn (Unit-Floor)
+ * The LocatedOn relationship represents units contained within floors. Each unit is on exactly one floor (in most real world scenarios the unit can span multiple floors but it has a door on one floor only), while floors contain multiple units.
  * Cardinality: One-to-Many (1:N)
  * Participation: Total on Unit side (every unit needs a floor), partial on Floor side (may lack unit definition in early stages of construction).
 
-* Manages (Admin-Building)
- * The Manages relationship indicates which admin created and manages a building. Each building has one managing admin for clear accountability, while admins manage multiple buildings. Necessary for access control.
+* ManagesBuilding (Admin-Building)
+ * The ManagesBuilding relationship indicates which admin created and manages a building. Each building has one managing admin for clear accountability, while admins manage multiple buildings. Necessary for access control.
  * Cardinality: One-to-Many (1:N)
  * Participation: Total on Building side, partial on Admin side.
 
-* Manages (Admin-Floor)
- * The Manages relationship indicates which admin created and manages a floor. Each floor has one managing admin responsible for floor details and layout images, while admins manage multiple floors.
+* ManagesFloor (Admin-Floor)
+ * The ManagesFloor relationship indicates which admin created and manages a floor. Each floor has one managing admin responsible for floor details and layout images, while admins manage multiple floors.
  * Cardinality: One-to-Many (1:N)
  * Participation: Total on Floor side, partial on Admin side.
 
-* Manages (Admin-Unit)
- * The Manages relationship indicates which admin created and manages a unit. Each unit has one managing admin for accountability on pricing and availability, while admins manage multiple units.
+* ManagesUnit (Admin-Unit)
+ * The ManagesUnit relationship indicates which admin created and manages a unit. Each unit has one managing admin for accountability on pricing and availability, while admins manage multiple units.
  * Cardinality: One-to-Many (1:N)
  * Participation: Total on Unit side, partial on Admin side.
@@ -219 +222 @@
  * Added relation between admin and floor
  * full_name on architect entity changed from multivalue attribute to an attribute
+* Version 03
+ * Expanded Inquiry to include response and responded_at attributes.
+ * Renamed "Has" relationships to unique names Contains (Building-Floor), LocatedOn (Floor-Unit).
+ * Renamed "Manages" relationships to unique names ManagesBuilding, ManagesFloor, ManagesUnit.
+
+