Changes between Version 10 and Version 11 of ddlScript-with-help-of-AI.sql

Timestamp:

09/20/26 07:26:19 (9 days ago)

Author:

235018

Comment:

--

ddlScript-with-help-of-AI.sql

@@ -93 +93 @@
 -- Create PERMISSIONS table
 CREATE TABLE permissions (
-    personal_is VARCHAR(10) PRIMARY KEY REFERENCES personal(id)
+    personal_id VARCHAR(10) PRIMARY KEY REFERENCES personal(id)
         ON DELETE CASCADE,
     type VARCHAR(50) NOT NULL,
@@ -139 +139 @@
 -- Create ORDER table
 CREATE TABLE "order" (
-    order_num VARCHAR(11) PRIMARY KEY,                   -- In the format: 3 digits for store ID, 3 digits for year when order is placed, 5 digits for the number of order for that store in that year
+    order_num VARCHAR(11) PRIMARY KEY,    -- In the format: 3 digits for store ID, 3 digits for year when order is placed, 5 digits for the number of order for that store in that year
     client_ID INTEGER REFERENCES client(client_ID)
         ON DELETE CASCADE,
     status VARCHAR(20) NOT NULL DEFAULT 'placed order',
     last_date_mod TIMESTAMP NOT NULL,
-    payment_method VARCHAR (250) NOT NULL,                  -- Format : "credit card, **** **** **** 6750" , or "cash", or "paypal, user@gmail.com",... Contains important information that are going to be needed when issuing a refund 
+    payment_method VARCHAR (250) NOT NULL,              -- Format : "credit card, **** **** **** 6750" , or "cash", or "paypal, user@gmail.com",... Contains important information that are going to be needed when issuing a refund 
     discount DECIMAL(5,2) DEFAULT 0.0 CHECK(discount>=0.0 AND discount<= 100.00),
     CONSTRAINT check_status (status IN ('placed order', 'being processed', 'shipping', 'delivered', 'canceled'))
@@ -168 +168 @@
     amount DECIMAL(5,2) NOT NULL,
     status VARCHAR(100) NOT NULL DEFAULT 'requested refund',
-    CONSTRAINT check_refund_status (status IN ('requested refund', 'being revied', 'approved', 'not approved', 'processed'))
+    CONSTRAINT check_refund_status (status IN ('requested refund', 'being reviewed', 'approved', 'not approved', 'processed'))
 
 );