{pdb_id}

Mousing over any column name shown in link font will provide more information on the data it contains

There is a window at the bottom of the page where you can entery SQL queries and view the results in a number of formats

viperdb_item
The viperdb_item table contains information on the data stored in specific columns of the VIPERdb-specific tables. It is analogous to the MMS_ITEM table.
FieldTypeNullKeyDefaultExtra
item_keyint(11)NOPRI auto_increment
idvarchar(32)NO
column_namevarchar(32)NO
category_keyint(11)NOMUL
descriptiontextYES
mandatorychar(1)NO
Enters your SQL query (only SELECT, SHOW and DESCRIBE supported):

Output format:   

Note: Only SELECT, SHOW or DESCRIBE queries can be performed, any other command will generate an error



Main | Data & Analysis | Utilities | Search | Contact Us | Help | Links | Mailing List | Cite VIPERdb | Disclaimer

©1998-2017. TSRI. All rights Reserved.