Table lawprod.MSCM.ROUTE 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
ROUTE_ID number 22
ROUTE_SOURCE_LOC.ROUTE_ID SYS_C00913849 R
ROUTE_STOP.ROUTE_ID SYS_C00913845 R
TRANSFER_LOCATION_ID number 22  √  null
LOCATION.LOCATION_ID SYS_C00913839 R
NAME varchar2 30
COMPANY number 4
COMPANY.COMPANY_NO SYS_C00913838 R
SEQUENCE_NO number 5
IS_DEFAULT_ROUTE char 1  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
ROUTE_ID Primary key Asc SYS_C00913837

Close relationships  within of separation: