Changes between Version 5 and Version 6 of Normalization

Timestamp:

08/24/26 18:34:52 (2 weeks ago)

Author:

213257

Comment:

--

Normalization

@@ -19 +19 @@
   timeslot_id, ts_date, ts_time_start, ts_time_end, ts_status,
   inquiry_id, inquiry_message, inquiry_status, inquiry_created_at,
+  inquiry_response, inquiry_responded_at
   appointment_id, appt_status
 )
@@ -40 +41 @@
 FD13: timeslot_id                     → ts_date, ts_time_start, ts_time_end, ts_status, agent_id
 FD14: (agent_id, ts_date, ts_time_start) → timeslot_id
-FD15: inquiry_id                      → inquiry_message, inquiry_status, inquiry_created_at, unit_id, client_id, agent_id
+FD15: inquiry_id                      → inquiry_message, inquiry_status, inquiry_created_at, unit_id, client_id, agent_id, inquiry_response, inquiry_responded_at
 FD16: appointment_id                  → appt_status, client_id, unit_id, timeslot_id
 FD17: timeslot_id                     → appointment_id
@@ -153 +154 @@
       inquiry_status,
       inquiry_created_at,
+      inquiry_response, 
+      inquiry_responded_at
       unit_id,
       client_id,
@@ -158 +161 @@
     )
     FDs: FD15 (inquiry_id → inquiry_message, inquiry_status,
-                             inquiry_created_at, unit_id, client_id, agent_id)
+                             inquiry_created_at, unit_id, client_id, agent_id, inquiry_response, inquiry_responded_at)
     Candidate key / PK: {inquiry_id}
     }}}