Changes between Version 2 and Version 3 of RelationalDesign

Timestamp:

12/04/22 21:08:41 (2 years ago)

Author:

201094

Comment:

--

RelationalDesign

@@ -10 +10 @@
 
  - //users// (**__ID_user__**, **username**, **password**, **first_name**, **last_name**,  address, contact_number, date_created)
- - //workers//(**__ID_worker*__**(users), **position**, **work_hours_from**,**work_hours_to**, **ID_cinema#**(cinemas))
- - //customers//(**__ID_customer*__**(users),points) 
+ - //workers//(**__ID_worker*__**(users), **position**, **work_hours_from**, **work_hours_to**, **ID_cinema#**(cinemas))
+ - //customers//(**__ID_customer*__**(users), points) 
  - //salaries//(**__ID_salary__**, **sum**, **date_from**, date_to, **ID_worker*__**(Workers))
  - //films//(**__ID_film__**, **name**, **duration**, **actors**, **genre**, **age_category**, **director**, description, release_date)
  - //cinemas//(**__ID_Cinema__**, **name**, **location**)
  - //events//(**__ID_event__**, **theme**, **duration**, **repeating**, **start_dates**)
- - //projections//(**__ID_projection__**, **date_time_start**, **type_of_technology**,**date_time_end**, **ID_film*__*(Films), ID_discount#(Discounts), ID_event%(Events))
- - //tickets//(**__ID_ticket__**, **price** , **ID_customer*__**(Customer), **ID_projection&**(Projections), ID_discount#(Discounts),**ID_seat%**(Seats))
+ - //projections//(**__ID_projection__**, **date_time_start**, **type_of_technology**, **date_time_end**, **ID_film*__*(Films), ID_discount#(Discounts), ID_event%(Events))
+ - //tickets//(**__ID_ticket__**, **price** , **ID_customer*__**(Customer), **ID_projection&**(Projections), ID_discount#(Discounts), **ID_seat%**(Seats))
  - //discounts//(**__ID_discount__**, **validity**, **code**, **type**, **percent**)
- - //seats//(**__ID_seat__**, **seat_number**, **ID_room*__**(Projection_Rooms) ,**ID_category&**(Categories))
+ - //seats//(**__ID_seat__**, **seat_number**, **ID_room*__**(Projection_Rooms) , **ID_category&**(Categories))
  - //projection_rooms//(**__ID_room__**, **number_of_seats** ,**projection_room_number**, **ID_cinema*__**(Cinemas))
  - //categories//(**__ID_category__**, **name**, extra_amount)