Changes between Version 14 and Version 15 of RelationalDesign


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

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v14 v15  
    77
    88* 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))
     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