Table odyssey_test._oat.qry_parameter
Parameters users are required to fill in before running a canned query.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
query_id int4 10 Query this parameter is for.
param_num int4 10 Sequence number of this parameter.
name text 2147483647 Name of parameter.
param_type text 2147483647
qry_parameter_type.param_type qry_parameter_param_type_fkey R
Type of parameter; reference to qry_parameter_type.
description text 2147483647  √  null Description of the parameter.

Table contained 136 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
query_id + param_num Primary key Asc/Asc qry_parameter_pkey

Close relationships: