Table shrdb.LAWRS.ERS_PARAMETERS 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
ID number 22
ERS_PARM_AVAILVALUES.ID Implied Constraint R
ERS_PARM_AVAILVALUES.PID SYS_C0011697 C
ERS_PARM_AVAILVALUES_IDS.PID SYS_C0011696 C
REPORTID number 22
PARAMETERNAME nvarchar2 200
ALLOWMULTIPLE nvarchar2 2  √  null
ALLOWNULLS nvarchar2 2  √  null
DEFAULTVALUES nvarchar2 200  √  null
DATATYPE nvarchar2 100  √  null
DATASIZE nvarchar2 50  √  null
MINVALUE nvarchar2 400  √  null
MAXVALUE nvarchar2 400  √  null
VALUESOURCETYPE nvarchar2 50  √  null
PARAMETERDESCRIPTION nvarchar2 500  √  null
PROMPTTEXT nvarchar2 400  √  null
PARAMETERINDEX number 22  √  null
ALWAYSPROMPT nvarchar2 2  √  null
SELECTIONFORMULAONLY nvarchar2 2  √  null
PARAMETERTYPE number 22  √  null
PARAMETERSOURCE number 22  √  null
DEPENDSON nvarchar2 200  √  null
HIDDEN number 22
PROMPTDISPLAYFORMAT nvarchar2 2  √  null
VALUETYPE nvarchar2 100  √  null
REPORTFIELD nvarchar2 200  √  null
VALUELISTTYPE nvarchar2 100  √  null
VALUESPAGINGSIZE number 22  √  null

Table contained 98 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc SYS_C0011486

Close relationships: