dunning2transactions

Module: collection

Junction table linking dunning notices to transactions.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Dunning-to-transaction ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		EXTRACT(epoch FROM now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
dunning dunning.ID	integer			Dunning notice ID (**dependency**)
transaction transactions.ID	integer			Transaction ID (**dependency**)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_dunning2transactions_transaction					btree	transaction
pk_dunning2transactions					btree	ID
u_dunning2transactions_dunning_transaction					btree	dunning, transaction

Name	Type
fk_dunning2transactions_dunning	foreign_key
fk_dunning2transactions_transaction	foreign_key
pk_dunning2transactions	primary_key
u_dunning2transactions_dunning_transaction	unique

Name	Type	Events	Function	Definition
td_dunning2transactions_status	after	delete	ftd_dunning2transactions_status
ti_dunning2transactions_status	after	insert	fti_dunning2transactions_status
ti_dunning2transactions_transaction	before	insert	ftiu_dunning2transactions_transaction
tu_dunning2transactions_status	after	update	ftu_dunning2transactions_status
tu_dunning2transactions_transaction	before	update	ftiu_dunning2transactions_transaction

Loading...