Datadictionary OpenWave 3.1.25 |
|
Table: tbkopcompgem
Datadictionary OpenWave 3.1.25 |
|
Table: tbkopcompgem
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppelingstabel tussen tbcompartiment en tb33gemeente
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbkopcompgem_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeycompartiment |
integer |
|
|
|
|
Foreign Key naar Tbcompartiment.DnKey. |
|
|
dnkey33gemeente |
integer |
|
|
|
|
Foreign Key naar Tb33gemeente.DnKey. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_kopcompgem_keycomp |
dnkeycompartiment |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_kopcompgem_keygem |
dnkey33gemeente |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_kopcompgemt_key33gem |
dnkey33gemeente IS NOT NULL |
|
cnn_kopcompgemt_keycomp |
dnkeycompartiment IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkopcompgem |
btree |
|
dnkey |
|
|
|
idu_kopcompgem_keycompkeygem |
btree |
|
dnkeycompartiment, dnkey33gemeente |
|
|
|
Triggers
There are no triggers for table tbkopcompgem
Rules
There are no rules for table tbkopcompgem
Policies
There are no policies for table tbkopcompgem
Referenced
There are no tables referenced by table tbkopcompgem
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeycompartiment INTEGER,
dnkey33gemeente INTEGER,
CONSTRAINT cpk_tbkopcompgem PRIMARY KEY(dnkey),
CONSTRAINT cnn_kopcompgemt_key33gem CHECK (dnkey33gemeente IS NOT NULL),
CONSTRAINT cnn_kopcompgemt_keycomp CHECK (dnkeycompartiment IS NOT NULL),
CONSTRAINT cfk_kopcompgem_keycomp FOREIGN KEY (dnkeycompartiment)
REFERENCES public.tbcompartiment(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_kopcompgem_keygem FOREIGN KEY (dnkey33gemeente)
REFERENCES public.tb33gemeente(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbkopcompgem
IS 'Koppelingstabel tussen tbcompartiment en tb33gemeente';
COMMENT ON COLUMN public.tbkopcompgem.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbkopcompgem.dnkeycompartiment
IS 'Foreign Key naar Tbcompartiment.DnKey.';
COMMENT ON COLUMN public.tbkopcompgem.dnkey33gemeente
IS 'Foreign Key naar Tb33gemeente.DnKey.';
CREATE UNIQUE INDEX idu_kopcompgem_keycompkeygem ON public.tbkopcompgem
USING btree (dnkeycompartiment, dnkey33gemeente);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|