Changes between Version 9 and Version 10 of Design

Timestamp:

12/17/25 22:49:22 (13 days ago)

Author:

213140

Comment:

--

Design

@@ -14 +14 @@
 * id_therapist референцира од therapist
 
-therapist (__'''id_therapist'''__, __id_user__*, '''office_location''', '''degree''', '''years_exp''')
+therapist (__'''id_therapist'''__, __id_user__*, '''office_location''', '''degree''', '''years_exp''', '''consultation_slots''')
 * id_user референцира од user
 
-blog (__'''id_blog'''__, __id_patient__*, '''content''', '''date_of_post''')
+blog (__'''id_blog'''__, __id_patient__*, '''content''', '''date_of_post''', '''title''')
 * id_patient референцира од patient 
 
@@ -24 +24 @@
 * id_patient референцира од patient
 
-diary (__'''id_diary'''__, __id_patient__*, '''date''', '''daily_rating''')
-* id_patient референцира од patient
-
-payment (__'''id_payment'''__, __id_patient__*, '''price''', '''date_of_payment''')
+diary (__'''id_diary'''__, __id_patient__*, '''date''', '''daily_rating''', '''content''')
 * id_patient референцира од patient
 
 therapy (__'''id_therapy'''__, '''name''', '''dose''', '''exp_date''')
 
-consultation (__'''id_consultation'''__, '''date''', '''price''')
+consultation (__'''id_consultation'''__, '''date''', '''price''', '''date_of_payment''', '''advice''')
 
 == DDL скрипта за бришење и креирање на табелите