' SBM Database Schema constants
' $File: //depot/DB Schema Constants.tsl $
' $DateTime: 2012/05/06 23:36:43 $
' $Revision: #2 $
' $Change: 2 $
' $Author: pthompson $
' Values for TS_FLDTYPE column
' TS_FLDTYPE_USER TS_FLDTYPE_RELATIONAL TS_FLDTYPE_MULTIPLE_RELATIONAL
CONST TS_FLDTYPE_NUMERIC = 100 'Integer or floating-point field.
CONST TS_FLDTYPE_TEXT = 101 'Text field up to 255 characters.
CONST TS_FLDTYPE_DATETIME = 103 'Date/Time field.
CONST TS_FLDTYPE_SELECTION = 104 'Single selection field.
CONST TS_FLDTYPE_BINARY = 105 'Binary field.
CONST TS_FLDTYPE_STATE = 106 'System-defined state field.
CONST TS_FLDTYPE_USER = 107 'User selection field.
CONST TS_FLDTYPE_PROJECT = 108 'System-defined project field.
CONST TS_FLDTYPE_SUMMATION = 109 'Calculated summation field.
CONST TS_FLDTYPE_MULTIPLE_SELECTION = 110 'Multi-selection selection field.
CONST TS_FLDTYPE_CONTACT = 111 'Contact selection field.
CONST TS_FLDTYPE_COMPANY = 112 'Obsolete.
CONST TS_FLDTYPE_INCIDENT = 113 'Incident selection field.
CONST TS_FLDTYPE_PRODUCT = 114 'Obsolete.
CONST TS_FLDTYPE_SERVICEAGREEMENT = 115 'Obsolete.
CONST TS_FLDTYPE_FOLDER = 116 'Folder link selection field.
CONST TS_FLDTYPE_KEYWORDLIST = 117 'Obsolete.
CONST TS_FLDTYPE_PRODUCTLIST = 118 'Obsolete.
CONST TS_FLDTYPE_PROBLEM = 119 'Obsolete.
CONST TS_FLDTYPE_RESOLUTION = 120 'Obsolete.
CONST TS_FLDTYPE_MERCHANDISE = 121 'Obsolete.
CONST TS_FLDTYPE_RELATIONAL = 122 'Single selection relational field.
CONST TS_FLDTYPE_SUBRELATIONAL = 123 'Sub-relational selection field.
CONST TS_FLDTYPE_SYSTEM = 124 'System field.
CONST TS_FLDTYPE_MULTIPLE_RELATIONAL = 125 'Multi-selection relational field.
CONST TS_FLDTYPE_MULTIPLE_USER = 126 'Multi-selection field of users.
CONST TS_FLDTYPE_MULTIPLE_GROUP = 127 'Multi-selection field of groups.
' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
' For TS_FLDTYPE_TEXT:
CONST TS_FLDATTRIB_MEMO = 0 ' Memo
CONST TS_FLDATTRIB_FIXEDTEXT = 1 ' Fixed length text
CONST TS_FLDATTRIB_JOURNAL = 2 ' SBM Journal field
CONST TS_FLDATTRIB_JOURNAL_RO = 3 ' SBM Append-Only Journal field
' For TS_FLDTYPE_NUMERIC:
CONST TS_FLDATTRIB_INT = 0
CONST TS_FLDATTRIB_FLOAT = 1
CONST TS_FLDATTRIB_FIXED_PRECISION = 2
' For TS_FLDTYPE_DATETIME:
CONST TS_FLDATTRIB_DT_DATEONLY = 0 'Date only field.
CONST TS_FLDATTRIB_DT_DATETIME = 1 'Combined date and time of day.
CONST TS_FLDATTRIB_DT_TIMEOFDAY = 2 'Time of day only.
CONST TS_FLDATTRIB_DT_ELAPSEDTIME = 3 'Elapsed time.
' For TS_FLDTYPE_BINARY (TeamScript can't handle HEX constants)
CONST TS_FLDATTRIB_BIN_LISTBOX = 0
CONST TS_FLDATTRIB_BIN_RADIOBUTTON = 1
CONST TS_FLDATTRIB_BIN_CHECKBOX = 2
CONST TS_FLDATTRIB_BIN_TRINARY = 16 ' &H10 ' Indicates that this binary field is really trinary.
' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
' Values for TS_PROPERTY column:
CONST TS_FLDPROP_NONE = 0 ' &h0
CONST TS_FLDPROP_NONEDITABLE = 1 ' &h1 Field will not be editable; i.e. read-only.
CONST TS_FLDPROP_CALC_BEFORE = 2 ' &h2 Calculation occurs before the transition form appears.
CONST TS_FLDPROP_CALC_AFTER = 4 ' &h4 Calculation occurs after the transition form is submitted.
CONST TS_FLDPROP_CALC_ADD_CUR = 8 ' &h8 Add the calculation to the current value.
CONST TS_FLDPROP_CALC_EMPTY_INVALID = 0 ' &h00 Empty value results in the field being invalid.
CONST TS_FLDPROP_CALC_EMPTY_SKIP_CALC = 16 ' &h10 If empty, skip the calculation.
CONST TS_FLDPROP_CALC_EMPTY_TREAT_ZERO = 32 ' &h20 If empty, use 0 for the field value and complete the calculation.
CONST TS_FLDPROP_CALC_EMPTY_MASK = 48 ' &h30 Mask for either/both above bits.
CONST TS_FLDPROP_CHECKBOXES = 256 ' &h100 If field can have multiple values, display the choices as checkboxes.
' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
' Values for TS_SYSCODE column. SYSCODE is dependent on table ID and Table type
CONST TS_SYSFLD_ID = 1
CONST TS_SYSFLD_PARENTID = 2
CONST TS_SYSFLD_PROJECTID = 3
CONST TS_SYSFLD_TITLE = 4
CONST TS_SYSFLD_DESC = 5
CONST TS_SYSFLD_STATE = 6
CONST TS_SYSFLD_DT_CREATE = 7
CONST TS_SYSFLD_DT_LASTMODIFIED = 8
CONST TS_SYSFLD_DT_LASTSTATECHANGE = 9
CONST TS_SYSFLD_DT_CLOSE = 10
CONST TS_SYSFLD_DT_REOPEN = 11
CONST TS_SYSFLD_USER_OWNER = 12
CONST TS_SYSFLD_USER_SUBMITTER = 13
CONST TS_SYSFLD_USER_LASTMODIFIER = 14
CONST TS_SYSFLD_USER_LASTSTATECHANGER = 15
CONST TS_SYSFLD_TEXT_DISPLAYID = 16
CONST TS_SYSFLD_SEL_CASETYPE = 17
CONST TS_SYSFLD_BIN_ACTIVEINACTIVE = 18
CONST TS_SYSFLD_FOLDERID = 19
CONST TS_SYSFLD_LASTINCIDENT = 20
CONST TS_SYSFLD_MULTIUSER_SECONDARYOWNER = 21
CONST TS_SYSFLD_COMPANY = 100
CONST TS_SYSFLD_CONTACT = 101
CONST TS_SYSFLD_MERCHANDISE = 102
CONST TS_SYSFLD_SERVICEAGREEMENT = 103
CONST TS_SYSFLD_PROBLEM = 104
CONST TS_SYSFLD_RESOLUTION = 105
CONST TS_SYSFLD_RESOLUTIONTITLE = 106
CONST TS_SYSFLD_RESOLUTIONDESC = 107
CONST TS_SYSFLD_CONTACT_COMPID = 200
CONST TS_SYSFLD_CONTACT_FNAME = 201
CONST TS_SYSFLD_CONTACT_MNAME = 202
CONST TS_SYSFLD_CONTACT_LNAME = 203
CONST TS_SYSFLD_CONTACT_USERID = 204
CONST TS_SYSFLD_CONTACT_PHONE = 205
CONST TS_SYSFLD_CONTACT_EMAIL = 206
CONST TS_SYSFLD_CONTACT_ADDRESS1 = 207
CONST TS_SYSFLD_CONTACT_ADDRESS2 = 208
CONST TS_SYSFLD_CONTACT_CITY = 209
CONST TS_SYSFLD_CONTACT_STATE = 210
CONST TS_SYSFLD_CONTACT_COUNTRY = 211
CONST TS_SYSFLD_CONTACT_ZIPCODE = 212
CONST TS_SYSFLD_CONTACT_FAXNUMBER = 213
CONST TS_SYSFLD_CONTACT_MOBILENUMBER = 214
CONST TS_SYSFLD_COMPANY_NUMBER = 300
CONST TS_SYSFLD_COMPANY_PRICONTACT = 301
CONST TS_SYSFLD_COMPANY_SECCONTACT = 302
CONST TS_SYSFLD_COMPANY_ADDRESS1 = 303
CONST TS_SYSFLD_COMPANY_ADDRESS2 = 304
CONST TS_SYSFLD_COMPANY_CITY = 305
CONST TS_SYSFLD_COMPANY_STATE = 306
CONST TS_SYSFLD_COMPANY_COUNTRY = 307
CONST TS_SYSFLD_COMPANY_ZIPCODE = 308
CONST TS_SYSFLD_COMPANY_FAXNUMBER = 309
CONST TS_SYSFLD_COMPANY_PHONENUMBER = 310
CONST TS_SYSFLD_DT_EXPIRATION = 400
CONST TS_SYSFLD_VISIBILITY = 500
CONST TS_SYSFLD_VISIBILITY = 500
CONST TS_SYSFLD_PRODUCTS = 501
CONST TS_SYSFLD_URL = 800
CONST TS_SYSFLD_DOC_LIB = 801
CONST TS_SYSFLD_PARENT_SITENAME = 802
CONST TS_SYSFLD_URL_ADDUSER = 803
CONST TS_SYSFLD_SHAREPOINT_USER = 804
CONST TS_SYSFLD_SHAREPOINT_PASS = 805
' Values for TS_TABLES.TS_ID column:
CONST TS_TBLID_NONE = "-1" ' Default. SBM BUG: AppScript will not all negative integers.
CONST TS_TBLID_CASES = 1 ' Deprecated. See note below. *
CONST TS_TBLID_CHANGES = 2
CONST TS_TBLID_FIELDS = 3
CONST TS_TBLID_GROUPS = 4
CONST TS_TBLID_LICENSES = 5 ' No longer valid.
CONST TS_TBLID_MEMBERS = 6
CONST TS_TBLID_PRIVILEGES = 7
CONST TS_TBLID_PROJECTS = 8
CONST TS_TBLID_PROJECTSELECTIONS = 9
CONST TS_TBLID_PROPERTIES = 10
CONST TS_TBLID_REPORTS = 11
CONST TS_TBLID_SELECTIONS = 12
CONST TS_TBLID_STATES = 13
CONST TS_TBLID_TRANSISSUETYPES = 14
CONST TS_TBLID_SYSTEMINFO = 15
CONST TS_TBLID_TRANSITIONS = 16
CONST TS_TBLID_USERS = 17
CONST TS_TBLID_TABLES = 18
CONST TS_TBLID_ATTACHMENTS = 19
CONST TS_TBLID_FOLDERS = 20
CONST TS_TBLID_FOLDERITEMS = 21
CONST TS_TBLID_FOLDERCOLUMNS = 22 ' No longer valid.
CONST TS_TBLID_VCACTIONS = 23
CONST TS_TBLID_PROJECTTRANSITIONS = 24
CONST TS_TBLID_NOTIFICATIONS = 25
CONST TS_TBLID_NOTIFICATIONRULES = 26
CONST TS_TBLID_NOTIFICATIONCONDITIONS = 27
CONST TS_TBLID_NOTIFICATIONEVENTS = 28
CONST TS_TBLID_NOTIFICATIONFIELDS = 29
CONST TS_TBLID_NOTIFICATIONMESSAGES = 30
CONST TS_TBLID_NOTIFICATIONPERMISSIONS = 31
CONST TS_TBLID_NOTIFICATIONSUBSCRIPTIONS = 32
CONST TS_TBLID_MACROS = 33
CONST TS_TBLID_WORKFLOWS = 34
CONST TS_TBLID_FIELDORDERINGS = 35
CONST TS_TBLID_INCIDENTS = 36 ' Deprecated. See note below. *
CONST TS_TBLID_COMPANIES = 37
CONST TS_TBLID_CONTACTS = 38
CONST TS_TBLID_MERCHANDISE = 39 ' Deprecated. See note below. *
CONST TS_TBLID_SERVICEAGREEMENTS = 40 ' Deprecated. See note below. *
CONST TS_TBLID_PROBLEMS = 41
CONST TS_TBLID_RESOLUTIONS = 42
CONST TS_TBLID_PRODUCTS = 43 ' Deprecated. See note below. *
CONST TS_TBLID_KEYWORDS = 44
CONST TS_TBLID_PRODUCTUSAGES = 45
CONST TS_TBLID_KEYWORDUSAGES = 46
CONST TS_TBLID_TRANSTRIGGERS = 47
CONST TS_TBLID_TRANSTRIGGERSTATES = 48 ' Replaced by TS_STACTIONS in 62002.
CONST TS_TBLID_TRANSTRIGGERTRANSITIONS = 49 ' Replaced by TS_STACTIONS in 62002.
CONST TS_TBLID_ADMINGROUPS = 50
CONST TS_TBLID_MAILHEADERFIELDS = 51
CONST TS_TBLID_MAILBOX = 52
CONST TS_TBLID_MAILMAPPINGS = 53
CONST TS_TBLID_SELFREGFIELDS = 54
CONST TS_TBLID_MSSELECTION = 55
CONST TS_TBLID_SYSTEMSETTINGS = 56
CONST TS_TBLID_GWESTATES = 57
CONST TS_TBLID_GWETRANSITIONS = 58
CONST TS_TBLID_GWECOMMENTS = 59
CONST TS_TBLID_SOLUTIONS = 60
CONST TS_TBLID_SUBTASKS = 61
CONST TS_TBLID_SECTIONS = 62 ' Not currently used.
CONST TS_TBLID_BROWSERS = 63
CONST TS_TBLID_RESOURCES = 64
CONST TS_TBLID_BLOBS = 65
CONST TS_TBLID_RECORDLOCKS = 66
CONST TS_TBLID_ITEMNOTIFICATIONS = 67
CONST TS_TBLID_USAGES = 68
CONST TS_TBLID_ADMINTABLES = 69
CONST TS_TBLID_GROUPENABLER = 70 ' No longer valid.
CONST TS_TBLID_ADMINLOCKS = 71
CONST TS_TBLID_EXTERNALDATABASES = 72
CONST TS_TBLID_EXTERNALPOSTINGS = 73
CONST TS_TBLID_EXTERNALPOSTFIELDMAP = 74
CONST TS_TBLID_ADMINCHANGES = 75
CONST TS_TBLID_LASTID = 76
CONST TS_TBLID_LASTIDS = 76
CONST TS_TBLID_URLSTORE = 77
CONST TS_TBLID_TRANSGROUPS = 78
CONST TS_TBLID_ATTACHMENTSEQUENCES = 79
CONST TS_TBLID_TOOLS = 80
CONST TS_TBLID_BRIDGES = 81
CONST TS_TBLID_FIELD_MAP = 82
CONST TS_TBLID_USER_MAP = 83
CONST TS_TBLID_XREF = 84
CONST TS_TBLID_MULTIUSERUSAGES = 85
CONST TS_TBLID_CONCURRENTLOGINS = 86
CONST TS_TBLID_LABELS = 87
CONST TS_TBLID_VCURLFORMATS = 88
CONST TS_TBLID_TRANSORDERINGS = 89
CONST TS_TBLID_USERSOLUTIONDATA = 90
CONST TS_TBLID_USERQUICKLINKS = 91
CONST TS_TBLID_CACHEACTIONS = 92
CONST TS_TBLID_TRANSATTRS = 93
CONST TS_TBLID_TRANSATTRUSAGES = 94
CONST TS_TBLID_URLINTEGRATIONS = 95
CONST TS_TBLID_URLUSAGES = 96
CONST TS_TBLID_LANGUAGES = 97
CONST TS_TBLID_STRINGIDENTIFIERS = 98
CONST TS_TBLID_STRINGS = 99
CONST TS_TBLID_STACTIONS = 100
CONST TS_TBLID_SELECTIONUSAGES = 101
CONST TS_TBLID_OBJATTRS = 102
CONST TS_TBLID_DBSOURCES = 103
CONST TS_TBLID_IMPORTOPTIONSETS = 104
CONST TS_TBLID_CHANGEACTIONS = 105
CONST TS_TBLID_CHANGETEXT = 107
CONST TS_TBLID_FIELDPRIVILEGES = 108
CONST TS_TBLID_OLDPASSWORDS = 109
CONST TS_TBLID_TRANSSIGNS = 110
CONST TS_TBLID_WSDESCRIPTIONS = 111
CONST TS_TBLID_WSCALLS = 112
CONST TS_TBLID_WSSELECTIONMAPPINGS = 113
CONST TS_TBLID_WSDATAMAPPINGS = 114
CONST TS_TBLID_CALENDARS = 115
CONST TS_TBLID_CALENDARWEEKDAYS = 116
CONST TS_TBLID_CALENDAROVERRIDES = 117
CONST TS_TBLID_CALENDARTIMERANGES = 118
CONST TS_TBLID_TIMEINSTATE = 119
CONST TS_TBLID_ROLES = 120
CONST TS_TBLID_PERMISSIONACTIONS = 121
CONST TS_TBLID_PERMISSIONOBJECTS = 122
CONST TS_TBLID_PERMISSIONCONDITIONS = 123
CONST TS_TBLID_PERMISSIONS = 124
CONST TS_TBLID_ROLEPERMISSIONS = 125
CONST TS_TBLID_SECURITYCONTROLS = 126
CONST TS_TBLID_FORMS = 127
CONST TS_TBLID_FORMUSAGES = 128
CONST TS_TBLID_FORMUSERPREF = 129
CONST TS_TBLID_TRANSITIONPOSTPROJECTS = 130
CONST TS_TBLID_APPLICATIONS = 131
CONST TS_TBLID_IMPORTSTATUS = 132
CONST TS_TBLID_REPORTDISPLAYFORMATS = 133
CONST TS_TBLID_ALFEVENTS = 134
CONST TS_TBLID_ALFEVENTCALLS = 135
CONST TS_TBLID_DELETEDOBJECTS = 136
CONST TS_TBLID_USERFORMSTATES = 137
CONST TS_TBLID_PROCESSMODELS = 138
CONST TS_TBLID_APPLICATIONPROCESSMODELS = 139
' * These tables are specific to the Issue Management and Incident Management
' solutions. The TS_ID listed above is correct after upgrade from a 4.0 database.
' If either or both solutions were deleted from a given database, and
' subsequently reinstalled, the tables were then created with different values
' for TS_ID. In short, these values can be used to reliably reference system
' tables, but not solution tables.
' Values for TS_TABLES.TS_TYPE column:
CONST TS_TBLTYPE_SYS = 0 ' System table, e.g. TS_USERS.
CONST TS_TBLTYPE_PRI = 1 ' Primary table, e.g. TTT_ISSUES.
CONST TS_TBLTYPE_AUX = 2 ' Auxiliary table, e.g. TTS_PRODUCTS.
CONST TS_TBLTYPE_SYSAUX = 3 ' System auxiliary table, e.g. TS_CONTACTS.
CONST TS_TBLTYPE_ARCHIVE = 4 ' Archive for another table.
' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
' Values for TS_OPTIONS column:
CONST TS_FLDOPTION_CHECKBOXES = 0002 ' Deprecated. Replaced by overridable property: TS_FLDPROP_CHECKBOXES.
CONST TS_FLDOPTION_SELECT_DEFAULT = 0000 ' Default field selection options.
CONST TS_FLDOPTION_SELECT_MULTIPLE = 0001 ' Allow multiple selections if set. Otherwise allow only one selection.
CONST TS_FLDOPTION_CHECKBOXES = 0002 ' Deprecated. Replaced by overridable property: TS_FLDPROP_CHECKBOXES.
CONST TS_FLDOPTION_FINDFIELD = 0004 ' Allow field to be searched during a find.
CONST TS_FLDOPTION_PREFORMATTED_HTML= 0008 ' Used to preserve text format on a cut and paste.
' CONST TS_FLDOPTION_STOPWATCH = &h0010 ' Elapsed time field that is to be viewed as a stopwatch.
CONST TS_FLDOPTION_STOPWATCH = 16 ' Elapsed time field that is to be viewed as a stopwatch.
CONST TS_FLDOPTION_PRECISION_MASK = 0000 ' F00 For fixed precision numeric fields only,
' i.e. fields of type TS_FLDTYPE_NUMERIC
' with attribute TS_FLDATTRIB_FIXED_PRECISION.
' Bits 8 - 11 of the TS_OPTIONS column specify the
' number of digits to display after the decimal point.
' CONST TS_FLDOPTION_PASSWORD = &h0020 ' For fixed length text fields only. Field will display in the browser as a password field.
CONST TS_FLDOPTION_PASSWORD = 32 ' For fixed length text fields only. Field will display in the browser as a password field.
' CONST TS_FLDOPTION_NODELETE = &h0040 ' Can only be set when the field is initially
CONST TS_FLDOPTION_NODELETE = 64 ' Can only be set when the field is initially
' created, and if set, the field cannot
' subsequently be deleted, e.g. system
' fields are not deletable.
'CONST TS_FLDOPTION_NOSECONDS = &h0080 ' Don't show seconds in Elapsed Time fields..
CONST TS_FLDOPTION_NOSECONDS = 128 ' Don't show seconds in Elapsed Time fields..
'CONST TS_FLDOPTION_GROUPING = &h1000 ' Shows thousands separators, e.g., 1,000 vs. 1000.
CONST TS_FLDOPTION_GROUPING = 4096 ' Shows thousands separators, e.g., 1,000 vs. 1000.
'CONST TS_FLDOPTION_BACKFILL = &h2000 ' Temporary flag indicating the new column should
CONST TS_FLDOPTION_BACKFILL = 8192 ' Temporary flag indicating the new column should
' be set to default value upon create. This corresponds
' to the checkbox "Backfill to existing items" in the
' Administrator Options tab, while adding a field.
' CONST TS_FLDOPTION_NODAYS = &h4000 ' Convert elapsed time to include number of days. Flag
CONST TS_FLDOPTION_NODAYS = 16384 ' Convert elapsed time to include number of days. Flag
' corresponds to the check box "Calculate Days" in the
' Administrator Options tab, while adding/editing a
' date time field. If the checkbox is checked in the
' options tab, this bit will be cleared.
'CONST TS_FLDOPTION_SORT_NEWEST_FIRST= &h8000 ' Used for journal fields only. Entries will be sorted starting with the newest entry.
CONST TS_FLDOPTION_SORT_NEWEST_FIRST= 32768 ' Used for journal fields only. Entries will be sorted starting with the newest entry.
'CONST TS_FLDOPTION_RENDER_HTML = &h10000 ' Used for memo fields only. When this flag is set,
CONST TS_FLDOPTION_RENDER_HTML = 65536 ' Used for memo fields only. When this flag is set,
' HTML tags in the field will be passed to the browser
' for rendering. Without this flag, HTML tags in the
' field will be escaped so that the tags will be
' displayed as plain text.
'CONST TS_FLDOPTION_ALLOW_HUGE = &h20000 ' Used for memo and journal fields in an Oracle
CONST TS_FLDOPTION_ALLOW_HUGE = 131072 ' Used for memo and journal fields in an Oracle
' database only. When this flag is set, the field
' will be created as a CLOB column. Without this
' flag, the field will be created as a VARCHAR
' column. The flag is not used in SQL Server or
' Access databases, where all memo and journal
' fields are created as LONGVARCHAR columns.
'CONST TS_FLDOPTION_SPANS_ROW = &h40000 ' Applicable to all fields, field is displayed on a row by itself.
CONST TS_FLDOPTION_SPANS_ROW = 262144 ' Applicable to all fields, field is displayed on a row by itself.
# |
Change |
User |
Description |
Committed |
|
#1
|
8137 |
Paul M. Thompson |
Initial test of accessing files in Google Drive via junction in the P4 workspace. |
|
|