Changes between Version 30 and Version 31 of RelationalDesign


Ignore:
Timestamp:
12/26/22 04:28:26 (2 years ago)
Author:
181006
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v30 v31  
    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_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))
    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 скрипта за бришење на табелите и креирање на табелите''