| | 4 | > '''Ознаки''' |
| | 5 | * примарни клучеви: bold и underline |
| | 6 | * надворешни клучеви: * до името на надворешниот клуч, во заграда табелата кон која покажува |
| | 7 | * not null атрибути: bold |
| | 8 | ---- |
| | 9 | > '''Табели''' |
| | 10 | * 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''') |
| | 11 | * Managers ('''__user_id__'''*(Users)) |
| | 12 | * Organizers ('''__user_id__'''*(Users), '''city''', '''country''', stripe_id, card_brand, card_last_four, trial_ends_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*(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_status''', '''stripe_plan''', quantity, trial_ends_at, ends_at, '''created_at''', updated_at, '''offer_id'''*(Offers)) |
| | 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)) |
| | 25 | |
| | 26 | |
| | 27 | |
