Changes between Version 15 and Version 16 of RelationalDesign

Timestamp:

11/28/22 12:12:46 (2 years ago)

Author:

181006

Comment:

--

RelationalDesign

@@ -6 +6 @@
 ----
 
-* Event ( __**id_event**__, **name**, **price**, **city**, **date**, **phone_number**, **id_user_artist***(User),**id_user_organizer***(User))
-* Gallery (__**id_event__***(Event), **style**)
-* Theatre (**__id_event__***(Event), **director**, **genre**, **duration**)
-* Museum (**__id_event__***(Event), workshop, **history**, **department**)
+* Event ( __**id_event**__, **name**, **price**, **city**, **date**, **phone_number**, **id_user_artist*** (User), **id_user_organizer*** (User))
+* Gallery (__**id_event__*** (Event), **style**)
+* Theatre (**__id_event__*** (Event), **director**, **genre**, **duration**)
+* Museum (**__id_event__*** (Event), **history**, **department**, workshop)
 * User (**__id_user__**, **username**, **email**, **surname**, **name**, **phone_number**)
-* Artist (**__id_user__*** (User), **type_of_artist**, **id_user_admin***(User))
+* Artist (**__id_user__*** (User), **type_of_artist**, **id_user_admin*** (User))
 * Admin (**__id_user__*** (User))
 * Organizer(__**id_user__*** (User))
 * Customer (__**id_user**__* (User), **transaction_account**)
-* Review ( __**id_review**__, **content**, **rating**, **created_at**, **id_user_artist***(User))
-* Seat(__**id_ticket**__*(Ticket), **id_event*** (Event), **id_seat**, **number**)  
-* Transaction ( __**id_transaction**__, **id_invoice**, **edited_at**, **name**, **created_at**)
-* Cart(__**id_cart**__, **total**)
-* Ticket( __**id_ticket**__, **price**, **date**, **location**, **type_of_event**, **id_event***(Event), **id_user_customer***(User), **id_cart**(Cart), **id_seat***(Seat))
-* Artist_Exhibits_Gallery (__**id_event_gallery**__*(Event), __**id_user_artist**__*(User))
-* Artist_acts_Theatre (__**id_event_theatre**__*(Event), __**id_user_artist**__*(User))
-* Event_has_seat (__**id_event**__*(Event), ___**id_seat**__*(Seat)) 
+* Review ( __**id_review**__, **content**, **rating**, **created_at**, **id_user_artist*** (User),  **id_user_customer*** (User))
+* Seat(__**id_event**__* (Event), __**id_seat**__, **number**)  
+* Transaction ( __**id_transaction**__, **id_cart*** (Cart), **id_invoice**, **edited_at**, **name**, **created_at**)
+* Cart(__**id_cart**__, __**id_user_customer**__* (User), **total**)
+* Ticket( __**id_ticket**__, **price**, **date**, **location**, **type_of_event**, **id_event***(Event), **id_user_customer***(User), **id_seat*** (Seat), **id_cart*** (Cart))
+
+* Artist_Exhibits_Gallery (__**id_event_gallery**__* (Event), __**id_user_artist**__* (User))
+* Artist_acts_Theatre (__**id_event_theatre**__* (Event), __**id_user_artist**__* (User))
 == ''DDL скрипта за бришење на табелите и креирање на табелите''