recreation_fee_sub_code

-1 rows


Description

Recreation fee sub-types that roll up to a fee type.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
recreation_fee_code varchar 1 null
recreation_fee.recreation_fee_code recreation_fee_sub_code_fk R
recreation_fee_code.recreation_fee_code recreation_fee_sub_code_recreation_fee_code_fkey R

Parent recreation fee type code.
recreation_fee_sub_code varchar 30 null
recreation_fee.recreation_fee_sub_code recreation_fee_sub_code_fk R

A code indicating a specific recreation fee sub-type.
description varchar 120 null

Description of the recreation fee sub-type.
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_fee_sub_code_pkey Primary key Asc/Asc recreation_fee_code + recreation_fee_sub_code

Relationships

Close relationships within degrees of separation