Lenovo ThinkPad T40p IBM System Information Center Administrator's Guide - Page 99

Table, Table, Asset.Query_Col_Info, Asset.Query_Group, Asset.Task

Get Lenovo ThinkPad T40p PDF manuals and user guides View all Lenovo ThinkPad T40p manuals
Add to My Manuals
Save this manual to your list of manuals

Page 99 highlights

Table 40. Table: Asset.Query_Col_Info Column Name QUERYKEY NAME DISPLAYCOL DISPLAYDATA ALIAS ACTION1 ACTION2 ACTION3 ACTION_LOGO ACTION_LOGO2 ACTION_LOGO3 ACTION_POPUP ACTION_POPUP2 ACTION_POPUP3 COLOUR ALIGN SUMMARY POPUP DELETEABLE AUTHORITY Type Name INTEGER VARCHAR INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR INTEGER CHARACTER Table 41. Table: Asset.Query_Group Column Name QUERYKEY GROUP_NAME Type Name INTEGER VARCHAR Table 42. Table: Asset.Task Column Name TASKKEY TYPE NAME DESCRIPTION SCHEDULED MENU ACTIVE RUNONCE START_DATE END_DATE PERIOD USER_QUERY Type Name INTEGER VARCHAR VARCHAR VARCHAR INTEGER VARCHAR INTEGER INTEGER TIMESTAMP TIMESTAMP INTEGER INTEGER Length 30 30 150 150 150 20 20 20 200 200 200 10 10 10 200 1 Nulls NO NO NO NO YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES NO Length 50 Nulls NO NO Length 30 50 255 50 Nulls NO NO NO YES NO YES NO NO YES YES NO NO Appendix B. Using database information 91

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
Table
40.
Table:
Asset.Query_Col_Info
Column
Name
Type
Name
Length
Nulls
QUERYKEY
INTEGER
NO
NAME
VARCHAR
30
NO
DISPLAYCOL
INTEGER
NO
DISPLAYDATA
INTEGER
NO
ALIAS
VARCHAR
30
YES
ACTION1
VARCHAR
150
YES
ACTION2
VARCHAR
150
YES
ACTION3
VARCHAR
150
YES
ACTION_LOGO
VARCHAR
20
YES
ACTION_LOGO2
VARCHAR
20
YES
ACTION_LOGO3
VARCHAR
20
YES
ACTION_POPUP
VARCHAR
200
YES
ACTION_POPUP2
VARCHAR
200
YES
ACTION_POPUP3
VARCHAR
200
YES
COLOUR
VARCHAR
10
YES
ALIGN
VARCHAR
10
YES
SUMMARY
VARCHAR
10
YES
POPUP
VARCHAR
200
YES
DELETEABLE
INTEGER
YES
AUTHORITY
CHARACTER
1
NO
Table
41.
Table:
Asset.Query_Group
Column
Name
Type
Name
Length
Nulls
QUERYKEY
INTEGER
NO
GROUP_NAME
VARCHAR
50
NO
Table
42.
Table:
Asset.Task
Column
Name
Type
Name
Length
Nulls
TASKKEY
INTEGER
NO
TYPE
VARCHAR
30
NO
NAME
VARCHAR
50
NO
DESCRIPTION
VARCHAR
255
YES
SCHEDULED
INTEGER
NO
MENU
VARCHAR
50
YES
ACTIVE
INTEGER
NO
RUNONCE
INTEGER
NO
START_DATE
TIMESTAMP
YES
END_DATE
TIMESTAMP
YES
PERIOD
INTEGER
NO
USER_QUERY
INTEGER
NO
Appendix
B.
Using
database
information
91