Changes between Version 3 and Version 4 of ERModel

Timestamp:

04/22/26 23:49:36 (10 days ago)

Author:

223162

Comment:

iminja od employ vo customer

ERModel

@@ -91 +91 @@
 * order_id serial, примарен клуч
 * comp_order_id int, задолжителен
-* company_employee_user_id int, задолжителен DEFAULT 1
+* company_customer_user_id int, задолжителен DEFAULT 1
 * order_datetime timestamp, задолжителен DEFAULT CURRENT_TIMESTAMP
 * o_status_id int, задолжителен
@@ -100 +100 @@
     ON UPDATE CASCADE
     ON DELETE RESTRICT
-* CONSTRAINT fk_customer_order_employee
-    FOREIGN KEY (company_employee_user_id)
-    REFERENCES company_employee(user_id)
+* CONSTRAINT fk_customer_order_customer
+    FOREIGN KEY (company_customer_user_id)
+    REFERENCES company_customer(user_id)
     ON UPDATE CASCADE
     ON DELETE SET DEFAULT
@@ -169 +169 @@
     ON DELETE SET DEFAULT
 
-**EMPLOYEE_LOYALTY**
-* emp_loyalty_id serial, примарен клуч
+**CUSTOMER_LOYALTY**
+* cus_loyalty_id serial, примарен клуч
 * user_id int, задолжителен и уникатен
-* emp_loyalty_curr_points int, задолжителен DEFAULT 0
-* emp_loyalty_joined_at timestamp, задолжителен DEFAULT CURRENT_TIMESTAMP
-* emp_loyalty_status_id int, задолжителен
+* cus_loyalty_curr_points int, задолжителен DEFAULT 0
+* cus_loyalty_joined_at timestamp, задолжителен DEFAULT CURRENT_TIMESTAMP
+* cus_loyalty_status_id int, задолжителен
 * tier_id int, задолжителен
-* CONSTRAINT fk_employee_loyalty_user
+* CONSTRAINT fk_customer_loyalty_user
     FOREIGN KEY (user_id)
-    REFERENCES company_employee(user_id)
-    ON UPDATE CASCADE
-    ON DELETE CASCADE
-* CONSTRAINT fk_employee_loyalty_status
-    FOREIGN KEY (emp_loyalty_status_id)
-    REFERENCES employee_loyalty_status(emp_loyalty_status_id)
-    ON UPDATE CASCADE
-    ON DELETE RESTRICT
-* CONSTRAINT fk_employee_loyalty_tier
+    REFERENCES customer(user_id)
+    ON UPDATE CASCADE
+    ON DELETE CASCADE
+* CONSTRAINT fk_customer_loyalty_status
+    FOREIGN KEY (cus_loyalty_status_id)
+    REFERENCES customer_loyalty_status(cus_loyalty_status_id)
+    ON UPDATE CASCADE
+    ON DELETE RESTRICT
+* CONSTRAINT fk_customer_loyalty_tier
     FOREIGN KEY (tier_id)
     REFERENCES loyalty_tier(tier_id)
     ON UPDATE CASCADE
     ON DELETE RESTRICT
-* CONSTRAINT chk_employee_loyalty_points CHECK (emp_loyalty_curr_points >= 0)
-
-**EMPLOYEE_LOYALTY_STATUS**
-* emp_loyalty_status_id serial, примарен клуч
-* emp_loyalty_status_name string, задолжителен и уникатен
+* CONSTRAINT chk_customer_loyalty_points CHECK (cus_loyalty_curr_points >= 0)
+
+**CUSTOMER_LOYALTY_STATUS**
+* cus_loyalty_status_id serial, примарен клуч
+* cus_loyalty_status_name string, задолжителен и уникатен
 
 **INGREDIENT**