Changes between Version 26 and Version 27 of RelationalDesign
- Timestamp:
- 12/08/22 13:38:09 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v26 v27 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_seat*** (Seat), **id_cart*** (Cart) )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 * 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 скрипта за бришење на табелите и креирање на табелите''