Table lawprod.MSCM.ACTIVITY_TYPE Generated by
SchemaSpy
Legend:
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
ACTIVITY_TYPE number 3
ACTIVITY_LOG.ACTIVITY_TYPE ACTLOGTYPE_FK R
LOC_GROUP_TYPE.ACTIVITY_TYPE SYS_C00914656 R
ACTIVITY_NAME varchar2 50  √  null
DESCRIPTION varchar2 50  √  null
IS_ACTIVE varchar2 1  √  null
MODULE varchar2 10  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
ACTIVITY_TYPE Primary key Asc ACTIVITYTYPE_PK

Close relationships  within of separation: