Changes between Version 21 and Version 22 of RelationalDesign

Timestamp:

12/08/22 13:03:00 (2 years ago)

Author:

181006

Comment:

--

RelationalDesign

@@ -6 +6 @@
 ----
 
+* 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**)
+
 * 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**)  
+
 * transactions ( __**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))