Version 14 (modified by 3 years ago) ( diff ) | ,
---|
Логички и физички дизајн
Релациска шема (со мапирачка трансформација)
Ознаки
- примарни клучеви: bold и underline
- надворешни клучеви: * до името на надворешниот клуч, во заграда табелата кон која покажува
- not null атрибути: bold
Табели
- Artist_Images (id, path, created_at, updated_at, artist_id*(Users))
- Artist_Sings_Genres (artist_id*(Users), 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*(Users), 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*(Users))
- Genres (id, name)
- Manager_Invites (id, email, invitation_token, created_at, updated_at, registered_at, artist_id*(Users))
- 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*(Users), 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*(Users), artist_id*(Users))
- 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 скрипта за бришење на табелите и креирање на табелите
DML скрипта за полнење на табелите со податоци
Релациски дијаграм изваден од DBeaver
Attachments (3)
-
kreiranje.sql
(9.7 KB
) - added by 3 years ago.
kreiranje.sql updated
- schema.jpg (70.1 KB ) - added by 3 years ago.
-
polnenje.sql
(42.8 KB
) - added by 3 years ago.
updated polnenje.sql
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.