Table HLPDTEST.STATEGPS.T_GPS_VIEWER_LOV_INFO 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
LOV_ID number 22
T_GPS_VIEWER_LOV_DEPENDONS.LOV_ID SYS_C0010277 C
T_GPS_VIEWER_MULTIPLE_LOV.LOV_ID SYS_C0032051 C
PROPERTY_ID number 22  √  null
T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID T_GPS_VIEWER_LOV_INFO_FK C
FDT_FILE varchar2 200  √  null
FDT_PARAMETER varchar2 200  √  null
ACTION_FLAG varchar2 200  √  null
FDT_INPUT_TYPE varchar2 50  √  null
AUTO_LOV varchar2 10  √  null
LOV_DEFAULT_VALUES varchar2 4000  √  null
DEFAULT_ACTION_FLAG varchar2 30  √  null
LOV_SELCTION varchar2 30  √  null
LOV_SELECTION varchar2 30  √  null
DYNAMIC_WHERE_CLAUSE varchar2 4000  √  null

Table contained 20,982 rows at Thu Oct 28 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
LOV_ID Primary key Asc SYS_C0010132
PROPERTY_ID Performance Asc T_GPS_VIEWER_LOV_INFO_INDEX

Close relationships  within of separation: