config.geolocation_service

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.geolocation_service_id_seq'::regclass)
active	`boolean`	Yes
owner FK	`integer`	No		→ actor.org_unit(id)
name	`text`	Yes
service_code	`text`	Yes
api_key	`text`	Yes

id PK

integer

nextval('config.geolocation_service_id_seq'::regclass)

active

boolean

Yes

owner FK

integer

name

text

Yes

service_code

text

Yes

api_key

text

Yes

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owner`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`cgs_owner_fkey`

owner

NO ACTION

DEFERRED

cgs_owner_fkey

Index Method Definition

Index	Method	Definition
`geolocation_service_pkey` PK	btree	`CREATE UNIQUE INDEX geolocation_service_pkey ON config.geolocation_service USING btree (id)`

geolocation_service_pkey PK

btree

CREATE UNIQUE INDEX geolocation_service_pkey ON config.geolocation_service USING btree (id)