User profiles tables
Check the Postgres, Db2 statements for the tables that are related to user profiles.
| Subject area | Table name | Description |
|---|---|---|
| User Profiles | user_profiles | A list of all the users of a catalog or project. |
user_profiles table
This table has the following columns:
user_id- The identifier for the user.user_name- The name of the user.display_name- What name is displayed for the user.first_name- User's first name.last_name- User's last name.email- User's email.
Postgres
CREATE TABLE statement:
CREATE TABLE user_profiles(user_id varchar(128) NOT NULL,user_name varchar(256),display_name varchar(256),first_name varchar(256),last_name varchar(256),email varchar(256),tech_start TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,tech_end TIMESTAMP(6) NOT NULL DEFAULT to_timestamp('9999-12-30','YYYY-MM-DD'),ts_id TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(user_id))
Db2
CREATE TABLE statement:
CREATE TABLE user_profiles(user_id varchar(128) NOT NULL,user_name varchar(256),display_name varchar(256),first_name varchar(256),last_name varchar(256),email varchar(256),tech_start TIMESTAMP(12) NOT NULL IMPLICITLY HIDDEN GENERATED ALWAYS AS ROW BEGIN,tech_end TIMESTAMP(12) NOT NULL IMPLICITLY HIDDEN GENERATED ALWAYS AS ROW END,ts_id TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS TRANSACTION START ID, PRIMARY KEY(user_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW
Learn more
Parent topic: Reporting tables