contracts

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Contract ID
fork	integer	plain		forks.ID	Fork ID (`null` for base module)
ownergroup	integer	plain		groups.ID	Owner group ID (`null`=PUBLIC)
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
assigneduser	integer	plain		users.ID	Assigned user ID
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: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
account	integer	plain		accounts.ID	Account ID
visibility	smallint	plain			Default: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text	main			Name
contractnum	text	main			Default: ''Contract number
date	bigint	plain			Default: EXTRACT(epoch FROM now())Designated date and time as a Unix timestamp (defaults to current date and time on creation)
datefrom	bigint	plain			Start date as a Unix timestamp; must be less than or equal to `dateto`
dateto	bigint	plain			End date as a Unix timestamp; must be greater than or equal to `datefrom`
datecancel	bigint	plain			Cancellation date as a Unix timestamp
status	smallint	plain			Default: 0Status (`0`=DRAFT, `1`=AWAITINGAPPROVAL, `2`=APPROVED, `3`=DISMISSED, `4`=ACTIVE, `5`=INACTIVE, `6`=EXPIRED, `7`=CANCELLED, `8`=CLOSED)
currency	character varying(3)	extended			Currency code (ISO 4217)
exchangerate	double precision	plain			Default: 1Exchange rate as a multiple of one monetary unit of the fixed system currency
billingcycle	smallint	plain			Billing cycle in months
lastbilling	bigint	plain			Last billing date and time as a Unix timestamp
description	text	extended			Default: ''Detailed general description
contractitems	json	extended			JSON-encoded items (array)
billingitems	json	extended			JSON-encoded items (array)
procurementitems	json	extended			JSON-encoded items (array)
autobilling	json	extended			JSON-encoded auto-billing data (object); only if `billingcycle` is not `null`

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_contracts_account					btree	account
fk_contracts_assigneduser					gin	assigneduser
fk_contracts_fork					gin	fork
fk_contracts_ownergroup					gin	ownergroup
i_contracts_autobilling					gin	status
i_contracts_date					btree	date
i_contracts_nofork					gin	fork
i_contracts_noowner					gin	ownergroup
pk_contracts					btree	ID
s_contracts_contractnum					gin	contractnum
s_contracts_name					gin	name

Name	Type
c_contracts_date	check
dc_contracts_autobilling	check
dc_contracts_billingcycle	check
dc_contracts_billingitems	check
dc_contracts_contractitems	check
dc_contracts_contractnum	check
dc_contracts_currency	check
dc_contracts_description	check
dc_contracts_exchangerate	check
dc_contracts_name	check
dc_contracts_procurementitems	check
dc_contracts_status	check
dc_contracts_visibility	check
fk_contracts_account	foreign_key
fk_contracts_assigneduser	foreign_key
fk_contracts_creator	foreign_key
fk_contracts_fork	foreign_key
fk_contracts_ownergroup	foreign_key
pk_contracts	primary_key

Loading...