Changes between Version 1 and Version 2 of Phase1_Partitioning

Timestamp:

12/10/25 00:26:24 (3 weeks ago)

Author:

226052

Comment:

--

Phase1_Partitioning

@@ -33 +33 @@
 {{{
 CREATE TABLE rental (
-    rental_id   BIGINT GENERATED ALWAYS AS IDENTITY,
+    rental_id BIGINT GENERATED ALWAYS AS IDENTITY,
     rental_date TIMESTAMP NOT NULL,
-    inventory_id INT NOT NULL,
-    customer_id  INT NOT NULL,
-    staff_id     INT NOT NULL,
-    return_date  TIMESTAMP,
-    last_update  TIMESTAMP DEFAULT now(),
-    PRIMARY KEY (rental_id, rental_date)
+    inventory_id BIGINT NOT NULL,
+    customer_id BIGINT NOT NULL,
+    staff_id BIGINT NOT NULL,
+    return_date TIMESTAMP,
+    last_update TIMESTAMP DEFAULT now() NOT NULL,
+    PRIMARY KEY (rental_id, rental_date),
+    CONSTRAINT fk_rental_inventory FOREIGN KEY (inventory_id) REFERENCES inventory(inventory_id) ON UPDATE CASCADE ON DELETE RESTRICT,
+    CONSTRAINT fk_rental_customer FOREIGN KEY (customer_id) REFERENCES customer(customer_id) ON UPDATE CASCADE ON DELETE RESTRICT,
+    CONSTRAINT fk_rental_staff FOREIGN KEY (staff_id) REFERENCES staff(staff_id) ON UPDATE CASCADE ON DELETE RESTRICT
 )
 PARTITION BY RANGE (rental_date);