| | 1 | = Логички и физички дизајн - Креирање база податоци (со SQL DDL) |
| | 2 | == Ознаки |
| | 3 | == Табели |
| | 4 | === Ентитети |
| | 5 | * USER (__'''user_id'''__, user_name, user_surname, user_email, user_mobile_no, city_id*) |
| | 6 | * * референцира до CITY (city_id) |
| | 7 | * VEHICLE (__'''vehicle_id'''__, vehicle_carry_weight, driver_id*, warehouse_id!**) |
| | 8 | * * референцира до DRIVER (user_id) |
| | 9 | * !** референцира до WAREHOUSE (warehouse_id) |
| | 10 | * DELIVERY (__'''delivery_id'''__, delivery_status, delivery_date_created, delivery_date, vehicle_id*) |
| | 11 | * * референцира до VEHICLE (vehicle_id) |
| | 12 | * PRO_FORMA (__'''pro_forma_id'''__, pro_forma_status, pro_forma_deadline, pro_forma_date_created, order_id*) |
| | 13 | * * референцира до ORDERS (order_id) |
| | 14 | * ARTICLE (__'''article_id'''__, article_price, article_image, article_name, article_weight, category_id*) |
| | 15 | * * референцира до CATEGORY (category_id) |
| | 16 | * ORDERS (__'''order_id'''__, order_date_created, order_status, delivery_id*, pro_forma_id!**) |
| | 17 | * * референцира до DELIVERY (delivery_id) |
| | 18 | * !** референцира до PRO_FORMA (pro_forma_id) |
| | 19 | * CITY (__'''city_id'''__, city_name) |
| | 20 | * MANAGER (__'''user_id*''''__, warehouse_id!**) |
| | 21 | * * референцира до USER (user_id) |
| | 22 | * !** референцира до WAREHOUSE (warehouse_id) |
| | 23 | * CUSTOMER (__'''user_id*''''__, customer_EDB, customer_company_name, customer_loc_address, customer_working_hours, customer_representative_image) |
| | 24 | * * референцира до USER (user_id) |
| | 25 | * DRIVER (__'''user_id*''''__, vehicle_id!**) |
| | 26 | * * референцира до USER (user_id) |
| | 27 | * !** референцира до VEHICLE (vehicle_id) |
| | 28 | * WAREHOUSE (__'''warehouse_id'''__, warehouse_address, manager_id*, city_id!**) |
| | 29 | * * референцира до MANAGER (user_id) |
| | 30 | * !** референцира до CITY (city_id) |
| | 31 | * CATEGORY (__'''category_id'''__, category_name) |
| | 32 | * ARTICLE_UNIT (__'''article_id*''''__, order_id!**) |
| | 33 | * * референцира до ARTICLE (article_id) |
| | 34 | * !** референцира до ORDERS (order_id) |
| | 35 | === Релации |
| | 36 | * WAREHOUSE_LOCATION (__'''warehouse_id*, city_id!**''''__) |
| | 37 | * * референцира до WAREHOUSE (warehouse_id) |
| | 38 | * !** референцира до CITY (city_id) |
| | 39 | * IN_STOCK (__'''city_id*, warehouse_id!**''''__) |
| | 40 | * * референцира до CITY (city_id) |
| | 41 | * !** референцира до WAREHOUSE (warehouse_id) |
| | 42 | |
| | 43 | == DDL скрипта за креирање и бришење на табелите |
| | 44 | == DML скрипта за полнење на табелите со податоци |
