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

Userkey, Integer, Attribute, Varchar, Value, Schema_name, Table_name, Column_name, Filetype, Version

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

Table 48. Table: Asset.User_Preference Column Name USERKEY ATTRIBUTE VALUE Type Name INTEGER VARCHAR VARCHAR Table 49. Table: Asset.XML_Lookup Column Name SCHEMA_NAME TABLE_NAME COLUMN_NAME TEXT FILETYPE VERSION XPATH NODETYPE ISKEY PROBE_SET Type Name VARCHAR VARCHAR VARCHAR INTEGER VARCHAR VARCHAR VARCHAR VARCHAR CHARACTER INTEGER Length 100 100 Nulls NO NO NO Length 64 64 64 20 20 255 10 1 Nulls NO NO NO NO NO NO NO NO YES NO Appendix B. Using database information 93

  • 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
48.
Table:
Asset.User_Preference
Column
Name
Type
Name
Length
Nulls
USERKEY
INTEGER
NO
ATTRIBUTE
VARCHAR
100
NO
VALUE
VARCHAR
100
NO
Table
49.
Table:
Asset.XML_Lookup
Column
Name
Type
Name
Length
Nulls
SCHEMA_NAME
VARCHAR
64
NO
TABLE_NAME
VARCHAR
64
NO
COLUMN_NAME
VARCHAR
64
NO
TEXT
INTEGER
NO
FILETYPE
VARCHAR
20
NO
VERSION
VARCHAR
20
NO
XPATH
VARCHAR
255
NO
NODETYPE
VARCHAR
10
NO
ISKEY
CHARACTER
1
YES
PROBE_SET
INTEGER
NO
Appendix
B.
Using
database
information
93