Schema
public
Owner
waveuser005
Descriptions
View van alle foreign keyconstraints met waarvan de naam begint met CFK_
Fields
Name | Data type | Description |
---|---|---|
dvfkconstraintname |
name |
Naam Van de foreign key constraint |
dnidbrontabel |
oid |
ID in pg_class van de tabel waarbij de foreign key gedefinieerd is |
dvbrontabelnaam |
name |
Naam van de tabel waarbij de foreign key gedefinieerd is |
dvbronkolomnaam |
name |
Kolomnaam in de brontabel waaruit de foreign key gedefinieerd is |
dnidreferencetabel |
oid |
ID in pg_class van de reference tabel |
dvreferencetabelnaam |
name |
Naam van de referencetabel |
dvreferencekolomnaam |
name |
Koomnaam van de referencetabel (meestal de primary key kolom) |
dvactiontype |
pg_catalog.char |
Actiontype bij delete van referentiekaart: a = no action, r = restrict, c = cascade, n = set null, d = set default |
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table vwadm_foreignkeys_allactiontype
Definition
CREATE VIEW public.vwadm_foreignkeys_allactiontype (
dvfkconstraintname,
dnidbrontabel,
dvbrontabelnaam,
dvbronkolomnaam,
dnidreferencetabel,
dvreferencetabelnaam,
dvreferencekolomnaam,
dvactiontype)
AS
SELECT a.conname AS dvfkconstraintname,
a.conrelid AS dnidbrontabel,
b.relname AS dvbrontabelnaam,
e.attname AS dvbronkolomnaam,
a.confrelid AS dnidreferencetabel,
d.relname AS dvreferencetabelnaam,
c.attname AS dvreferencekolomnaam,
a.confdeltype AS dvactiontype
FROM pg_constraint a
LEFT JOIN pg_class b ON a.conrelid = b.oid
LEFT JOIN pg_attribute c ON a.conindid = c.attrelid
LEFT JOIN pg_class d ON a.confrelid = d.oid
LEFT JOIN pg_attribute e ON a.conrelid = e.attrelid AND (('{'::text ||
e.attnum) || '}'::text) = a.conkey::character varying::text
WHERE a.contype = 'f'::"char" AND upper(a.conname::text) ~~ 'CFK_%'::text;
COMMENT ON VIEW public.vwadm_foreignkeys_allactiontype
IS 'View van alle foreign keyconstraints met waarvan de naam begint met CFK_';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dvfkconstraintname
IS 'Naam Van de foreign key constraint';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dnidbrontabel
IS 'ID in pg_class van de tabel waarbij de foreign key gedefinieerd is';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dvbrontabelnaam
IS 'Naam van de tabel waarbij de foreign key gedefinieerd is';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dvbronkolomnaam
IS 'Kolomnaam in de brontabel waaruit de foreign key gedefinieerd is';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dnidreferencetabel
IS 'ID in pg_class van de reference tabel';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dvreferencetabelnaam
IS 'Naam van de referencetabel';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dvreferencekolomnaam
IS 'Koomnaam van de referencetabel (meestal de primary key kolom)';
COMMENT ON COLUMN public.vwadm_foreignkeys_allactiontype.dvactiontype
IS 'Actiontype bij delete van referentiekaart: a = no action, r = restrict, c = cascade, n = set null, d = set default';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 25-10-2024 14:43 |
![]() ![]() ![]() |