diff --git a/STINK_student_records/STINK_student_records_schema.sql b/STINK_student_records/STINK_student_records_schema.sql index 1774312..e7f957f 100644 --- a/STINK_student_records/STINK_student_records_schema.sql +++ b/STINK_student_records/STINK_student_records_schema.sql @@ -100,7 +100,7 @@ Contact_Phone VARCHAR2(11), -- at least 11, maybe more Contact_Address VARCHAR2(200) NOT NULL, Email VARCHAR2(50) NOT NULL, - Username VARCHAR2(50) NOT NULL + Username VARCHAR2(10) NOT NULL CONSTRAINT Person_Username_Unique UNIQUE, -- bonus marks! -- CONSTRAINT Person_PK PRIMARY KEY ( Person_ID )