Table slot9.WORLD.TSTA.MAP_SHAPE_POINTS
This table is used for mapping and a shape is defined for an agency on the agency admin page
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
SHAPE_ID number 38
MAP_SHAPES.SHAPE_ID MSP_MS_FK C
LONGITUDE varchar2 30
LATITUDE varchar2 30
POINT_INDEX number 38

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"POINT_INDEX" IS NOT NULL MSP_INDEX_NN
"LATITUDE" IS NOT NULL MSP_LATITUDE_NN
"LONGITUDE" IS NOT NULL MSP_LONGITUDE_NN
"SHAPE_ID" IS NOT NULL MSP_SHAPE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
SHAPE_ID + LATITUDE + LONGITUDE Primary key Asc/Asc/Asc MSP_PK
SHAPE_ID Performance Asc MSP_MS_FK_I

Close relationships  within of separation: