recreation_activity

-1 rows


Description

The types of available activities for a given project.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 200 null
recreation_resource.rec_resource_id recreation_activity_rec_resource_id_fkey R

File identification assigned to Recreation Resources. Assigned file number. Usually the Licence, Tenure or Private Mark number.
recreation_activity_code int4 10 null
recreation_activity_code.recreation_activity_code recreation_activity_recreation_activity_code_fkey R

Code describing the Recreation Activity.
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)
idx_recreation_activity_rec_resource_id Performance Asc rec_resource_id
recreation_activity_rec_resource_id_recreation_activity_cod_key Must be unique Asc/Asc rec_resource_id + recreation_activity_code

Relationships

Close relationships within degrees of separation