Changes between Version 23 and Version 24 of RelationalDesign
- Timestamp:
- 12/08/22 13:21:44 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v23 v24 8 8 * users (**__id_user__**, **username**, **email**, **surname**, **name**, **phone_number**) 9 9 10 * artist (**__id_user__*** (User), ** id_user_admin*** (User), **type_of_artist**)10 * artist (**__id_user__*** (User), **type_of_artist**, **id_user_admin*** (User)) 11 11 12 12 * admins (**__id_user__*** (User)) … … 16 16 * customer (__**id_user**__* (User), **transaction_account**) 17 17 18 * events ( __**id_event**__, ** id_user_artist*** (User), **id_user_organizer*** (User), **name**, **price**, **city**, **date**, **phone_number**)18 * events ( __**id_event**__, **name**, **price**, **city**, **date**, **phone_number**, **id_user_artist*** (User), **id_user_organizer*** (User)) 19 19 20 20 * gallery (__**id_event__*** (Event), **style**) … … 24 24 * museum (**__id_event__*** (Event), **history**, **department**, workshop) 25 25 26 * review ( __**id_review**__, ** id_user_artist*** (User), **id_user_customer*** (User), **content**, **rating**, **created_at**)26 * review ( __**id_review**__, **content**, **rating**, **created_at**, **id_user_artist*** (User), **id_user_customer*** (User)) 27 27 28 28 * seat(__**id_event**__* (Event), __**id_seat**__, **number**) 29 29 30 * transactions ( __**id_transaction**__, **id_ cart*** (Cart), **id_invoice**, **edited_at**, **name**, **created_at**)30 * transactions ( __**id_transaction**__, **id_invoice**, **edited_at**, **name**, **created_at**, **id_cart*** (Cart)) 31 31 32 * cart(__**id_ cart**__, __**id_user_customer**__* (User),**total**)32 * cart(__**id_user_customer**__* (User), __**id_cart**__, **total**) 33 33 34 * ticket( __**id_ticket**__, ** id_event*** (Event), **id_user_customer*** (User), **id_seat*** (Seat), **id_cart*** (Cart), **price**, **date**, **location**, **type_of_event**)34 * ticket( __**id_ticket**__, **price**, **date**, **location**, **type_of_event**, **id_event*** (Event), **id_user_customer*** (User), **id_seat*** (Seat), **id_cart*** (Cart)) 35 35 36 36 * artist_Exhibits_Gallery (__**id_event_gallery**__* (Event), __**id_user_artist**__* (User))
