Changes between Version 4 and Version 5 of DDL

Timestamp:

09/13/25 22:07:01 (2 days ago)

Author:

211228

Comment:

--

DDL

@@ -19 +19 @@
 Payment (__'''p_id__''', '''amount''', '''payment_date''', student_id*, '''payed_month''')[[br]]
 * student_id референцира од Student(__'''u_id'''__)[[br]]
-Block (__'''block_id__''', '''num_available_rooms''')[[br]]
+Block (__'''block_id__''', '''num_available_rooms''', '''total_rooms''')[[br]]
 Room (__'''room_number__''', __'''block_id__'''*, '''is_available''', '''capacity''')[[br]]
 * block_id референцира од Block(block_id)[[br]]
@@ -26 +26 @@
 * employee_id референцира од Employee(u_id)[[br]]
 * student_id референцира од Student(u_id)[[br]]
-Student_Took_Room ('''start_date''', end_date, __'''student_id__'''*, __'''room_num__'''*, __'''block_id__'''*)[[br]]
+Student_Took_Room ('''start_date''', end_date, __'''student_id__'''*, __'''room_num__'''*, __'''block_id__'''*, '''end_stay_requested''', '''requested_end_date''')[[br]]
 * room_num, block_id референцираат од Room(room_number, block_id)[[br]]
 * student_id референцира од Student(u_id)
@@ -36 +36 @@
 == ER дијаграм изваден од DBeaver
 
-[[Image(ER_DBeaver.jpg)]]
+[[Image(ER_DBeaver1.jpg)]]