Changes between Version 26 and Version 27 of RelationalDesign


Ignore:
Timestamp:
12/08/22 13:38:09 (2 years ago)
Author:
181006
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v26 v27  
    66----
    77
    8 * users (**__id_user__**, **username**, **email**, **surname**, **name**, **phone_number**)
     8* users ( **__id_user__**, **username**, **email**, **surname**, **name**, **phone_number** )
    99
    10 * artist (**__id_user__*** (User), **type_of_artist**, **id_user_admin*** (User))
     10* artist ( **__id_user__*** (User), **type_of_artist**, **id_user_admin*** (User) )
    1111
    12 * admins (**__id_user__*** (User))
     12* admins ( **__id_user__*** (User) )
    1313
    14 * organizer(__**id_user__*** (User))
     14* organizer( __**id_user__*** (User) )
    1515
    16 * customer (__**id_user**__* (User), **transaction_account**)
     16* customer ( __**id_user**__* (User), **transaction_account** )
    1717
    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) )
    1919
    20 * gallery (__**id_event__*** (Event), **style**)
     20* gallery ( __**id_event__*** (Event), **style** )
    2121
    22 * theatre (**__id_event__*** (Event), **director**, **genre**, **duration**)
     22* theatre ( **__id_event__*** (Event), **director**, **genre**, **duration** )
    2323
    24 * museum (**__id_event__*** (Event), **history**, **department**, workshop)
     24* museum ( **__id_event__*** (Event), **history**, **department**, workshop )
    2525
    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) )
    2727
    28 * seat(__**id_event**__* (Event), __**id_seat**__, **number**
     28* seat( __**id_event**__* (Event), __**id_seat**__, **number**
    2929
    30 * cart(__**id_user_customer**__* (User), __**id_cart**__,  **total**)
     30* cart( __**id_user_customer**__* (User), __**id_cart**__,  **total** )
    3131
    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) )
    3333
    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) )
    3535
    36 * artist_Exhibits_Gallery (__**id_event_gallery**__* (Event), __**id_user_artist**__* (User))
     36* artist_Exhibits_Gallery ( __**id_event_gallery**__* (Event), __**id_user_artist**__* (User) )
    3737
    38 * artist_acts_Theatre (__**id_event_theatre**__* (Event), __**id_user_artist**__* (User))
     38* artist_acts_Theatre ( __**id_event_theatre**__* (Event), __**id_user_artist**__* (User) )
    3939
    4040== ''DDL скрипта за бришење на табелите и креирање на табелите''