recreation_resource_type_view_public

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

SELECT rr.rec_resource_id,
        CASE
            WHEN ((rr.display_on_public_site = true) AND ((rmf.recreation_resource_type)::text = 'RR'::text)) THEN 'SIT'::character varying
            ELSE rmf.recreation_resource_type
        END AS rec_resource_type_code,
    rrtc.description
   FROM ((rst.recreation_resource rr
     LEFT JOIN ( SELECT DISTINCT ON (recreation_map_feature.rec_resource_id) recreation_map_feature.rec_resource_id,
            recreation_map_feature.recreation_resource_type,
            recreation_map_feature.amend_status_date
           FROM rst.recreation_map_feature
          ORDER BY recreation_map_feature.rec_resource_id, recreation_map_feature.amend_status_date DESC) rmf ON (((rr.rec_resource_id)::text = (rmf.rec_resource_id)::text)))
     LEFT JOIN rst.recreation_resource_type_code rrtc ON (((
        CASE
            WHEN ((rr.display_on_public_site = true) AND ((rmf.recreation_resource_type)::text = 'RR'::text)) THEN 'SIT'::character varying
            ELSE rmf.recreation_resource_type
        END)::text = (rrtc.rec_resource_type_code)::text)));

Possibly Referenced Tables/Views

recreation_map_feature

recreation_resource_type_view_public

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views