Changes between Version 5 and Version 6 of RelationalDesign
- Timestamp:
- 11/15/24 17:53:42 (3 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v5 v6 10 10 * * референцира до DRIVER (user_id) 11 11 * !** референцира до WAREHOUSE (warehouse_id) 12 * DELIVERY (__'''delivery_id'''__, delivery_status, delivery_date_created, delivery_date, vehicle_id* )12 * DELIVERY (__'''delivery_id'''__, delivery_status, delivery_date_created, delivery_date, vehicle_id*, delivery_status_id!**) 13 13 * * референцира до VEHICLE (vehicle_id) 14 * PRO_FORMA (__'''pro_forma_id'''__, pro_forma_status, pro_forma_deadline, pro_forma_date_created, order_id*) 14 * !** референцира до DELIVERY_STATUS (delivery_status_id) 15 * PRO_FORMA (__'''pro_forma_id'''__, pro_forma_status, pro_forma_deadline, pro_forma_date_created, order_id*, pro_forma_status_id!**) 15 16 * * референцира до ORDERS (order_id) 17 * !** референцира до PRO_FORMA_STATUS (pro_forma_status_id) 16 18 * ARTICLE (__'''article_id'''__, article_price, article_image, article_name, article_weight, category_id*) 17 19 * * референцира до CATEGORY (category_id) 18 * ORDERS (__'''order_id'''__, order_date, order_status, order_sum, order_fulfillment_date, delivery_id*, pro_forma_id!**, customer_id!*** )20 * ORDERS (__'''order_id'''__, order_date, order_status, order_sum, order_fulfillment_date, delivery_id*, pro_forma_id!**, customer_id!***, order_status_id!**!**) 19 21 * * референцира до DELIVERY (delivery_id) 20 22 * !** референцира до PRO_FORMA (pro_forma_id) 21 23 * !*** референцира до CUSTOMER(user_id) 24 * !**!** референцира до ORDER_STATUS(order_status_id) 22 25 * CITY (__'''city_id'''__, city_name) 23 26 * MANAGER (__'''user_id*''''__, warehouse_id!**) … … 36 39 * * референцира до ARTICLE (article_id) 37 40 * !** референцира до ORDERS (order_id) 38 === Релации 39 * IN_STOCK (__'''city_id*, warehouse_id!**'''__) 40 * * референцира до CITY (city_id) 41 * !** референцира до WAREHOUSE (warehouse_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) 42 44 43 45 == DDL скрипта за креирање и бришење на табелите