Changes between Version 30 and Version 31 of RelationalDesign
- Timestamp:
- 12/26/22 04:28:26 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v30 v31 6 6 ---- 7 7 8 * users ( **__id_user__**, **username**, **email**, **surname**, **name**, **phone_number**)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), **type_of_artist**, **id_user_admin*** (User)) 11 11 12 * admins ( **__id_user__*** (User))12 * admins (**__id_user__*** (User)) 13 13 14 * organizer( __**id_user__*** (User))14 * organizer(__**id_user__*** (User)) 15 15 16 * customer ( __**id_user**__* (User), **transaction_account**)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**__, **name**, **price**, **city**, **date**, **phone_number**, **id_user_artist*** (User), **id_user_organizer*** (User)) 19 19 20 * gallery ( __**id_event__*** (Event), **style**)20 * gallery (__**id_event__*** (Event), **style**) 21 21 22 * theatre ( **__id_event__*** (Event), **director**, **genre**, **duration**)22 * theatre (**__id_event__*** (Event), **director**, **genre**, **duration**) 23 23 24 * museum ( **__id_event__*** (Event), **history**, **department**, workshop)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**__, **content**, **rating**, **created_at**, **id_user_artist*** (User), **id_user_customer*** (User)) 27 27 28 * seat( __**id_event**__* (Event), __**id_seat**__, **number**)28 * seat(__**id_event**__* (Event), __**id_seat**__, **number**) 29 29 30 * cart( __**id_user_customer**__* (User), __**id_cart**__, **total**)30 * cart(__**id_user_customer**__* (User), __**id_cart**__, **total**) 31 31 32 * transactions ( __**id_transaction**__, **id_invoice**, **edited_at**, **name**, **created_at**, **(id_user_customer, id_cart)*** (Cart))32 * transactions (__**id_transaction**__, **id_invoice**, **edited_at**, **name**, **created_at**, **(id_user_customer, id_cart)*** (Cart)) 33 33 34 * ticket( __**id_ticket**__, **price**, **date**, **location**, **type_of_event**, **id_event*** (Event), **id_user_customer*** (User), **(id_event, id_seat)*** (Seat), **(id_user_customer, id_cart)*** (Cart))34 * ticket(__**id_ticket**__, **price**, **date**, **location**, **type_of_event**, **id_event*** (Event), **id_user_customer*** (User), **(id_event, id_seat)*** (Seat), **(id_user_customer, id_cart)*** (Cart)) 35 35 36 * artist_Exhibits_Gallery ( __**id_event_gallery**__* (Event), __**id_user_artist**__* (User))36 * artist_Exhibits_Gallery (__**id_event_gallery**__* (Event), __**id_user_artist**__* (User)) 37 37 38 * artist_acts_Theatre ( __**id_event_theatre**__* (Event), __**id_user_artist**__* (User))38 * artist_acts_Theatre (__**id_event_theatre**__* (Event), __**id_user_artist**__* (User)) 39 39 40 40 == ''DDL скрипта за бришење на табелите и креирање на табелите''