Answer To: ITECH7201 Assignment 1 Specification ITECH7201 Software Engineering: Analysis and Design Assignment...
Neha answered on Sep 01 2021
43924/Class Diagram.eapx
Object_ID Name Scope Stereotype Containment IsStatic IsCollection IsOrdered AllowDuplicates LowerBound UpperBound Container Notes Derived ID Pos GenOption Length Precision Scale Const Style Classifier Default Type ea_guid StyleEx
2 cashlist Public Not Specified 0 0 0 0 1 1 1 0 int {914CBAB8-4152-4b36-B8AD-C64588DD2978} volatile=0;
2 cardlist Public Not Specified 0 0 0 0 1 1 2 1 int {07BD9BB6-FD27-42bf-BFE5-924026D411B3} volatile=0;
2 chargelist Public Not Specified 0 0 0 0 1 1 3 2 int {807D8822-07EC-41d0-B0A1-9111F08CE35F} volatile=0;
3 amount Private Not Specified 0 0 0 0 1 1 4 0 int {CC4FD49A-4484-4aad-A0C4-CE0392DE9BAB} volatile=0;
3 mode Private Not Specified 0 0 0 0 1 1 5 1 int {2D959317-1DF7-496c-8148-EA06DF4BBEF7} volatile=0;
4 chargesum Private Not Specified 0 0 0 0 1 1 6 0 int {34229ACC-5661-4292-B17A-F405AAE5AFE2} volatile=0;
4 sum Private Not Specified 0 0 0 0 1 1 7 1 int {8765D451-8757-44ec-85BF-8AC36CB54172} volatile=0;
4 surcharge Private Not Specified 0 0 0 0 1 1 8 2 int {1BF87727-F801-43d2-8270-D7333897089D} volatile=0;
5 sum Private Not Specified 0 0 0 0 1 1 9 0 int {92E0EFAE-DB49-427f-ACAA-72F59016CCAE} volatile=0;
Object_ID Constraint AttName Type Notes ID
PropertyID ElementID Property VALUE NOTES ea_guid
AuthorName Roles Notes
Cardinality
*
0
0..*
0..1
1
1..
1..*
CategoryID Name Type NOTES
Name Organisation Phone1 Phone2 Mobile Fax Email Roles Notes
Complexity NumericWeight
Extreme 6
High 4
Low 2
Medium 3
V.High 5
V.Low 1
Connector_ID Name Direction Notes Connector_Type SubType SourceCard SourceAccess SourceElement DestCard DestAccess DestElement SourceRole SourceRoleType SourceRoleNote SourceContainment SourceIsAggregate SourceIsOrdered SourceQualifier DestRole DestRoleType DestRoleNote DestContainment DestIsAggregate DestIsOrdered DestQualifier Start_Object_ID End_Object_ID Top_Start_Label Top_Mid_Label Top_End_Label Btm_Start_Label Btm_Mid_Label Btm_End_Label Start_Edge End_Edge PtStartX PtStartY PtEndX PtEndY SeqNo HeadStyle LineStyle RouteStyle IsBold LineColor Stereotype VirtualInheritance LinkAccess PDATA1 PDATA2 PDATA3 PDATA4 PDATA5 DiagramID ea_guid SourceConstraint DestConstraint SourceIsNavigable DestIsNavigable IsRoot IsLeaf IsSpec SourceChangeable DestChangeable SourceTS DestTS StateFlags ActionFlags IsSignal IsStimulus DispatchAction Target2 StyleEx SourceStereotype DestStereotype SourceStyle DestStyle EventFlags
1 Source -> Destination Realisation Public Public Unspecified 0 0 Unspecified 0 0 3 2 0 0 0 0 0 0 0 0 0 3 0 -1 0 SX=0;SY=0;EX=0;EY=0; 0 {76EF4C19-82F0-4366-8BE9-B7DD1E334894} false true false false false none none instance instance false false 0 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
2 Source -> Destination Generalization Public Public Unspecified 0 0 Unspecified 0 0 5 3 0 0 0 0 0 0 0 0 0 3 0 -1 0 SX=0;SY=0;EX=0;EY=0; 0 {E92E9CD3-2F18-4113-8FE3-BDAA600142B0} false true false false false none none instance instance false false 6619250 Union=0;Derived=0;AllowDuplicates=0; Union=0;Derived=0;AllowDuplicates=0;
3 Source -> Destination Generalization Public Public Unspecified 0 0 Unspecified 0 0 4 3 0 0 0 0 0 0 0 0 0 3 0 -1 0 SX=0;SY=0;EX=0;EY=0; 0 {D3C572B4-0100-4b65-AFA5-A7171BE17439} false true false false false none none instance instance false false 5177390 Union=0;Derived=0;AllowDuplicates=0; Union=0;Derived=0;AllowDuplicates=0;
ConnectorID Constraint ConstraintType Notes
PropertyID ElementID Property VALUE NOTES ea_guid
Connector_Type Description
Abstraction Abstraction
Aggregation Aggregation
Assembly Assembly
Association Association
Collaboration Collaboration
CommunicationPath CommunicationPath
Connector Composite Connector
ControlFlow ControlFlow
Delegate Delegate
Dependency Dependency
Deployment Deployment
ERLink ERLink
Extension Extension
Generalization Generalization
InformationFlow InformationFlow
Instantiation Instantiation
InterruptFlow InterruptFlow
Manifest Manifest
Nesting Nesting
NoteLink NoteLink
ObjectFlow ObjectFlow
Package Package
ProtocolConformance ProtocolConformance
ProtocolTransition ProtocolTransition
Realisation Realisation
Sequence Sequence
StateFlow StateFlow
Substitution Substitution
Usage Usage
UseCase UseCase
ConstantName ConstantValue
CompanyName Sparx Systems
ECF_EC 1.4
ECF_EWF -0.03
HoursPerUCP 20
ProjectName DOJ
TCF_TC 0.6
TCF_TWF 0.01
Constraint Description Notes
Invariant A state the object must always be in
Post-condition An ending state that must be met
Pre-condition A starting state that must be met
Process A process that must occur
Type ProductName DataType Size MaxLen MaxPrec MaxScale DefaultLen DefaultPrec DefaultScale User PDATA1 PDATA2 PDATA3 PDATA4 HasLength GenericType DatatypeID
DDL Oracle CHAR 1 2000 0 0 1 0 0 0 char 1
DDL Oracle VARCHAR2 1 4000 0 0 50 0 0 0 varchar 2
DDL Oracle VARCHAR 1 4000 0 0 50 0 0 0 varchar 3
DDL Oracle NCHAR 1 2000 0 0 50 0 0 0 nchar 4
DDL Oracle NVARCHAR 1 4000 0 0 50 0 0 0 nvarchar 5
DDL Oracle FLOAT 1 126 0 0 126 0 0 0 float 6
DDL Oracle NUMBER 2 0 38 0 0 8 2 0 number 7
DDL Oracle DATE 0 0 0 0 0 0 0 0 datetime 8
DDL Oracle ROWID 0 0 0 0 0 0 0 0 uniqueidentifier 9
DDL Oracle RAW 1 2000 0 0 2000 0 0 0 binary 10
DDL Oracle LONG RAW 0 0 0 0 0 0 0 0 binary 11
DDL Oracle CLOB 0 0 0 0 0 0 0 0 text 12
DDL Oracle LONG 0 0 0 0 0 0 0 0 long 13
DDL Oracle NCLOB 0 0 0 0 0 0 0 0 ntext 15
DDL Oracle BLOB 0 0 0 0 0 0 0 0 blob 16
DDL Oracle BFILE 0 0 0 0 0 0 0 0 blob 17
DDL SQLServer7 binary 1 8000 0 0 10 0 0 0 binary 18
DDL SQLServer7 bit 0 0 0 0 0 0 0 0 boolean 19
DDL SQLServer7 char 1 8000 0 0 1 0 0 0 char 20
DDL SQLServer7 datetime 0 0 0 0 0 0 0 0 DateTime 21
DDL SQLServer7 decimal 2 0 38 0 0 18 0 0 decimal 22
DDL SQLServer7 float 1 53 0 0 53 0 0 0 float 23
DDL SQLServer7 image 0 0 0 0 0 0 0 0 binary 24
DDL SQLServer7 int 0 0 0 0 0 0 0 0 integer 25
DDL SQLServer7 money 0 0 0 0 0 0 0 0 currency 26
DDL SQLServer7 nchar 1 4000 0 0 10 0 0 0 nchar 27
DDL SQLServer7 ntext 0 0 0 0 0 0 0 0 ntext 28
DDL SQLServer7 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 29
DDL SQLServer7 numeric 2 0 38 0 0 18 0 0 numeric 30
DDL SQLServer7 real 0 0 0 0 0 0 0 0 real 31
DDL SQLServer7 smalldatetime 0 0 0 0 0 0 0 0 datetime 32
DDL SQLServer7 smallint 0 0 0 0 0 0 0 0 smallint 33
DDL SQLServer7 smallmoney 0 0 0 0 0 0 0 0 money 34
DDL SQLServer7 text 0 0 0 0 0 0 0 0 text 35
DDL SQLServer7 timestamp 0 0 0 0 0 0 0 0 timestamp 36
DDL SQLServer7 tinyint 0 0 0 0 0 0 0 0 tinyint 37
DDL SQLServer7 varchar 1 8000 0 0 50 0 0 0 varchar 38
DDL SQLServer7 varbinary 1 8000 0 0 50 0 0 0 varbinary 39
DDL SQLServer7 uniqueidentifier 0 0 0 0 0 0 0 0 uniqueidentifier 40
DDL MSAccess Text 1 255 0 0 50 0 0 0 char 41
DDL MSAccess Memo 0 65535 0 0 0 0 0 0 text 42
DDL MSAccess DateTime 0 0 0 0 0 0 0 0 datetime 43
DDL MSAccess Integer 0 0 0 0 0 0 0 0 integer 45
DDL MSAccess Long 0 0 0 0 0 0 0 0 long 46
DDL MSAccess Single 0 0 7 0 0 0 7 0 float 47
DDL MSAccess Double 0 0 0 0 0 0 0 0 double 48
DDL MSAccess Counter 0 0 0 0 0 0 0 0 counter 49
DDL MSAccess YesNo 0 0 0 0 0 0 0 0 boolean 50
Code Visual Basic Boolean 0 0 0 0 0 0 0 0 Boolean 51
Code Visual Basic Byte 0 0 0 0 0 0 0 0 Byte 52
Code Visual Basic Currency 0 0 0 0 0 0 0 0 Currency 53
Code Visual Basic Date 0 0 0 0 0 0 0 0 DateTime 54
Code Visual Basic Double 0 0 0 0 0 0 0 0 Double 55
Code Visual Basic Integer 0 0 0 0 0 0 0 0 Integer 56
Code Visual Basic Long 0 0 0 0 0 0 0 0 Long 57
Code Visual Basic Object 0 0 0 0 0 0 0 0 58
Code Visual Basic Single 0 0 0 0 0 0 0 0 59
Code Visual Basic String 0 0 0 0 0 0 0 0 String 60
Code Visual Basic Variant 0 0 0 0 0 0 0 0 Variant 61
Code C++ char 0 0 0 0 0 0 0 0 Char 62
Code C++ int 0 0 0 0 0 0 0 0 Integer 63
Code C++ short 0 0 0 0 0 0 0 0 Short 64
Code C++ long 0 0 0 0 0 0 0 0 Long 65
Code C++ float 0 0 0 0 0 0 0 0 Float 66
Code C++ double 0 0 0 0 0 0 0 0 Double 67
Code C++ void 0 0 0 0 0 0 0 0 68
Code C++ unsigned char 0 0 0 0 0 0 0 0 69
Code C++ unsigned int 0 0 0 0 0 0 0 0 Uint 70
Code C++ unsigned short 0 0 0 0 0 0 0 0 71
Code C++ unsigned long 0 0 0 0 0 0 0 0 Ulong 72
Code Java byte 0 0 0 0 0 0 0 0 Byte 73
Code Java char 0 0 0 0 0 0 0 0 Char 74
Code Java int 0 0 0 0 0 0 0 0 Integer 75
Code Java short 0 0 0 0 0 0 0 0 Short 76
Code Java boolean 0 0 0 0 0 0 0 0 Boolean 77
Code Java long 0 0 0 0 0 0 0 0 Long 78
Code Java float 0 0 0 0 0 0 0 0 Float 79
Code Java double 0 0 0 0 0 0 0 0 Double 80
Code Delphi Boolean 0 0 0 0 0 0 0 0 Boolean 81
Code Delphi Byte 0 0 0 0 0 0 0 0 Byte 82
Code Delphi Cardinal 0 0 0 0 0 0 0 0 83
Code Delphi Char 0 0 0 0 0 0 0 0 Char 84
Code Delphi Currency 0 0 0 0 0 0 0 0 Currency 85
Code Delphi Double 0 0 0 0 0 0 0 0 Double 86
Code Delphi Extended 0 0 0 0 0 0 0 0 87
Code Delphi Integer 0 0 0 0 0 0 0 0 Integer 88
Code Delphi LongInt 0 0 0 0 0 0 0 0 89
Code Delphi LongWord 0 0 0 0 0 0 0 0 Ulong 90
Code Delphi Single 0 0 0 0 0 0 0 0 91
Code Delphi ShortInt 0 0 0 0 0 0 0 0 92
Code Delphi SmallInt 0 0 0 0 0 0 0 0 93
Code Delphi String 0 0 0 0 0 0 0 0 String 94
Code Delphi Real 0 0 0 0 0 0 0 0 95
Code Delphi Variant 0 0 0 0 0 0 0 0 Variant 96
Code Delphi Word 0 0 0 0 0 0 0 0 Word 98
Code C# void 0 0 0 0 0 0 0 0 99
Code C# sbyte 0 0 0 0 0 0 0 0 100
Code C# byte 0 0 0 0 0 0 0 0 Byte 101
Code C# short 0 0 0 0 0 0 0 0 Short 102
Code C# ushort 0 0 0 0 0 0 0 0 Ushort 103
Code C# int 0 0 0 0 0 0 0 0 Integer 104
Code C# uint 0 0 0 0 0 0 0 0 Uint 105
Code C# long 0 0 0 0 0 0 0 0 Long 106
Code C# ulong 0 0 0 0 0 0 0 0 Ulong 107
Code C# char 0 0 0 0 0 0 0 0 Char 108
Code C# float 0 0 0 0 0 0 0 0 Float 109
Code C# double 0 0 0 0 0 0 0 0 Double 110
Code C# bool 0 0 0 0 0 0 0 0 Boolean 111
Code C# decimal 0 0 0 0 0 0 0 0 Float 112
Code VBNet Integer 0 0 0 0 0 0 0 0 Integer 113
Code VBNet String 0 0 0 0 0 0 0 0 String 114
Code VBNet Short 0 0 0 0 0 0 0 0 Short 115
Code VBNet Long 0 0 0 0 0 0 0 0 Long 116
Code VBNet Char 0 0 0 0 0 0 0 0 Char 117
Code VBNet Byte 0 0 0 0 0 0 0 0 Byte 118
Code VBNet Boolean 0 0 0 0 0 0 0 0 Boolean 119
Code VBNet Double 0 0 0 0 0 0 0 0 Double 120
Code VBNet Date 0 0 0 0 0 0 0 0 Date 121
Code VBNet Object 0 0 0 0 0 0 0 0 122
Code VBNet Single 0 0 0 0 0 0 0 0 Single 123
Code VBNet Datetime 0 0 0 0 0 0 0 0 DateTime 124
Code VBNet Decimal 0 0 0 0 0 0 0 0 125
DDL DB2 BIGINT 0 0 0 0 0 0 0 0 bigint 126
DDL DB2 CHARACTER 1 254 0 0 10 0 0 0 char 128
DDL DB2 DATE 0 0 0 0 0 0 0 0 date 130
DDL DB2 DECIMAL 2 31 31 0 0 5 0 0 decimal 131
DDL DB2 DOUBLE 0 0 0 0 0 0 0 0 double 132
DDL DB2 INTEGER 0 0 0 0 0 0 0 0 integer 133
DDL DB2 LONG VARCHAR 0 0 0 0 0 0 0 0 text 134
DDL DB2 REAL 0 0 0 0 0 0 0 0 real 135
DDL DB2 TIME 0 0 0 0 0 0 0 0 time 137
DDL DB2 TIMESTAMP 0 0 0 0 0 0 0 0 timestamp 138
DDL MySql BIT 1 64 0 0 1 0 0 0 bit 140
DDL MySql BOOL 0 0 0 0 0 0 0 0 boolean 141
DDL MySql TINYINT 0 0 0 0 0 0 0 0 tinyint 142
DDL MySql SMALLINT 0 0 0 0 0 0 0 0 smallint 143
DDL MySql INTEGER 0 0 0 0 0 0 0 0 integer 144
DDL MySql MEDIUMINT 0 0 0 0 0 0 0 0 mediumint 145
DDL MySql BIGINT 0 0 0 0 0 0 0 0 bigint 146
DDL MySql FLOAT 2 0 24 0 0 0 0 0 float 147
DDL MySql DOUBLE 2 0 53 30 0 10 2 0 double 148
DDL MySql DOUBLE PRECISION 2 0 53 30 0 10 2 0 double 149
DDL MySql REAL 2 0 53 30 0 10 2 0 real 150
DDL MySql NUMERIC 2 0 65 30 0 10 2 0 numeric 151
DDL MySql DECIMAL 2 0 65 30 0 10 2 0 decimal 152
DDL MySql DATE 0 0 0 0 0 0 0 0 date 153
DDL MySql DATETIME 1 6 0 0 0 0 0 0 datetime 154
DDL MySql TIME 1 6 0 0 0 0 0 0 time 155
DDL MySql TIMESTAMP 1 6 0 0 0 0 0 0 timestamp 156
DDL MySql CHAR 1 255 0 0 10 0 0 0 char 157
DDL MySql VARCHAR 1 65535 0 0 50 0 0 0 varchar 158
DDL MySql BLOB 0 0 0 0 0 0 0 0 blob 159
DDL MySql TEXT 0 0 0 0 0 0 0 0 text 160
DDL SQL Server 2000 decimal 2 38 38 38 0 10 2 0 decimal 161
DDL SQL Server 2000 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 162
DDL SQL Server 2000 numeric 2 38 38 38 0 10 2 0 numeric 163
DDL SQL Server 2000 varbinary 1 8000 0 0 50 0 0 0 varbinary 164
DDL SQL Server 2000 bit 0 0 0 0 0 0 0 0 boolean 165
DDL InterBase integer 0 0 0 0 10 0 0 0 integer 167
DDL InterBase smallint 0 0 0 0 10 0 0 0 smallint 168
DDL MySql NCHAR 1 255 0 0 10 0 0 0 nchar 169
DDL InterBase timestamp 0 0 0 0 0 0 0 0 datetime 170
DDL PostgreSQL real 1 53 0 0 53 0 0 0 real 171
DDL SQL Server 2000 char 1 8000 0 0 10 0 0 0 char 174
DDL SQL Server 2000 timestamp 0 0 0 0 0 0 0 0 timestamp 175
DDL InterBase double precision 0 0 0 0 0 0 0 0 double 178
DDL SQL Server 2000 binary 1 8000 0 0 10 0 0 0 Binary 179
DDL SQL Server 2000 image 0 0 0 0 0 0 0 0 blob 180
DDL SQL Server 2000 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 181
DDL SQL Server 2000 smalldatetime 0 0 0 0 0 0 0 0 datetime 182
DDL PostgreSQL numeric 2 0 1000 1000 0 0 0 0 numeric 183
DDL DB2 FLOAT 0 0 0 0 0 0 0 0 float 184
DDL PostgreSQL integer 0 0 0 0 0 0 0 0 integer 185
DDL PostgreSQL varchar 1 1048576 0 0 50 0 0 0 varchar 186
DDL InterBase blob sub_type 0 0 0 0 0 0 0 0 0 blob 188
DDL SQL Server 2000 money 0 0 0 0 0 19 4 0 currency 190
DDL SQL Server 2000 ntext 0 0 0 0 0 0 0 0 ntext 191
DDL SQL Server 2000 uniqueidentifier 0 0 0 0 0 0 0 0 guid 192
DDL PostgreSQL bigint 0 0 0 0 0 0 0 0 bigint 195
DDL DB2 SMALLINT 0 0 0 0 0 0 0 0 smallint 196
DDL MSAccess OLEObject 0 0 0 0 0 0 0 0 blob 199
DDL SQL Server 2000 int 0 0 0 0 0 0 0 0 integer 201
DDL SQL Server 2000 datetime 0 0 0 0 0 0 0 0 datetime 203
DDL SQL Server 2000 float 0 53 0 0 53 0 0 0 float 204
DDL SQL Server 2000 nchar 1 4000 0 0 10 0 0 0 nchar 205
DDL Oracle NVARCHAR2 1 4000 0 0 50 0 0 0 nvarchar 206
DDL InterBase varchar 1 32767 0 0 50 0 0 0 varchar 209
DDL MSAccess Byte 0 0 0 0 0 0 0 0 tinyint 210
DDL SQL Server 2000 real 0 53 0 0 53 0 0 0 double 211
DDL SQL Server 2000 text 0 0 0 0 0 0 0 0 text 212
DDL SQL Server 2000 tinyint 0 0 0 0 0 0 0 0 tinyint 213
DDL PostgreSQL smallint 0 0 0 0 0 0 0 0 smallint 214
DDL SQL Server 2000 smallint 0 0 0 0 0 0 0 0 smallint 216
DDL SQL Server 2000 varchar 1 8000 0 0 50 0 0 0 varchar 217
DDL DB2 CHAR 1 254 0 0 10 0 0 0 char 218
DDL PostgreSQL char 1 1048576 0 0 1 0 0 0 char 219
DDL PostgreSQL decimal 2 0 1000 1000 0 0 0 0 decimal 220
DDL PostgreSQL text 0 0 0 0 0 0 0 0 text 221
DDL SQL Server 2000 bigint 0 0 0 0 0 0 0 0 bigint 222
DDL SQL Server 2000 smallmoney 0 0 0 0 0 0 0 0 money 226
DDL InterBase blob sub_type 1 0 0 0 0 0 0 0 0 text 227
DDL InterBase char 1 32767 0 0 10 0 0 0 char 228
DDL PostgreSQL boolean 0 0 0 0 0 0 0 0 boolean 230
DDL PostgreSQL timestamp 1 6 0 0 0 0 0 0 datetime 231
DDL MySql NVARCHAR 1 65535 0 0 50 0 0 0 nvarchar 232
DDL PostgreSQL bytea 0 0 0 0 0 0 0 0 blob 233
DDL InterBase decimal 2 0 64 64 0 10 2 0 decimal 235
Code PHP var 0 0 1 var 236
Code C# string 0 0 1 String 237
Code C++ wchar_t 0 0 1 Char 238
Code C++ bool 0 0 1 Boolean 239
DDL Sybase ASE tinyint 0 0 0 0 0 0 0 0 tinyint 240
DDL Sybase ASE smallint 0 0 0 0 0 0 0 0 smallint 241
DDL Sybase ASE int 0 0 0 0 0 0 0 0 integer 242
DDL Sybase ASE numeric 2 0 38 38 0 18 0 0 numeric 243
DDL Sybase ASE decimal 2 0 38 38 0 18 0 0 decimal 244
DDL Sybase ASE float 0 0 0 0 0 0 0 0 float 245
DDL Sybase ASE double precision 0 0 0 0 0 0 0 0 double 246
DDL Sybase ASE real 0 0 0 0 0 0 0 0 real 247
DDL Sybase ASE smallmoney 0 0 0 0 0 0 0 0 money 248
DDL Sybase ASE money 0 0 0 0 0 0 0 0 money 249
DDL Sybase ASE smalldatetime 0 0 0 0 0 0 0 0 datetime 250
DDL Sybase ASE datetime 0 0 0 0 0 0 0 0 datetime 251
DDL Sybase ASE char 1 16384 0 0 50 0 0 0 char 252
DDL Sybase ASE varchar 1 16384 0 0 100 0 0 0 varchar 253
DDL Sybase ASE unichar 1 0 0 0 50 0 0 0 char 254
DDL Sybase ASE univarchar 1 0 0 0 50 0 0 0 varchar 255
DDL Sybase ASE nchar 1 16384 0 0 50 0 0 0 nchar 256
DDL Sybase ASE nvarchar 1 16384 0 0 50 0 0 0 nvarchar 257
DDL Sybase ASE text 0 0 0 0 50 0 0 0 text 258
DDL Sybase ASE binary 1 255 0 0 1 0 0 0 binary 259
DDL Sybase ASE image 0 0 0 0 0 0 0 0 blob 261
DDL Sybase ASE bit 0 0 0 0 0 0 0 0 boolean 262
DDL Informix INTEGER 0 0 0 0 0 0 0 0 integer 263
DDL Informix INT 0 0 0 0 0 0 0 0 integer 264
DDL Informix SMALLINT 0 0 0 0 0 0 0 0 smallint 265
DDL Informix INT8 0 0 0 0 0 0 0 0 bigint 266
DDL Informix SERIAL 0 0 0 0 0 0 0 0 integer 267
DDL Informix SERIAL8 0 0 0 0 0 0 0 0 integer 268
DDL Informix FLOAT 0 0 0 0 0 0 0 0 float 269
DDL Informix SMALLFLOAT 0 4 0 0 4 0 0 0 float 270
DDL Informix DECIMAL 2 0 32 32 0 8 3 0 decimal 271
DDL Informix DEC 2 0 32 32 0 8 3 0 decimal 272
DDL Informix MONEY 2 0 32 3 0 8 3 0 money 273
DDL Informix DATE 0 0 0 0 0 0 0 0 date 274
DDL Informix DATETIME HOUR TO MINUTE 0 0 0 0 0 0 0 0 datetime 275
DDL Informix DATETIME YEAR TO YEAR 0 0 0 0 0 0 0 0 datetime 276
DDL Informix DATETIME YEAR TO MONTH 0 0 0 0 0 0 0 0 datetime 277
DDL Informix DATETIME YEAR TO DAY 0 0 0 0 0 0 0 0 datetime 278
DDL Informix DATETIME YEAR TO HOUR 0 0 0 0 0 0 0 0 datetime 279
DDL Informix DATETIME YEAR TO MINUTE 0 0 0 0 0 0 0 0 datetime 280
DDL Informix DATETIME YEAR TO SECOND 0 0 0 0 0 0 0 0 datetime 281
DDL Informix DATETIME YEAR TO FRACTION 1 5 0 0 3 0 0 0 datetime 282
DDL Informix DATETIME MONTH TO MONTH 0 0 0 0 0 0 0 0 datetime 283
DDL Informix DATETIME MONTH TO DAY 0 0 0 0 0 0 0 0 datetime 284
DDL Informix DATETIME MONTH TO HOUR 0 0 0 0 0 0 0 0 datetime 285
DDL Informix DATETIME MONTH TO MINUTE 0 0 0 0 0 0 0 0 datetime 286
DDL Informix DATETIME MONTH TO SECOND 0 0 0 0 0 0 0 0 datetime 287
DDL Informix DATETIME MONTH TO FRACTION 1 5 0 0 3 0 0 0 datetime 288
DDL Informix DATETIME DAY TO DAY 0 0 0 0 0 0 0 0 datetime 289
DDL Informix DATETIME DAY TO HOUR 0 0 0 0 0 0 0 0 datetime 290
DDL Informix DATETIME DAY TO MINUTE 0 0 0 0 0 0 0 0 datetime 291
DDL Informix DATETIME DAY TO SECOND 0 0 0 0 0 0 0 0 datetime 292
DDL Informix DATETIME DAY TO FRACTION 1 5 0 0 3 0 0 0 datetime 293
DDL Informix DATETIME HOUR TO HOUR 0 0 0 0 0 0 0 0 datetime 294
DDL Informix DATETIME HOUR TO FRACTION 1 5 0 0 3 0 0 0 datetime 295
DDL Informix DATETIME HOUR TO SECOND 0 0 0 0 0 0 0 0 datetime 296
DDL Informix DATETIME MINUTE TO MINUTE 0 0 0 0 0 0 0 0 datetime 297
DDL Informix DATETIME MINUTE TO SECOND 0 0 0 0 0 0 0 0 datetime 298
DDL Informix DATETIME MINUTE TO FRACTION 1 5 0 0 3 0 0 0 datetime 299
DDL Informix DATETIME SECOND TO SECOND 0 0 0 0 0 0 0 0 datetime 300
DDL Informix DATETIME SECOND TO FRACTION 1 5 0 0 3 0 0 0 datetime 301
DDL Informix DATETIME FRACTION TO FRACTION 1 5 0 0 3 0 0 0 datetime 302
DDL Informix BOOLEAN 0 0 0 0 0 0 0 0 boolean 303
DDL Informix CHAR 1 32767 0 0 10 0 0 0 char 304
DDL Informix CHARACTER 1 32767 0 0 10 0 0 0 char 305
DDL Informix NCHAR 1 32767 0 0 50 0 0 0 nchar 306
DDL Informix CHARACTER VARYING 1 255 0 0 0 0 0 0 char 307
DDL Informix VARCHAR 1 255 0 0 10 0 0 0 varchar 308
DDL Informix NVARCHAR 1 255 0 0 50 0 0 0 nvarchar 309
DDL Informix LVARCHAR 1 32767 0 0 2048 0 0 0 char 310
DDL Informix TEXT 0 0 0 0 0 0 0 0 text 311
DDL Informix BYTE 0 0 0 0 0 0 0 0 Binary 312
DDL Informix BLOB 0 0 0 0 0 0 0 0 blob 313
DDL Informix CLOB 0 0 0 0 0 0 0 0 ntext 314
DDL Ingres ansidate 0 0 0 0 0 0 0 0 ansidate 315
DDL Ingres bigint 0 0 0 0 0 0 0 0 bigint 316
DDL Ingres byte 1 32000 0 0 0 0 0 0 Binary 317
DDL Ingres byte var 1 32000 0 0 0 0 0 0 Binary 318
DDL Ingres c 1 32000 0 0 0 0 0 0 char 319
DDL Ingres char 1 32000 0 0 0 0 0 0 char 320
DDL Ingres date 0 0 0 0 0 0 0 0 date 321
DDL Ingres decimal 2 0 31 10 0 5 0 0 decimal 322
DDL Ingres float 1 53 0 0 8 0 0 0 float 323
DDL Ingres float4 0 0 0 0 0 0 0 0 real 324
DDL Ingres float8 0 0 0 0 0 0 0 0 float 325
DDL Ingres ingresdate 0 0 0 0 0 0 0 0 date 326
DDL Ingres int1 0 0 0 0 0 0 0 0 integer1 327
DDL Ingres int2 0 0 0 0 0 0 0 0 smallint 328
DDL Ingres int4 0 0 0 0 0 0 0 0 int 329
DDL Ingres int8 0 0 0 0 0 0 0 0 bigint 330
DDL Ingres integer 0 0 0 0 0 0 0 0 integer 331
DDL Ingres interval day to second 0 0 0 0 0 0 0 0 interval day to second 332
DDL Ingres interval year to month 0 0 0 0 0 0 0 0 interval year to month 333
DDL Ingres long byte 0 0 0 0 0 0 0 0 long byte 334
DDL Ingres long nvarchar 0 0 0 0 0 0 0 0 long nvarchar 335
DDL Ingres long varchar 0 0 0 0 0 0 0 0 long varchar 336
DDL Ingres money 0 0 0 0 0 0 0 0 money 337
DDL Ingres nchar 1 16000 0 0 0 0 0 0 nchar 338
DDL Ingres nvarchar 1 16000 0 0 0 0 0 0 nvarchar 339
DDL Ingres Object Key 0 0 0 0 0 0 0 0 OBJECT_KEY 340
DDL Ingres Table Key 0 0 0 0 0 0 0 0 TABLE_KEY 341
DDL Ingres text 1 32000 0 0 0 0 0 0 text 342
DDL Ingres time with local time zone 0 0 0 0 0 0 0 0 time 343
DDL Ingres time with time zone 0 0 0 0 0 0 0 0 time 344
DDL Ingres time without time zone 0 0 0 0 0 0 0 0 TABLE_KEY 345
DDL Ingres timestamp with local time zone 0 0 0 0 0 0 0 0 timestampt 346
DDL Ingres timestamp with time zone 0 0 0 0 0 0 0 0 timestampt 347
DDL Ingres timestamp without time zone 0 0 0 0 0 0 0 0 timestampt 348
DDL Ingres varchar 1 32000 0 0 0 0 0 0 varchar 349
DDL SQL Server 2005 bigint 0 0 0 0 0 0 0 0 bigint 350
DDL SQL Server 2005 int 0 0 0 0 0 0 0 0 integer 351
DDL SQL Server 2005 smallint 0 0 0 0 0 0 0 0 smallint 352
DDL SQL Server 2005 tinyint 0 0 0 0 0 0 0 0 tinyint 353
DDL SQL Server 2005 bit 0 0 0 0 0 0 0 0 boolean 354
DDL SQL Server 2005 decimal 2 38 38 38 0 10 2 0 decimal 355
DDL SQL Server 2005 numeric 2 38 38 38 0 10 2 0 numeric 356
DDL SQL Server 2005 money 0 0 0 0 0 19 4 0 currency 357
DDL SQL Server 2005 smallmoney 0 0 0 0 0 0 0 0 money 358
DDL SQL Server 2005 float 0 53 0 0 53 0 0 0 float 359
DDL SQL Server 2005 real 0 53 0 0 53 0 0 0 double 360
DDL SQL Server 2005 datetime 0 0 0 0 0 0 0 0 datetime 361
DDL SQL Server 2005 smalldatetime 0 0 0 0 0 0 0 0 datetime 362
DDL SQL Server 2005 char 1 8000 0 0 10 0 0 0 char 363
DDL SQL Server 2005 varchar 1 8000 0 0 50 0 0 0 varchar 364
DDL SQL Server 2005 text 0 0 0 0 0 0 0 0 text 365
DDL SQL Server 2005 nchar 1 4000 0 0 10 0 0 0 nchar 366
DDL SQL Server 2005 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 367
DDL SQL Server 2005 ntext 0 0 0 0 0 0 0 0 ntext 368
DDL SQL Server 2005 binary 1 8000 0 0 10 0 0 0 Binary 369
DDL SQL Server 2005 varbinary 1 8000 0 0 50 0 0 0 varbinary 370
DDL SQL Server 2005 image 0 0 0 0 0 0 0 0 blob 371
DDL SQL Server 2005 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 372
DDL SQL Server 2005 timestamp 0 0 0 0 0 0 0 0 timestamp 373
DDL SQL Server 2005 uniqueidentifier 0 0 0 0 0 0 0 0 guid 374
DDL SQL Server 2005 xml 0 0 0 0 0 0 0 0 text 375
DDL Informix INTERVAL YEAR TO YEAR 0 9 0 0 0 0 0 0 interval 376
DDL Informix INTERVAL YEAR TO MONTH 0 9 0 0 0 0 0 0 interval 377
DDL Informix INTERVAL MONTH TO MONTH 0 9 0 0 0 0 0 0 interval 378
DDL Informix INTERVAL DAY TO DAY 0 9 0 0 0 0 0 0 interval 379
DDL Informix INTERVAL DAY TO HOUR 0 9 0 0 0 0 0 0 interval 380
DDL Informix INTERVAL DAY TO MINUTE 0 9 0 0 0 0 0 0 interval 381
DDL Informix INTERVAL DAY TO SECOND 0 9 0 0 0 0 0 0 interval 382
DDL Informix INTERVAL DAY TO FRACTION 1 5 0 0 0 0 0 0 interval 383
DDL Informix INTERVAL HOUR TO HOUR 0 9 0 0 0 0 0 0 interval 384
DDL Informix INTERVAL HOUR TO MINUTE 0 9 0 0 0 0 0 0 interval 385
DDL Informix INTERVAL HOUR TO SECOND 0 9 0 0 0 0 0 0 interval 386
DDL Informix INTERVAL HOUR TO FRACTION 1 5 0 0 0 0 0 0 interval 387
DDL Informix INTERVAL MINUTE TO MINUTE 0 9 0 0 0 0 0 0 interval 388
DDL Informix INTERVAL MINUTE TO SECOND 0 9 0 0 0 0 0 0 interval 389
DDL Informix INTERVAL MINUTE TO FRACTION 1 5 0 0 0 0 0 0 interval 390
DDL Informix INTERVAL SECOND TO SECOND 0 9 0 0 0 0 0 0 interval 391
DDL Informix INTERVAL SECOND TO FRACTION 1 5 0 0 0 0 0 0 interval 392
DDL Informix INTERVAL FRACTION TO FRACTION 1 5 0 0 0 0 0 0 interval 393
DDL SQL Server 2005 varchar(max) 0 0 0 0 0 0 0 0 varchar 394
DDL SQL Server 2005 varbinary(max) 0 0 0 0 0 0 0 0 varbinary 395
DDL SQL Server 2008 bigint 0 0 0 0 0 0 0 0 bigint 396
DDL SQL Server 2008 bit 0 0 0 0 0 0 0 0 boolean 397
DDL SQL Server 2008 decimal 2 38 38 38 0 10 2 0 decimal 398
DDL SQL Server 2008 int 0 0 0 0 0 0 0 0 integer 399
DDL SQL Server 2008 money 0 0 0 0 0 19 4 0 currency 400
DDL SQL Server 2008 numeric 2 38 38 38 0 10 2 0 numeric 401
DDL SQL Server 2008 smallint 0 0 0 0 0 0 0 0 smallint 402
DDL SQL Server 2008 smallmoney 0 0 0 0 0 0 0 0 money 403
DDL SQL Server 2008 tinyint 0 0 0 0 0 0 0 0 tinyint 404
DDL SQL Server 2008 float 0 53 0 0 53 0 0 0 float 405
DDL SQL Server 2008 real 0 53 0 0 53 0 0 0 double 406
DDL SQL Server 2008 date 0 0 0 0 0 0 0 0 date 407
DDL SQL Server 2008 datetime2 1 7 0 0 7 0 0 0 datetime 408
DDL SQL Server 2008 datetime 0 0 0 0 0 0 0 0 datetime 409
DDL SQL Server 2008 datetimeoffset 1 7 0 0 7 0 0 0 datetime 410
DDL SQL Server 2008 smalldatetime 0 0 0 0 0 0 0 0 datetime 411
DDL SQL Server 2008 time 1 7 0 0 7 0 0 0 time 412
DDL SQL Server 2008 char 1 8000 0 0 10 0 0 0 char 413
DDL SQL Server 2008 varchar 1 8000 0 0 50 0 0 0 varchar 414
DDL SQL Server 2008 varchar(max) 0 0 0 0 0 0 0 0 varchar 415
DDL SQL Server 2008 text 0 0 0 0 0 0 0 0 text 416
DDL SQL Server 2008 nchar 1 4000 0 0 10 0 0 0 nchar 417
DDL SQL Server 2008 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 418
DDL SQL Server 2008 nvarchar(max) 0 0 0 0 0 0 0 0 varchar 419
DDL SQL Server 2008 ntext 0 0 0 0 0 0 0 0 ntext 420
DDL SQL Server 2008 binary 1 8000 0 0 10 0 0 0 Binary 421
DDL SQL Server 2008 varbinary 1 8000 0 0 50 0 0 0 varbinary 422
DDL SQL Server 2008 varbinary(max) 0 0 0 0 0 0 0 0 varbinary 423
DDL SQL Server 2008 image 0 0 0 0 0 0 0 0 blob 424
DDL SQL Server 2008 timestamp 0 0 0 0 0 0 0 0 timestamp 425
DDL SQL Server 2008 uniqueidentifier 0 0 0 0 0 0 0 0 guid 426
DDL SQL Server 2008 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 427
DDL SQL Server 2008 xml 0 0 0 0 0 0 0 0 text 428
DDL SQL Server 2008 hierarchyid 0 0 0 0 0 0 0 0 text 429
DDL SQL Server 2008 geometry 0 0 0 0 0 0 0 0 text 430
DDL SQL Server 2008 geography 0 0 0 0 0 0 0 0 text 431
DDL MSAccess 2007 Text 1 255 0 0 50 0 0 0 char 432
DDL MSAccess 2007 Memo 0 0 0 0 0 0 0 0 text 433
DDL MSAccess 2007 DateTime 0 0 0 0 0 0 0 0 datetime 434
DDL MSAccess 2007 Currency 0 0 0 0 0 0 0 0 currency 435
DDL MSAccess 2007 Integer 0 0 0 0 0 0 0 0 integer 436
DDL MSAccess 2007 Long 0 0 0 0 0 0 0 0 long 437
DDL MSAccess 2007 Single 0 0 0 0 0 0 0 0 float 438
DDL MSAccess 2007 Double 0 0 0 0 0 0 0 0 double 439
DDL MSAccess 2007 Counter 0 0 0 0 0 0 0 0 counter 440
DDL MSAccess 2007 YesNo 0 0 0 0 0 0 0 0 boolean 441
DDL MSAccess 2007 OLEObject 0 0 0 0 0 0 0 0 blob 442
DDL MSAccess 2007 Byte 0 0 0 0 0 0 0 0 tinyint 443
DDL MSAccess 2007 Decimal 0 0 0 0 0 0 0 0 decimal 445
DDL SQLite INTEGER 0 0 0 0 0 0 0 0 integer 447
DDL SQLite NUMERIC 0 0 0 0 0 0 0 0 numeric 448
DDL SQLite TEXT 0 0 0 0 0 0 0 0 text 449
DDL SQLite NONE 0 0 0 0 0 0 0 0 blob 450
DDL SQLite REAL 0 0 0 0 0 0 0 0 real 451
DDL InterBase numeric 2 0 64 64 0 10 2 0 numeric 452
DDL InterBase float 0 0 0 0 0 0 0 0 float 453
DDL Oracle BINARY_FLOAT 0 0 0 0 0 0 0 0 float 454
DDL Oracle BINARY_DOUBLE 0 0 0 0 0 0 0 0 double 455
DDL Oracle TIMESTAMP 1 9 0 0 6 0 0 0 timestamp 456
DDL Oracle TIMESTAMP WITH TIME ZONE 1 9 0 0 6 0 0 0 timestamp with time zone 457
DDL Oracle TIMESTAMP WITH LOCAL TIME ZONE 1 9 0 0 6 0 0 0 timestamp with local time zone 458
DDL Oracle INTERVAL YEAR TO MONTH 1 9 0 0 2 0 0 0 interval year to month 459
DDL Oracle INTERVAL DAY TO SECOND 2 0 9 9 0 2 6 0 interval day to second 460
DDL Oracle ANYDATA 0 0 0 0 0 0 0 0 text 461
DDL Oracle ANYTYPE 0 0 0 0 0 0 0 0 text 462
DDL Oracle ANYDATASET 0 0 0 0 0 0 0 0 text 463
DDL Oracle URITYPE 0 0 0 0 0 0 0 0 uri 464
DDL Oracle DBURITYPE 0 0 0 0 0 0 0 0 uri 465
DDL Oracle XDBURITYPE 0 0 0 0 0 0 0 0 uri 466
DDL Oracle HTTPURITYPE 0 0 0 0 0 0 0 0 uri 467
DDL Oracle XMLTYPE 0 0 0 0 0 0 0 0 xml 468
DDL Oracle SDO_GEOMETRY 0 0 0 0 0 0 0 0 spatial 469
DDL Oracle SDO_TOPO_GEOMETRY 0 0 0 0 0 0 0 0 spatial 470
DDL Oracle SDO_GEORASTER 0 0 0 0 0 0 0 0 spatial 471
DDL Oracle ORDAUDIO 0 0 0 0 0 0 0 0 media 472
DDL Oracle ORDIMAGE 0 0 0 0 0 0 0 0 media 473
DDL Oracle ORDVIDEO 0 0 0 0 0 0 0 0 media 474
DDL Oracle ORDDOC 0 0 0 0 0 0 0 0 media 475
DDL Oracle ORDDICOM 0 0 0 0 0 0 0 0 media 476
DDL Oracle SI_STILLIMAGE 0 0 0 0 0 0 0 0 image 477
DDL Oracle SI_COLOR 0 0 0 0 0 0 0 0 image 478
DDL Oracle SI_AVERAGECOLOR 0 0 0 0 0 0 0 0 image 479
DDL Oracle SI_COLORHISTOGRAM 0 0 0 0 0 0 0 0 image 480
DDL Oracle SI_POSITIONALCOLOR 0 0 0 0 0 0 0 0 image 481
DDL Oracle SI_TEXTURE 0 0 0 0 0 0 0 0 image 482
DDL Oracle SI_FEATURELIST 0 0 0 0 0 0 0 0 image 483
DDL MySql BINARY 1 255 0 0 50 0 0 0 binary 484
DDL MySql ENUM 0 0 0 0 0 0 0 0 enum 485
DDL MySql GEOMETRY 0 0 0 0 0 0 0 0 geometry 486
DDL MySql GEOMETRYCOLLECTION 0 0 0 0 0 0 0 0 geometrycollection 487
DDL MySql INT 0 0 0 0 0 0 0 0 integer 488
DDL MySql LINESTRING 0 0 0 0 0 0 0 0 linestring 489
DDL MySql LONGBLOB 0 0 0 0 0 0 0 0 longblob 490
DDL MySql LONGTEXT 0 0 0 0 0 0 0 0 longtext 491
DDL MySql MEDIUMBLOB 0 0 0 0 0 0 0 0 mediumblob 492
DDL MySql MEDIUMTEXT 0 0 0 0 0 0 0 0 mediumtext 493
DDL MySql MULTILINESTRING 0 0 0 0 0 0 0 0 multilinestring 494
DDL MySql MULTIPOINT 0 0 0 0 0 0 0 0 multipoint 495
DDL MySql MULTIPOLYGON 0 0 0 0 0 0 0 0 multipolygon 496
DDL MySql POINT 0 0 0 0 0 0 0 0 point 497
DDL MySql POLYGON 0 0 0 0 0 0 0 0 polygon 498
DDL MySql SET 0 0 0 0 0 0 0 0 set 499
DDL MySql TINYBLOB 0 0 0 0 0 0 0 0 tinyblob 500
DDL MySql TINYTEXT 0 0 0 0 0 0 0 0 tinytext 501
DDL MySql VARBINARY 1 65535 0 0 50 0 0 0 varbinary 502
DDL MySql YEAR 1 4 0 0 4 0 0 0 date 503
DDL PostgreSQL xml 0 0 0 0 0 0 0 0 xml 504
DDL PostgreSQL uuid 0 0 0 0 0 0 0 0 guid 505
DDL PostgreSQL date 0 0 0 0 0 0 0 0 date 506
DDL PostgreSQL interval 1 6 0 0 0 0 0 0 interval 507
DDL PostgreSQL time 1 6 0 0 0 0 0 0 time 508
DDL PostgreSQL time with time zone 1 6 0 0 0 0 0 0 time 509
DDL PostgreSQL time without time zone 1 6 0 0 0 0 0 0 time 510
DDL PostgreSQL timestamp with time zone 1 6 0 0 0 0 0 0 datetime 511
DDL PostgreSQL timestamp without time zone 1 6 0 0 0 0 0 0 datetime 512
DDL PostgreSQL inet 0 0 0 0 0 0 0 0 inet 513
DDL PostgreSQL cidr 0 0 0 0 0 0 0 0 cidr 514
DDL PostgreSQL macaddr 0 0 0 0 0 0 0 0 macaddr 515
DDL PostgreSQL money 0 0 0 0 0 0 0 0 currency 516
DDL PostgreSQL bit 1 83886080 0 0 1 0 0 0 bit 517
DDL PostgreSQL bit varying 1 83886080 0 0 0 0 0 0 varbit 518
DDL PostgreSQL double precision 0 0 0 0 0 0 0 0 double 519
DDL PostgreSQL serial 0 0 0 0 0 0 0 0 serial 520
DDL PostgreSQL bigserial 0 0 0 0 0 0 0 0 serial 521
DDL PostgreSQL smallserial 0 0 0 0 0 0 0 0 smallserial 522
DDL PostgreSQL point 0 0 0 0 0 0 0 0 point 523
DDL PostgreSQL line 0 0 0 0 0 0 0 0 line 524
DDL PostgreSQL lseg 0 0 0 0 0 0 0 0 lseg 525
DDL PostgreSQL box 0 0 0 0 0 0 0 0 box 526
DDL PostgreSQL path 0 0 0 0 0 0 0 0 path 527
DDL PostgreSQL polygon 0 0 0 0 0 0 0 0 polygon 528
DDL PostgreSQL circle 0 0 0 0 0 0 0 0 circle 529
DDL SQL Server 2012 bigint 0 0 0 0 0 0 0 0 bigint 549
DDL SQL Server 2012 binary 1 8000 0 0 10 0 0 0 binary 550
DDL SQL Server 2012 bit 0 0 0 0 0 0 0 0 boolean 551
DDL SQL Server 2012 char 1 8000 0 0 10 0 0 0 char 552
DDL SQL Server 2012 date 0 0 0 0 0 0 0 0 date 553
DDL SQL Server 2012 datetime 0 0 0 0 0 0 0 0 datetime 554
DDL SQL Server 2012 datetime2 1 7 0 0 7 0 0 0 datetime 555
DDL SQL Server 2012 datetimeoffset 1 7 0 0 7 0 0 0 datetime 556
DDL SQL Server 2012 decimal 2 38 38 38 0 18 0 0 decimal 557
DDL SQL Server 2012 float 0 53 0 0 53 0 0 0 float 558
DDL SQL Server 2012 geography 0 0 0 0 0 0 0 0 text 559
DDL SQL Server 2012 geometry 0 0 0 0 0 0 0 0 text 560
DDL SQL Server 2012 hierarchyid 0 0 0 0 0 0 0 0 text 561
DDL SQL Server 2012 image 0 0 0 0 0 0 0 0 blob 562
DDL SQL Server 2012 int 0 0 0 0 0 0 0 0 integer 563
DDL SQL Server 2012 money 0 0 0 0 0 19 4 0 currency 564
DDL SQL Server 2012 nchar 1 4000 0 0 10 0 0 0 nchar 565
DDL SQL Server 2012 ntext 0 0 0 0 0 0 0 0 ntext 566
DDL SQL Server 2012 numeric 2 38 38 38 0 18 0 0 numeric 567
DDL SQL Server 2012 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 568
DDL SQL Server 2012 nvarchar(max) 0 0 0 0 0 0 0 0 varchar 569
DDL SQL Server 2012 real 0 53 0 0 53 0 0 0 double 570
DDL SQL Server 2012 smalldatetime 0 0 0 0 0 0 0 0 datetime 571
DDL SQL Server 2012 smallint 0 0 0 0 0 0 0 0 smallint 572
DDL SQL Server 2012 smallmoney 0 0 0 0 0 0 0 0 money 573
DDL SQL Server 2012 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 574
DDL SQL Server 2012 text 0 0 0 0 0 0 0 0 text 575
DDL SQL Server 2012 time 1 7 0 0 7 0 0 0 time 576
DDL SQL Server 2012 timestamp 0 0 0 0 0 0 0 0 timestamp 577
DDL SQL Server 2012 tinyint 0 0 0 0 0 0 0 0 tinyint 578
DDL SQL Server 2012 uniqueidentifier 0 0 0 0 0 0 0 0 guid 579
DDL SQL Server 2012 varbinary 1 8000 0 0 50 0 0 0 varbinary 580
DDL SQL Server 2012 varbinary(max) 0 0 0 0 0 0 0 0 varbinary 581
DDL SQL Server 2012 varchar 1 8000 0 0 50 0 0 0 varchar 582
DDL SQL Server 2012 varchar(max) 0 0 0 0 0 0 0 0 varchar 583
DDL SQL Server 2012 xml 0 0 0 0 0 0 0 0 text 584
DDL Oracle MDSYS.ST_GEOMETRY 0 0 0 0 0 0 0 0 geometry 793
DDL Oracle MDSYS.ST_GEOMCOLLECTION 0 0 0 0 0 0 0 0 geometrycollection 794
DDL Oracle MDSYS.ST_POINT 0 0 0 0 0 0 0 0 point 795
DDL Oracle MDSYS.ST_POLYGON 0 0 0 0 0 0 0 0 polygon 796
DDL Oracle MDSYS.ST_LINESTRING 0 0 0 0 0 0 0 0 linestring 797
DDL Oracle MDSYS.ST_MULTILINESTRING 0 0 0 0 0 0 0 0 multilinestring 798
DDL Oracle MDSYS.ST_MULTIPOINT 0 0 0 0 0 0 0 0 multipoint 799
DDL Oracle MDSYS.ST_MULTIPOLYGON 0 0 0 0 0 0 0 0 multipolygon 800
DDL PostgreSQL box2d 0 0 0 0 0 0 0 0 box 801
DDL PostgreSQL box3d 0 0 0 0 0 0 0 0 box3d 802
DDL PostgreSQL geometry 0 0 0 0 0 0 0 0 geometry 803
DDL PostgreSQL geometry(point) 0 0 0 0 0 0 0 0 point 804
DDL PostgreSQL geometry(polygon) 0 0 0 0 0 0 0 0 polygon 805
DDL PostgreSQL geometry(linestring) 0 0 0 0 0 0 0 0 linestring 806
DDL PostgreSQL geometry(geometrycollection) 0 0 0 0 0 0 0 0 geometrycollection 807
DDL PostgreSQL geometry(multipoint) 0 0 0 0 0 0 0 0 multipoint 808
DDL PostgreSQL geometry(multipolygon) 0 0 0 0 0 0 0 0 multipolygon 809
DDL PostgreSQL geometry(multilinestring) 0 0 0 0 0 0 0 0 multilinestring 810
DDL PostgreSQL geometry_dump 0 0 0 0 0 0 0 0 geometry_dump 811
DDL PostgreSQL geography 0 0 0 0 0 0 0 0 geography 812
DDL PostgreSQL geography(point) 0 0 0 0 0 0 0 0 point2 813
DDL PostgreSQL geography(polygon) 0 0 0 0 0 0 0 0 polygon2 814
DDL PostgreSQL geography(linestring) 0 0 0 0 0 0 0 0 linestring2 815
DDL PostgreSQL geography(geometrycollection) 0 0 0 0 0 0 0 0 geometrycollection2 816
DDL PostgreSQL geography(multipoint) 0 0 0 0 0 0 0 0 multipoint2 817
DDL PostgreSQL geography(multipolygon) 0 0 0 0 0 0 0 0 multipolygon2 818
DDL PostgreSQL geography(multilinestring) 0 0 0 0 0 0 0 0 multilinestring2 819
DDL MSAccess GUID 0 0 0 0 0 0 0 0 guid 820
DDL MSAccess 2007 GUID 0 0 0 0 0 0 0 0 guid 821
DDL Sybase ASE varbinary 1 255 0 0 1 0 0 0 varbinary 826
DDL Sybase bigint 0 0 0 0 0 0 0 0 int8 827
DDL Sybase binary 1 32767 0 0 50 0 0 0 binary 828
DDL Sybase bit 0 0 0 0 0 0 0 0 bit 829
DDL Sybase char 1 32767 0 0 10 0 0 0 char 830
DDL Sybase date 0 0 0 0 0 0 0 0 date4 831
DDL Sybase datetime 0 0 0 0 0 0 0 0 datetime8 832
DDL Sybase datetimeoffset 0 0 0 0 0 0 0 0 datetimeoffset 833
DDL Sybase decimal 2 0 127 127 0 30 6 0 decimal 834
DDL Sybase double 0 0 0 0 0 0 0 0 double 835
DDL Sybase float 0 0 0 0 4 0 0 0 float 836
DDL Sybase integer 0 0 0 0 0 0 0 0 int4 837
DDL Sybase image 0 0 0 0 0 0 0 0 long binary 838
DDL Sybase long binary 0 0 0 0 0 0 0 0 long binary 839
DDL Sybase long nvarchar 0 0 0 0 0 0 0 0 longnvarchar 840
DDL Sybase long varbit 0 0 0 0 0 0 0 0 varbit 841
DDL Sybase long varchar 0 0 0 0 0 0 0 0 longvarchar 842
DDL Sybase money 0 0 0 0 0 0 0 0 money 843
DDL Sybase nchar 1 32767 0 0 10 0 0 0 nchar 844
DDL Sybase ntext 0 0 0 0 0 0 0 0 ntext 845
DDL Sybase numeric 2 0 127 127 0 30 6 0 numeric 846
DDL Sybase nvarchar 1 32767 0 0 50 0 0 0 nvarchar 847
DDL Sybase real 0 0 0 0 4 0 0 0 float 848
DDL Sybase smalldatetime 0 0 0 0 0 0 0 0 datetime4 849
DDL Sybase smallint 0 0 0 0 0 0 0 0 int2 850
DDL Sybase smallmoney 0 0 0 0 0 0 0 0 smallmoney 851
DDL Sybase ST_Geometry 0 0 0 0 0 0 0 0 geometry 852
DDL Sybase ST_GeomCollection 0 0 0 0 0 0 0 0 geometrycollection 853
DDL Sybase ST_Point 0 0 0 0 0 0 0 0 point 854
DDL Sybase ST_Polygon 0 0 0 0 0 0 0 0 polygon 855
DDL Sybase ST_LineString 0 0 0 0 0 0 0 0 linestring 856
DDL Sybase ST_MultiLineString 0 0 0 0 0 0 0 0 multilinestring 857
DDL Sybase ST_MultiPoint 0 0 0 0 0 0 0 0 multipoint 858
DDL Sybase ST_MultiPolygon 0 0 0 0 0 0 0 0 multipolygon 859
DDL Sybase text 0 0 0 0 0 0 0 0 text 860
DDL Sybase tinyint 0 0 0 0 0 0 0 0 int1 861
DDL Sybase time 0 0 0 0 0 0 0 0 time 862
DDL Sybase timestamp 0 0 0 0 0 0 0 0 timestamp8 863
DDL Sybase timestamp with time zone 0 0 0 0 0 0 0 0 timestamptz 864
DDL Sybase uniqueidentifier 0 0 0 0 0 0 0 0 uniqueidentifier 865
DDL Sybase uniqueidentifierstr 0 0 0 0 0 0 0 0 uniqueidentifier 866
DDL Sybase varbinary 1 32767 0 0 1 0 0 0 varbinary 867
DDL Sybase varbit 1 32767 0 0 1 0 0 0 varbit 868
DDL Sybase varchar 1 32767 0 0 50 0 0 0 varchar 869
DDL Sybase xml 0 0 0 0 0 0 0 0 xml 870
DDL Firebird smallint 0 0 0 0 0 0 0 0 smallint 871
DDL Firebird integer 0 0 0 0 0 0 0 0 integer 872
DDL Firebird bigint 0 0 0 0 0 0 0 0 bigint 873
DDL Firebird date 0 0 0 0 0 0 0 0 date 874
DDL Firebird time 0 0 0 0 0 0 0 0 time 875
DDL Firebird timestamp 0 0 0 0 0 0 0 0 datetime 876
DDL Firebird double precision 0 0 0 0 0 0 0 0 double 877
DDL Firebird blob sub_type 0 0 0 0 0 0 0 0 0 blob 878
DDL Firebird blob sub_type 1 0 0 0 0 0 0 0 0 text 879
DDL Firebird varchar 1 32767 0 0 50 0 0 0 varchar 880
DDL Firebird char 1 32767 0 0 50 0 0 0 char 881
DDL Firebird decimal 2 0 64 64 0 10 2 0 decimal 882
DDL Firebird numeric 2 0 64 64 0 10 2 0 numeric 883
DDL Firebird float 0 0 0 0 0 0 0 0 float 884
DDL DB2 ST_MULTISURFACE 0 0 0 0 0 0 0 0 multisurface 912
DDL DB2 ST_MULTISURFACE 0 0 0 0 0 0 0 0 multisurface 932
DDL DB2 BLOB 1 2147483647 0 0 1048576 0 0 0 blob 934
DDL DB2 CLOB 1 2147483647 0 0 1048576 0 0 0 clob 935
DDL DB2 DBCLOB 1 1073741823 0 0 1 0 0 0 dbclob 936
DDL DB2 GRAPHIC 1 127 0 0 1 0 0 0 graphic 937
DDL DB2 LONG VARGRAPHIC 0 0 0 0 0 0 0 0 longvargraphic 938
DDL DB2 VARGRAPHIC 1 16336 0 0 1 0 0 0 vargraphic 939
DDL DB2 VARCHAR 1 32672 0 0 10 0 0 0 varchar 940
DDL DB2 XML 0 0 0 0 0 0 0 0 xml 941
DDL DB2 ST_CURVE 0 0 0 0 0 0 0 0 curve 942
DDL DB2 ST_GEOMCOLLECTION 0 0 0 0 0 0 0 0 geometrycollection 943
DDL DB2 ST_GEOMETRY 0 0 0 0 0 0 0 0 geometry 944
DDL DB2 ST_LINESTRING 0 0 0 0 0 0 0 0 linestring 945
DDL DB2 ST_POINT 0 0 0 0 0 0 0 0 point 946
DDL DB2 ST_POLYGON 0 0 0 0 0 0 0 0 polygon 947
DDL DB2 ST_SURFACE 0 0 0 0 0 0 0 0 surface 948
DDL DB2 ST_MULTICURVE 0 0 0 0 0 0 0 0 multicurve 949
DDL DB2 ST_MULTILINESTRING 0 0 0 0 0 0 0 0 multilinestring 950
DDL DB2 ST_MULTIPOINT 0 0 0 0 0 0 0 0 multipoint 951
DDL DB2 ST_MULTIPOLYGON 0 0 0 0 0 0 0 0 multipolygon 952
DDL DB2 ST_MULTISURFACE 0 0 0 0 0 0 0 0 multisurface 953
DDL MSAccess Currency 0 0 0 0 0 0 0 0 currency 954
Diagram_ID Package_ID ParentID Diagram_Type Name Version Author ShowDetails Notes Stereotype AttPub AttPri AttPro Orientation cx cy Scale CreatedDate ModifiedDate HTMLPath ShowForeign ShowBorder ShowPackageContents PDATA Locked ea_guid TPos Swimlanes StyleEx
1 2 0 Logical Class 1.0 Raghav 0 true true true P 787 1138 100 9/1/19 9/1/19 true true true HideRel=0;ShowTags=0;ShowReqs=0;ShowCons=0;OpParams=1;ShowSN=0;ScalePI=0;PPgs.cx=0;PPgs.cy=0;PSize=9;ShowIcons=1;SuppCN=0;HideProps=0;HideParents=0;UseAlias=0;HideAtts=0;HideOps=0;HideStereo=0;HideEStereo=0;ShowRec=1;ShowRes=0;ShowShape=1;FormName=; false {2EDD77FB-17C2-4d5c-A20F-605187CF384A} locked=false;orientation=0;width=0;inbar=false;names=false;color=-1;bold=false;fcol=0;tcol=-1;ofCol=-1;ufCol=-1;hl=1;ufh=0;hh=0;cls=0;bw=0;hli=0; ExcludeRTF=0;DocAll=0;HideQuals=0;AttPkg=1;ShowTests=0;ShowMaint=0;SuppressFOC=1;MatrixActive=0;SwimlanesActive=1;KanbanActive=0;MatrixLineWidth=1;MatrixLineClr=0;MatrixLocked=0;TConnectorNotation=UML 2.1;TExplicitNavigability=0;AdvancedElementProps=1;AdvancedFeatureProps=1;AdvancedConnectorProps=1;m_bElementClassifier=1;SPT=1;MDGDgm=;STBLDgm=;ShowNotes=0;VisibleAttributeDetail=0;ShowOpRetType=1;SuppressBrackets=0;SuppConnectorLabels=0;PrintPageHeadFoot=0;ShowAsList=0;SuppressedCompartments=;Theme=:119;SaveTag=B0D2B6CE;
DiagramID ConnectorID Geometry Style Hidden Path Instance_ID
1 1 SX=0;SY=0;EX=0;EY=0;EDGE=4;$LLB=;LLT=;LMT=;LMB=;LRT=;LRB=;IRHS=;ILHS=; Mode=3;EOID=EF4D6C08;SOID=C8249549;Color=-1;LWidth=0; false 1
1 2 SX=0;SY=0;EX=0;EY=0;EDGE=4;$LLB=;LLT=;LMT=;LMB=;LRT=;LRB=;IRHS=;ILHS=; Mode=3;EOID=C8249549;SOID=8F60D50C;Color=-1;LWidth=0; false 2
1 3 SX=0;SY=0;EX=0;EY=0;EDGE=4;$LLB=;LLT=;LMT=;LMB=;LRT=;LRB=;IRHS=;ILHS=; Mode=3;EOID=C8249549;SOID=BFE351B2;Color=-1;LWidth=0; false 3
Diagram_ID Object_ID RectTop RectLeft RectRight RectBottom Sequence ObjectStyle Instance_ID
1 2 -135 182 272 -255 4 DUID=EF4D6C08; 1
1 3 -147 414 504 -243 3 DUID=C8249549; 2
1 4 -56 661 761 -165 2 DUID=BFE351B2; 3
1 5 -278 666 756 -361 1 DUID=8F60D50C; 4
Diagram_Type Name Package_ID
Activity Activity 1
Analysis Analysis 1
Collaboration Collaboration 1
Component Component 1
CompositeStructure CompositeStructure 1
Custom Custom 1
Deployment Deployment 1
InteractionOverview InteractionOverview 1
Logical Logical View 1
Object Object 1
Package Package 1
Sequence Sequence 1
Statechart Statechart 1
Timing Timing 1
Use Case Use Case View 1
DocID DocName Notes Style ElementID ElementType StrContent BinContent DocType Author Version IsActive Sequence DocDate
ECFID Description Weight Value Notes
ECF01 Familiar with Rational Unified Process 1.5 4.0
ECF02 Application experience 0.5 3.0
ECF03 Object-oriented experience 1.0 4.0
ECF04 Lead analyst capability 0.5 4.0
ECF05 Motivation 1.0 3.0
ECF06 Stable requirements 2.0 4.0
ECF07 Part-time workers -1.0 0.0
ECF08 Difficult programming language -1.0 3.0
EffortType Description NumericWeight Notes
Analysis Analyzing System 1.0 Analysis
Coding Developing code 1.0 Code writing
Construction Design and build system components 1.0 The construction phase is concerned with designing and building the components necessary to implement the system as specified.
Design Designing specifications 1.0 Process of developing system design
Elaboration Refine specification. Set up project 1.0 The elaboration phase is concerned with refining the system specification, setting up project infrastructure and agreeing on the body of work to be completed.
Transition Implementation, acceptance testing 1.0 The Transition phase revolves around the implementation of the project and the acceptance testing carried out by the end user
FileID AppliesTo Category Name File Notes FileDate FileSize
AppliesTo Option
CMACRO _AFX_NO_DEBUG_CRT;_AFX_NO_OCC_SUPPORT;_AFX_OLD_EXCEPTIONS;_AFX_PACKING;_AFXDLL;_DEBUG;_MSC_VER;_UNICODE;AFX_CDECL;AFX_COMDAT;AFX_DATA;AFX_DATADEF;AFX_NOVTABLE;AFXAPI;APICALL;BEGIN_INTERFACE_PART ^ END_INTERFACE_PART;BEGIN_PARAM_MAP ^ END_PARAM_MAP;CONTROLLER_API;DECLARE_DYNAMIC();DECLARE_DYNCREATE();DECLARE_INTERFACE_MAP();DECLARE_MESSAGE_MAP();defined();PASCAL;SWLAPI;WINAPI;
Status
class nKill=0;nLang=1;sLang=Java;bConstructor=1;bConInline=0;sConScope=Public;bCpyConstructor=0;bCpyConInline=0;sCpyConScope=Public;bDestructor=1;bDesVirtual=1;bDesInline=0;sDesScope=Public;CHeader=.h;CBody=.cpp;JBody=.java;VBody=.cls;VBNetBody=.vb;WFSBody=.vbs;JavaScriptBody=.js;ModelicaBody=.mo;MDGBPSimExecutionEngineExtensionBody=;sAssocName=m_$LinkClass;bGetSet=1;bGenInterfaces=1;JCol=Vector;CCol=[];VCol=Collection;bVMultiuse=1;bVPersist=0;bVDatabind=0;bVDatasource=0;bVGlobal=0;bVCreatable=1;bVExposed=0;sMTS=0;sCRefType=*;sCGetPrefix=Get;sCSetPrefix=Set;sJGetPrefix=get;sJSetPrefix=set;sCSGetPrefix=Get;sCSSetPrefix=Set;sVVersion=6.0;CSBody=.cs;DBody=.pas;bJInnerClasses=1;sJCollection=;sCodePage=;sPHPBody=.php;sPHPVersion=;sPHPGetPrefix=get;sPHPSetPrefix=set;ASBody=.as;PyBody=.py;CPPVersion=;ASVersion=2.0;ANSICHeader=.h;ANSICBody=.c;ANSIC_OOSupport=0;ANSIC_NSDLMT=_;ANSIC_RefParam=1;ANSIC_RefStyle=*;ANSIC_RefName=this;ANSIC_ConstructorName=new;ANSIC_DestructorName=delete;CPPCollections=CArray<#TYPE#>�CMap�;CSCollections=List<#TYPE#>�Stack<#TYPE#>�Queue<#TYPE#>�;JCollections=HashSet<#TYPE#>�Map�List<#TYPE#>�;CPPWrappers=unique_ptr<#TYPE#>�shared_ptr<#TYPE#>�weak_ptr<#TYPE#>�;
scenario usesManagedList=0;
Term Type Meaning GlossaryID
Type Template
ImageID Name Type Image
Type
Requirement
UseCase
Component
Issue IssueDate Owner Status Notes Resolver DateResolved Resolution IssueID Category Priority Severity IssueType
ListID Category Name NVal Notes
{1E9843C4-0788-4948-8FCA-EF9E0D9B9369} ConstStatusType Build
{4C61C3E6-B721-41a7-BFB3-699DF50BC4D9} ConstStatusType Validated
{5A276B14-D271-431f-A63C-D76B5572F829} ConstStatusType Proposed
{AC15A9A3-8278-4e4e-AA88-23DF5EA35B43} ConstStatusType Approved
{CD22EDBC-4F15-4b1c-A8D9-EAC780A2CE98} ConstStatusType Mandatory
{FDF9A368-23F8-4730-9637-D43E35628A12} ConstStatusType Implemented
MaintType Description NumericWeight Notes
Object_ID Name Scope Type
Metric Description NumericWeight Notes
Breakage Convergence, rework, software scrap 1.0 Reworked SLOC per change.
Change Change control, stability 1.0 Change requests,
Cost Budget, cost, expenditure 1.0 Cost per day, percentage expended.
Progress Iteration, planning, actuals 1.0 Measures such as function points, SLOC, scenarios, test cases.
Team Staffing, team dynamics 1.0 Resource turnover
Object_ID Object_Type Diagram_ID Name Alias Author Version Note Package_ID Stereotype NType Complexity Effort Style Backcolor BorderStyle BorderWidth Fontcolor Bordercolor CreatedDate ModifiedDate Status Abstract Tagged PDATA1 PDATA2 PDATA3 PDATA4 PDATA5 Concurrency Visibility Persistence Cardinality GenType GenFile Header1 Header2 Phase Scope GenOption GenLinks Classifier ea_guid ParentID RunState Classifier_guid TPos IsRoot IsLeaf IsSpec IsActive StateFlags PackageFlags Multiplicity StyleEx ActionFlags EventFlags
1 Package 0 Class Raghav 1.0 1 0 1 0 -1 0 -1 -1 -1 9/1/19 9/1/19 Proposed 0 0 2 Java 1.0 Public 0 {1B73E244-AC1F-479e-B8F7-0F93D587C87B} 0 false false false false
2 Interface 0 shop Raghav 1.0 2 0 1 0 -1 0 -1 -1 -1 9/1/19 9/1/19 Proposed 1 0 Java 1.0 Public 0 {46663093-A1D2-4866-AE3E-B866E001035B} 0 false false false false
3 Class 0 Payment Raghav 1.0 2 0 1 0 -1 0 -1 -1 -1 9/1/19 9/1/19 Proposed 0 0 Java 0 Java 1.0 Public 0 {304B8A5B-55C4-40b2-86C6-43D135AD5492} 0 false false false false
4 Class 0 Card Raghav 1.0 2 0 1 0 -1 0 -1 -1 -1 9/1/19 9/1/19 Proposed 0 0 Java 0 Java 1.0 Public 0 {EB7E065E-2F88-421b-B925-14549DA75A1C} 0 false false false false
5 Class 0 Cash Raghav 1.0 2 0 1 0 -1 0 -1 -1 -1 9/1/19 9/1/19 Proposed 0 0 Java 0 Java 1.0 Public 0 {F755F22A-74A6-4b15-9B1D-121F1C9131E4} 0 false false false false
Object_ID Constraint ConstraintType Weight Notes Status
Object_ID Effort EffortType EValue Notes
Object_ID FileName Type Note FileSize FileDate
Object_ID Metric MetricType EValue Notes
Object_ID Problem ProblemType DateReported Status ProblemNotes ReportedBy ResolvedBy DateResolved Version ResolverNotes Priority Severity
PropertyID Object_ID Property Value Notes ea_guid
ReqID Object_ID Requirement ReqType Status Notes Stability Difficulty Priority LastUpdate
Object_ID Resource Role Time Notes PercentComplete DateStart DateEnd History ExpectedHours ActualHours
Object_ID Risk RiskType EValue Notes
Object_ID Scenario ScenarioType EValue Notes XMLContent ea_guid
Object_ID Test TestClass TestType Notes InputData AcceptanceCriteria Status DateRun Results RunBy CheckBy
Object_ID TRX TRXType Weight Notes
Object_Type Description DesignObject ImageID
Action Action true 8
ActionPin ActionPin true 8
Activity Activity false 21
ActivityParameter ActivityParameter true 8
ActivityPartition ActivityPartition true 8
ActivityRegion ActivityRegion true 8
Actor Actor false 6
Artifact UML Artifact true 8
Association Association false 0
Boundary Boundary false 0
CentralBufferNode CentralBufferNode true 8
Change Change true 19
Class Class true 5
Collaboration Collaboration false 7
CollaborationOccurrence CollaborationOccurrence true 8
Comment Comment true 8
Component Component true 10
ConditionalNode ConditionalNode true 8
Constraint Constraint true 8
DataStore DataStore true 8
DataType DataType true 8
Decision Decision false 0
DeploymentSpecification DeploymentSpecification true 8
Device Device true 8
DiagramFrame DiagramFrame true 8
Entity Entity false 5
EntryPoint UML Entry Point true 8
Enumeration Enumeration true 8
Event Event false 0
ExceptionHandler ExceptionHandler true 8
ExecutionEnvironment ExecutionEnvironment true 8
ExitPoint UML Exit Point true 8
ExpansionNode UML Expansion Node true 8
ExpansionRegion ExpansionRegion true 8
Feature Feature true 8
GUIElement User interface object true 16
InformationItem InformationItem true 8
Interaction Interaction true 8
InteractionFragment InteractionFragment true 8
InteractionOccurrence InteractionOccurrence true 8
InteractionState InteractionState true 8
Interface Interface false 8
InterruptibleActivityRegion InterruptibleActivityRegion true 8
Issue Issue true 19
Label Label false 0
LoopNode LoopNode true 8
MergeNode MergeNode true 8
MessageEndpoint MessageEndpoint true 8
Node Node true 9
Note Note false 0
Object Object false 5
ObjectNode ObjectNode true 8
Package Package true 4
Parameter UML Activity Parameter true 8
Part Part true 8
Port UML Port true 8
PrimitiveType PrimitiveType true 8
ProtocolStateMachine ProtocolStateMachine true 8
ProvidedInterface ProvidedInterface true 8
Region Region true 8
Report System report true 17
RequiredInterface RequiredInterface true 8
Requirement Requirement true 19
Risk Risk true 8
Screen Interface Screen true 11
Sequence Sequence false 0
Signal Signal true 8
State State Chart Object true 20
StateMachine StateMachine true 8
StateNode Start End State false 59
Synchronization Synchronization false 0
Task Task true 8
Text Text false 0
TimeLine TimeLine true 8
Trigger Trigger true 8
UMLDiagram UML Diagram true 8
UseCase UseCase false 7
User User false 0
Defect Defect true 8
Test Test true 8
ObjectType ComplexityWeight
Actor 1.0
UseCase 5.0
OperationID Object_ID Name Scope Type ReturnArray Stereotype IsStatic Concurrency Notes Behaviour Abstract GenOption Synchronized Pos Const Style Pure Throws Classifier Code IsRoot IsLeaf IsQuery StateFlags ea_guid StyleEx
1 2 pay Public void Sequential 0 false false false false {A3342EDB-2A25-4120-9370-EA763B40B215}
2 2 sale Public void Sequential 1 false false false false {DD403925-037B-4a5c-AD80-BC805411F16F}
3 3 pay Public void Sequential 0 false false false false {C5E043C8-ABB0-4bbb-9179-57BF9240222F}
4 3 sale Public void Sequential 1 false false false false {AFAA8FF7-4BD5-4de2-A144-C1A48928AC49}
5 5 pay Public void Sequential 0 false false false false {C5F635B1-266C-45d4-AC14-F5997B5A3C31}
6 5 sale Public void Sequential 1 false false false false {542C5F92-D087-41b8-B27C-5E90F82F319F}
7 4 pay Public void Sequential 0 false false false false {516539E5-F98F-425b-BE64-C4ACE3315C7D}
8 4 sale Public void Sequential 1 false false false false {35E00FBE-A17D-416a-8688-11C3A014A4BA}
OperationID Name Type Default Notes Pos Const Style Kind Classifier ea_guid StyleEx
OperationID PostCondition Type Notes
OperationID PreCondition Type Notes
PropertyID ElementID Property VALUE NOTES ea_guid
1 3 Implements shop.pay Qualified name for the interface operation {62736FEA-BDB2-46b2-8FB1-1BFD31F186C5}
2 3 ImplementsGuid {A3342EDB-2A25-4120-9370-EA763B40B215} Identifies the interface operation {9B6C1F50-3F1D-4b64-8728-9B2D3CD8D17C}
3 4 Implements shop.sale Qualified name for the interface operation {82AEB736-C86A-4c18-AA71-828F7E7349C2}
4 4 ImplementsGuid {DD403925-037B-4a5c-AD80-BC805411F16F} Identifies the interface operation {67CD0257-DC44-40b2-824B-9D080284924C}
5 5 Implements shop.pay Qualified name for the interface operation {62736FEA-BDB2-46b2-B9EE-B8DD4963CE0D}
6 5 ImplementsGuid {A3342EDB-2A25-4120-9370-EA763B40B215} Identifies the interface operation {9B6C1F50-3F1D-4b64-9C47-D2F377747E5D}
7 6 Implements shop.sale Qualified name for the interface operation {82AEB736-C86A-4c18-88D6-13884147C9C5}
8 6 ImplementsGuid {DD403925-037B-4a5c-AD80-BC805411F16F} Identifies the interface operation {67CD0257-DC44-40b2-8FED-E8D95B4D8580}
9 7 Implements shop.pay Qualified name for the interface operation {62736FEA-BDB2-46b2-BEC9-4B878CA09EF6}
10 7 ImplementsGuid {A3342EDB-2A25-4120-9370-EA763B40B215} Identifies the interface operation {9B6C1F50-3F1D-4b64-BF1F-52DE6C9835BC}
11 8 Implements shop.sale Qualified name for the interface operation {82AEB736-C86A-4c18-9E58-865FE52E0A04}
12 8 ImplementsGuid {DD403925-037B-4a5c-AD80-BC805411F16F} Identifies the interface operation {67CD0257-DC44-40b2-8943-822B1DB4F2FB}
Package_ID Name Parent_ID CreatedDate ModifiedDate Notes ea_guid XMLPath IsControlled LastLoadDate LastSaveDate Version Protected PkgOwner UMLVersion UseDTD LogXML CodePath Namespace TPos PackageFlags BatchSave BatchLoad
1 Model 0 4/17/12 4/17/12 {816F9AFD-8B0F-4605-895F-00BC305D4E13} false false false false
2 Class 1 9/1/19 9/1/19 {1B73E244-AC1F-479e-B8F7-0F93D587C87B} false 1.0 false false false isModel=1;VICON=3;
PaletteID Name Type
PaletteID ItemID
PhaseID PhaseName PhaseNotes PhaseStyle StartDate EndDate PhaseContent
Datatype Description
boolean true/false
char character
double double
int integer
long long number
string character string
xml XML Data
ProblemType Description NumericWeight Notes
HW Hardware related 1.0
Network Network problems 1.0 Network issues
Perform Performance 1.5 Performance related problems
SW Software 2.0 Software related issues
User User caused problem 1.0 Problems caused by user
Role Description Notes
Application Analyst Define and model the application structure
Business Analyst Model business processes
C++ Programmer Programming in Visual C++
Developer Application development
Java Programmer Java programming
Project Manager Manage schedule Manage the project schedule
Solution Architect Lead Technical and Project Architect Define and communicate application architecture
Use Case Modeller Use Case modelling
VB Programmer Visual Basic Programming
Property Description Notes
Requirement Description NumericWeight Notes
Display System will display in a specified format 1.0 Information will be displayed in a particular way
Functional Functional Requirement 1.0 Comments here
Performance Performance based requirement 1.0 The system must meet some performance criteria
Printing System printing requirement 1.0 The system will allow the user(s) to print out some artifact as required by the specification.
Report The system will roduce a report 1.0 The system will have the facility to produce a report as required
Testing Testing requirement 1.6 Testing requirement
Validate Validate a particular rule 1.0 The system will validate a specific rule as supplied in the business requirements
Name Organisation Phone1 Phone2 Mobile Fax Email Roles Notes
Risk Description NumericWeight Notes
ConnectorID Constraint ConnectorEnd ConstraintType Notes
Type Template
TemplateID RootPackage Filename Details ProcessChildren ShowDiagrams Heading Requirements Associations Scenarios ChildDiagrams Attributes Methods ImageType Paging Intro Resources Constraints Tagged ShowTag ShowAlias PDATA1 PDATA2 PDATA3 PDATA4
RuleID RuleName RuleType RuleActive ErrorMsg Flags RuleOCL Notes RuleXML
ScenarioType Description NumericWeight Notes
Alternate Alternate pathway 1.0 Path of execution that includes exceptional conditions.
Basic Path Basic execution path 1.0 The standard execution path with no exceptions
Simple Standard scenario 1.0 Used to describe ordinary usage
ScriptID ScriptCategory ScriptName ScriptAuthor Notes Script
GroupID GroupName Description
GroupID PermissionID
UserID GroupID EntityType EntityID Timestamp LockType
PermissionID PermissionName
Property Value
UserID UserLogin FirstName Surname Department Password
UserID GroupID
UserID PermissionID
SnapshotID SeriesID Position SnapshotName Notes Style ElementID ElementType StrContent BinContent1 BinContent2
Status Description
Approved Item is approved
Implemented Finished
Mandatory Required
Proposed Item has been proposed
Validated Approved and Checked
Stereotype AppliesTo Description MFEnabled MFPath Metafile Style ea_guid VisualType
process activity A classifier whose instances represent a flow false {B4DA5868-0565-4475-A05B-B8E79B52F184}
subscribe association Source class will be notified when an event occurs in target false {A7CCCE6C-5E11-4aed-83A5-D729B75DE5D8}
column AttribTable A column attribute for a table false {7E6C36A1-E4E0-4b1d-8789-C1E3227BF7D5}
case worker business class A worker who directly interacts with actors outside the system false {DD4995B3-5281-4abe-90EB-FCDE865F314B}
entity business class Passive class accessed and manipulated by workers false {6223D48B-FECC-4d23-BAD2-26306BE7ED21}
internal worker business class A worker that interacts with other workers and entities inside the system. false {9E73C30C-8A9D-4731-8905-641BBC803D86}
worker business class An abstraction of a human that works within the system. false {B91412D3-1E73-45d4-B3CB-7B259F909F26}
object system business model Contains business process objects, work units, organization units and relationships false {47B9826A-441D-40be-945B-D63AB2F50A76}
organization unit business model Subsystem corresponding to an organizational unit of the actual business false {707A91A2-24B8-4d1e-8C32-182B7AC8F1AA}
work unit business model Subsystem with one or more entities false {DC83A5EF-EDBB-4592-AED4-105328A142A8}
asp page class A Microsoft active server page false {97C3341B-A6AF-44dd-B14E-074A28B0C000}
boundary class Specifies an element that is at the system boundary (e.g.. User Interface) false {2176DC37-E14F-4b31-B372-2668EB9CDF07}
client page class A class that represents a client based web page false {E3965DD9-DEA7-4a50-B1AA-47701A0AE274}
clientscript class A collection of client-side scripts false {02E79968-B79B-4498-9D08-C57FACAEEB29}
control class Specifies an element that controls the work and lifetimes of other objects false {AB0FE133-07BE-4e8c-A748-6E83DAC021AB}
entity class Specifies a persistent element mainly concerned with managing its own state false {AB60ABAC-0E69-49b3-A163-706C8294F020}
enumeration class Specifies an enumerated type false {97EE0E53-9120-4bc6-9AA2-752D20CB2FAE}
exception class An event may be thrown or caught by operation false {9C078B5C-8A56-4d1c-8E0F-BB61E61C735A}
form class A class that represents a html form false {6D04D7C0-5C21-4eaf-B9F3-B8E2D6ED22F7}
frameset class A class that represents a html frame set false {84629C7C-AB91-4227-8596-EF0FCDA23A8F}
implementationClass class Implementation of a class in some programming language false {593E1E62-5E16-48f4-9952-9B573782A2B1}
interface class A collection of operations that specify a service of a class or component false {0297A65C-34BA-4c80-AB93-DA80FAD4D4F8}
jsp page class A java server page false {E9A9D1AD-B4A7-4d48-9726-9A5934648C83}
model document class Set a class as an RTF "Model Document" false Fill=-1;Border=-1;Font=-1; {CAD0F2AC-8D6C-40f9-BF0D-0AD9F973CAEC}
powertype class A classifier whose objects are all children of a given parent false {53812FDC-3AFF-481a-9EE0-1B800A8427C3}
process class A classifier whose instances represent a flow false {522326F2-8828-4fee-AA29-3FBA178CB878}
script library class A library of subroutines/functions for web pages false {05CBD732-E54D-4dde-BB56-7DCD95B71B1F}
server page class A class that represents a server based web page false {3125E8C8-8DDB-4feb-971A-3DC690638EA4}
servlet class A java servlet component false {BDE2C10B-41C1-4369-B8BB-EB29B4B4A178}
signal class Specifies an asynchronous stimulus communicated amongst instances false {39A8130E-C4A4-4a06-8DAF-275F3D1D5A6F}
stereotype class The classifier is a stereotype that may be applied to other elements false {FD019F8F-7422-4b73-8426-7222A284EA59}
table class A class that represents a database table false {53760251-780B-4178-95D7-F177FDC67D0E}
target class A class that represents a target false {6E2B576A-97D9-4a78-9B42-AA0CE869AE31}
thread class A classifier whose instances represent a lightweight flow of control false {174D95AA-4243-4bcd-AF14-7B677595B39B}
type class An abstract class specifying the structure but not implementation of a set of objects false {A319995C-8F19-4d38-B068-485C981167E0}
utility class A class whose attributes and operations are all class-scoped false {3EF1BA80-9175-4bbd-9256-AE771479A0D3}
web page class A html web page false {AD620798-2BA9-4d07-ACB0-727E364E2593}
metaclass classifier A classifier whose objects are all classes false {BF1A05C3-FF80-4bd8-85C3-F3E5867BCCB8}
requirement comment Specifies a desired feature, property or behavior of system false {E71C71D5-5E49-407a-802D-82E297F2488E}
responsibility comment Specifies a contract by or an obligation of a class false {F2AFB850-DC2B-4bff-B1A2-B03093254F7C}
document component The component represents a document false {3BB789FD-6E41-4844-9BDD-894903196DCA}
executable component A component may be executed on a node false {23310F29-A3C0-4cea-8937-5FE19832055F}
file component Component represents a document containing source code false {042E91C8-5CD8-4320-BA72-F3E1D444AAC0}
library component Static or dynamic object library false {E9014E64-137C-4a80-BD30-F5A0C73AC3C5}
table component A component that represents a database table false {A632696D-CE77-4ae0-84B3-4D9B3DBFE52D}
invariant constraint Constrain must always hold for associated element false {7720139C-656B-4a12-B349-F26C9FD473A5}
postcondition constraint A constraint must hold after the invocation of an element false {B5ECEBC3-3670-4000-93BE-A2AEEA7D1EA4}
precondition constraint A constraint that must hold before an element is invoked false {504127F7-E4EE-4a5c-BEDC-8408A8D8DE69}
access dependency Public contents of target are accessible to namespace of source false {8D6BD2B7-F0AF-4654-80B7-1E636CB3F7F2}
bind dependency Source instantiates target template using given parameters false {E464BC61-C325-400f-B8B8-ADC07AF8A387}
call dependency Source invokes the target false {0EBF29FC-6D77-4582-AA25-590ED7D2C944}
derive dependency Source may be computed from target false {AFF5D7CD-7CA1-43ff-AEB1-27C2A29B513E}
friend dependency Source is given special visibility of target false {85A27B46-52E3-4f66-ABD7-7C4ECA5A5477}
import dependency Public contents of target are imported into source namespace false {4DD3F35E-EA37-403a-A7FD-CDBD8320EB92}
instanceOf dependency The source object is an instance of the target false {3C5AA069-9516-4c98-917F-0B1354208FA4}
instantiate dependency Operations on the source class create instances of the target class false {BEF8A2C7-70EB-4415-BF49-35C6865C76FE}
powertype dependency A classifier whose objects are all children of a given parent false {588DD245-69BD-40d6-A2E1-9C704592C22F}
refine dependency Source is at a finer degree of abstraction than source false {C4B3904E-B078-44a9-B04E-FC170C59BD4D}
send dependency The source sends the target an event false {837FA615-0217-4514-9D03-E8267052DD80}
trace dependency The target is an historical ancestor of source false {91B3FA28-60EF-46cc-BFFD-78CD6ECFACEC}
use dependency The semantics of the source depend on the public part of the target false {B2F050F9-6CCD-499d-A396-B5658AF59CE2}
implementation generalization Child inherits implementation of parent but does not support its interfaces false {2D6D1F54-4955-4d02-BB4D-FDEE6DEDF831}
button GUIElement A button GUI element false {B13A4F7B-94A5-471b-9F18-780C83AA5651}
checkbox GUIElement A checkbox GUI element false {110868B1-BFF5-4c21-AD7E-7BDCD566478F}
combobox GUIElement A combo box GUI element false {201F9C4F-AAD2-4125-AE14-5E64EBF860ED}
date GUIElement A GUI element for date entry false {D1E058BD-9F72-4f0b-A9C1-2FDD59E4239B}
dialog GUIElement A GUI screen false {02C8F1CE-2B88-4931-A3E2-50F53B7615EC}
dropdown GUIElement A GUI element that forces user selection false {ACF0FD2E-EBE9-4462-A353-0BB844D35775}
form GUIElement A GUI screen false {8EED8E75-44C2-4a34-A5CC-95C45F072856}
hline GUIElement false Fill=-1;Border=-1;Font=-1; {46D22169-C4B4-4dc1-9FDD-76F59228A67A}
list GUIElement A List of Information false {ACC05246-8C88-47aa-A32A-A8188195312E}
listview GUIElement A stand list view control false {0A759BCE-57D9-4e52-AF2B-B6CD3D516147}
panel GUIElement A GUI element for grouping other controls false {23A49C7B-658B-4606-B8E2-0098D9B20AA2}
radio GUIElement A radio button GUI element false {28A5A2D4-F4CD-400e-9B21-4DC9ABD32A71}
report GUIElement A List of Information with an expandable text field false {EA87EA3B-8A0A-44cd-BCE1-F6E6E2D168B0}
tab GUIElement A tab control GUI element false {7D575BF8-5DB4-4506-BAF9-B7645C323AB1}
textbox GUIElement A GUI element for user text entry false {FC736290-22D8-4ac2-B5F5-B6876D30589F}
time GUIElement A GUI element for time entry false {5A661842-0178-4530-83AF-83B4D6E5B2D2}
treelist GUIElement A List of Information with a tree structure false {E9E742A1-0C88-489d-8DAE-74593F41C6F7}
vline GUIElement false Fill=-1;Border=-1;Font=-1; {6E763C07-A9E4-45f1-AD74-B2DF7088EA02}
global link end Corresponding object is visible because of enclosing scope false {73374F30-BA20-40c4-8A4A-6D9D8D4E6A51}
local link end The corresponding object is visible in local scope false {63D6C14F-AF9B-40a0-A78B-7A4A5A4EFB02}
parameter link end The corresponding element is visible because it is a parameter false {337A1A6B-C3C8-4ce8-9D09-D71E864F99DE}
self link end The corresponding object is visible because it is the dispatcher false {05289024-4F66-4275-A346-2B9BF42939B8}
become message Target is same as source but later in time false {20951BD5-AB8C-48a2-A122-6324BF5002D2}
copy message Target is exact but independent copy of source false {7625DA7B-1894-4c3a-A22B-E83D28AA5258}
create message Target is created by event or message false {98981DF6-97C9-418a-BA00-925343A14B1A}
destroy message Target is destroyed by event or message false {379AAA43-B7B1-4efe-A22D-88E9C3987147}
analysis system model Contains analysis classes - entities, boundaries and control elements false {4C35B6BC-2000-4721-AC55-4FB177782F98}
design system model Contains design elements false {B6BA6457-126D-4d47-81FE-A33D0E6C8A26}
implementation system model Contains implementation subsystems and/or components and relationships false {EDF0565A-F1FC-4a40-A0CF-0A8D0DB7BBE1}
use case system model Specifies the services offered to the users false {BDE2BD55-02F0-44ee-BA08-D758D5402E96}
cdrom node A class that represents a CDRom drive false {C0CB5400-139A-4702-B57B-7C6068455334}
cd-rom node A class that represents a CDRom drive false {03D6465B-CAB3-43d7-8348-7983B846A6E3}
computer node A class that represents a computer false {0C18E934-D830-4724-B67A-6ACB82DA953C}
disk array node A class that represents a disk array false {D90A49D8-A366-4368-A888-F9FF40F7F831}
pc node A class that represents a personal computer false {CE22907A-B7A7-4122-A2EE-26783F193C8E}
pc client node A class that represents a clients PC false {4E2B9643-E056-43fa-A2F2-B89CE303F9C6}
pc server node A class that represents a PC server false {C19F74E8-95A4-448f-B079-9FF86F5FBBD5}
secure node A class that represents aet false {80BC3CF4-B261-4761-8823-0F69CE9A6E68}
server node A class that represents a server false {DEB98B88-E78D-4d63-8366-C58BD308DC5B}
storage node A class that represents a storage device false {4A614A50-A849-4c20-BDD9-24B0F1E3ACE1}
unix server node A class that represents a Unix server false {7030A63B-895C-43eb-9E7A-132405157402}
user pc node A class that represents a users PC false {40975D2C-6497-4be3-85AA-5F7AF6ECC128}
check OpTable A Check constraint to enforce domain integrity false {8F0AE685-4215-428e-9AE4-E69171032912}
FK OpTable A Foreign Key false {27D91946-3DAF-43f5-9226-EB8D404D4ED5}
index OpTable An index of one or more columns false {48CB0A57-6D9E-4908-8EEE-FBECC4F2CFDE}
PK OpTable A Primary Key false {A6627F37-1EE8-4dba-8FC4-0C2241C25F8D}
proc OpTable A stored procedure false {32750AD8-09B7-4a7c-B799-1181409A69FF}
trigger OpTable A trigger which executes automatically when an UPDATE, INSERT, or DELETE statement is issued false {E31D7D1B-5C82-406a-A673-4066AC0AC7F9}
unique OpTable A Unique constraint to enforce the integrity of a database automatically false {805F2635-1F44-4403-B8A6-ED30361B1F05}
facade package Package is a view of another concrete package false {E570AA6F-E329-4eaf-8196-28DFAFF9AB75}
framework package Package consists mainly of patterns false {1C81BEDC-A9B1-42a0-82AE-93780B109D1E}
model package A semantically closed abstraction of a system false {F2569D9D-EB37-4385-A2B5-4E991DBB2995}
stub package A package serves as a proxy for the public contents of another package false {F40EF2F5-A1AA-49f6-A648-47B60562D2F0}
subsystem package A grouping of elements that constitute a specification of behavior offered by other contained elements false {C221469F-9508-4105-8D7E-788038A08107}
system package A package representing the entire system being modeled false {BB485A4A-6D98-4528-9436-77772C4535E6}
communicate uses Communication between actor and use case false {9F9C15EF-4723-4e3f-ACE6-4E6028665F2F}
extend uses Target use case extends the source at a given extension point false {2D8D8B96-A5C4-4bbb-8F47-8E636E44EECC}
include uses Source use case explicitly includes the behavior of target false {A52CF199-DC05-46da-83D8-5FB1AAAC9AE2}
PropertyID ElementID BaseClass TagValue Notes
TaskID Name TaskType NOTES Priority Status Owner StartDate EndDate Phase History Percent TotalTime ActualTime AssignedTo
TCFID Description Weight Value Notes
TCF01 Distributed System 2.0 5.0
TCF02 Response or throughput performance objectives 1.0 4.0
TCF03 End user efficiency (online) 1.0 2.0
TCF04 Complex internal processing 1.0 4.0
TCF05 Code must be re-usable 1.0 2.0
TCF06 Easy to install 0.5 5.0
TCF07 Easy to use 0.5 3.0
TCF08 Portable 2.0 3.0
TCF09 Easy to change 1.0 3.0
TCF10 Concurrent 1.0 2.0
TCF11 Includ special security features 1.0 2.0
TCF12 Provide direct access for third parties 1.0 5.0
TCF13 Special user training faciities are required 1.0 3.0
TemplateID TemplateType TemplateName Notes Style Template
TestClass Description
PlanID Category Name Author Notes TestPlan
TestType Description NumericWeight Notes
Load Performance under load 1.0 Stress testing
Regression Regression Testing 1.0 Regression
Standard Simple Test procedure 1.0 Used to test basic path
Description NumericWeight Notes TRX TRX_ID Style
PatternID PatternCategory PatternName Style Notes PatternXML Version
ElementID VersionID ElementType Flags ExternalFile Notes Owner VersionDate Branch ElementXML
XrefID Name Type Visibility Namespace Requirement Constraint Behavior Partition Description Client Supplier Link
XrefID ToolID Name Type Visibility Namespace Requirement Constraint Behavior Partition Description Client Supplier Link
{6E5FED3A-DF6C-40db-BEEC-4528AB8C8A2E} Model Views PView 8 0 ModelRoot NULL
XrefID ToolID Name Type Visibility Namespace Requirement Constraint Behavior Partition Description Client Supplier Link
Property Value
310_Category 1
310_Columns 1
310_FileTable 1
310_Generalization 1
310_Images 1
310_Metafile 2
310_Palette 1
310_QObject 1
310_TableList 1
310_TableList2 1
310_Tasks 1
310_XREF 1
350_AttGUID 1
350_DataTypes 1
350_DiagramConnectorID 1
350_DiagramObjectID 1
350_DocumentEX 1
350_FeaturePos 1
350_Flags 1
350_IssueEx 1
350_OpGUID 1
350_Package 1
350_ParamGUID 1
350_Phases 1
350_ResourceHours 1
350_ResourceTables 1
350_RoleExtra 1
350_Scenario 1
350_Snapshot 1
350_Stereotype 1
350_Styles 1
350_SystemTaggedValues 1
350_TableList 1
350_TableListEx 1
350_Tables 1
350_TestTables 1
350_TRXTypes 1
350_UserSecurity 1
Association 1
AttID 1
CheckObjectTypes 1
Classifier 1
ClassifierGUID 1
CodeGen 1
Const 1
DDL 1
DiagramLink 1
DiagramObjectStyle 1
EA1000Updates 1
EA300Classifier 1
EA300MSAccessDT 1
EA300VBDT 1
EA3FieldSizes 3
EA3TableNames 1
EA600Updates 1
EA610Updates 1
EA650Updates 1
EA800Updates 1
EA900Updates 1
EAGUID 1
Elem300 1
FileDir $EAPDIR
Gen25Fixes 1
GenericDataType 1
GUID 2
IsNavigable 1
LangDT25 1
LastUpdate 3B58F782F406:123456789012
Namespace 1
NodeStereo 1
ObjectParent 1
ObjectScope 1
OperationCode 1
OpPos 1
OpsClean 1
Orphans30 1
PackageControl 3
Packages 1
ParamIDX 1
QDF_25 1
QueryDefs_116 1
RoleConstraints 1
RTFFIELDS 1
RunState 1
Seq_Gap 35
Stereotypes 1
Styles 1
TaggedVals 1
TPos 2
Version 4.01
VersionDate Jan-31-2004
WebStereo 1
ProjectGUID {9F9683FB-1A69-4da6-B58D-6CD2E144C812}
EA1310Updates 1
TableName NewName RelOrder FixCode
TRXTypes t_trxtypes 1 true
TestTypes t_testtypes 1 true
TestClass t_testclass 1 true
TCF t_tcf 1 true
Stereotypes t_stereotypes 1 true
StatusTypes t_statustypes 1 true
ScenarioTypes t_scenariotypes 1 true
RTFReport t_rtfreport 1 true
RTF t_rtf 1 true
RoleConstraint t_roleconstraint true
RiskTypes t_risktypes 1 true
Resources t_resources 1 true
RequireTypes t_requiretypes 1 true
PropertyTypes t_propertytypes 1 true
ProjectRoles t_projectroles 1 true
ProblemTypes t_problemtypes 1 true
Primitives t_primitives 1 true
Package t_package 1 false
OperationPres t_operationpres 6 true
OperationPosts t_operationposts 6 true
OperationParams t_operationparams 6 true
Operation t_operation 5 false
OCF t_ocf 1 true
ObjectTRX t_objecttrx 5 true
ObjectTests t_objecttests 5 true
ObjectScenarios t_objectscenarios 5 true
ObjectRisks t_objectrisks 5 true
ObjectResource t_objectresource 5 true
ObjectRequires t_objectrequires 5 true
ObjectProperties t_objectproperties 5 true
ObjectProblems t_objectproblems 5 true
ObjectMetrics t_objectmetrics 5 true
ObjectFiles t_objectfiles 5 true
ObjectEffort t_objecteffort 5 true
ObjectConstraint t_objectconstraint 5 true
Object_Types t_objecttypes 5 true
Object t_object 3 true
MetricTypes t_metrictypes 1 true
Method t_method 5 true
MaintTypes t_mainttypes 1 true
Implement t_implement 2 true
HTML t_html 1 true
Glossary t_glossary 2 true
EffortTypes t_efforttypes 1 true
ECF t_ecf 1 true
DiagramTypes t_diagramtypes 1 true
DiagramObjects t_diagramobjects 6 true
Diagram t_diagram 5 true
ConstraintTypes t_constrainttypes 1 true
Constants t_constants 1 true
ConnectorConstraint t_connectorconstraint 7 true
Connector_Types t_connectortypes 1 true
Connector t_connector 6 true
ComplexityTypes t_complexitytypes 1 true
Clients t_clients 1 true
Cardinality t_cardinality 1 true
Authors t_authors 1 true
AttributeConstraints t_attributeconstraints 7 true
Attribute t_attribute 6 true
t_issues 6 true
UpdateFlag_Indexes1220 UpdateFlag_Indexes1220 10 true
QueryName NewName FixCode
qAttribute q_attribute true
qConnections q_connections true
qConnections2 q_connections2 true
qConnections3 q_connections3 true
qConnector q_connector true
qDatatypes q_datatypes true
qECF q_ecf true
qImplements q_implements true
qImplements2 q_implements2 true
qMethod q_method true
qObject q_object true
qObjectRealizes q_objectrealizes true
qObjectTests q_objecttests true
qOrphans q_orphans true
qPackages q_packages true
qRealizes1 q_realizes1 true
qRealizes2 q_realizes2 true
qResource q_resource true
qSumECF q_sumecf true
qSumTCF q_sumtcf true
qTCF q_tcf true
qUCMetrics q_ucmetrics true
qVisibleObject q_visibleobject true
TableName RelOrder DisplayName FromVer ToVer
t_attribute 6 Object Attributes 1.1.0 9.9.9
t_attributeconstraints 7 Attribute Constraints 1.1.0 9.9.9
t_attributetag 7 Attribute Tag 3.0.0 9.9.9
t_authors 1 Project Authors 1.1.0 9.9.9
t_cardinality 1 Object Cardinality 1.1.0 9.9.9
t_category 1 Category 3.5.0 9.9.9
t_clients 1 Project Clients 1.1.0 9.9.9
t_complexitytypes 1 Complexity Types 1.1.0 9.9.9
t_connector 6 Connectors 1.1.0 9.9.9
t_connectorconstraint 7 Connector Constraints 1.1.0 9.9.9
t_connectortag 7 Connector Tag 3.0.0 9.9.9
t_connectortypes 1 Connector Types 3.5.0 9.9.9
t_constants 1 Constants 1.1.0 9.9.9
t_constrainttypes 1 Constraint Types 1.1.0 9.9.9
t_datatypes 1 Data Types 1.1.0 9.9.9
t_diagram 5 Diagrams 1.1.0 9.9.9
t_diagramlinks 6 Diagram Links 1.1.0 9.9.9
t_diagramobjects 6 Diagram Objects 1.1.0 9.9.9
t_diagramtypes 2 Diagram Types 1.1.0 9.9.9
t_document 7 Document 3.5.0 9.9.9
t_ecf 1 ECF Values 1.1.0 9.9.9
t_efforttypes 1 Effort Types 1.1.0 9.9.9
t_files 7 Files 3.5.0 9.9.9
t_genopt 1 Generation Options 1.1.0 9.9.9
t_glossary 2 Glossary 1.1.0 9.9.9
t_html 7 HTML 3.5.0 9.9.9
t_image 7 Images 3.1.0 9.9.9
t_implement 2 Implementation Details 1.1.0 9.9.9
t_issues 6 Issue Details 1.1.0 9.9.9
t_lists 1 Lists 3.5.0 9.9.9
t_mainttypes 1 Maintenance Types 1.1.0 9.9.9
t_method 5 Methods 1.1.0 9.9.9
t_metrictypes 1 Metric Types 1.1.0 9.9.9
t_object 3 Object Details 1.1.0 9.9.9
t_objectconstraint 5 Object Constraints 1.1.0 9.9.9
t_objecteffort 5 Object Effort 1.1.0 9.9.9
t_objectfiles 5 Object Files 1.1.0 9.9.9
t_objectmetrics 5 Object Metrics 1.1.0 9.9.9
t_objectproblems 5 Object Problems 1.1.0 9.9.9
t_objectproperties 5 Object Properties 1.1.0 9.9.9
t_objectrequires 5 Object Requires 1.1.0 9.9.9
t_objectresource 5 Object Resources 1.1.0 9.9.9
t_objectrisks 5 Object Risks 1.1.0 9.9.9
t_objectscenarios 5 Object Scenarios 1.1.0 9.9.9
t_objecttests 5 Object Tests 1.1.0 9.9.9
t_objecttrx 5 Object TRX 1.1.0 9.9.9
t_objecttypes 1 Object Types 3.5.0 9.9.9
t_ocf 1 OCF Values 1.1.0 9.9.9
t_operation 5 Operations 1.1.0 9.9.9
t_operationparams 6 Operation Parameters 1.1.0 9.9.9
t_operationposts 6 Operation Post Conditions 1.1.0 9.9.9
t_operationpres 6 Operation Pre Conditions 1.1.0 9.9.9
t_operationtag 7 Operation Tag 3.0.0 9.9.9
t_package 1 Packages 1.1.0 9.9.9
t_palette 5 Palettes 3.1.0 9.9.9
t_paletteitem 7 Palette Items 3.1.0 9.9.9
t_phase 7 Phases 3.5.0 9.9.9
t_problemtypes 1 Problem Types 1.1.0 9.9.9
t_projectroles 1 Project Roles 1.1.0 9.9.9
t_propertytypes 1 Property Types 1.1.0 9.9.9
t_requiretypes 1 Require Types 1.1.0 9.9.9
t_resources 1 Resources 1.1.0 9.9.9
t_risktypes 1 Risk Types 1.1.0 9.9.9
t_roleconstraint 0 Role Constraints 1.1.0 9.9.9
t_rtf 7 RTF 3.5.0 9.9.9
t_rtfreport 1 RTF Reports 1.1.0 9.9.9
t_rules 7 Rules 3.5.0 9.9.9
t_scenariotypes 1 Scenario Types 1.1.0 9.9.9
t_script 7 Scripts 3.5.0 9.9.9
t_secgroup 3 Security Groups 3.5.0 9.9.9
t_secgrouppermission 7 Group Permissions 3.5.0 9.9.9
t_seclocks 7 Security Locks 3.5.0 9.9.9
t_secpermission 3 Permissions 3.5.0 9.9.9
t_secpolicies 1 Security Policies 3.5.0 9.9.9
t_secuser 3 Security User 3.5.0 9.9.9
t_secusergroup 7 User Group 3.5.0 9.9.9
t_secuserpermission 7 User Permissions 3.5.0 9.9.9
t_snapshot 7 Snapshots 3.5.0 9.9.9
t_statustypes 1 Status Types 1.1.0 9.9.9
t_stereotypes 1 Stereotypes 1.1.0 9.9.9
t_taggedvalue 7 Model Tagged Values 3.5.0 9.9.9
t_tasks 7 To Do List 3.1.0 9.9.9
t_tcf 1 TCF Values 1.1.0 9.9.9
t_template 7 Templates 3.5.0 9.9.9
t_testclass 1 Test Classes 1.1.0 9.9.9
t_testplans 7 Test Plans 3.5.0 9.9.9
t_testtypes 1 Test Types 1.1.0 9.9.9
t_trxtypes 1 TRX Types 1.1.0 9.9.9
t_umlpattern 7 UML Patterns 3.5.0 9.9.9
t_version 7 Files 3.5.0 9.9.9
t_xref 7 XRef 3.1.0 9.9.9
t_xrefsystem 7 System XRef 3.5.0 9.9.9
t_xrefuser 7 User XRef 3.5.0 9.9.9
usys_system 7 System Settings 3.1.0 9.9.9
SELECT t_attribute.Object_ID, t_attribute.Name, t_attribute.Scope, t_attribute.Type
FROM t_object INNER JOIN t_attribute ON t_object.Object_ID = t_attribute.Object_ID
ORDER BY t_attribute.Object_ID, t_attribute.Name;
SELECT t_object.Object_ID AS SourceID, t_object.Name AS SourceName, t_object.Object_Type AS SourceType, t_connector.Connector_Type, Object_1.Object_Type AS DestType, Object_1.Name AS DestName, Object_1.Object_ID AS DestID, t_connector.Connector_ID
FROM t_object INNER JOIN (t_connector INNER JOIN t_object AS Object_1 ON t_connector.End_Object_ID = Object_1.Object_ID) ON t_object.Object_ID = t_connector.Start_Object_ID;
SELECT Object_1.Object_ID AS SourceID, Object_1.Name AS SourceName, Object_1.Object_Type AS SourceType, t_connector.Connector_Type, t_object.Object_Type AS DestType, t_object.Name AS DestName, t_object.Object_ID AS DestID, t_connector.Connector_ID
FROM t_object INNER JOIN (t_connector INNER JOIN t_object AS Object_1 ON t_connector.End_Object_ID = Object_1.Object_ID) ON t_object.Object_ID = t_connector.Start_Object_ID;
SELECT t_connector.Name AS ConName, Object_1.Object_ID AS SourceID, Object_1.Name AS SourceName, Object_1.Object_Type AS SourceType, t_connector.Connector_Type, t_connector.Stereotype, t_object.Object_Type AS DestType, t_object.Name AS DestName, t_object.Object_ID AS DestID, t_connector.Notes
FROM t_object INNER JOIN (t_connector INNER JOIN t_object AS Object_1 ON t_connector.End_Object_ID = Object_1.Object_ID) ON t_object.Object_ID = t_connector.Start_Object_ID;
SELECT t_connector.*, t_diagramobjects.Diagram_ID
FROM (t_diagramobjects INNER JOIN t_connector ON t_diagramobjects.Object_ID = t_connector.Start_Object_ID) INNER JOIN t_diagramobjects AS DiagramObjects_1 ON (t_connector.End_Object_ID = DiagramObjects_1.Object_ID) AND (t_diagramobjects.Diagram_ID = DiagramObjects_1.Diagram_ID)
WHERE (((t_connector.DiagramID)=0 Or (t_connector.DiagramID)=[t_diagramobjects].[Diagram_ID]))
ORDER BY t_connector.SeqNo;
select Name from t_object where Object_Type='Class'
UNION select Datatype as Name from t_primitives;
SELECT t_ecf.ECFID, t_ecf.Description, t_ecf.Weight, t_ecf.Value, t_ecf.Notes, [Weight]*[Value] AS ExValue
FROM t_ecf;
SELECT t_package.Package_ID, t_package.Name AS Package, t_connector.End_Object_ID AS ObjectID, Object_1.Name AS ObjectName, Object_1.Object_Type AS ObjectType, t_connector.Connector_Type AS Connector, t_object.Object_ID AS ImplementedByID, t_object.Name AS ImplementorName, t_object.Object_Type AS ImplementorType, t_objecttypes.DesignObject
FROM (t_objecttypes INNER JOIN t_object ON t_objecttypes.Object_Type = t_object.Object_Type) INNER JOIN ((t_connector INNER JOIN t_object AS Object_1 ON t_connector.End_Object_ID = Object_1.Object_ID) INNER JOIN t_package ON Object_1.Package_ID = t_package.Package_ID) ON t_object.Object_ID = t_connector.Start_Object_ID
WHERE (((t_connector.Connector_Type)="Realisation"))
ORDER BY t_package.Package_ID;
SELECT t_diagram.Diagram_ID, t_method.Object_ID, t_method.Name, t_method.Scope, t_method.Type
FROM (t_diagram INNER JOIN t_object ON t_diagram.Diagram_ID = t_object.Diagram_ID) INNER JOIN t_method ON t_object.Object_ID = t_method.Object_ID
ORDER BY t_method.Object_ID, t_method.Name;
SELECT t_diagramobjects.RectTop, t_diagramobjects.RectLeft, t_diagramobjects.RectRight, t_diagramobjects.RectBottom, t_diagramobjects.Diagram_ID, t_diagramobjects.ObjectStyle, t_object.Object_ID, t_object.Object_Type, t_object.Name, t_object.Alias, t_object.Author, t_object.Version, t_object.Note, t_object.Package_ID, t_object.Stereotype, t_object.NType, t_object.Complexity, t_object.Effort, t_object.Style, t_object.BorderStyle, t_object.Backcolor, t_object.CreatedDate, t_object.ModifiedDate, t_package.Name AS PackageName, t_object.Status, t_diagramobjects.Sequence, t_object.Abstract, t_object.Tagged, t_object.BorderWidth, t_object.Fontcolor, t_object.Bordercolor, t_object.PDATA1, t_object.PDATA2, t_object.PDATA3, t_object.PDATA4, t_object.PDATA5, t_object.GenType, t_object.GenFile, t_object.Header1, t_object.Header2, t_object.Phase, t_object.Scope, t_object.GenOption, t_object.GenLinks, t_object.Classifier, t_object.ea_guid, t_object.RunState, t_object_1.Name AS ClassName, t_object.IsRoot, t_object.IsLeaf, t_object.IsSpec, t_object.IsActive, t_object.StateFlags, t_object.PackageFlags, t_object.Multiplicity
FROM t_package INNER JOIN ((t_object LEFT JOIN t_diagramobjects ON t_object.Object_ID = t_diagramobjects.Object_ID) LEFT JOIN t_object AS t_object_1 ON t_object.Classifier = t_object_1.Object_ID) ON t_package.Package_ID = t_object.Package_ID;
SELECT t_object.Object_ID, t_object.Name, t_object.Object_Type AS Type, t_package.Name AS Package, t_objecttypes.DesignObject
FROM t_package INNER JOIN (t_objecttypes INNER JOIN t_object ON t_objecttypes.Object_Type = t_object.Object_Type) ON t_package.Package_ID = t_object.Package_ID
WHERE (((t_objecttypes.DesignObject)=True));
SELECT t_object.Package_ID, t_objecttests.Object_ID, t_objecttests.Test, t_objecttests.TestClass, t_objecttests.TestType, t_objecttests.Notes, t_objecttests.InputData, t_objecttests.AcceptanceCriteria, t_objecttests.Status, t_objecttests.DateRun, t_objecttests.Results, t_objecttests.RunBy, t_objecttests.CheckBy
FROM t_objecttests INNER JOIN t_object ON t_objecttests.Object_ID = t_object.Object_ID;
SELECT Object_1.Name, t_objecttypes.ImageID, t_object.Object_ID, t_package.Package_ID, Object_1.Stereotype, Object_1.Object_Type
FROM ((t_object INNER JOIN t_package ON (t_object.Name = t_package.Name) AND (t_object.Package_ID = t_package.Parent_ID)) INNER JOIN t_object AS Object_1 ON t_package.Package_ID = Object_1.Package_ID) INNER JOIN t_objecttypes ON Object_1.Object_Type = t_objecttypes.Object_Type
WHERE (((t_objecttypes.ImageID)>0));
SELECT t_package.Name AS Package, t_object.Object_ID, t_object.Object_Type, t_object.Diagram_ID, t_object.Name, t_object.Alias, t_object.Author, t_object.Version, t_object.Note, t_object.Package_ID, t_object.Stereotype, t_object.NType, t_object.Complexity, t_object.Effort, t_object.Style, t_object.Backcolor, t_object.BorderStyle, t_object.BorderWidth, t_object.Fontcolor, t_object.Bordercolor, t_object.CreatedDate, t_object.ModifiedDate, t_object.Status, t_object.Abstract, t_object.Tagged, t_object.PDATA1, t_object.PDATA2, t_object.PDATA3, t_object.PDATA4, t_object.PDATA5, t_object.Concurrency, t_object.Visibility, t_object.Persistence, t_object.Cardinality, t_object.GenType, t_object.GenFile, t_object.Header1, t_object.Header2, t_object.Phase
FROM t_package INNER JOIN t_object ON t_package.Package_ID = t_object.Package_ID;
SELECT t_object.Name, t_object.Object_Type AS Type, t_package.Name AS Package, t_connector.End_Object_ID AS ObjectID, t_object.Object_ID AS RealizedByID,...