{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

viper_profile_fields
FieldTypeNullKeyDefaultExtra
field_idmediumint(8) unsignedNOPRI auto_increment
field_namevarchar(255)NO
field_typetinyint(4)NOMUL
field_identvarchar(20)NO
field_lengthvarchar(20)NO
field_minlenvarchar(255)NO
field_maxlenvarchar(255)NO
field_novaluevarchar(255)NO
field_default_valuevarchar(255)NO
field_validationvarchar(20)NO
field_requiredtinyint(1) unsignedNO
field_show_on_regtinyint(1) unsignedNO
field_hidetinyint(1) unsignedNO
field_no_viewtinyint(1) unsignedNO
field_activetinyint(1) unsignedNO
field_ordermediumint(8) unsignedNOMUL
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.