Changes between Version 13 and Version 14 of RelationalDesign


Ignore:
Timestamp:
03/10/22 16:23:38 (3 years ago)
Author:
191151
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v13 v14  
    88----
    99> '''Табели'''
     10* Artist_Images ('''__id__''', '''path''', '''created_at''', updated_at, '''artist_id'''*(Users))
     11* Artist_Sings_Genres ('''artist_id'''*(Users), '''genre_id'''*(Genres))
     12* Artist_Types ('''__id__''', '''name''')
     13* Artists ('''__user_id__'''*(Users), birth_date, city, country, short_description, price_per_hour, instagram_link, soundcloud_link, apple_music_link, youtube_link, spotify_link, manager_id*(Users), artist_type_id*(Artist_Types), admin_verified_at)
     14* Event_Types ('''__id__''', '''name''')
     15* Events ('''__id__''', '''title''', '''slug''', '''start_time''', '''end_time''',  '''event_date''', '''city''', '''country''', description, '''event_type_id'''*(Event_Types),'''created_at''', updated_at,  '''organizer_id'''*(Users))
     16* Genres ('''__id__''', '''name''')
     17* Manager_Invites ('''__id__''', '''email''', '''invitation_token''', '''created_at''', updated_at, registered_at, '''artist_id'''*(Users))
     18* Managers ('''__user_id__'''*(Users))
     19* Offer_comments ('''__id__''', '''content''', '''created_at''', updated_at, '''author_id'''*(Users), '''offer_id'''*(Offers))
     20* Offers ('''__id__''', '''slug''', '''payment_type''', '''created_at''', updated_at, completed_at, '''artist_id'''*(Users), '''event_id'''*(Events), price, '''status''')
     21* Organizers ('''__user_id__'''*(Users), city, country)
     22* Password_Resets ('''email''', '''token''', created_at)
     23* Reviews ('''__id__''', '''rating''', '''content''', '''created_at''', '''organizer_id'''*(Users), '''artist_id'''*(Users))
     24* Transactions ('''__id__''', '''name''', '''stripe_id''', stripe_price, '''created_at''', updated_at, '''offer_id'''*(Offers), invoice_id)
    1025* Users ('''__id__''', '''email''', '''username''', '''password''', '''name''', '''created_at''', updated_at, deleted_at, email_verified_at, '''profile_picture''', last_login_at, last_login_ip, user_agent, '''type''', remember_token, stripe_id, pm_type, pm_last_four, trial_ends_at)
    11 * Managers ('''__user_id__'''*(Users))
    12 * Organizers ('''__user_id__'''*(Users), '''city''', '''country''')
    13 * Artists ('''__user_id__'''*(Users), birth_date, city, country, admin_verified_at, short_description, price_per_hour, instagram_link, soundcloud_link, apple_music_link, youtube_link, spotify_link, manager_id*(Users), artist_type_id*(Artist_Types))
    14 * Artist_Types ('''__id__''', '''name''')
    15 * Manager_Invites ('''__id__''', '''email''', '''name''', '''invitation_token''', '''created_at''', updated_at, registered_at, '''artist_id'''*(Users))
    16 * Genres ('''__id__''', '''name''')
    17 * Events ('''__id__''', '''created_at''', updated_at, '''slug''', '''city''', '''country''', '''title''', '''end_time''', '''start_time''', '''event_date''', description, '''event_type_id'''*(Event_Types), '''organizer_id'''*(Users))
    18 * Event_Types ('''__id__''', '''name''')
    19 * Offers ('''__id__''', '''slug''', price, '''payment_type''', '''status''', '''created_at''', updated_at, completed_at, '''artist_id'''*(Users), '''event_id'''*(Events))
    20 * Offer_comments ('''__id__''', '''content''', '''created_at''', updated_at, '''author_id'''*(Users), '''offer_id'''*(Offers))
    21 * Transactions ('''__id__''', '''name''', '''stripe_id''', stripe_price, '''created_at''', updated_at, '''offer_id'''*(Offers), invoice_id)
    22 * Artist_Images ('''__id__''', '''path''', '''created_at''', updated_at, '''artist_id'''*(Users))
    23 * Reviews ('''__id__''', '''rating''', '''content''', '''created_at''', '''organizer_id'''*(Users), '''artist_id'''*(Users))
    24 * Artist_sings_genres ('''artist_id'''*(Users), '''genre_id'''*(Genres))
    2526
    2627