money.collections_tracker

↑ money schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: collections_tracker_collector_fkey, collections_tracker_location_fkey, collections_tracker_usr_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('money.collections_tracker_id_seq'::regclass)
usr FK	`integer`	No		→ actor.usr(id)
collector FK	`integer`	No		→ actor.usr(id)
location FK	`integer`	No		→ actor.org_unit(id)
enter_time	`timestamp with time zone`	Yes

id PK

bigint

nextval('money.collections_tracker_id_seq'::regclass)

usr FK

integer

→ actor.usr(id)

collector FK

integer

→ actor.usr(id)

location FK

integer

→ actor.org_unit(id)

enter_time

timestamp with time zone

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`collector`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`collections_tracker_collector_fkey`
`location`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`collections_tracker_location_fkey`
`usr`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`collections_tracker_usr_fkey`

collector

actor.usr(id)

NO ACTION

DEFERRED

collections_tracker_collector_fkey

location

actor.org_unit(id)

NO ACTION

DEFERRED

collections_tracker_location_fkey

usr

actor.usr(id)

NO ACTION

DEFERRED

collections_tracker_usr_fkey

Indexes

Index Method Definition

Index	Method	Definition
`collections_tracker_pkey` PK	btree	`CREATE UNIQUE INDEX collections_tracker_pkey ON money.collections_tracker USING btree (id)`
`m_c_t_usr_collector_location_once_idx` UNIQUE	btree	`CREATE UNIQUE INDEX m_c_t_usr_collector_location_once_idx ON money.collections_tracker USING btree (usr, collector, location)`
`m_c_t_collector_idx`	btree	`CREATE INDEX m_c_t_collector_idx ON money.collections_tracker USING btree (collector)`

collections_tracker_pkey PK

btree

CREATE UNIQUE INDEX collections_tracker_pkey ON money.collections_tracker USING btree (id)

m_c_t_usr_collector_location_once_idx UNIQUE

btree

CREATE UNIQUE INDEX m_c_t_usr_collector_location_once_idx ON money.collections_tracker USING btree (usr, collector, location)

m_c_t_collector_idx

btree

CREATE INDEX m_c_t_collector_idx ON money.collections_tracker USING btree (collector)