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