recreation_maintenance_standard_code

-1 rows


Description

Codes describing the maintenance standards for recreation projects.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
maintenance_standard_code varchar 1 null
recreation_maintenance_standard_code_history.maintenance_standard_code Implied Constraint R
recreation_resource.maintenance_standard_code recreation_resource_maintenance_standard_code_fkey R
recreation_resource_history.maintenance_standard_code Implied Constraint R

Code describing the Maintenance Standard of a given site. E.g. User Maintained, Maintained to Standard, Not Maintained.
description varchar 200 null

Description of the code value
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_maintenance_standard_code_pkey Primary key Asc maintenance_standard_code

Relationships

Close relationships within degrees of separation