Changes between Version 2 and Version 3 of RelationalDesign


Ignore:
Timestamp:
12/17/25 14:37:58 (11 days ago)
Author:
233144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v2 v3  
    99== Tables ==
    1010
    11 1. '''Users''' ('''**id**''', '''username''', '''password''', '''email''')
     111. '''Users''' ('''**__id__**''', '''username''', '''password''', '''email''')
    1212
    13 2. '''Admins''' ('''**user_id**'''* (Users))
     132. '''Admins''' ('''**__user_id__**'''* (Users))
    1414
    15 3. '''Components''' ('''**id**''', '''name''', '''brand''', '''price''', img_url)
     153. '''Components''' ('''**__id__**''', '''name''', '''brand''', '''price''', img_url)
    1616
    17 4. '''CPU''' ('''**component_id**'''* (Components), '''socket''', '''cores''', '''threads''', '''base_clock''', boost_clock, '''tdp''')
     174. '''CPU''' ('''**__component_id__**'''* (Components), '''socket''', '''cores''', '''threads''', '''base_clock''', boost_clock, '''tdp''')
    1818
    19195. '''GPU''' ('''**component_id**'''* (Components), '''vram''', '''tdp''', base_clock, boost_clock, '''chipset''', '''length''')
    2020
    21 6. '''Memory''' ('''**component_id**'''* (Components), '''type''', '''speed''', '''capacity''', '''modules''')
     216. '''Memory''' ('''**__component_id__**'''* (Components), '''type''', '''speed''', '''capacity''', '''modules''')
    2222
    23 7. '''Storage''' ('''**component_id**'''* (Components), '''type''', '''capacity''', '''form_factor''')
     237. '''Storage''' ('''**__component_id__**'''* (Components), '''type''', '''capacity''', '''form_factor''')
    2424
    25 8. '''Power_Supply''' ('''**component_id**'''* (Components), '''type''', '''wattage''', '''form_factor''')
     258. '''Power_Supply''' ('''**__component_id__**'''* (Components), '''type''', '''wattage''', '''form_factor''')
    2626
    27 9. '''Motherboard''' ('''**component_id**'''* (Components), '''socket''', '''chipset''', '''form_factor''', '''ram_type''', '''num_ram_slots''', '''max_ram_capacity''')
     279. '''Motherboard''' ('''**__component_id__**'''* (Components), '''socket''', '''chipset''', '''form_factor''', '''ram_type''', '''num_ram_slots''', '''max_ram_capacity''')
    2828
    29 10. '''PC_Case''' ('''**component_id**'''* (Components), '''cooler_max_height''', '''gpu_max_length''')
     2910. '''PC_Case''' ('''**__component_id__**'''* (Components), '''cooler_max_height''', '''gpu_max_length''')
    3030
    31 11. '''Case_Storage_Form_Factors''' ('''**case_id**''', '''**form_factor**''')
     3111. '''Case_Storage_Form_Factors''' ('''**__case_id__**''', '''**__form_factor__**''')
    3232
    33 12. '''Case_PS_Form_Factors''' ('''**case_id**''', '''**form_factor**''')
     3312. '''Case_PS_Form_Factors''' ('''**__case_id__**''', '''**__form_factor__**''')
    3434
    35 13. '''Case_Mobo_Form_Factors''' ('''**case_id**''', '''**form_factor**''')
     3513. '''Case_Mobo_Form_Factors''' ('''**__case_id__**''', '''**__form_factor__**''')
    3636
    37 14. '''Cooler''' ('''**component_id**'''* (Components), '''type''', '''height''', '''max_tdp_supported''')
     3714. '''Cooler''' ('''**__component_id__**'''* (Components), '''type''', '''height''', '''max_tdp_supported''')
    3838
    39 15. '''Cooler_CPU_Sockets''' ('''**cooler_id**''', '''**socket**''')
     3915. '''Cooler_CPU_Sockets''' ('''**__cooler_id__**''', '''**__socket__**''')
    4040
    41 16. '''Memory_Card''' ('''**component_id**'''* (Components), '''num_slots''', '''interface''')
     4116. '''Memory_Card''' ('''**__component_id__**'''* (Components), '''num_slots''', '''interface''')
    4242
    43 17. '''Optical_Drive''' ('''**component_id**'''* (Components), '''form_factor''', '''type''', '''interface''', '''write_speed''', '''read_speed''')
     4317. '''Optical_Drive''' ('''**__component_id__**'''* (Components), '''form_factor''', '''type''', '''interface''', '''write_speed''', '''read_speed''')
    4444
    45 18. '''Sound_Card''' ('''**component_id**'''* (Components), '''sample_rate''', '''bit_depth''', '''chipset''', '''interface''')
     4518. '''Sound_Card''' ('''**__component_id__**'''* (Components), '''sample_rate''', '''bit_depth''', '''chipset''', '''interface''')
    4646
    47 19. '''Sound_Card_Channels''' ('''**sound_card_id**''', '''**channel**''')
     4719. '''Sound_Card_Channels''' ('''**__sound_card_id__**''', '''**__channel__**''')
    4848
    49 20. '''Cables''' ('''**component_id**'''* (Components), '''length_cm''', '''type''')
     4920. '''Cables''' ('''**__component_id__**'''* (Components), '''length_cm''', '''type''')
    5050
    51 21. '''Network_Adapter''' ('''**component_id**'''* (Components), '''wifi_version''', '''interface''', '''num_antennas''')
     5121. '''Network_Adapter''' ('''**__component_id__**'''* (Components), '''wifi_version''', '''interface''', '''num_antennas''')
    5252
    53 22. '''Network_Card''' ('''**component_id**'''* (Components), '''num_ports''', '''speed''', '''interface''')
     5322. '''Network_Card''' ('''**__component_id__**'''* (Components), '''num_ports''', '''speed''', '''interface''')
    5454
    55 23. '''Build''' ('''**id**''', '''user_id'''* (Users), '''name''', '''created_at''', description, '''total_price''', '''is_approved''')
     5523. '''Build''' ('''**__id__**''', '''user_id'''* (Users), '''name''', '''created_at''', description, '''total_price''', '''is_approved''')
    5656
    57 24. '''Build_Component''' ('''**build_id**''', '''**component_id**''')
     5724. '''Build_Component''' ('''**__build_id__**''', '''**__component_id__**''')
    5858
    59 25. '''Favorite_Build''' ('''**build_id**''', '''**user_id**''')
     5925. '''Favorite_Build''' ('''**__build_id__**''', '''**__user_id__**''')
    6060
    61 26. '''Rating_Build''' ('''**build_id**''', '''**user_id**''', '''value''')
     6126. '''Rating_Build''' ('''**__build_id__**''', '''**__user_id__**''', '''value''')
    6262
    63 27. '''Review''' ('''**id**''', '''build_id'''* (Build), '''user_id'''* (Users), '''content''', '''created_at''')
     6327. '''Review''' ('''**__id__**''', '''build_id'''* (Build), '''user_id'''* (Users), '''content''', '''created_at''')
    6464
    65 28. '''Suggestions''' ('''**id**''', '''user_id'''* (Users), admin_id* (Admins), '''link''', admin_comment, description, '''status''', '''component_type''')
     6528. '''Suggestions''' ('''**__id__**''', '''user_id'''* (Users), admin_id* (Admins), '''link''', admin_comment, description, '''status''', '''component_type''')
    6666
    6767== DDL script for creating the database schema ==