Changes between Version 16 and Version 17 of RelationalDesign

Timestamp:

11/29/22 21:02:57 (2 years ago)

Author:

191285

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), **history**, **department**, workshop)
-* User (**__id_user__**, **username**, **email**, **surname**, **name**, **phone_number**)
-* 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),  **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))
+* events ( __**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)
+* users (**__id_user__**, **username**, **email**, **surname**, **name**, **phone_number**)
+* artist (**__id_user__*** (User), **type_of_artist**, **id_user_admin*** (User))
+* admins (**__id_user__*** (User))
+* organizer(__**id_user__*** (User))
+* customer (__**id_user**__* (User), **transaction_account**)
+* 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))
+* artist_Exhibits_Gallery (__**id_event_gallery**__* (Event), __**id_user_artist**__* (User))
+* artist_acts_Theatre (__**id_event_theatre**__* (Event), __**id_user_artist**__* (User))
 == ''DDL скрипта за бришење на табелите и креирање на табелите''