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)

Indexes

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

Relationships

Close relationships within degrees of separation