Логички и физички дизајн

Релациска шема (со мапирачка трансформација)

Ознаки

• примарни клучеви: bold и underline
• надворешни клучеви: * до името на надворешниот клуч, во заграда табелата кон која покажува
• not null атрибути: bold

---

Табели

• Artist_Images (id, path, created_at, updated_at, artist_id*(Artists))
• Artist_Sings_Genres (artist_id*(Artists), genre_id*(Genres))
• Artist_Types (id, name)
• 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)
• Event_Types (id, name)
• 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))
• Genres (id, name)
• Manager_Invites (id, email, invitation_token, created_at, updated_at, registered_at, artist_id*(Artists))
• Managers (user_id*(Users))
• Offer_comments (id, content, created_at, updated_at, author_id*(Users), offer_id*(Offers))
• Offers (id, slug, payment_type, created_at, updated_at, completed_at, artist_id*(Artists), event_id*(Events), price, status)
• Organizers (user_id*(Users), city, country)
• Password_Resets (email, token, created_at)
• Reviews (id, rating, content, created_at, organizer_id*(Organizers), artist_id*(Artists))
• Transactions (id, name, stripe_id, stripe_price, created_at, updated_at, offer_id*(Offers), invoice_id)
• 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)

DDL скрипта за бришење на табелите и креирање на табелите

kreiranje.sql​

DML скрипта за полнење на табелите со податоци

polnenje.sql​

Релациски дијаграм изваден од DBeaver