     user_password_id             BIGINT       NOT NULL,
     user_personal_information_id BIGINT DEFAULT NULL,
     -- table constraints
-    CONSTRAINT user_account_unique PRIMARY KEY (user_account_id),
-    CONSTRAINT user_email_address_unique UNIQUE(user_personal_information_id),
+    CONSTRAINT user_account_uq PRIMARY KEY (user_account_id),
+    CONSTRAINT user_email_address_uq UNIQUE(user_personal_information_id),
     CONSTRAINT user_account_fk FOREIGN KEY (user_account_id) REFERENCES user_account (id),
-    CONSTRAINT user_password_fk FOREIGN KEY (user_password_id, user_account_id) REFERENCES user_password (id, user_account_id),
-    CONSTRAINT user_email_address_fk FOREIGN KEY (user_account_id, user_email_address) REFERENCES user_email (user_account_id, address)
+    CONSTRAINT user_personal_information_fk FOREIGN KEY (user_personal_information_id) REFERENCES user_personal_information (id),
+    CONSTRAINT user_password_fk FOREIGN KEY (user_password_id, user_account_id) REFERENCES user_password (id, user_account_id)
+--     CONSTRAINT user_email_address_fk FOREIGN KEY (user_account_id, user_email_address) REFERENCES user_email (user_account_id, address)
 );
 
+CREATE TABLE public_profile_account (
+    -- table columns with their constraints
+    id BIGINT,
+    user_account_id BIGINT,
+    name TEXT,
+    address TEXT,
+    about TEXT,
+    -- TODO:MODELING PICTURE(avatar)
+    -- table constraints
+    CONSTRAINT public_profile_account_pk PRIMARY KEY (id),
+    CONSTRAINT user_account_id_fk FOREIGN KEY (user_account_id) REFERENCES user_account(id)
+);
 
+CREATE TABLE content_node (
+    -- table columns with their constraints
+    id BIGSERIAL,
+    user_account_id BIGINT,
+    description TEXT NOT NULL,
+    registration_datetime TIMESTAMP(2) WITH TIME ZONE NOT NULL DEFAULT current_timestamp(2),
+    -- table constraints
+    PRIMARY KEY (id)
+);
 
-
-
-
-
-
-
-
-
-

    user_account_id   BIGINT                      NOT NULL,
    address           VARCHAR(254)                NOT NULL,
    verified          BOOLEAN                              DEFAULT FALSE,
    register_datetime TIMESTAMP(2) WITH TIME ZONE NOT NULL DEFAULT current_timestamp(2),
    -- table constraints
    CONSTRAINT user_email_address_pk PRIMARY KEY (user_account_id, address)
);


    role_id         BIGINT NOT NULL,
    -- table constraints
    CONSTRAINT user_session_pk PRIMARY KEY (id),
    CONSTRAINT role_account_fk FOREIGN KEY (user_account_id, role_id) REFERENCES role_account_mapping (user_account_id, role_id)
);

CREATE TABLE user_password (
