Changes between Version 14 and Version 15 of RelationalDesign
- Timestamp:
- 03/30/22 17:51:58 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v14 v15 8 8 ---- 9 9 > '''Табели''' 10 * Artist_Images ('''__id__''', '''path''', '''created_at''', updated_at, '''artist_id'''*( Users))11 * Artist_Sings_Genres ('''artist_id'''*( Users), '''genre_id'''*(Genres))10 * Artist_Images ('''__id__''', '''path''', '''created_at''', updated_at, '''artist_id'''*(Artists)) 11 * Artist_Sings_Genres ('''artist_id'''*(Artists), '''genre_id'''*(Genres)) 12 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)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*(Managers), artist_type_id*(Artist_Types), admin_verified_at) 14 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))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'''*(Organizers)) 16 16 * Genres ('''__id__''', '''name''') 17 * Manager_Invites ('''__id__''', '''email''', '''invitation_token''', '''created_at''', updated_at, registered_at, '''artist_id'''*( Users))17 * Manager_Invites ('''__id__''', '''email''', '''invitation_token''', '''created_at''', updated_at, registered_at, '''artist_id'''*(Artists)) 18 18 * Managers ('''__user_id__'''*(Users)) 19 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''')20 * Offers ('''__id__''', '''slug''', '''payment_type''', '''created_at''', updated_at, completed_at, '''artist_id'''*(Artists), '''event_id'''*(Events), price, '''status''') 21 21 * Organizers ('''__user_id__'''*(Users), city, country) 22 22 * Password_Resets ('''email''', '''token''', created_at) 23 * Reviews ('''__id__''', '''rating''', '''content''', '''created_at''', '''organizer_id'''*( Users), '''artist_id'''*(Users))23 * Reviews ('''__id__''', '''rating''', '''content''', '''created_at''', '''organizer_id'''*(Organizers), '''artist_id'''*(Artists)) 24 24 * Transactions ('''__id__''', '''name''', '''stripe_id''', stripe_price, '''created_at''', updated_at, '''offer_id'''*(Offers), invoice_id) 25 25 * 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)