speleothems

846 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
siteid int4 10 √ null
sites.siteid speleothems_siteid_fkey C
entityid serial 10 √ nextval('ndb.speleothems_entityid_seq'::regclass)
entitycovers.entityid entitycovers_entityid_fkey C
entitydripheight.entityid entitydripheight_entityid_fkey C
entitygeology.entityid entitygeology_entityid_fkey C
entitylandusecover.entityid entitylandusecover_entityid_fkey C
entityrelationship.entityid entityrelationship_entityid_fkey R
entityrelationship.referenceentityid entityrelationship_referenceentityid_fkey R
entitysamples.entityid entitysamples_entityid_fkey R
entityvegetationcover.entityid entityvegetationcover_entityid_fkey C
externalspeleothemdata.entityid externalspeleothemdata_entityid_fkey C
speleothemcollectionunits.entityid speleothemcollectionunits_entityid_fkey C
externalspeleothemdata.entityid externalspeleothemdata_entityid_fkey C
entityname text 2147483647 √ null
monitoring bool 1 √ null
rockageid int4 10 √ null
relativeages.relativeageid speleothems_rockageid_fkey R
entrancedistance float4 8,8 √ null
entrancedistanceunits int4 10 √ null
variableunits.variableunitsid speleothems_entrancedistanceunits_fkey R
speleothemtypeid int4 10 √ null
speleothemtypes.speleothemtypeid speleothems_speleothemtypeid_fkey R

Indexes

Constraint Name Type Sort Column(s)
speleothems_pkey Primary key Asc entityid

Relationships

Close relationships within degrees of separation