dunning2transactions

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Dunning-to-transaction ID
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
creationdate	bigint	plain			Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification)
dunning	integer	plain		dunning.ID	Dunning notice ID (**dependency**)
transaction	integer	plain		transactions.ID	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_creator	foreign_key
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...