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