Changes between Version 12 and Version 13 of RelationalDesign

Timestamp:

12/13/21 19:11:39 (3 years ago)

Author:

193064

Comment:

--

RelationalDesign

@@ -10 +10 @@
  - Payment_type('''__payment_type_id__''', '''payment_type''', '''payment_id*'''(Payment))
 
- - Payment('''__payment_id__''', '''payment_date''')
+ - Payment('''__payment_id__''', '''payment_date''','''client_id*'''(Client))
 
- - Reservation('''__reservation_id__''', '''reservation_end_date''')
+ - Reservation('''__reservation_id__''', '''reservation_end_date''','''payment_id*'''(Payment), '''payment_type_id*'''(Payment_type),'''client_id*'''(Client), '''projection_id*'''(MovieProjection))
 
- - Client('''client_id''')
+ - Client('''client_id''','''user_id*'''(Users))
 
- - Seat('''__seat_id__''', '''seat_number''', '''seat_row_number''')
+ - Seat('''__seat_id__''', '''seat_number''', '''seat_row_number''',('''__seat_id__''','''__auditorium_id__''','''__projection_id__'''),'''auditorium_id*'''(Auditorium),'''reservation_id*'''(Reservation),'''projection_id*'''(MovieProjection))
 
- - Auditorium('''__auditorium_id__''','''auditorium_name''', '''auditorium_capacity''')
+ - Auditorium('''__auditorium_id__''','''auditorium_name''', '''auditorium_capacity''','''projection_id*'''(MovieProjection))
 
- - Firm('''__firm_id__''', '''firm_city''', '''firm_adress''', '''firm_name''')
+ - Firm('''__firm_id__''', '''firm_city''', '''firm_adress''', '''firm_name''','''auditorium_id*'''(Auditorium), '''employee_id*'''(Employee))
 
- - Movieprojection('''__projection_id__''', '''projection_movie_start''', '''projection_movie_end''', '''projection_screening_date''', '''projection_type''', '''projection_price''')
+ - Movieprojection('''__projection_id__''', '''projection_movie_start''', '''projection_movie_end''', '''projection_screening_date''', '''projection_type''', '''projection_price''','''movie_id*'''(Movie))
 
- - Employee('''employee_id''')
+ - Employee('''employee_id''','''user_id*'''(Users))
 
  - Genre('''__genre_id__''', '''genre_name''')
 
- - Movie('''__movie_id__''', '''movie_name''', '''movie_age_category''','''movie_production''', '''movie_film_director''', '''movie_cast''','''movie_time_duration''')
+ - Movie('''__movie_id__''', '''movie_name''', '''movie_age_category''','''movie_production''', '''movie_film_director''', '''movie_cast''','''movie_time_duration''','''genre_id*'''(Genre))
 
  - User('''__user_id__''', '''user_username''', '''user_password''','''user_phone_number''','''user_name''', '''user_surname''', '''user_email''', '''user_role''')