Datadictionary OpenWave 3.1.32 |
|
Table: tbkoppelbklactrefcontour
Datadictionary OpenWave 3.1.32 |
|
Table: tbkoppelbklactrefcontour
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevrefcontour (REV referentiecontouren)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbkoppelbklactrefcontour_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeymilcodebkl |
integer |
|
|
|
|
Foreign key naar REV BKL-activiteit (tbmilcodebkl.dnkey |
|
|
dnkeyrevrefcontour |
integer |
|
|
|
|
Foreign key naar REV referentiecontour (tbrevrefcontour.dnkey) |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbkoppelbklactrefcontour_keymilcodebkl |
dnkeymilcodebkl |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkoppelbklactrefcontour_keyrevrefcontour |
dnkeyrevrefcontour |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbkoppelbklactrefcontour_keymilcodebkl |
dnkeymilcodebkl IS NOT NULL |
|
cnn_tbkoppelbklactrefcontour_keyrevrefcontour |
dnkeyrevrefcontour IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkoppelbklactrefcontour |
btree |
|
dnkey |
|
|
|
idu_koppelbklactrefcontour_bklrefcontour |
btree |
|
dnkeymilcodebkl, dnkeyrevrefcontour |
|
|
|
Triggers
There are no triggers for table tbkoppelbklactrefcontour
Rules
There are no rules for table tbkoppelbklactrefcontour
Policies
There are no policies for table tbkoppelbklactrefcontour
Referenced
There are no tables referenced by table tbkoppelbklactrefcontour
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodebkl INTEGER,
dnkeyrevrefcontour INTEGER,
CONSTRAINT cpk_tbkoppelbklactrefcontour PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbkoppelbklactrefcontour_keymilcodebkl CHECK (dnkeymilcodebkl IS NOT NULL),
CONSTRAINT cnn_tbkoppelbklactrefcontour_keyrevrefcontour CHECK (dnkeyrevrefcontour IS NOT NULL),
CONSTRAINT cfk_tbkoppelbklactrefcontour_keymilcodebkl FOREIGN KEY (dnkeymilcodebkl)
REFERENCES public.tbmilcodebkl(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkoppelbklactrefcontour_keyrevrefcontour FOREIGN KEY (dnkeyrevrefcontour)
REFERENCES public.tbrevrefcontour(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbkoppelbklactrefcontour
IS 'Koppeltabel tbmilcodebkl (BKL-activiteiten) en tbrevrefcontour (REV referentiecontouren)';
COMMENT ON COLUMN public.tbkoppelbklactrefcontour.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbkoppelbklactrefcontour.dnkeymilcodebkl
IS 'Foreign key naar REV BKL-activiteit (tbmilcodebkl.dnkey';
COMMENT ON COLUMN public.tbkoppelbklactrefcontour.dnkeyrevrefcontour
IS 'Foreign key naar REV referentiecontour (tbrevrefcontour.dnkey)';
CREATE UNIQUE INDEX idu_koppelbklactrefcontour_bklrefcontour ON public.tbkoppelbklactrefcontour
USING btree (dnkeymilcodebkl, dnkeyrevrefcontour);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|