All Tables Details

Design Name full_db
Version Date 24.04.2025 12:49:13
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 (2147483647) 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 (2147483647) 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_BASELINECOLLECTION_RICHPAGES
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 FK_RICHPAGE   F   BIGINT LT        
4 FK_URI_RICHPAGE       BIGINT LT        


Table Name POLARION.REL_BASELINECOLLECTION_UPSTREAMCOLLECTIONS
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_BASELINECOLLECTION   F   BIGINT LT        
4 FK_URI_BASELINECOLLECTION       BIGINT LT        
5 C_REV_BASELINECOLLECTION       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 (2147483647) 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 (2147483647) LT        
8 C_CREATED       Timestamp LT        
9 C_DESCRIPTION       VARCHAR (2147483647) LT        
10 C_ID       VARCHAR (2147483647) 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 (2147483647) LT        
16 C_TITLE       VARCHAR (2147483647) LT        
17 C_TYPE       VARCHAR (2147483647) LT        
18 C_UPDATED       Timestamp LT        
19 FK_UPDATEDBY   F   BIGINT LT        
20 FK_URI_UPDATEDBY       BIGINT 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_TITLE       VARCHAR LT        
4 C_ROLE       VARCHAR LT        
5 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 (2147483647) 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 (2147483647) 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