recreation_asset_code

-1 rows


Description

Codes describing the classification type of an individual recreation asset (e.g. Campsite, Table, Toilet). Not FTA-synced; managed internally.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
asset_code serial 10 √ nextval('rst.recreation_asset_code_asset_code_seq'::regclass)
recreation_asset.asset_code fk_asset_asset_code R
recreation_asset_code_history.asset_code Implied Constraint R
recreation_asset_history.asset_code Implied Constraint R

Surrogate primary key for the asset type code.
description varchar 120 √ null

Description of the asset type.
updated_at timestamp 29,6 √ now()
updated_by text 2147483647 √ null
created_at timestamp 29,6 √ now()
created_by text 2147483647 √ null
sys_period tstzrange 2147483647 tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone)
has_length bool 1 false

Indicates whether a length measurement is applicable for this asset type (dimension code L).
has_width bool 1 false

Indicates whether a width measurement is applicable for this asset type (dimension code W).
has_area bool 1 false

Indicates whether an area measurement is applicable for this asset type (dimension code A).
default_value numeric 7,2 √ null

Default monetary value for an asset of this type, derived from the legacy structure type value/dimension (e.g., $50/m for Boardwalks).

Indexes

Constraint Name Type Sort Column(s)
recreation_asset_code_pkey Primary key Asc asset_code

Relationships

Close relationships within degrees of separation