lakeparameters

22654 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
siteid int4 10 null
sites.siteid fk_lakeparameters_sitesC

FK: SiteID links to Sites table

lakeparameterid int4 10 null
lakeparametertypes.lakeparameterid fk_lakeparameters_lakeparametertypesC

FK: LakeParameter ID links to LakeParameterTypes table

value float8 17,17 null

Numerical value of parameter

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
lakeparameters_pkey Primary key Asc/Asc siteid + lakeparameterid
ix_lakeparameterid_lakeparameters Performance Asc lakeparameterid
ix_siteid_lakeparameters Performance Asc siteid

Relationships