Changes between Version 4 and Version 5 of RelationalDesign


Ignore:
Timestamp:
12/17/25 18:18:45 (11 days ago)
Author:
233144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v4 v5  
    292910. '''PC_Case''' ('''**__component_id__**'''* (Components), '''cooler_max_height''', '''gpu_max_length''')
    3030
    31 11. '''Case_Storage_Form_Factors''' ('''**__case_id__**'''*(PC_Case), '''**__form_factor__**''')
     3111. '''Case_Storage_Form_Factors''' ('''**__case_id__**'''*(PC_Case), '''**__form_factor__**''', **num_slots**)
    3232
    333312. '''Case_PS_Form_Factors''' ('''**__case_id__**'''*(PC_Case), '''**__form_factor__**''')
    … …  
    434317. '''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''', '''channel''')
    4646
    47 19. '''Sound_Card_Channels''' ('''**__sound_card_id__**'''*(Sound_Card), '''**__channel__**''')
     4719. '''Cables''' ('''**__component_id__**'''* (Components), '''length_cm''', '''type''')
    4848
    49 20. '''Cables''' ('''**__component_id__**'''* (Components), '''length_cm''', '''type''')
     4920. '''Network_Adapter''' ('''**__component_id__**'''* (Components), '''wifi_version''', '''interface''', '''num_antennas''')
    5050
    51 21. '''Network_Adapter''' ('''**__component_id__**'''* (Components), '''wifi_version''', '''interface''', '''num_antennas''')
     5121. '''Network_Card''' ('''**__component_id__**'''* (Components), '''num_ports''', '''speed''', '''interface''')
    5252
    53 22. '''Network_Card''' ('''**__component_id__**'''* (Components), '''num_ports''', '''speed''', '''interface''')
     5322. '''Build''' ('''**__id__**''', '''user_id'''* (Users), '''name''', '''created_at''', description, '''total_price''', '''is_approved''')
    5454
    55 23. '''Build''' ('''**__id__**''', '''user_id'''* (Users), '''name''', '''created_at''', description, '''total_price''', '''is_approved''')
     5523. '''Build_Component''' ('''**__build_id__**'''*(Build), '''**__component_id__**'''*(Component))
    5656
    57 24. '''Build_Component''' ('''**__build_id__**'''*(Build), '''**__component_id__**'''*(Component))
     5724. '''Favorite_Build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users))
    5858
    59 25. '''Favorite_Build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users))
     5925. '''Rating_Build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users), '''value''')
    6060
    61 26. '''Rating_Build''' ('''**__build_id__**'''*(Build), '''**__user_id__**'''*(Users), '''value''')
     6126. '''Review''' ('''**__id__**''', '''build_id'''* (Build), '''user_id'''* (Users), '''content''', '''created_at''')
    6262
    63 27. '''Review''' ('''**__id__**''', '''build_id'''* (Build), '''user_id'''* (Users), '''content''', '''created_at''')
    64 
    65 28. '''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''')
    6664
    6765== DDL script for creating the database schema ==