Changes between Version 3 and Version 4 of ddlScript.sql

Timestamp:

12/21/25 22:25:07 (9 days ago)

Author:

235018

Comment:

--

ddlScript.sql

@@ -56 +56 @@
     product_code INTEGER PRIMARY KEY NULL REFERENCES product(code) 
         ON DELETE CASCADE,
-    color VARCHAR(20)
+    color VARCHAR(50)
 );
 
@@ -69 +69 @@
     physical_address VARCHAR(100) NOT NULL,   -- ADDRESS FORMAT : st.(st-name) num.(unit-num), (city) (post-code), (country)?????
     store_email VARCHAR(20) UNIQUE NOT NULL,
-    rating NUMERIC NOT NULL DEFAULT 0.0 CHECK (rating>=0.0) 
+    rating NUMERIC NOT NULL DEFAULT 0 CHECK (rating>=0.0) 
 );
 
@@ -75 +75 @@
 -- Table 5
 -- Create PERSONAL table
-CREATE TABLE personal (
-    ssn VARCHAR(13) UNIQUE NOT NULL PRIMARY KEY,
+CREATE TABLE personal (     -- Should a member of the personal have a personal_id, so that one person can work at 2 different stores? Or do we make a Composite key: (personal_ssn, store_id)?
+    ssn VARCHAR(13) PRIMARY KEY,
     first_name VARCHAR(20) NOT NULL,
     last_name VARCHAR(20) NOT NULL,
     email VARCHAR(50) UNIQUE NOT NULL,
-    password VARCAHR NOT NULL
+    password VARCAHR(max) NOT NULL
 );