Changes between Version 2 and Version 3 of LogicalAndPhysicalDesign

Timestamp:

12/07/25 23:13:33 (3 weeks ago)

Author:

231035

Comment:

--

LogicalAndPhysicalDesign

@@ -2 +2 @@
 == DDL
 {{{
+
+CREATE TYPE user_role AS ENUM ('ADMIN', 'USER', 'GUEST');
 
 CREATE TABLE User (
@@ -7 +9 @@
     username     VARCHAR(50)  NOT NULL UNIQUE,
     email        VARCHAR(255) NOT NULL UNIQUE,
-    role         VARCHAR(30)  NOT NULL,
+    role         user_role  NOT NULL,
     fullname     VARCHAR(100),
     name         VARCHAR(50),