recreation_resource_type_view

0 rows


Description

Provides a list of resource type codes and descriptions for recreation resources to be used as the source of truth for getting the recreation resource type code for a recreation resource for display on the public site. This was needed to mitigate bugs from junk data in the recreation map feature table as well as the request to show some recreation reserves as sites on the public site.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 20 √ null
recreation_resource.rec_resource_id Implied Constraint R
rec_resource_type_code varchar 2147483647 √ null
description varchar 200 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views