config.billing_type

↑ config schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.billing_type_id_seq'::regclass)

name

text

No

owner FK

integer

No

→ actor.org_unit(id)

default_price

numeric(6,2)

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

config_billing_type_owner_fkey

Unique Constraints

  • billing_type_once_per_lib: (name, owner)

Indexes

Index Method Definition

billing_type_pkey PK

btree

CREATE UNIQUE INDEX billing_type_pkey ON config.billing_type USING btree (id)

billing_type_once_per_lib UNIQUE

btree

CREATE UNIQUE INDEX billing_type_once_per_lib ON config.billing_type USING btree (name, owner)

Referenced By

The following tables have foreign keys pointing to config.billing_type (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

money.billing

btype

id

billing_btype_fkey
Previous
Next