Changes between Initial Version and Version 1 of ERModel

Timestamp:

12/13/25 00:32:18 (2 weeks ago)

Author:

233051

Comment:

--

ERModel

@@ +1 @@
+= ERModel
+
+== Diagram
+[[Image(ERDiagram_v1.png)]]
+
+== Data requirements
+=== Entities
+**Users** – Entity that defines the users of the platform.
+* id – numeric type (primary key)
+* username – text type (required, unique)
+* password – text type (required)
+* email – text type (required, unique)
+
+**Admins** – Administrator profile. Inherits from Users.
+* user_id – numeric type (primary key, foreign key to Users)
+* Suggestion – Lets users to suggest components that they want to be added.
+* id – numeric type (primary key)
+* user_id – numeric type (foreign key to Users)
+* admin_id – numeric type (foreign key to Admins)
+* link – text type (required)
+* admin_comment – text type (optional)
+* description – text type (optional)
+* status – text type (required)
+* component type – text type (required)
+
+**Component** – Entity representing all hardware components.
+* id – numeric type (primary key)
+* name – text type (required)
+* brand – text type (required)
+* price – numeric type (required)
+* img_url – text type (optional)
+
+**CPU** – Entity detailing CPU components. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* socket – text type (required)
+* cores – numeric type (required)
+* threads – numeric type (required)
+* base_clock – numeric type (required)
+* boost_clock – numeric type (optional)
+* tdp – numeric type (required)
+
+**GPU** – Entity for graphics cards. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* vram – numeric type (required)
+* tdp – numeric type (required)
+* base_clock – numeric type (optional)
+* boost_clock – numeric type (optional)
+* chipset – text type (required)
+* length – numeric type (required)
+
+**Memory** – RAM modules. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* type – text type (required)
+* speed – numeric type (required)
+* capacity – numeric type (required)
+* modules – numeric type (required)
+
+**Power_Supply** – Power supply units. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* type – text type (required)
+* wattage – numeric type (required)
+* form_factor – text type (required)
+
+**Case** – Computer cases. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* cooler_max_height – numeric type (required)
+* gpu_max_length – numeric type (required)
+
+**Case_Storage_Form_Factors** – Supported storage form factors for a case.
+* case_id – numeric type (primary key & foreign key to Case)
+* form_factor – text type (primary key)
+
+**Case_PS_Form_Factors** – Supported Power Supply form factors for a case.
+* case_id – numeric type (primary key & foreign key to Case)
+* form_factor – text type (primary key)
+
+**Case_Mobo_Form_Factors** – Supported motherboard form factors for a case.
+* case_id – numeric type (primary key & foreign key to Case)
+* form_factor – text type (primary key)
+
+**Cooler** – CPU coolers. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* type – text type (required)
+* height – numeric type (required)
+* max_tdp_supported – numeric type (required)
+
+**Cooler_CPU_Sockets** – Supported CPU sockets for a cooler.
+* cooler_id – numeric type (primary key & foreign key to Cooler)
+* socket – text type (primary key)
+
+**Motherboard** – Motherboards. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* socket – text type (required)
+* chipset – text type (required)
+* form_factor – text type (required)
+* ram_type – text type (required)
+* num_ram_slots – numeric type (required)
+* max_ram_capacity – numeric type (required)
+
+**Storage** – Storage devices. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* type – text type (required)
+* capacity – numeric type (required)
+* form_factor – text type (required)
+
+**Memory_Card** – Memory card readers. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* num_slots – numeric type (required)
+* interface – text type (required)
+
+**Optical_Drive** – CD/DVD/Blu-Ray drives. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* form_factor – text type (required)
+* type – text type (required)
+* interface – text type (required)
+* write_speed – numeric type (required)
+* read_speed – numeric type (required)
+
+**Sound_Card** – Dedicated sound cards. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* sample_rate – numeric type (required)
+* bit_depth – numeric type (required)
+* 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)
+
+**Cables** – Computer cables. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* length_cm – numeric type (required)
+* type – text type (required)
+
+**Network_Adapter** – Wireless network adapters. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* wifi_version – text type (required)
+* interface – text type (required)
+* num_antennas – numeric type (required)
+
+**Network_Card** – Wired network cards. Inherits from Component.
+* component_id – numeric type (primary & foreign key to Component)
+* num_ports – numeric type (required)
+* speed – numeric type (required)
+* interface – text type (required)
+
+**Build** – Entity for user PC configurations.
+* id – numeric type (primary key)
+* user_id – numeric type (foreign key to Users)
+* name – text type (required)
+* created_at – date type (required)
+* description – text type (optional)
+* total_price – numeric type (required)
+* is_approved – boolean type (required)
+
+**Build_Component** – Components belonging to a configuration.
+* build_id – numeric type (primary key, foreign key to Build)
+* component_id – numeric type (primary key, foreign key to Component)
+
+**Favorite_Build** – User’s favorited configurations.
+* build_id – numeric type (primary key, foreign key to Build)
+* user_id – numeric type (primary key, foreign key to Users)
+
+**Rating_Build** – Ratings for PC builds.
+* build_id – numeric type (primary key, foreign key to Build)
+* user_id – numeric type (primary key, foreign key to Users)
+* value – numeric type (required)
+
+**Review** – User comments on a build.
+* id – numeric type (primary key)
+* build_id – numeric type (foreign key to Build)
+* user_id – numeric type (foreign key to Users)
+* content – text type (required)
+* created_at – text type (required)
+
+=== Relations
+* **owns_build** – 1:N relationship between Users and Build, linking a user to their PC configurations.
+* **has_component** – N:M relationship between Build and Component, representing components included in a build.
+* **favorites** – N:M relationship between Users and Build, allowing users to favorite builds.
+* **rates** – N:M relationship between Users and Build, allowing users to give ratings (1–5).
+* **written_by** – 1:N relationship between Users and Review, linking users to their written reviews.
+* **reviews** – 1:N relationship between Build and Review, linking reviews to a specific build.
+* **submit** – 1:N relationship between Users and Suggestion, allowing users to suggest components.
+* **moderate** – 1:N relationship between Admins and Suggestion, allowing admins to approve or reject user suggestions.