Changes between Version 12 and Version 13 of RelationalDesign


Ignore:
Timestamp:
11/15/22 23:40:31 (2 years ago)
Author:
191285
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v12 v13  
    66----
    77
    8 * Event ( **id_event**, **name**, **price**, **city**, **date**, **phone_number**, **id_user_artist***(User),id_user_organizer*(User))
    9 * Gallery (id_event*(Event), style)
    10 * Theatre (id_event*(Event), director, genre, duration)
    11 * Museum (id_event*(Event), workshop, history, department)
    12 * User (id_user, username, email, surname, name, phone_number)
    13 * Artist (id_user* (User), type_of_artist, id_user_admin*(User))
    14 * Admin (id_user* (User))
    15 * Organizer(id_user* (User))
    16 * Customer (id_user* (User), transaction_account)
    17 * Review ( id_review, content, rating, created_at,id_user_artist*(User))
    18 * Seat(id_ticket*(Ticket), id_event* (Event), id_seat, number
    19 * Transaction ( id_transaction, id_invoice, edited_at, name, created_at)
    20 * Cart(id_cart, total)
    21 * Ticket( id_ticket, price, date, location, type_of_event, id_event*(Event), id_user_customer*(User), id_cart (Cart), id_seat*(Seat))
    22 * Artist_Exhibits_Gallery (id_event_gallery*(Event), id_user_artist*(User))
    23 * Artist_acts_Theatre (id_event_theatre*(Event), id_user_artist*(User))
    24 * Event_has_seat (id_event*(Event), id_seat*(Seat))
     8* Event ( **id_event**, **name**, **price**, **city**, **date**, **phone_number**, **id_user_artist***(User),**id_user_organizer***(User))
     9* Gallery (**id_event***(Event), **style**)
     10* Theatre (**id_event***(Event), **director**, **genre**, **duration**)
     11* Museum (**id_event***(Event), workshop, **history**, **department**)
     12* User (**id_user**, **username**, **email**, **surname**, **name**, **phone_number**)
     13* Artist (**id_user*** (User), **type_of_artist**, **id_user_admin***(User))
     14* Admin (**id_user*** (User))
     15* Organizer(id_user*** (User))
     16* Customer (id_user*** (User), **transaction_account**)
     17* Review ( **id_review**, **content**, **rating**, **created_at**, **id_user_artist***(User))
     18* Seat(**id_ticket***(Ticket), **id_event*** (Event), **id_seat**, **number**
     19* Transaction ( **id_transaction**, **id_invoice**, **edited_at**, **name**, **created_at**)
     20* Cart(**id_cart**, **total**)
     21* Ticket( **id_ticket**, **price**, **date**, **location**, **type_of_event**, **id_event***(Event), **id_user_customer***(User), **id_cart**(Cart), **id_seat***(Seat))
     22* Artist_Exhibits_Gallery (**id_event_gallery***(Event), **id_user_artist***(User))
     23* Artist_acts_Theatre (**id_event_theatre***(Event), **id_user_artist***(User))
     24* Event_has_seat (**id_event***(Event), **id_seat***(Seat))
    2525== ''DDL скрипта за бришење на табелите и креирање на табелите''
    2626