TablesReference

Design Name	full_db
Version Date	02.10.2024 09:20:05
Version Comment
Model Name	Polarion2

Table Name	POLARION.ATTACHMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CONTENT				BINARY	LT
8	C_FILENAME				VARCHAR	LT
9	C_ID				VARCHAR	LT
10	C_LENGTH				BIGINT	LT
11	FK_PROJECT		F		BIGINT	LT
12	FK_URI_PROJECT				BIGINT	LT
13	C_TITLE				VARCHAR	LT
14	C_UPDATED				Timestamp	LT
15	C_URL				VARCHAR	LT
16	FK_WORKITEM		F		BIGINT	LT
17	FK_URI_WORKITEM				BIGINT	LT

Table Name	POLARION.BASELINE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	FK_BASEOBJECT				BIGINT	LT
8	FK_URI_BASEOBJECT				BIGINT	LT
9	C_BASEREVISION				VARCHAR	LT
10	C_DESCRIPTION				VARCHAR	LT
11	C_ID				VARCHAR	LT
12	C_LOCATION				VARCHAR	LT
13	C_NAME				VARCHAR	LT
14	FK_PROJECT		F		BIGINT	LT
15	FK_URI_PROJECT				BIGINT	LT

Table Name	POLARION.BASELINECOLLECTION
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	FK_BRANCHEDFROM		F		BIGINT	LT
8	FK_URI_BRANCHEDFROM				BIGINT	LT
9	C_CLOSEDON				Timestamp	LT
10	C_CREATED				Timestamp	LT
11	C_DESCRIPTION				VARCHAR	LT
12	C_ID				VARCHAR	LT
13	C_LOCATION				VARCHAR	LT
14	C_NAME				VARCHAR	LT
15	FK_PROJECT		F		BIGINT	LT
16	FK_URI_PROJECT				BIGINT	LT
17	FK_REUSEDFROM		F		BIGINT	LT
18	FK_URI_REUSEDFROM				BIGINT	LT
19	C_UPDATED				Timestamp	LT

Table Name	POLARION.BUILD
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_BIRLOCATION				VARCHAR	LT
8	FK_BUILDARTIFACT		F		BIGINT	LT
9	FK_URI_BUILDARTIFACT				BIGINT	LT
10	C_BUILDDESCRIPTORNAME				VARCHAR	LT
11	C_BUILDSTAMP				VARCHAR	LT
12	C_BUILDSTATUS				VARCHAR	LT
13	C_BUILDTAG				VARCHAR	LT
14	C_CALCULATIONDESCRIPTORNAME				VARCHAR	LT
15	C_CREATIONTIME				Timestamp	LT
16	C_FINISHTIME				Timestamp	LT
17	C_ID				VARCHAR	LT
18	C_JOBID				VARCHAR	LT
19	C_LOCALDEPLOYMENTSPACENAME				VARCHAR	LT
20	C_LOGFILES					LT
21	C_STARTTIME				Timestamp	LT

Table Name	POLARION.BUILDARTIFACT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_AGGREGATIONRESOURCES					LT
6	C_ARTIFACTID				VARCHAR	LT
7	C_BASELOCATION				VARCHAR	LT
8	C_BUILDDEPENDENCIES					LT
9	C_BUILDDESCRIPTORS					LT
10	C_CALCULATIONDESCRIPTORS					LT
11	C_DESCRIPTION				VARCHAR	LT
12	FK_GROUPENTITY				BIGINT	LT
13	FK_URI_GROUPENTITY				BIGINT	LT
14	C_GROUPID				VARCHAR	LT
15	C_ID				VARCHAR	LT
16	C_LABEL				VARCHAR	LT
17	C_REPOSITORYTAG				VARCHAR	LT
18	C_RESOURCES					LT
19	C_TYPE				VARCHAR	LT

Table Name	POLARION.CATEGORY
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_DESCRIPTION				VARCHAR	LT
6	C_ID				VARCHAR	LT
7	C_NAME				VARCHAR	LT
8	FK_PROJECT		F		BIGINT	LT
9	FK_URI_PROJECT				BIGINT	LT

Table Name	POLARION.CF_BASELINECOLLECTION
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_BASELINECOLLECTION		F		BIGINT	LT
2	FK_URI_BASELINECOLLECTION				BIGINT	LT
3	C_NAME				VARCHAR	LT
4	C_BOOLEAN_VALUE				BIT (1)	LT
5	C_LONG_VALUE				BIGINT	LT
6	C_FLOAT_VALUE				REAL	LT
7	C_CURRENCY_VALUE				NUMERIC (20,2)	LT
8	C_DATE_VALUE				Timestamp	LT
9	C_DATEONLY_VALUE				Date	LT
10	C_DURATIONTIME_VALUE				REAL	LT
11	C_STRING_VALUE				VARCHAR	LT
12	C_TEXT_VALUE				VARCHAR	LT

Table Name	POLARION.CF_MODULE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_MODULE		F		BIGINT	LT
2	FK_URI_MODULE				BIGINT	LT
3	C_NAME				VARCHAR	LT
4	C_BOOLEAN_VALUE				BIT (1)	LT
5	C_LONG_VALUE				BIGINT	LT
6	C_FLOAT_VALUE				REAL	LT
7	C_CURRENCY_VALUE				NUMERIC (20,2)	LT
8	C_DATE_VALUE				Timestamp	LT
9	C_DATEONLY_VALUE				Date	LT
10	C_DURATIONTIME_VALUE				REAL	LT
11	C_STRING_VALUE				VARCHAR	LT
12	C_TEXT_VALUE				VARCHAR	LT

Table Name	POLARION.CF_PLAN
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_PLAN		F		BIGINT	LT
2	FK_URI_PLAN				BIGINT	LT
3	C_NAME				VARCHAR	LT
4	C_BOOLEAN_VALUE				BIT (1)	LT
5	C_LONG_VALUE				BIGINT	LT
6	C_FLOAT_VALUE				REAL	LT
7	C_CURRENCY_VALUE				NUMERIC (20,2)	LT
8	C_DATE_VALUE				Timestamp	LT
9	C_DATEONLY_VALUE				Date	LT
10	C_DURATIONTIME_VALUE				REAL	LT
11	C_STRING_VALUE				VARCHAR	LT
12	C_TEXT_VALUE				VARCHAR	LT

Table Name	POLARION.CF_TESTRUN
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_TESTRUN		F		BIGINT	LT
2	FK_URI_TESTRUN				BIGINT	LT
3	C_NAME				VARCHAR	LT
4	C_BOOLEAN_VALUE				BIT (1)	LT
5	C_LONG_VALUE				BIGINT	LT
6	C_FLOAT_VALUE				REAL	LT
7	C_CURRENCY_VALUE				NUMERIC (20,2)	LT
8	C_DATE_VALUE				Timestamp	LT
9	C_DATEONLY_VALUE				Date	LT
10	C_DURATIONTIME_VALUE				REAL	LT
11	C_STRING_VALUE				VARCHAR	LT
12	C_TEXT_VALUE				VARCHAR	LT

Table Name	POLARION.CF_WORKITEM
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_WORKITEM		F		BIGINT	LT
2	FK_URI_WORKITEM				BIGINT	LT
3	C_NAME				VARCHAR	LT
4	C_TESTSTEPS_VALUE					LT
5	C_BOOLEAN_VALUE				BIT (1)	LT
6	C_LONG_VALUE				BIGINT	LT
7	C_FLOAT_VALUE				REAL	LT
8	C_CURRENCY_VALUE				NUMERIC (20,2)	LT
9	C_DATE_VALUE				Timestamp	LT
10	C_DATEONLY_VALUE				Date	LT
11	C_DURATIONTIME_VALUE				REAL	LT
12	C_STRING_VALUE				VARCHAR	LT
13	C_TEXT_VALUE				VARCHAR	LT

Table Name	POLARION.COMMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	C_ID				VARCHAR	LT
9	FK_PARENTCOMMENT		F		BIGINT	LT
10	FK_URI_PARENTCOMMENT				BIGINT	LT
11	FK_PROJECT		F		BIGINT	LT
12	FK_URI_PROJECT				BIGINT	LT
13	C_RESOLVED				BIT (1)	LT
14	C_TAGS					LT
15	C_TEXT				VARCHAR	LT
16	C_TITLE				VARCHAR	LT
17	C_VISIBLETO					LT
18	FK_WORKITEM		F		BIGINT	LT
19	FK_URI_WORKITEM				BIGINT	LT

Table Name	POLARION.DOCUMENTWORKFLOWSIGNATURE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_BRANCHEDFROM		F		BIGINT	LT
6	FK_URI_BRANCHEDFROM				BIGINT	LT
7	C_ID				VARCHAR	LT
8	FK_PROJECT		F		BIGINT	LT
9	FK_URI_PROJECT				BIGINT	LT
10	C_SIGNATURESTATE				VARCHAR	LT
11	C_TARGETSTATUSID				VARCHAR	LT
12	C_TRANSITIONDATAREVISION				VARCHAR	LT
13	FK_WORKFLOWOBJECT		F		BIGINT	LT
14	FK_URI_WORKFLOWOBJECT				BIGINT	LT

Table Name	POLARION.ENUM_OPTIONS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PROJECT	P		Y	VARCHAR	LT
2	C_TYPE	P		Y	VARCHAR	LT
3	C_ENUMID	P		Y	VARCHAR	LT
4	C_ID	P		Y	VARCHAR	LT
5	C_NAME				VARCHAR	LT
6	C_SORTORDER				Integer	LT
7	C_HIDDEN				BIT (1)	LT
8	C_DESCRIPTION				VARCHAR	LT
9	C_COLOR				VARCHAR	LT
10	C_ICONURL				VARCHAR	LT
11	C_UILINK				VARCHAR	LT
12	C_URL				VARCHAR	LT

Table Name	POLARION.MODULE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_ALLOWEDWITYPES					LT
6	C_ARELINKSFROMPARENTTOCHILD				BIT (1)	LT
7	FK_AUTHOR		F		BIGINT	LT
8	FK_URI_AUTHOR				BIGINT	LT
9	C_AUTOSUSPECT				BIT (1)	LT
10	FK_BRANCHEDFROM		F		BIGINT	LT
11	FK_URI_BRANCHEDFROM				BIGINT	LT
12	C_BRANCHEDWITHINITIALIZEDFIELDS					LT
13	C_BRANCHEDWITHQUERY				VARCHAR	LT
14	C_CREATED				Timestamp	LT
15	C_DERIVEDFIELDS					LT
16	FK_DERIVEDFROM		F		BIGINT	LT
17	FK_URI_DERIVEDFROM				BIGINT	LT
18	C_DERIVEDFROMLINKROLE				VARCHAR	LT
19	C_HEADINGSIDEBARFIELDS				VARCHAR	LT
20	C_HOMEPAGECONTENT				VARCHAR	LT
21	C_ID				VARCHAR	LT
22	C_LOCATION				VARCHAR	LT
23	C_MODULEABSOLUTELOCATION				VARCHAR	LT
24	C_MODULEFOLDER				VARCHAR	LT
25	C_MODULELOCATION				VARCHAR	LT
26	C_MODULENAME				VARCHAR	LT
27	FK_PROJECT		F		BIGINT	LT
28	FK_URI_PROJECT				BIGINT	LT
29	C_STATUS				VARCHAR	LT
30	C_STRUCTURELINKROLE				VARCHAR	LT
31	C_TCCONFIGURATORCONTEXTUID				VARCHAR	LT
32	C_TITLE				VARCHAR	LT
33	C_TYPE				VARCHAR	LT
34	C_UPDATED				Timestamp	LT
35	FK_UPDATEDBY		F		BIGINT	LT
36	FK_URI_UPDATEDBY				BIGINT	LT
37	C_USESOUTLINENUMBERING				BIT (1)	LT
38	FK_VARIANT		F		BIGINT	LT
39	FK_URI_VARIANT				BIGINT	LT

Table Name	POLARION.MODULEATTACHMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CONTENT				BINARY	LT
8	C_FILENAME				VARCHAR	LT
9	C_ID				VARCHAR	LT
10	C_LENGTH				BIGINT	LT
11	FK_MODULE		F		BIGINT	LT
12	FK_URI_MODULE				BIGINT	LT
13	FK_PROJECT		F		BIGINT	LT
14	FK_URI_PROJECT				BIGINT	LT
15	C_TITLE				VARCHAR	LT
16	C_UPDATED				Timestamp	LT
17	C_URL				VARCHAR	LT

Table Name	POLARION.MODULECOMMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	C_ID				VARCHAR	LT
9	FK_MODULE		F		BIGINT	LT
10	FK_URI_MODULE				BIGINT	LT
11	FK_PARENTCOMMENT		F		BIGINT	LT
12	FK_URI_PARENTCOMMENT				BIGINT	LT
13	FK_PROJECT		F		BIGINT	LT
14	FK_URI_PROJECT				BIGINT	LT
15	FK_REFERREDWORKITEM		F		BIGINT	LT
16	FK_URI_REFERREDWORKITEM				BIGINT	LT
17	C_RESOLVED				BIT (1)	LT
18	C_TAGS					LT
19	C_TEXT				VARCHAR	LT

Table Name	POLARION.PLAN
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_ALLOWEDTYPES					LT
6	FK_AUTHOR		F		BIGINT	LT
7	FK_URI_AUTHOR				BIGINT	LT
8	C_CALCULATIONTYPE				VARCHAR	LT
9	C_CAPACITY				REAL	LT
10	C_COLOR				VARCHAR	LT
11	C_CREATED				Timestamp	LT
12	C_DEFAULTESTIMATE				REAL	LT
13	C_DESCRIPTION				VARCHAR	LT
14	C_DUEDATE				Date	LT
15	C_ESTIMATIONFIELD				VARCHAR	LT
16	C_FINISHEDON				Timestamp	LT
17	C_HOMEPAGECONTENT				VARCHAR	LT
18	C_ID				VARCHAR	LT
19	C_ISTEMPLATE				BIT (1)	LT
20	C_LOCATION				VARCHAR	LT
21	C_NAME				VARCHAR	LT
22	FK_PARENT		F		BIGINT	LT
23	FK_URI_PARENT				BIGINT	LT
24	C_PREVIOUSTIMESPENT				REAL	LT
25	C_PRIORITIZATIONFIELD				VARCHAR	LT
26	FK_PROJECT		F		BIGINT	LT
27	FK_URI_PROJECT				BIGINT	LT
28	C_SORTORDER				Integer	LT
29	C_STARTDATE				Date	LT
30	C_STARTEDON				Timestamp	LT
31	C_STATUS				VARCHAR	LT
32	FK_TEMPLATE		F		BIGINT	LT
33	FK_URI_TEMPLATE				BIGINT	LT
34	C_UPDATED				Timestamp	LT
35	C_USEREPORTFROMTEMPLATE				BIT (1)	LT

Table Name	POLARION.PROJECT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_ACTIVE				BIT (1)	LT
6	C_COLOR				VARCHAR	LT
7	C_DESCRIPTION				VARCHAR	LT
8	C_FINISH				Date	LT
9	C_ICON				VARCHAR	LT
10	C_ID				VARCHAR	LT
11	FK_LEAD		F		BIGINT	LT
12	FK_URI_LEAD				BIGINT	LT
13	C_LOCATION				VARCHAR	LT
14	C_LOCKWORKRECORDSDATE				Date	LT
15	C_NAME				VARCHAR	LT
16	FK_PROJECTGROUP		F		BIGINT	LT
17	FK_URI_PROJECTGROUP				BIGINT	LT
18	C_START				Date	LT
19	C_TRACKERPREFIX				VARCHAR	LT

Table Name	POLARION.PROJECTGROUP
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_LOCATION				VARCHAR	LT
6	C_NAME				VARCHAR	LT
7	FK_PARENT		F		BIGINT	LT
8	FK_URI_PARENT				BIGINT	LT

Table Name	POLARION.REL_MODULE_WORKITEM
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_ID			Y	BIGINT - AI - ID	LT		nextval('rel_module_workitem_c_id_seq'::regclass)
2	FK_URI_MODULE			Y	BIGINT	LT
3	FK_WORKITEM		F	Y	BIGINT	LT
4	FK_URI_WORKITEM			Y	BIGINT	LT

Table Name	POLARION.REL_USER_WORKITEM_VOTES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_USER		F		BIGINT	LT
2	FK_URI_USER				BIGINT	LT
3	FK_WORKITEM		F		BIGINT	LT
4	FK_URI_WORKITEM				BIGINT	LT

Table Name	POLARION.REL_USER_WORKITEM_WATCHES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_USER		F		BIGINT	LT
2	FK_URI_USER				BIGINT	LT
3	FK_WORKITEM		F		BIGINT	LT
4	FK_URI_WORKITEM				BIGINT	LT

Table Name	POLARION.REL_WORKITEM_CATEGORY_CATEGORIES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_WORKITEM		F		BIGINT	LT
2	FK_URI_WORKITEM				BIGINT	LT
3	FK_CATEGORY		F		BIGINT	LT
4	FK_URI_CATEGORY				BIGINT	LT

Table Name	POLARION.REL_WORKITEM_USER_ASSIGNEE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_WORKITEM		F		BIGINT	LT
2	FK_URI_WORKITEM				BIGINT	LT
3	FK_USER		F		BIGINT	LT
4	FK_URI_USER				BIGINT	LT

Table Name	POLARION.REVISION
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_AUTHOR				VARCHAR	LT
6	C_BRANCH				VARCHAR	LT
7	C_CREATED				Timestamp	LT
8	C_INTERNALCOMMIT				BIT (1)	LT
9	C_MESSAGE				VARCHAR	LT
10	C_NAME				VARCHAR	LT
11	C_REPOSITORYNAME				VARCHAR	LT

Table Name	POLARION.RICHPAGE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	C_HOMEPAGECONTENT				VARCHAR	LT
9	C_ID				VARCHAR	LT
10	C_LOCATION				VARCHAR	LT
11	C_PAGELOCATION				VARCHAR	LT
12	C_PAGENAME				VARCHAR	LT
13	C_PARENTSPACEID				VARCHAR	LT
14	FK_PROJECT		F		BIGINT	LT
15	FK_URI_PROJECT				BIGINT	LT
16	C_SPACEID				VARCHAR	LT
17	C_TITLE				VARCHAR	LT
18	C_UPDATED				Timestamp	LT
19	FK_UPDATEDBY		F		BIGINT	LT
20	FK_URI_UPDATEDBY				BIGINT	LT

Table Name	POLARION.RICHPAGEATTACHMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CONTENT				BINARY	LT
8	C_FILENAME				VARCHAR	LT
9	C_ID				VARCHAR	LT
10	C_LENGTH				BIGINT	LT
11	FK_PROJECT		F		BIGINT	LT
12	FK_URI_PROJECT				BIGINT	LT
13	FK_RICHPAGE		F		BIGINT	LT
14	FK_URI_RICHPAGE				BIGINT	LT
15	C_TITLE				VARCHAR	LT
16	C_UPDATED				Timestamp	LT
17	C_URL				VARCHAR	LT

Table Name	POLARION.RICHPAGECOMMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	C_ID				VARCHAR	LT
9	FK_PARENTCOMMENT		F		BIGINT	LT
10	FK_URI_PARENTCOMMENT				BIGINT	LT
11	FK_PROJECT		F		BIGINT	LT
12	FK_URI_PROJECT				BIGINT	LT
13	C_RESOLVED				BIT (1)	LT
14	FK_RICHPAGE		F		BIGINT	LT
15	FK_URI_RICHPAGE				BIGINT	LT
16	C_TAGS					LT
17	C_TEXT				VARCHAR	LT

Table Name	POLARION.SCRIPT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CONTENT				BINARY	LT
8	C_CREATED				Timestamp	LT
9	C_DESCRIPTION				VARCHAR	LT
10	C_ID				VARCHAR	LT
11	c_logsstored				BIT (1)	LT
12	c_monitored				BIT (1)	LT
13	FK_PROJECT		F		BIGINT	LT
14	FK_URI_PROJECT				BIGINT	LT
15	C_REFERENCENAME				VARCHAR	LT
16	C_TITLE				VARCHAR	LT
17	C_TYPE				VARCHAR	LT
18	C_UPDATED				Timestamp	LT
19	FK_UPDATEDBY		F		BIGINT	LT
20	FK_URI_UPDATEDBY				BIGINT	LT
21	FK_MAINTAINER		F		BIGINT	LT
22	FK_URI_MAINTAINER				BIGINT	LT
23	C_STORELOGS				BIT (1)	LT

Table Name	POLARION.STRUCT_BASELINECOLLECTION_ELEMENTS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_BASELINECOLLECTION		F		BIGINT	LT
2	FK_URI_P_BASELINECOLLECTION				BIGINT	LT
3	FK_OBJECT				BIGINT	LT
4	FK_URI_OBJECT				BIGINT	LT
5	C_REVISION				VARCHAR	LT

Table Name	POLARION.STRUCT_BUILDARTIFACT_TYPESPECIFICDATA
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_BUILDARTIFACT		F		BIGINT	LT
2	FK_URI_P_BUILDARTIFACT				BIGINT	LT
3	C_KEY				VARCHAR	LT
4	C_VALUE				VARCHAR	LT

Table Name	POLARION.STRUCT_BUILD_BUILDEVENTS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_BUILD		F		BIGINT	LT
2	FK_URI_P_BUILD				BIGINT	LT
3	C_WARNCOUNT				Integer	LT
4	C_ERRORCOUNT				Integer	LT
5	C_FATALCOUNT				Integer	LT

Table Name	POLARION.STRUCT_BUILD_BUILDREQUESTORSPECIFICDATA
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_BUILD		F		BIGINT	LT
2	FK_URI_P_BUILD				BIGINT	LT
3	C_KEY				VARCHAR	LT
4	C_VALUE				VARCHAR	LT

Table Name	POLARION.STRUCT_BUILD_BUILDTESTRESULTS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_BUILD		F		BIGINT	LT
2	FK_URI_P_BUILD				BIGINT	LT
3	C_TESTCOUNT				Integer	LT
4	C_FAILURECOUNT				Integer	LT
5	C_ERRORCOUNT				Integer	LT
6	C_SKIPPEDCOUNT				Integer	LT

Table Name	POLARION.STRUCT_BUILD_DEPLOYEDARTIFACTS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_BUILD		F		BIGINT	LT
2	FK_URI_P_BUILD				BIGINT	LT
3	C_LABEL				VARCHAR	LT
4	C_LOCATION				VARCHAR	LT

Table Name	POLARION.STRUCT_BUILD_LINKEDWORKITEMS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_BUILD		F		BIGINT	LT
2	FK_URI_P_BUILD				BIGINT	LT
3	C_ROLE				VARCHAR	LT
4	FK_WORKITEM		F		BIGINT	LT
5	FK_URI_WORKITEM				BIGINT	LT
6	C_REVISION				VARCHAR	LT

Table Name	POLARION.STRUCT_COMMENT_SIGNATUREDATA
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_COMMENT		F		BIGINT	LT
2	FK_URI_P_COMMENT				BIGINT	LT
3	C_VERDICT				VARCHAR	LT
4	C_TARGETSTATUSID				VARCHAR	LT
5	C_SIGNERROLE				VARCHAR	LT
6	C_WORKFLOWACTIONID				VARCHAR	LT
7	FK_WORKFLOWSIGNATURE				BIGINT	LT
8	FK_URI_WORKFLOWSIGNATURE				BIGINT	LT

Table Name	POLARION.STRUCT_DOCUMENTWORKFLOWSIGNATURE_SIGNATURES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_DOCUMENTWORKFLOWSIGNATURE		F		BIGINT	LT
2	FK_URI_P_DOCUMENTWORKFLOWSIGNATURE				BIGINT	LT
3	FK_SIGNEDBY		F		BIGINT	LT
4	FK_URI_SIGNEDBY				BIGINT	LT
5	C_VERDICT				VARCHAR	LT
6	C_VERDICTTIME				Timestamp	LT
7	C_SIGNEDREVISION				VARCHAR	LT
8	C_SIGNERROLE				VARCHAR	LT
9	FK_VERDICTCOMMENT				BIGINT	LT
10	FK_URI_VERDICTCOMMENT				BIGINT	LT

Table Name	POLARION.STRUCT_MODULECOMMENT_IMPORTEDCOMMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_MODULECOMMENT		F		BIGINT	LT
2	FK_URI_P_MODULECOMMENT				BIGINT	LT
3	C_AUTHOR				VARCHAR	LT
4	C_INITIALS				VARCHAR	LT
5	C_CREATED				Timestamp	LT

Table Name	POLARION.STRUCT_MODULECOMMENT_SIGNATUREDATA
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_MODULECOMMENT		F		BIGINT	LT
2	FK_URI_P_MODULECOMMENT				BIGINT	LT
3	C_VERDICT				VARCHAR	LT
4	C_TARGETSTATUSID				VARCHAR	LT
5	C_SIGNERROLE				VARCHAR	LT
6	C_WORKFLOWACTIONID				VARCHAR	LT
7	FK_WORKFLOWSIGNATURE				BIGINT	LT
8	FK_URI_WORKFLOWSIGNATURE				BIGINT	LT

Table Name	POLARION.STRUCT_MODULE_LINKEDOSLCRESOURCES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_MODULE		F		BIGINT	LT
2	FK_URI_P_MODULE				BIGINT	LT
3	C_URL				VARCHAR	LT
4	C_ROLE				VARCHAR	LT
5	C_LABEL				VARCHAR	LT
6	C_REVISION				VARCHAR	LT

Table Name	POLARION.STRUCT_MODULE_OUTLINENUMBERING
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_MODULE		F		BIGINT	LT
2	FK_URI_P_MODULE				BIGINT	LT
3	C_PREFIX				VARCHAR	LT

Table Name	POLARION.STRUCT_MODULE_RENDERINGLAYOUTS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_MODULE		F		BIGINT	LT
2	FK_URI_P_MODULE				BIGINT	LT
3	C_LABEL				VARCHAR	LT
4	C_TYPE				VARCHAR	LT
5	C_LAYOUTER				VARCHAR	LT

Table Name	POLARION.STRUCT_MODULE_TCVARIANT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_MODULE		F		BIGINT	LT
2	FK_URI_P_MODULE				BIGINT	LT
3	C_NAME				VARCHAR	LT
4	C_UID				VARCHAR	LT

Table Name	POLARION.STRUCT_MODULE_XCELERATORSHARES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_MODULE		F		BIGINT	LT
2	FK_URI_P_MODULE				BIGINT	LT
3	C_COLLABORATIONSPACEID				VARCHAR	LT
4	C_PROJECTNAME				VARCHAR	LT
5	C_PROJECTID				VARCHAR	LT
6	C_LASTSHARED				Timestamp	LT
7	C_REVURN				VARCHAR	LT
8	C_CONSISTENCYSTAMP				VARCHAR	LT

Table Name	POLARION.STRUCT_PLAN_RECORDS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_PLAN		F		BIGINT	LT
2	FK_URI_P_PLAN				BIGINT	LT
3	FK_ITEM		F		BIGINT	LT
4	FK_URI_ITEM				BIGINT	LT

Table Name	POLARION.STRUCT_RICHPAGECOMMENT_SIGNATUREDATA
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_RICHPAGECOMMENT		F		BIGINT	LT
2	FK_URI_P_RICHPAGECOMMENT				BIGINT	LT
3	C_VERDICT				VARCHAR	LT
4	C_TARGETSTATUSID				VARCHAR	LT
5	C_SIGNERROLE				VARCHAR	LT
6	C_WORKFLOWACTIONID				VARCHAR	LT
7	FK_WORKFLOWSIGNATURE				BIGINT	LT
8	FK_URI_WORKFLOWSIGNATURE				BIGINT	LT

Table Name	POLARION.STRUCT_TESTRUNCOMMENT_SIGNATUREDATA
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_TESTRUNCOMMENT		F		BIGINT	LT
2	FK_URI_P_TESTRUNCOMMENT				BIGINT	LT
3	C_VERDICT				VARCHAR	LT
4	C_TARGETSTATUSID				VARCHAR	LT
5	C_SIGNERROLE				VARCHAR	LT
6	C_WORKFLOWACTIONID				VARCHAR	LT
7	FK_WORKFLOWSIGNATURE				BIGINT	LT
8	FK_URI_WORKFLOWSIGNATURE				BIGINT	LT

Table Name	POLARION.STRUCT_TESTRUNWORKFLOWSIGNATURE_SIGNATURES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_TESTRUNWORKFLOWSIGNATURE		F		BIGINT	LT
2	FK_URI_P_TESTRUNWORKFLOWSIGNATURE				BIGINT	LT
3	FK_SIGNEDBY		F		BIGINT	LT
4	FK_URI_SIGNEDBY				BIGINT	LT
5	C_VERDICT				VARCHAR	LT
6	C_VERDICTTIME				Timestamp	LT
7	C_SIGNEDREVISION				VARCHAR	LT
8	C_SIGNERROLE				VARCHAR	LT
9	FK_VERDICTCOMMENT				BIGINT	LT
10	FK_URI_VERDICTCOMMENT				BIGINT	LT

Table Name	POLARION.STRUCT_TESTRUN_RECORDS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_TESTRUN		F		BIGINT	LT
2	FK_URI_P_TESTRUN				BIGINT	LT
3	C_CUSTOM_FIELDS					LT
4	FK_TESTCASE		F		BIGINT	LT
5	FK_URI_TESTCASE				BIGINT	LT
6	C_TESTCASEREVISION				VARCHAR	LT
7	FK_DEFECT		F		BIGINT	LT
8	FK_URI_DEFECT				BIGINT	LT
9	C_RESULT				VARCHAR	LT
10	FK_EXECUTEDBY		F		BIGINT	LT
11	FK_URI_EXECUTEDBY				BIGINT	LT
12	C_EXECUTED				Timestamp	LT
13	C_DURATION				REAL	LT
14	C_COMMENT				VARCHAR	LT
15	C_TESTSTEPRESULTS					LT
16	C_TESTPARAMETERS					LT
17	C_ITERATION				Integer	LT
18	C_SIGNED				BIT (1)	LT

Table Name	POLARION.STRUCT_TESTRUN_TESTPARAMETERS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_TESTRUN		F		BIGINT	LT
2	FK_URI_P_TESTRUN				BIGINT	LT

Table Name	POLARION.STRUCT_WORKITEMWORKFLOWSIGNATURE_SIGNATURES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEMWORKFLOWSIGNATURE		F		BIGINT	LT
2	FK_URI_P_WORKITEMWORKFLOWSIGNATURE				BIGINT	LT
3	FK_SIGNEDBY		F		BIGINT	LT
4	FK_URI_SIGNEDBY				BIGINT	LT
5	C_VERDICT				VARCHAR	LT
6	C_VERDICTTIME				Timestamp	LT
7	C_SIGNEDREVISION				VARCHAR	LT
8	C_SIGNERROLE				VARCHAR	LT
9	FK_VERDICTCOMMENT				BIGINT	LT
10	FK_URI_VERDICTCOMMENT				BIGINT	LT

Table Name	POLARION.STRUCT_WORKITEM_APPROVALS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	FK_USER		F		BIGINT	LT
4	FK_URI_USER				BIGINT	LT
5	C_STATUS				VARCHAR	LT
6	C_SECUREAPPROVALCOMMENTID				VARCHAR	LT

Table Name	POLARION.STRUCT_WORKITEM_EXTERNALLYLINKEDWORKITEMS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	C_ROLE				VARCHAR	LT
4	C_WORKITEMURI				VARCHAR	LT

Table Name	POLARION.STRUCT_WORKITEM_HYPERLINKS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	C_ROLE				VARCHAR	LT
4	C_URL				VARCHAR	LT

Table Name	POLARION.STRUCT_WORKITEM_LINKEDOSLCRESOURCES
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	C_URL				VARCHAR	LT
4	C_ROLE				VARCHAR	LT
5	C_LABEL				VARCHAR	LT
6	C_REVISION				VARCHAR	LT

Table Name	POLARION.STRUCT_WORKITEM_LINKEDREVISIONS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	C_REVISION				VARCHAR	LT
4	C_MESSAGE				VARCHAR	LT
5	C_REPOSITORYNAME				VARCHAR	LT
6	C_REMOVED				BIT (1)	LT

Table Name	POLARION.STRUCT_WORKITEM_LINKEDWORKITEMS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	C_ROLE				VARCHAR	LT
4	FK_WORKITEM		F		BIGINT	LT
5	FK_URI_WORKITEM				BIGINT	LT
6	C_REVISION				VARCHAR	LT
7	C_SUSPECT				BIT (1)	LT

Table Name	POLARION.STRUCT_WORKITEM_LINKEDWORKITEMSDERIVED
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	C_ROLE				VARCHAR	LT
4	FK_WORKITEM		F		BIGINT	LT
5	FK_URI_WORKITEM				BIGINT	LT
6	C_REVISION				VARCHAR	LT
7	C_SUSPECT				BIT (1)	LT

Table Name	POLARION.STRUCT_WORKITEM_PLANNINGCONSTRAINTS
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	FK_P_WORKITEM		F		BIGINT	LT
2	FK_URI_P_WORKITEM				BIGINT	LT
3	C_DATE				Timestamp	LT
4	C_CONSTRAINT				VARCHAR	LT

Table Name	POLARION.SUBTERRA_URI_MAP
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	VARCHAR	LT
2	C_ID			Y	BIGINT - AI - ID	LT		nextval('subterra_uri_map_c_id_seq'::regclass)

Table Name	POLARION.TESTRUN
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	FK_DOCUMENT		F		BIGINT	LT
9	FK_URI_DOCUMENT				BIGINT	LT
10	C_FINISHEDON				Timestamp	LT
11	C_GROUPID				VARCHAR	LT
12	C_HOMEPAGECONTENT				VARCHAR	LT
13	C_ID				VARCHAR	LT
14	C_IDPREFIX				VARCHAR	LT
15	C_ISTEMPLATE				BIT (1)	LT
16	C_KEEPINHISTORY				BIT (1)	LT
17	C_LOCATION				VARCHAR	LT
18	FK_PROJECT		F		BIGINT	LT
19	FK_URI_PROJECT				BIGINT	LT
20	C_QUERY				VARCHAR	LT
21	C_SELECTTESTCASESBY				VARCHAR	LT
22	C_STATUS				VARCHAR	LT
23	FK_SUMMARYDEFECT		F		BIGINT	LT
24	FK_URI_SUMMARYDEFECT				BIGINT	LT
25	FK_TEMPLATE		F		BIGINT	LT
26	FK_URI_TEMPLATE				BIGINT	LT
27	C_TITLE				VARCHAR	LT
28	C_TYPE				VARCHAR	LT
29	C_UPDATED				Timestamp	LT
30	C_USEREPORTFROMTEMPLATE				BIT (1)	LT

Table Name	POLARION.TESTRUNATTACHMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CONTENT				BINARY	LT
8	C_FILENAME				VARCHAR	LT
9	C_ID				VARCHAR	LT
10	C_LENGTH				BIGINT	LT
11	FK_PROJECT		F		BIGINT	LT
12	FK_URI_PROJECT				BIGINT	LT
13	FK_TESTRUN		F		BIGINT	LT
14	FK_URI_TESTRUN				BIGINT	LT
15	C_TITLE				VARCHAR	LT
16	C_UPDATED				Timestamp	LT
17	C_URL				VARCHAR	LT

Table Name	POLARION.TESTRUNCOMMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	C_ID				VARCHAR	LT
9	FK_PARENTCOMMENT		F		BIGINT	LT
10	FK_URI_PARENTCOMMENT				BIGINT	LT
11	FK_PROJECT		F		BIGINT	LT
12	FK_URI_PROJECT				BIGINT	LT
13	C_RESOLVED				BIT (1)	LT
14	C_TAGS					LT
15	FK_TESTRUN		F		BIGINT	LT
16	FK_URI_TESTRUN				BIGINT	LT
17	C_TEXT				VARCHAR	LT
18	C_TITLE				VARCHAR	LT

Table Name	POLARION.TESTRUNWORKFLOWSIGNATURE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_ID				VARCHAR	LT
6	FK_PROJECT		F		BIGINT	LT
7	FK_URI_PROJECT				BIGINT	LT
8	C_SIGNATURESTATE				VARCHAR	LT
9	C_TARGETSTATUSID				VARCHAR	LT
10	C_TRANSITIONDATAREVISION				VARCHAR	LT
11	FK_WORKFLOWOBJECT		F		BIGINT	LT
12	FK_URI_WORKFLOWOBJECT				BIGINT	LT

Table Name	POLARION.TIMEPOINT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_CLOSED				BIT (1)	LT
6	C_DESCRIPTION				VARCHAR	LT
7	C_EARLIESTPLANNEDSTART				Date	LT
8	FK_GROUPENTITY				BIGINT	LT
9	FK_URI_GROUPENTITY				BIGINT	LT
10	C_ID				VARCHAR	LT
11	C_NAME				VARCHAR	LT
12	FK_PROJECT		F		BIGINT	LT
13	FK_URI_PROJECT				BIGINT	LT
14	C_TIME				Date	LT

Table Name	POLARION.T_USER
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_AVATARFILENAME				VARCHAR	LT
6	C_DESCRIPTION				VARCHAR	LT
7	C_DISABLEDNOTIFICATIONS				BIT (1)	LT
8	C_EMAIL				VARCHAR	LT
9	C_HOMEPAGECONTENT				VARCHAR	LT
10	C_ID				VARCHAR	LT
11	C_INITIALS				VARCHAR	LT
12	C_NAME				VARCHAR	LT

Table Name	POLARION.USERGROUP
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_DESCRIPTION				VARCHAR	LT
6	C_ID				VARCHAR	LT
7	C_LDAPSEARCHFILTER				VARCHAR	LT
8	C_LOCATION				VARCHAR	LT
9	C_NAME				VARCHAR	LT
10	C_SSOSYNCHRONIZATIONALLOWED				BIT (1)	LT

Table Name	POLARION.WATCHLIST
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_USERID				VARCHAR	LT

Table Name	POLARION.WIKIPAGE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	C_HOMEPAGECONTENT				VARCHAR	LT
9	C_ID				VARCHAR	LT
10	C_LOCATION				VARCHAR	LT
11	C_PAGELOCATION				VARCHAR	LT
12	C_PAGENAME				VARCHAR	LT
13	C_PARENTSPACEID				VARCHAR	LT
14	FK_PROJECT		F		BIGINT	LT
15	FK_URI_PROJECT				BIGINT	LT
16	C_SPACEID				VARCHAR	LT
17	C_TITLE				VARCHAR	LT
18	C_TYPE				VARCHAR	LT
19	C_UPDATED				Timestamp	LT
20	FK_UPDATEDBY		F		BIGINT	LT
21	FK_URI_UPDATEDBY				BIGINT	LT

Table Name	POLARION.WIKIPAGEATTACHMENT
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CONTENT				BINARY	LT
8	C_FILENAME				VARCHAR	LT
9	C_ID				VARCHAR	LT
10	C_LENGTH				BIGINT	LT
11	FK_PROJECT		F		BIGINT	LT
12	FK_URI_PROJECT				BIGINT	LT
13	C_TITLE				VARCHAR	LT
14	C_UPDATED				Timestamp	LT
15	C_URL				VARCHAR	LT
16	FK_WIKIPAGE		F		BIGINT	LT
17	FK_URI_WIKIPAGE				BIGINT	LT

Table Name	POLARION.WORKITEM
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	FK_AUTHOR		F		BIGINT	LT
6	FK_URI_AUTHOR				BIGINT	LT
7	C_CREATED				Timestamp	LT
8	C_DESCRIPTION				VARCHAR	LT
9	C_DUEDATE				Date	LT
10	C_ID				VARCHAR	LT
11	C_INITIALESTIMATE				REAL	LT
12	C_LOCATION				VARCHAR	LT
13	FK_MODULE		F		BIGINT	LT
14	FK_URI_MODULE				BIGINT	LT
15	C_OUTLINENUMBER				VARCHAR	LT
16	C_PLANNEDEND				Timestamp	LT
17	C_PLANNEDSTART				Timestamp	LT
18	C_PREVIOUSSTATUS				VARCHAR	LT
19	C_PRIORITY				VARCHAR	LT
20	FK_PROJECT		F		BIGINT	LT
21	FK_URI_PROJECT				BIGINT	LT
22	C_REMAININGESTIMATE				REAL	LT
23	C_RESOLUTION				VARCHAR	LT
24	C_RESOLVEDON				Timestamp	LT
25	C_SEVERITY				VARCHAR	LT
26	C_STATUS				VARCHAR	LT
27	FK_TIMEPOINT		F		BIGINT	LT
28	FK_URI_TIMEPOINT				BIGINT	LT
29	C_TIMESPENT				REAL	LT
30	C_TITLE				VARCHAR	LT
31	C_TYPE				VARCHAR	LT
32	C_UPDATED				Timestamp	LT

Table Name	POLARION.WORKITEMWORKFLOWSIGNATURE
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_ID				VARCHAR	LT
6	FK_PROJECT		F		BIGINT	LT
7	FK_URI_PROJECT				BIGINT	LT
8	C_SIGNATURESTATE				VARCHAR	LT
9	C_TARGETSTATUSID				VARCHAR	LT
10	C_TRANSITIONDATAREVISION				VARCHAR	LT
11	FK_WORKFLOWOBJECT		F		BIGINT	LT
12	FK_URI_WORKFLOWOBJECT				BIGINT	LT

Table Name	POLARION.WORKRECORD
Functional Name
Abbreviation
Classification Type Name
Object Type Name

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	C_PK	P		Y	BIGINT	LT
2	C_URI				BIGINT	LT
3	C_REV				BIGINT	LT
4	C_DELETED				BIT (1)	LT
5	C_COMMENT				VARCHAR	LT
6	C_DATE				Date	LT
7	C_ID				VARCHAR	LT
8	FK_PROJECT		F		BIGINT	LT
9	FK_URI_PROJECT				BIGINT	LT
10	C_TIMESPENT				REAL	LT
11	C_TYPE				VARCHAR	LT
12	FK_USER		F		BIGINT	LT
13	FK_URI_USER				BIGINT	LT
14	FK_WORKITEM		F		BIGINT	LT
15	FK_URI_WORKITEM				BIGINT	LT