money.billable_xact

↑ money schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('money.billable_xact_id_seq'::regclass)
usr FK	`integer`	No		→ actor.usr(id)
xact_start	`timestamp with time zone`	No	now()
xact_finish	`timestamp with time zone`	Yes
unrecovered	`boolean`	Yes

id PK

bigint

nextval('money.billable_xact_id_seq'::regclass)

usr FK

integer

→ actor.usr(id)

xact_start

timestamp with time zone

now()

xact_finish

timestamp with time zone

Yes

unrecovered

boolean

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`usr`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`money_billable_xact_usr_fkey`

usr

actor.usr(id)

NO ACTION

DEFERRED

money_billable_xact_usr_fkey

Indexes

Index Method Definition

Index	Method	Definition
`billable_xact_pkey` PK	btree	`CREATE UNIQUE INDEX billable_xact_pkey ON money.billable_xact USING btree (id)`
`m_b_x_open_xacts_idx`	btree	`CREATE INDEX m_b_x_open_xacts_idx ON money.billable_xact USING btree (usr)`

billable_xact_pkey PK

btree

CREATE UNIQUE INDEX billable_xact_pkey ON money.billable_xact USING btree (id)

m_b_x_open_xacts_idx

btree

CREATE INDEX m_b_x_open_xacts_idx ON money.billable_xact USING btree (usr)