| 7 | | * USERS (__'''user_id'''__, user_name, user_surname, user_email, user_mobile, city_id*) |
| | 7 | * CATEGORY (__'''category_id'''__, category_name) |
| | 8 | * CITY (__'''city_id'''__, city_name) |
| | 9 | * ORDER_STATUS (__**order_status_id**__, order_status_name, order_status_description) |
| | 10 | * DELIVERY_STATUS (__**delivery_status_id**__, delivery_status_name, delivery_status_description) |
| | 11 | * PRO_FORMA_STATUS (__**pro_forma_status_id**__, pro_forma_status_name, pro_forma_status_description) |
| | 12 | * USERS (__'''user_id'''__, user_name, user_surname, user_pass, user_salt, user_email, user_email_conf, user_mobile, user_image, city_id*) |
| 9 | | * VEHICLE (__'''vehicle_id'''__, vehicle_carry_weight, vehicle_service_interval, vehicle_kilometers, vehicle_last_service, driver_id*, warehouse_id!**) |
| 10 | | * * референцира до DRIVER (user_id) |
| | 14 | * CUSTOMER (__'''user_id*''''__, customer_EDB, customer_company_name, customer_address, customer_open_time, customer_close_time, customer_representative_image) |
| | 15 | * WAREHOUSE (__'''warehouse_id'''__, warehouse_address, city_id*) |
| | 16 | * * референцира до CITY (city_id) |
| | 17 | * MANAGER (__'''user_id*''''__, warehouse_id!**) |
| | 18 | * * референцира до USER (user_id) |
| 12 | | * DELIVERY (__'''delivery_id'''__, delivery_status, delivery_date_created, delivery_date, vehicle_id*, delivery_status_id!**) |
| 13 | | * * референцира до VEHICLE (vehicle_id) |
| 14 | | * !** референцира до DELIVERY_STATUS (delivery_status_id) |
| | 20 | * * референцира до USER (user_id) |
| | 21 | * VEHICLE (__'''vehicle_id'''__, vehicle_carry_weight, vehicle_service_interval, vehicle_kilometers, vehicle_last_service, vehicle_last_service_km, vehicle_plate, vehicle_vin, vehicle_reg, warehouse_id*) |
| | 22 | * * референцира до WAREHOUSE (warehouse_id) |
| | 23 | * DRIVER (__'''user_id*''''__, vehicle_id!**) |
| | 24 | * * референцира до USER (user_id) |
| | 25 | * !** референцира до VEHICLE (vehicle_id) |
| | 26 | * MANUFACTURER (__'''manufacturer_id'''__, manufacturer_name, manufacturer_address, manufacturer_mobile, manufacturer_email) |
| | 27 | * ARTICLE (__'''article_id'''__, article_image, article_name, article_weight, category_id*, manufacturer_id!**) |
| | 28 | * * референцира до CATEGORY (category_id) |
| | 29 | * !** референцира до MANUFACTURER (manufacturer_id) |
| | 30 | * PRICE (__'''price_id'''__, price, price_eff_date, article_id*) |
| | 31 | * * референцира до ARTICLE (article_id) |
| 18 | | * ARTICLE (__'''article_id'''__, article_price, article_image, article_name, article_weight, category_id*) |
| 19 | | * * референцира до CATEGORY (category_id) |
| 20 | | * ORDERS (__'''order_id'''__, order_date, order_status, order_sum, order_fulfillment_date, delivery_id*, pro_forma_id!**, customer_id!***, order_status_id!**!**) |
| 21 | | * * референцира до DELIVERY (delivery_id) |
| 22 | | * !** референцира до PRO_FORMA (pro_forma_id) |
| 23 | | * !*** референцира до CUSTOMER(user_id) |
| | 35 | * DELIVERY (__''delivery_id''__, delivery_date_created, delivery_date, delivery_start_km, delivery_end_km, delivery_start_time, delivery_end_time, vehicle_id*, delivery_status_id!**) |
| | 36 | * * референцира до VEHICLE (vehicle_id) |
| | 37 | * !** референцира до DELIVERY_STATUS (delivery_status_id) |
| | 38 | * ORDERS (__'''order_id'''__, order_date, order_sum, order_fulfillment_date, order_comment, customer_id*, delivery_id!**, pro_forma_id!***, order_status_id!**!**) |
| | 39 | * * референцира до CUSTOMER (user_id) |
| | 40 | * !** референцира до DELIVERY (delivery_id) |
| | 41 | * !*** референцира до PRO_FORMA(pro_forma_id) |
| 25 | | * CITY (__'''city_id'''__, city_name) |
| 26 | | * MANAGER (__'''user_id*''''__, warehouse_id!**) |
| 27 | | * * референцира до USER (user_id) |
| | 43 | * ARTICLE_UNIT (__**unit_id**__, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, article_id*, warehouse_id !** order_id!***) |
| | 44 | * * референцира до ARTICLE (article_id) |
| 29 | | * CUSTOMER (__'''user_id*''''__, customer_EDB, customer_company_name, customer_address, customer_open_time, customer_close_time, customer_representative_image) |
| 30 | | * * референцира до USER (user_id) |
| 31 | | * DRIVER (__'''user_id*''''__, vehicle_id!**) |
| 32 | | * * референцира до USER (user_id) |
| 33 | | * !** референцира до VEHICLE (vehicle_id) |
| 34 | | * WAREHOUSE (__'''warehouse_id'''__, warehouse_address, manager_id*, city_id!**) |
| 35 | | * * референцира до MANAGER (user_id) |
| 36 | | * !** референцира до CITY (city_id) |
| 37 | | * CATEGORY (__'''category_id'''__, category_name) |
| 38 | | * ARTICLE_UNIT (__**unit_id**__, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, article_id*, order_id!**) |
| 39 | | * * референцира до ARTICLE (article_id) |
| 40 | | * !** референцира до ORDERS (order_id) |
| 41 | | * ORDER_STATUS (__**order_status_id**__, order_status_name, order_status_description) |
| 42 | | * DELIVERY_STATUS (__**delivery_status_id**__, delivery_status_name, delivery_status_description) |
| 43 | | * PRO_FORMA_STATUS (__**pro_forma_status_id**__, pro_forma_status_name, pro_forma_status_description) |
| | 46 | * !*** референцира до ORDERS (order_id) |
