Tags reporting tables
Check the Postgres, Db2 statements for the tables that are related to tags.
| Subject area | Table name | Description |
|---|---|---|
| Tags | Tags | The tags that are defined. |
Tags table
This table has the following columns:
tag_name- The name of the tag.
Postgres
CREATE TABLE statement:
create table tags(tag_name varchar(256) not null,
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(tag_name));
Db2
CREATE TABLE statement:
create table tags(tag_name varchar(256) not null,
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(tag_name),
period SYSTEM_TIME (tech_start,
tech_end) )
Learn more
Parent topic: Reporting tables