Changes between Version 5 and Version 6 of ddlScript-with-help-of-AI.sql

Timestamp:

12/30/25 12:32:24 (16 hours ago)

Author:

235018

Comment:

--

ddlScript-with-help-of-AI.sql

@@ -88 +88 @@
 -- Create PERSONAL table
 CREATE TABLE personal (
-    id CHAR(7) PRIMARY KEY,                                     -- Format 13 digits :   0101001451001, 1209995423736,...
+    id CHAR(7) PRIMARY KEY,                                     -- Format 3 digits for store, 4 digits for employee ID
     first_name VARCHAR(20) NOT NULL,
     last_name VARCHAR(20) NOT NULL,
+    ssn CHAR(13) NOT NULL,
     email VARCHAR(50) UNIQUE NOT NULL,
     password VARCHAR NOT NULL