fam_forest_client

-1 rows


Description

A forest client is a business, individual, or agency that is identified as an entity that a user can have a privilege “on behalf of”.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
client_number_id int8 19 √ null
fam_group.client_number_id reffam_forest_client25 R
fam_role.client_number_id reffam_forest_client24 R

Sequentially assigned number to identify a ministry client.
create_user varchar 100 null

The user or proxy account that created the record.
create_date timestamptz 35,6 CURRENT_TIMESTAMP

The date and time the record was created.
update_user varchar 100 √ null

The user or proxy account that created or last updated the record.
update_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The date and time the record was created or last updated.
forest_client_number varchar 2147483647 null

Id number as String from external Forest Client source(api/table) that identifies the Forest Client.

Indexes

Constraint Name Type Sort Column(s)
fam_for_cli_pk Primary key Asc client_number_id
fam_for_cli_num_uk Must be unique Asc forest_client_number
ix_app_fam_fam_forest_client_forest_client_number Performance Asc forest_client_number

Relationships

Close relationships within degrees of separation