Lenovo ThinkPad T23 IBM System Information Center Administrator's Guide - Page 99
Table, Table, Asset.Query_Col_Info, Asset.Query_Group, Asset.Task
View all Lenovo ThinkPad T23 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 99 highlights
Table 40. Table: Asset.Query_Col_Info Column Name QUERYKEY NAME DISPLAYCOL DISPLAYDATA ALIAS ACTION1 ACTION2 ACTION3 ACTION_LOGO ACTION_LOGO2 ACTION_LOGO3 ACTION_POPUP ACTION_POPUP2 ACTION_POPUP3 COLOUR ALIGN SUMMARY POPUP DELETEABLE AUTHORITY Type Name INTEGER VARCHAR INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR INTEGER CHARACTER Table 41. Table: Asset.Query_Group Column Name QUERYKEY GROUP_NAME Type Name INTEGER VARCHAR Table 42. Table: Asset.Task Column Name TASKKEY TYPE NAME DESCRIPTION SCHEDULED MENU ACTIVE RUNONCE START_DATE END_DATE PERIOD USER_QUERY Type Name INTEGER VARCHAR VARCHAR VARCHAR INTEGER VARCHAR INTEGER INTEGER TIMESTAMP TIMESTAMP INTEGER INTEGER Length 30 30 150 150 150 20 20 20 200 200 200 10 10 10 200 1 Nulls NO NO NO NO YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES NO Length 50 Nulls NO NO Length 30 50 255 50 Nulls NO NO NO YES NO YES NO NO YES YES NO NO Appendix B. Using database information 91