Lenovo ThinkPad T41p IBM System Information Center Administrator's Guide - Page 100

Table, Table, Asset.Task, continued, Asset.Task_Log, Asset.Task_Selected, Asset.TX_Log, Asset.

Page 100 highlights

Table 42. Table: Asset.Task (continued) Column Name Type Name USERLIST VARCHAR QUERY INTEGER MAIL_TEMPLATE INTEGER CREATOR VARCHAR CREATED TIMESTAMP Table 43. Table: Asset.Task_Log Column Name TASKKEY USERKEY USER_LIST COMMENT DATETIME Type Name INTEGER INTEGER VARCHAR VARCHAR TIMESTAMP Table 44. Table: Asset.Task_Selected Column Name TASKKEY MENU_NAME DESCRIPTION Type Name INTEGER VARCHAR VARCHAR Table 45. Table: Asset.TX_Log Column Name USERKEY HWKEY TX_DATA TX_TIME DATETIME Type Name INTEGER INTEGER VARCHAR INTEGER TIMESTAMP Table 46. Table: Asset.User_Authority Column Name USERKEY AUTHTYPE AUTHORITY Type Name INTEGER VARCHAR CHARACTER Table 47. Table: Asset.User_Group Column Name GROUPKEY NAME CREATED Type Name INTEGER VARCHAR TIMESTAMP Length 100 20 Nulls YES NO YES YES NO Length 2000 200 Nulls NO YES YES YES YES Length 50 250 Nulls NO YES YES Length 500 10 Nulls NO YES NO YES NO Length 20 1 Nulls NO NO NO Length 50 Nulls NO NO NO 92

  • 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
42.
Table:
Asset.Task
(continued)
Column
Name
Type
Name
Length
Nulls
USERLIST
VARCHAR
100
YES
QUERY
INTEGER
NO
MAIL_TEMPLATE
INTEGER
YES
CREATOR
VARCHAR
20
YES
CREATED
TIMESTAMP
NO
Table
43.
Table:
Asset.Task_Log
Column
Name
Type
Name
Length
Nulls
TASKKEY
INTEGER
NO
USERKEY
INTEGER
YES
USER_LIST
VARCHAR
2000
YES
COMMENT
VARCHAR
200
YES
DATETIME
TIMESTAMP
YES
Table
44.
Table:
Asset.Task_Selected
Column
Name
Type
Name
Length
Nulls
TASKKEY
INTEGER
NO
MENU_NAME
VARCHAR
50
YES
DESCRIPTION
VARCHAR
250
YES
Table
45.
Table:
Asset.TX_Log
Column
Name
Type
Name
Length
Nulls
USERKEY
INTEGER
NO
HWKEY
INTEGER
YES
TX_DATA
VARCHAR
500
NO
TX_TIME
INTEGER
YES
DATETIME
TIMESTAMP
10
NO
Table
46.
Table:
Asset.User_Authority
Column
Name
Type
Name
Length
Nulls
USERKEY
INTEGER
NO
AUTHTYPE
VARCHAR
20
NO
AUTHORITY
CHARACTER
1
NO
Table
47.
Table:
Asset.User_Group
Column
Name
Type
Name
Length
Nulls
GROUPKEY
INTEGER
NO
NAME
VARCHAR
50
NO
CREATED
TIMESTAMP
NO
92