Changes between Version 3 and Version 4 of RelationalDesign
- Timestamp:
- 12/11/21 13:52:10 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v3 v4 8 8 === Табели 9 9 10 Payment_type('''__payment_type_id__''', '''payment_type''')10 - Payment_type('''__payment_type_id__''', '''payment_type''') 11 11 12 Payment('''__payment_id__''', '''payment_date''')12 - Payment('''__payment_id__''', '''payment_date''') 13 13 14 Reservation('''__reservation_id__''', '''reservation_end_date''')14 - Reservation('''__reservation_id__''', '''reservation_end_date''') 15 15 16 Client('''client_id''')16 - Client('''client_id''') 17 17 18 Seat('''__seat_id__''', '''seat_number''', '''seat_row_number''')18 - Seat('''__seat_id__''', '''seat_number''', '''seat_row_number''') 19 19 20 Auditorium('''__auditorium_id__''','''auditorium_name''', '''auditorium_capacity''')20 - Auditorium('''__auditorium_id__''','''auditorium_name''', '''auditorium_capacity''') 21 21 22 Firm('''__firm_id__''', '''firm_city''', '''firm_adress''', '''firm_name''')22 - Firm('''__firm_id__''', '''firm_city''', '''firm_adress''', '''firm_name''') 23 23 24 Movieprojection('''__projection_id__''', '''projection_movie_start''', '''projection_movie_end''', '''projection_screening_date''', '''projection_type''', '''projection_price''')24 - Movieprojection('''__projection_id__''', '''projection_movie_start''', '''projection_movie_end''', '''projection_screening_date''', '''projection_type''', '''projection_price''') 25 25 26 Employee('''employee_id''')26 - Employee('''employee_id''') 27 27 28 Genre('''__genre_id__''', '''genre_name''')28 - Genre('''__genre_id__''', '''genre_name''') 29 29 30 Movie('''__movie_id__''', '''movie_name''', '''movie_age_category''','''movie_production''', '''movie_film_director''', '''movie_cast''','''movie_time_duration''')30 - Movie('''__movie_id__''', '''movie_name''', '''movie_age_category''','''movie_production''', '''movie_film_director''', '''movie_cast''','''movie_time_duration''') 31 31 32 User('''__user_id__''', '''user_username''', '''user_password''','''user_phone_number''','''user_name''', '''user_surname''', '''user_email''', '''user_role''')32 - User('''__user_id__''', '''user_username''', '''user_password''','''user_phone_number''','''user_name''', '''user_surname''', '''user_email''', '''user_role''') 33 33 34 34 == Креирање на табели