sip.account

↑ sip schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('sip.account_id_seq'::regclass)

enabled

boolean

No

true

setting_group FK

integer

No

→ sip.setting_group(id)

sip_username

text

No

usr FK

bigint

No

→ actor.usr(id)

workstation FK

integer

Yes

→ actor.workstation(id)

transient

boolean

No

false

activity_who

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

setting_group

sip.setting_group(id)

NO ACTION

NO ACTION

DEFERRED

account_setting_group_fkey

usr

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

account_usr_fkey

workstation

actor.workstation(id)

NO ACTION

NO ACTION

No

account_workstation_fkey

Unique Constraints

  • account_sip_username_key: (sip_username)

Indexes

Index Method Definition

account_pkey PK

btree

CREATE UNIQUE INDEX account_pkey ON sip.account USING btree (id)

account_sip_username_key UNIQUE

btree

CREATE UNIQUE INDEX account_sip_username_key ON sip.account USING btree (sip_username)

Referenced By

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

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

sip.session

account

id

session_account_fkey
Previous
Next