Changes between Version 5 and Version 6 of AdvancedApplicationDesign_v2

Timestamp:

09/23/25 00:12:23 (2 weeks ago)

Author:

212012

Comment:

--

AdvancedApplicationDesign_v2

@@ -245 +245 @@
     values (new_case_id, p_case_name, CURRENT_DATE, 'A', p_police_station_id);
     
-    select coalesce(MAX(s_id), 0) + 1 INTO new_statement_id FROM Statements;
-    
-    insert into Statements (s_id, statement_date, description, incident_timestamp, incident_place, c_id, pe_id, victim_pe_id, witness_pe_id)
+    select coalesce(MAX(s_id), 0) + 1 into new_statement_id from statements;
+    
+    insert into statements (s_id, statement_date, description, incident_timestamp, incident_place, c_id, pe_id, victim_pe_id, witness_pe_id)
     values (new_statement_id, CURRENT_DATE, p_statement_description, p_incident_timestamp, p_incident_place, new_case_id, p_policeman_id, p_victim_id, p_witness_id);