Changes between Version 7 and Version 8 of Нормализација и подобрувања на дизајнот на базата
- Timestamp:
- 03/09/25 15:58:29 (3 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Нормализација и подобрувања на дизајнот на базата
v7 v8 11 11 [[Image(baza.png, height=200px)]] \\ 12 12 \\ 13 '''Табела 1 -> orders :'''id_order, payment_method, status, delivery_price, total_price, invoive_code, order_date, id_customer 13 '''Табела 1 -> orders :''' \\ 14 id_order, payment_method, status, delivery_price, total_price, invoive_code, order_date, id_customer 14 15 15 16 16 '''Табела 2 :'''17 customers:id_customer, email, first_name, last_name, delivery_address, password, phone17 '''Табела 2 -> customers:''' \\ 18 id_customer, email, first_name, last_name, delivery_address, password, phone 18 19 19 '''Табела 3:''' delivery: id_delivery, delivery_address, status, id_order 20 '''Табела 3 -> delivery:''' \\ 21 id_delivery, delivery_address, status, id_order 20 22 21 23 22 '''Табела 4:''' 23 contains: quantity, size, price, id_order, id_stock 24 '''Табела 4 -> contains:''' 25 \\ 26 quantity, size, price, id_order, id_stock 24 27 25 28 26 '''Табела 5 :'''27 stock:id_stock, id_product, size, quantity, price29 '''Табела 5 -> stock:''' 30 \\ id_stock, id_product, size, quantity, price 28 31 29 32 30 '''Табела 6 :'''31 products:id_product, id_category, product_name, color, price, description, image_url33 '''Табела 6 -> products :''' 34 \\ id_product, id_category, product_name, color, price, description, image_url 32 35 33 36 34 '''Табела 7 :'''35 categories:id_category, category_name37 '''Табела 7 -> categories:''' 38 \\ id_category, category_name
