Table mob_odm2.odm2.spatialreferences 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
spatialreferenceid serial 10  √  nextval('odm2.spatialreferences_spatialreferenceid_seq'::regclass)
categoricalresults.spatialreferenceid fk_categoricalresults_spatialreferences C
measurementresults.spatialreferenceid fk_measurementresults_spatialreferences C
pointcoverageresults.spatialreferenceid fk_pointcoverageresults_spatialreferences C
profileresults.spatialreferenceid fk_profileresults_spatialreferences C
sectionresults.spatialreferenceid fk_sectionresults_spatialreferences C
sites.spatialreferenceid fk_sites_spatialreferences C
spatialreferenceexternalidentifiers.spatialreferenceid fk_spatialreferenceexternalidentifiers_spatialreferences C
spectraresults.spatialreferenceid fk_spectraresults_spatialreferences C
timeseriesresults.spatialreferenceid fk_timeseriesresults_spatialreferences C
trajectoryresults.spatialreferenceid fk_trajectoryresults_spatialreferences C
transectresults.spatialreferenceid fk_transectresults_spatialreferences C
srscode varchar 50  √  null
srsname varchar 255
srsdescription varchar 5000  √  null
srslink varchar 255  √  null

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
spatialreferenceid Primary key Asc spatialreferences_pkey

Close relationships  within of separation: