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

== Релациска шема (со мапирачка трансформација)
> '''Ознаки'''
* примарни клучеви: '''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 скрипта за бришење на табелите и креирање на табелите
[attachment:kreiranje.sql]

== DML скрипта за полнење на табелите со податоци 
[attachment:polnenje.sql]

== Релациски дијаграм изваден од DBeaver
[[Image(schema.jpg)]]