| | 1 | == Релациска шема (со мапирачка трансформација) |
| | 2 | |
| | 3 | === Ознаки |
| | 4 | |
| | 5 | - Примарните клучеви се означени со bold и underline |
| | 6 | - Надворешните клучеви се означени со *,^,%,& |
| | 7 | - Задолжителни атрибути, односно not null со bold |
| | 8 | |
| | 9 | === Табели |
| | 10 | |
| | 11 | - //users// (**__ID_user__**, **username**, **password**, **first_name**, **last_name**, address, contact_number, date_created) |
| | 12 | - //workers//(**__ID_worker*__**(users), **position**, **work_hours_from**,**work_hours_to**, **ID_cinema^**(cinemas)) |
| | 13 | - //customers//(**__ID_customer*__**(users),points) |
| | 14 | - //salaries//(**__ID_salary__**, **sum**, **date_from**, date_to, **ID_worker*__**(Workers)) |
| | 15 | - //films//(**__ID_film__**, **name**, **duration**, **actors**, **genre**, **age_category**, **director**, description, release_date) |
| | 16 | - //cinemas//(**__ID_Cinema__**, **name**, **location**) |
| | 17 | - //events//(**__ID_event__**, **theme**, **duration**, **repeating**, **start_dates**) |
| | 18 | - //projections//(**__ID_projection__**, **date_time_start**, **type_of_technology**,**date_time_end**, **ID_film*__*(Films), ID_discount^(Discounts), ID_event%(Events)) |
| | 19 | - //tickets//(**__ID_ticket__**, **price** , **ID_customer*__**(Customer), **ID_projection&**(Projections), ID_discount^(Discounts),**ID_seat%**(Seats)) |
| | 20 | - //discounts//(**__ID_discount__**, **validity**, **code**, **type**, **percent**) |
| | 21 | - //seats//(**__ID_seat__**, **seat_number**, **ID_room*__**(Projection_Rooms) ,**ID_category&**(Categories)) |
| | 22 | - //projection_rooms//(**__ID_room__**, **number_of_seats** ,**projection_room_number**, **ID_cinema*__**(Cinemas)) |
| | 23 | - //categories//(**__ID_category__**, **name**, extra_amount) |
| | 24 | |
| | 25 | |
| | 26 | |
| | 27 | == DDL скрипта за бришење на табелите и креирање на табелите |
| | 28 | |
| | 29 | '''[attachment:kreiranje_v2.sql]''' |
| | 30 | |
| | 31 | == DML скрипта за полнење на табелите со податоци |
| | 32 | |
| | 33 | '''[attachment:polnenje_v2.sql]''' |
| | 34 | |
| | 35 | == Релациски дијаграм изваден од DBeaver |
| | 36 | |
| | 37 | [[Image(schema_v2.png, 100%, center)]] |
