recreation_partner_relationship_type_code

-1 rows


Description

Codes describing the type of relationship a partner holds with a recreation resource (e.g. Site Operator). Not FTA-synced; managed internally.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
partner_relationship_type_code varchar 20 null
recreation_agreement_holder.partner_relationship_type_code recreation_agreement_holder_partner_relationship_type_code_fkey R
recreation_agreement_holder_history.partner_relationship_type_code Implied Constraint R
recreation_partner_relationship_type_code_history.partner_relationship_type_code Implied Constraint R

Code identifying the partner relationship type.
description varchar 120 null

Description of the partner relationship type.
updated_at timestamp 29,6 √ now()
sys_period tstzrange 2147483647 tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone)

Indexes

Constraint Name Type Sort Column(s)
recreation_partner_relationship_type_code_pkey Primary key Asc partner_relationship_type_code

Relationships

Close relationships within degrees of separation