Datadictionary OpenWave 3.1.25 |
|
View: vwadm_foreignkeys_noaction
Datadictionary OpenWave 3.1.25 |
|
View: vwadm_foreignkeys_noaction
Schema
public
Owner
waveuser005
Descriptions
View van alle foreign keyconstraints met No Action, 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 |
Kolomnaam van de referencetabel (meestal de primary key kolom) |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwadm_foreignkeys_noaction
Definition
dvfkconstraintname,
dnidbrontabel,
dvbrontabelnaam,
dvbronkolomnaam,
dnidreferencetabel,
dvreferencetabelnaam,
dvreferencekolomnaam)
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
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 a.confdeltype = 'a'::"char" AND
upper(a.conname::text) ~~ 'CFK_%'::text;
COMMENT ON VIEW public.vwadm_foreignkeys_noaction
IS 'View van alle foreign keyconstraints met No Action, waarvan de naam begint met CFK_';
COMMENT ON COLUMN public.vwadm_foreignkeys_noaction.dvfkconstraintname
IS 'Naam Van de foreign key constraint';
COMMENT ON COLUMN public.vwadm_foreignkeys_noaction.dnidbrontabel
IS 'ID in pg_class van de tabel waarbij de foreign key gedefinieerd is';
COMMENT ON COLUMN public.vwadm_foreignkeys_noaction.dvbrontabelnaam
IS 'Naam van de tabel waarbij de foreign key gedefinieerd is';
COMMENT ON COLUMN public.vwadm_foreignkeys_noaction.dvbronkolomnaam
IS 'Kolomnaam in de brontabel waaruit de foreign key gedefinieerd is';
COMMENT ON COLUMN public.vwadm_foreignkeys_noaction.dnidreferencetabel
IS 'ID in pg_class van de reference tabel';
COMMENT ON COLUMN public.vwadm_foreignkeys_noaction.dvreferencetabelnaam
IS 'Naam van de referencetabel';
COMMENT ON COLUMN public.vwadm_foreignkeys_noaction.dvreferencekolomnaam
IS 'Kolomnaam van de referencetabel (meestal de primary key kolom)';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|