Changes between Version 3 and Version 4 of ERModel

Timestamp:

12/17/25 16:49:38 (11 days ago)

Author:

233144

Comment:

--

ERModel

@@ -2 +2 @@
 
 == Diagram
-[[Image(ERDiagram_v1.png)]]
+[[Image(ERDiagram_v2.png)]]
 
 == Data requirements
@@ -71 +71 @@
 * case_id – numeric type (primary key & foreign key to Case)
 * form_factor – text type (primary key)
+* num_slots – numeric type (required)
 
 **Case_PS_Form_Factors** – Supported Power Supply form factors for a case.
@@ -124 +125 @@
 * chipset – text type (required)
 * interface – text type (required)
-
-**Sound_Card_Channels** – Supported channels for a sound card.
-* soundcard_id – numeric type (primary & foreign key to Sound_Card)
-* channel – text type (primary key)
+* channel – text type (required)
 
 **Cables** – Computer cables. Inherits from Component.