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

Table, Table, Asset.Custom_Query, continued, Asset.Custom_Query_Group_Access, Asset.

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 97 highlights

Table 31. Table: Asset.Custom_Query (continued) Column Name Type Name DESCRIPTION VARCHAR SQL_DATA LONG VARCHAR CREATOR INTEGER CREATED TIMESTAMP Length 120 10 Nulls YES NO YES NO Table 32. Table: Asset.Custom_Query_Group_Access Column Name Type Name CUSTOM_QUERYKEY INTEGER GROUPKEY INTEGER Length Nulls NO NO Table 33. Table: Asset.Custom_Query_User_Access Column Name Type Name CUSTOM_QUERYKEY INTEGER USERKEY INTEGER Length Nulls NO NO Table 34. Table: Asset.Filestore Column Name HWKEY REVISION FILETYPE FILEDATA FILENAME MIMETYPE Type Name INTEGER INTEGER VARCHAR LONG BIT, VARYING VARCHAR VARCHAR Length 25 50 50 Nulls NO NO NO YES YES YES Table 35. Table: Asset.Menu_Actions Column Name QUERYKEY MENU NAME COL1 COL2 COL3 COL4 MENU_ACTION LOGO MULTIPLE CLICKTYPE DESCRIPTION AUTHORITY Type Name INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR CHARACTER VARCHAR CHARACTER Length 30 30 60 60 60 60 150 40 15 1 200 1 Nulls NO NO NO NO NO NO NO YES YES NO NO YES NO Appendix B. Using database information 89

  • 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
31.
Table:
Asset.Custom_Query
(continued)
Column
Name
Type
Name
Length
Nulls
DESCRIPTION
VARCHAR
120
YES
SQL_DATA
LONG
VARCHAR
NO
CREATOR
INTEGER
YES
CREATED
TIMESTAMP
10
NO
Table
32.
Table:
Asset.Custom_Query_Group_Access
Column
Name
Type
Name
Length
Nulls
CUSTOM_QUERYKEY
INTEGER
NO
GROUPKEY
INTEGER
NO
Table
33.
Table:
Asset.Custom_Query_User_Access
Column
Name
Type
Name
Length
Nulls
CUSTOM_QUERYKEY
INTEGER
NO
USERKEY
INTEGER
NO
Table
34.
Table:
Asset.Filestore
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
FILETYPE
VARCHAR
25
NO
FILEDATA
LONG
BIT,
VARYING
YES
FILENAME
VARCHAR
50
YES
MIMETYPE
VARCHAR
50
YES
Table
35.
Table:
Asset.Menu_Actions
Column
Name
Type
Name
Length
Nulls
QUERYKEY
INTEGER
NO
MENU
VARCHAR
30
NO
NAME
VARCHAR
30
NO
COL1
VARCHAR
60
NO
COL2
VARCHAR
60
NO
COL3
VARCHAR
60
NO
COL4
VARCHAR
60
NO
MENU_ACTION
VARCHAR
150
YES
LOGO
VARCHAR
40
YES
MULTIPLE
VARCHAR
15
NO
CLICKTYPE
CHARACTER
1
NO
DESCRIPTION
VARCHAR
200
YES
AUTHORITY
CHARACTER
1
NO
Appendix
B.
Using
database
information
89