recreation_fee_fdl_log

-1 rows


Description

Append-only audit log recording each time a fee determination letter was confirmed by staff when creating or updating a recreation fee.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('rst.recreation_fee_fdl_log_id_seq'::regclass)

Surrogate primary key.
fee_id int4 10 null
recreation_fee.fee_id recreation_fee_fdl_log_fee_id_fkey R

Foreign key to the recreation fee this confirmation relates to.
confirmed_by text 2147483647 null

IDIR username of the staff member who confirmed the fee determination letter.
confirmed_at timestamptz 35,6 now()

Timestamp when the confirmation was recorded.

Indexes

Constraint Name Type Sort Column(s)
recreation_fee_fdl_log_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation