Changes between Version 12 and Version 13 of RelationalDesign

Timestamp:

03/01/22 13:50:33 (2 years ago)

Author:

191215

Comment:

--

RelationalDesign

@@ -8 +8 @@
 ----
 > '''Табели'''
-* Users ('''__id__''', '''email''', '''username''', '''password''', '''full_name''', '''created_at''', updated_at, deleted_at, email_verified_at, '''profile_picture''', last_login_at, last_login_ip, user_agent, '''type''')
+* 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)
 * Managers ('''__user_id__'''*(Users))
-* Organizers ('''__user_id__'''*(Users), '''city''', '''country''', stripe_id, card_brand, card_last_four, trial_ends_at)
-* 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))
+* Organizers ('''__user_id__'''*(Users), '''city''', '''country''')
+* 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))
 * Artist_Types ('''__id__''', '''name''')
 * Manager_Invites ('''__id__''', '''email''', '''name''', '''invitation_token''', '''created_at''', updated_at, registered_at, '''artist_id'''*(Users))
@@ -17 +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))
 * Event_Types ('''__id__''', '''name''')
-* Offers ('''__id__''', '''slug''', '''price''', '''payment_type''', '''status''', '''created_at''', updated_at, completed_at, '''artist_id'''*(Users), '''event_id'''*(Events))
+* Offers ('''__id__''', '''slug''', price, '''payment_type''', '''status''', '''created_at''', updated_at, completed_at, '''artist_id'''*(Users), '''event_id'''*(Events))
 * Offer_comments ('''__id__''', '''content''', '''created_at''', updated_at, '''author_id'''*(Users), '''offer_id'''*(Offers))
-* Transactions ('''__id__''', '''name''', '''stripe_id''', '''stripe_status''', '''stripe_plan''', '''quantity''', trial_ends_at, ends_at, '''created_at''', updated_at, '''offer_id'''*(Offers))
+* Transactions ('''__id__''', '''name''', '''stripe_id''', stripe_price, '''created_at''', updated_at, '''offer_id'''*(Offers), invoice_id)
 * Artist_Images ('''__id__''', '''path''', '''created_at''', updated_at, '''artist_id'''*(Users))
 * Reviews ('''__id__''', '''rating''', '''content''', '''created_at''', '''organizer_id'''*(Users), '''artist_id'''*(Users))