0 / 0
User profiles tables

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

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more