admin_transfer

-1 rows


Description

Table represents transfers made by PBJ Administrators

Columns

Column Type Size Nulls Auto Default Children Parents Comments
admin_transfer_id int8 19 null
dim_transfer_method_id int4 10 null
dim_transfer_method.dim_transfer_method_id admin_transfer_dim_transfer_method_id_fkey R
customer_id int4 10 √ null
customer.customer_id Implied Constraint R
administrator_id int4 10 √ null
administrator.administrator_id admin_transfer_administrator_id_fkey R
internal_comment text 2147483647 √ null
external_comment text 2147483647 √ null
transfer_timestamp timestamptz 35,6 √ null
amount numeric 14,2 √ null
dim_date_id int4 10 √ null
dim_date.dim_date_id admin_transfer_dim_date_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
admin_transfer_pkey Primary key Asc/Asc admin_transfer_id + dim_transfer_method_id
admin_transfer_timestamp_idx Performance Asc transfer_timestamp

Relationships

Close relationships within degrees of separation