Changes between Version 17 and Version 18 of RelationalDesign


Ignore:
Timestamp:
01/29/26 00:35:36 (11 days ago)
Author:
233144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v17 v18  
    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''', '''type''', img_url)
     153. '''components''' ('''**__id__**''', '''name''', '''brand''', '''price''', '''type''', 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
    19 5. '''GPU''' ('''**__component_id__**'''* (Components), '''vram''', '''tdp''', base_clock, boost_clock, '''chipset''', '''length''')
     195. '''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''', '''pci_express_slots''')
     279. '''motherboard''' ('''**__component_id__**'''* (Components), '''socket''', '''chipset''', '''form_factor''', '''ram_type''', '''num_ram_slots''', '''max_ram_capacity''', '''pci_express_slots''')
    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__**'''*(PC_Case), '''**__form_factor__**''', **num_slots**)
     3111. '''case_storage_form_factors''' ('''**__case_id__**'''*(PC_Case), '''**__form_factor__**''', **num_slots**)
    3232
    33 12. '''Case_PS_Form_Factors''' ('''**__case_id__**'''*(PC_Case), '''**__form_factor__**''')
     3312. '''case_ps_form_factors''' ('''**__case_id__**'''*(PC_Case), '''**__form_factor__**''')
    3434
    35 13. '''Case_Mobo_Form_Factors''' ('''**__case_id__**'''*(PC_Case), '''**__form_factor__**''')
     3513. '''case_mobo_form_factors''' ('''**__case_id__**'''*(PC_Case), '''**__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__**'''*(Cooler), '''**__socket__**''')
     3915. '''cooler_cpu_sockets''' ('''**__cooler_id__**'''*(Cooler), '''**__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''', '''channel''')
     4518. '''sound_card''' ('''**__component_id__**'''* (Components), '''sample_rate''', '''bit_depth''', '''chipset''', '''interface''', '''channel''')
    4646
    47 19. '''Cables''' ('''**__component_id__**'''* (Components), '''length_cm''', '''type''')
     4719. '''cables''' ('''**__component_id__**'''* (Components), '''length_cm''', '''type''')
    4848
    49 20. '''Network_Adapter''' ('''**__component_id__**'''* (Components), '''wifi_version''', '''interface''', '''num_antennas''')
     4920. '''network_adapter''' ('''**__component_id__**'''* (Components), '''wifi_version''', '''interface''', '''num_antennas''')
    5050
    51 21. '''Network_Card''' ('''**__component_id__**'''* (Components), '''num_ports''', '''speed''', '''interface''')
     5121. '''network_card''' ('''**__component_id__**'''* (Components), '''num_ports''', '''speed''', '''interface''')
    5252
    53 22. '''Build''' ('''**__id__**''', '''user_id'''* (Users), '''name''', '''created_at''', description, '''total_price''', '''is_approved''')
     5322. '''build''' ('''**__id__**''', '''user_id'''* (Users), '''name''', '''created_at''', description, '''total_price''', '''is_approved''')
    5454
    55 23. '''Build_Component''' ('''**__build_id__**'''*(Build), '''**__component_id__**'''*(Component), num_components)
     5523. '''build_component''' ('''**__build_id__**'''*(Build), '''**__component_id__**'''*(Component), num_components)
    5656
    57 24. '''Favorite_Build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users))
     5724. '''favorite_build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users))
    5858
    59 25. '''Rating_Build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users), '''value''')
     5925. '''rating_build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users), '''value''')
    6060
    61 26. '''Review''' ('''**__id__**''', '''build_id'''* (Build), '''user_id'''* (Users), '''content''', '''created_at''')
     6126. '''review''' ('''**__id__**''', '''build_id'''* (Build), '''user_id'''* (Users), '''content''', '''created_at''')
    6262
    63 27. '''Suggestions''' ('''**__id__**''', '''user_id'''* (Users), admin_id* (Admins), '''link''', admin_comment, description, '''status''', '''component_type''')
     6327. '''suggestions''' ('''**__id__**''', '''user_id'''* (Users), admin_id* (Admins), '''link''', admin_comment, description, '''status''', '''component_type''')
    6464
    6565== DDL script for creating the database schema ==