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

Table, Table, Asset.Menu_Links, Asset.Passwords, Asset.Query, Asset.Query_Col_Ctrl

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

Table 36. Table: Asset.Menu_Links Column Name QUERYKEY MENU COL1 COL2 COL3 COL4 QUERYKEY2 Type Name INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR INTEGER Table 37. Table: Asset.Passwords Column Name USERKEY PASSWORD UPDATED Type Name INTEGER VARCHAR TIMESTAMP Table 38. Table: Asset.Query Column Name QUERYKEY NAME DESCRIPTION SQL_DATA FONTSIZE AUTHORITY DISPLAY REFRESH CREATOR CREATED Type Name INTEGER VARCHAR VARCHAR LONG VARCHAR INTEGER CHARACTER INTEGER INTEGER VARCHAR TIMESTAMP Table 39. Table: Asset.Query_Col_Ctrl Column Name QUERYKEY NAME DISPLAYCOL DISPLAYDATA ALIAS COLOUR ALIGN SUMMARY POPUP DELETEABLE AUTHORITY Type Name INTEGER VARCHAR INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR INTEGER CHARACTER Length 30 60 60 60 60 Nulls NO NO NO NO NO NO NO Length 100 Nulls NO NO NO Length 50 120 1 20 10 Nulls NO NO YES NO NO NO NO NO YES NO Length 30 30 10 10 10 200 1 Nulls NO NO NO NO YES YES YES YES YES YES NO 90

  • 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
36.
Table:
Asset.Menu_Links
Column
Name
Type
Name
Length
Nulls
QUERYKEY
INTEGER
NO
MENU
VARCHAR
30
NO
COL1
VARCHAR
60
NO
COL2
VARCHAR
60
NO
COL3
VARCHAR
60
NO
COL4
VARCHAR
60
NO
QUERYKEY2
INTEGER
NO
Table
37.
Table:
Asset.Passwords
Column
Name
Type
Name
Length
Nulls
USERKEY
INTEGER
NO
PASSWORD
VARCHAR
100
NO
UPDATED
TIMESTAMP
NO
Table
38.
Table:
Asset.Query
Column
Name
Type
Name
Length
Nulls
QUERYKEY
INTEGER
NO
NAME
VARCHAR
50
NO
DESCRIPTION
VARCHAR
120
YES
SQL_DATA
LONG
VARCHAR
NO
FONTSIZE
INTEGER
NO
AUTHORITY
CHARACTER
1
NO
DISPLAY
INTEGER
NO
REFRESH
INTEGER
NO
CREATOR
VARCHAR
20
YES
CREATED
TIMESTAMP
10
NO
Table
39.
Table:
Asset.Query_Col_Ctrl
Column
Name
Type
Name
Length
Nulls
QUERYKEY
INTEGER
NO
NAME
VARCHAR
30
NO
DISPLAYCOL
INTEGER
NO
DISPLAYDATA
INTEGER
NO
ALIAS
VARCHAR
30
YES
COLOUR
VARCHAR
10
YES
ALIGN
VARCHAR
10
YES
SUMMARY
VARCHAR
10
YES
POPUP
VARCHAR
200
YES
DELETEABLE
INTEGER
YES
AUTHORITY
CHARACTER
1
NO
90