Changes between Version 1 and Version 2 of Normalization

Timestamp:

09/24/26 14:16:09 (6 days ago)

Author:

201178

Comment:

--

Normalization

@@ -509 +509 @@
 == Финални табели (BCNF) ==
 
- # '''ROLE''' (role_id PK, role_name, description)
- # '''APP_USER''' (user_id PK, role_id FK, username, password_hash, first_name, last_name, email, active)
- # '''SESSION''' (token PK, user_id FK, created_at, expires_at)
- # '''SHIFT''' (shift_id PK, user_id FK, start_time, end_time)
- # '''SHIFT_CLOSE''' (shift_id PK, closed_at, closed_by FK, total, order_count)
- # '''RESTAURANT_TABLE''' (table_id PK, table_number, capacity, status)
- # '''CATEGORY''' (category_id PK, name, description, active)
- # '''PRODUCT''' (product_id PK, category_id FK, name, description, price, active, min_stock)
- # '''ORDERS''' (order_id PK, user_id FK, table_id FK, created_at, status)
- # '''ORDER_ITEM''' (order_id PK, item_number PK, product_id FK, quantity, unit_price, status)
- # '''PAYMENT''' (payment_id PK, order_id FK, amount, method, payment_date)
- # '''INVOICE''' (invoice_id PK, payment_id FK, invoice_number, issued_at)
- # '''INGREDIENT''' (ingredient_id PK, name, unit, min_stock, active)
- # '''RECIPE''' (recipe_id PK, product_id FK)
- # '''RECIPE_ITEM''' (recipe_id PK, ingredient_id PK, quantity_needed)
- # '''INVENTORY''' (inventory_id PK, product_id FK, quantity_change, operation_type, created_at)
- # '''INGREDIENT_INVENTORY''' (id PK, ingredient_id FK, quantity_change, operation_type, created_at)
- # '''AUDIT_LOG''' (log_id PK, user_id FK, action, entity_name, created_at)
- # '''APP_SETTINGS''' (id PK, restaurant_name, vat_rate, currency, printer_config)
- # '''SETTINGS''' (id PK, restaurant_name, vat_percent, currency, printer_ip, printer_port)
+ * '''ROLE''' (role_id PK, role_name, description)
+ * '''APP_USER''' (user_id PK, role_id FK, username, password_hash, first_name, last_name, email, active)
+ * '''SESSION''' (token PK, user_id FK, created_at, expires_at)
+ * '''SHIFT''' (shift_id PK, user_id FK, start_time, end_time)
+ * '''SHIFT_CLOSE''' (shift_id PK, closed_by FK, total, order_count, closed_at)
+ * '''RESTAURANT_TABLE''' (table_id PK, table_number, capacity, status)
+ * '''CATEGORY''' (category_id PK, name, description, active)
+ * '''PRODUCT''' (product_id PK, category_id FK, name, description, price, active, min_stock)
+ * '''ORDERS''' (order_id PK, user_id FK, table_id FK, created_at, status)
+ * '''ORDER_ITEM''' (order_id PK, item_number PK, product_id FK, quantity, unit_price, status)
+ * '''PAYMENT''' (payment_id PK, order_id FK, amount, method, payment_date)
+ * '''INVOICE''' (invoice_id PK, payment_id FK, invoice_number, issued_at)
+ * '''INGREDIENT''' (ingredient_id PK, name, unit, min_stock, active)
+ * '''RECIPE''' (recipe_id PK, product_id FK)
+ * '''RECIPE_ITEM''' (recipe_id PK, ingredient_id PK, quantity_needed)
+ * '''INVENTORY''' (inventory_id PK, product_id FK, quantity_change, operation_type, created_at)
+ * '''INGREDIENT_INVENTORY''' (id PK, ingredient_id FK, quantity_change, operation_type, created_at)
+ * '''AUDIT_LOG''' (log_id PK, user_id FK, action, entity_name, created_at)
+ * '''APP_SETTINGS''' (id PK, restaurant_name, vat_rate, currency, printer_config)
+ * '''SETTINGS''' (id PK, restaurant_name, vat_percent, currency, printer_ip, printer_port)
 
 == Заклучок ==