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

Table, Table, Asset.Drivers, continued, Asset.Email_Template, Asset.Filesharing, Asset.GINA, 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 89 highlights

Table 4. Table: Asset.Drivers (continued) Column Name Type Name FILE_SIZE INTEGER Length Nulls YES Table 5. Table: Asset.Email_Template Column Name EMAILKEY LOCALE NAME DESCRIPTION EMAIL_FROM TITLE CONTENT CREATOR CREATED Type Name INTEGER CHARACTER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR TIMESTAMP Length 2 50 200 70 80 2000 20 Nulls NO NO NO YES YES YES NO YES NO Table 6. Table: Asset.Filesharing Column Name HWKEY REVISION S_NAME S_PATH S_TYPE S_UNAUTHORISED_ ACCESS Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR Length 100 100 100 7 Nulls NO NO YES YES YES YES Table 7. Table: Asset.GINA Column Name HWKEY REVISION GINADLL COMPANY VERSION DESCRIPTION Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR Length 40 100 100 100 Nulls NO NO YES YES YES YES Table 8. Table: Asset.Group_Members Column Name GROUPKEY USERKEY Type Name INTEGER INTEGER Length Nulls NO NO Table 9. Table: Asset.HW_Security Column Name HWKEY Type Name INTEGER Length Nulls NO Appendix B. Using database information 81

  • 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
4.
Table:
Asset.Drivers
(continued)
Column
Name
Type
Name
Length
Nulls
FILE_SIZE
INTEGER
YES
Table
5.
Table:
Asset.Email_Template
Column
Name
Type
Name
Length
Nulls
EMAILKEY
INTEGER
NO
LOCALE
CHARACTER
2
NO
NAME
VARCHAR
50
NO
DESCRIPTION
VARCHAR
200
YES
EMAIL_FROM
VARCHAR
70
YES
TITLE
VARCHAR
80
YES
CONTENT
VARCHAR
2000
NO
CREATOR
VARCHAR
20
YES
CREATED
TIMESTAMP
NO
Table
6.
Table:
Asset.Filesharing
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
S_NAME
VARCHAR
100
YES
S_PATH
VARCHAR
100
YES
S_TYPE
VARCHAR
100
YES
S_UNAUTHORISED_
ACCESS
VARCHAR
7
YES
Table
7.
Table:
Asset.GINA
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
GINADLL
VARCHAR
40
YES
COMPANY
VARCHAR
100
YES
VERSION
VARCHAR
100
YES
DESCRIPTION
VARCHAR
100
YES
Table
8.
Table:
Asset.Group_Members
Column
Name
Type
Name
Length
Nulls
GROUPKEY
INTEGER
NO
USERKEY
INTEGER
NO
Table
9.
Table:
Asset.HW_Security
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
Appendix
B.
Using
database
information
81