Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| rmf_skey | int4 | 10 | null |
|
|
The SKEY for the RECREATION MAP FEATURE. |
|||||
| rec_resource_id | varchar | 10 | √ | null |
|
|
File identification assigned to Provincial Forest Use files. Assigned file number. Usually the Licence, Tenure or Private Mark number. |
||||
| section_id | varchar | 30 | √ | null |
|
|
The section id for the RECREATION MAP FEATURE. |
||||
| amendment_id | int4 | 10 | √ | null |
|
|
The amendment id for the RECREATION MAP FEATURE. |
||||
| amend_status_code | varchar | 3 | √ | null |
|
|
Code to indicate status of amendment, that is, pending, approved or disallowed. This references Timber_Status_Code. |
||||
| recreation_resource_type | varchar | 3 | √ | null |
|
|
Identifies the RECREATION MAP FEATURE TYPE CODE. |
||||
| amend_status_date | date | 13 | √ | null |
|
|
The date the amendment status was changed. |
||||
| retirement_date | date | 13 | √ | null |
|
|
The date the entry is retired. |
||||
| revision_count | int4 | 10 | √ | null |
|
|
A count of the number of times an entry in the entity has been modified. Used to validate if the current information displayed on a user’s web browser is the most current. |
||||
| recreation_map_feature_guid | varchar | 36 | √ | null |
|
|
Global Unique Identifier generated by the system for new records. It was added for FTA 5. |
||||
| updated_at | timestamp | 29,6 | √ | now() |
|
|
The timestamp of the last update to the road section record. |
||||
| updated_by | text | 2147483647 | √ | null |
|
|
The userid of the individual who last updated this road section record. |
||||
| created_at | timestamp | 29,6 | √ | now() |
|
|
Contains the system timestamp when data in a table was inserted. |
||||
| created_by | text | 2147483647 | √ | null |
|
|
The userid responsible for inserting data into a table. |
||||
| sys_period | tstzrange | 2147483647 | tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| recreation_map_feature_pkey | Primary key | Asc | rmf_skey |
| idx_recreation_map_feature_rec_resource_id | Performance | Asc | rec_resource_id |
| idx_recreation_map_feature_recreation_resource_type | Performance | Asc | recreation_resource_type |
| idx_recreation_map_feature_rmf_skey | Performance | Asc | rmf_skey |
| recreation_map_feature_rec_resource_id_section_id_key | Must be unique | Asc/Asc | rec_resource_id + section_id |
Relationships
Close relationships within degrees of separation
