ledgers

Module: payments

Financial ledgers for payment categorization.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Ledger ID
fork forks.ID	integer			Fork ID (`null` for base module)
ownergroup groups.ID	integer			Owner group ID (`null`=PUBLIC)
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		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
visibility	smallint		0	Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text			Name
description	text		''	Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_ledgers_fork					gin	fork
fk_ledgers_ownergroup					gin	ownergroup
i_ledgers_nofork					gin	fork
i_ledgers_noowner					gin	ownergroup
pk_ledgers					btree	ID
s_ledgers_name					gin	name

Name	Type
dc_ledgers_description	check
dc_ledgers_name	check
dc_ledgers_visibility	check
fk_ledgers_fork	foreign_key
fk_ledgers_ownergroup	foreign_key
pk_ledgers	primary_key

Loading...