recreation_asset_history

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
asset_id int8 19 null
parent_id int8 19 √ null
recreation_fee_fdl_log.id Implied Constraint R
asset_tag varchar 50 √ null
rec_resource_id varchar 20 null
recreation_resource.rec_resource_id Implied Constraint R
asset_code int4 10 null
recreation_asset_code.asset_code Implied Constraint R
asset_name varchar 200 √ null
asset_comment text 2147483647 √ null
legacy_structure_id varchar 20 √ null
asset_length numeric 7,1 √ null
asset_width numeric 7,1 √ null
asset_area numeric 7,1 √ null
default_value numeric 7,2 √ null
actual_value numeric 7,2 √ null
installation_date date 13 √ null
updated_at timestamp 29,6 √ null
updated_by text 2147483647 √ null
created_at timestamp 29,6 √ null
created_by text 2147483647 √ null
sys_period tstzrange 2147483647 null

Relationships

Close relationships within degrees of separation