Datadictionary OpenWave 3.1.35 |
|
Table: tbkophdfst3en4mba
Datadictionary OpenWave 3.1.35 |
|
Table: tbkophdfst3en4mba
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel die MBA activiteiten (tbsrttoestemming)van hoofdstuk 3 koppelt aan MBA activiteiten (tbsrttoestemming) van hoofdstuk 4 of 5 of 2
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbkophdfst3en4mba_dnkey_seq'::regclass) |
Primary key van de koppeltabel |
|
|
dnkeysrttoestemming3 |
integer |
|
|
|
|
Foreign key naar tbsrttoestemming hoofdstuk 3 MBA activiteit |
|
|
dnkeysrttoestemming4 |
integer |
|
|
|
|
Foreign key naar tbsrttoestemming hoofdstuk 4 of 5 of 2 MBA activiteit |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbkophdfst3en4mba_dnkeysrttoestemming3 |
dnkeysrttoestemming3 |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkophdfst3en4mba_dnkeysrttoestemming4 |
dnkeysrttoestemming4 |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbkophdfst3en4mba_dnkeysrttoestemming3 |
dnkeysrttoestemming3 IS NOT NULL |
|
cnn_tbkophdfst3en4mba_dnkeysrttoestemming4 |
dnkeysrttoestemming4 IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkophdfst3en4mba |
btree |
|
dnkey |
|
|
|
idu_tbkophdfst3en4mba_keysrttoesteming34 |
btree |
|
dnkeysrttoestemming3, dnkeysrttoestemming4 |
|
|
|
Triggers
There are no triggers for table tbkophdfst3en4mba
Rules
There are no rules for table tbkophdfst3en4mba
Policies
There are no policies for table tbkophdfst3en4mba
Referenced
There are no tables referenced by table tbkophdfst3en4mba
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeysrttoestemming3 INTEGER STORAGE PLAIN,
dnkeysrttoestemming4 INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbkophdfst3en4mba PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbkophdfst3en4mba_dnkeysrttoestemming3 CHECK (dnkeysrttoestemming3 IS NOT NULL),
CONSTRAINT cnn_tbkophdfst3en4mba_dnkeysrttoestemming4 CHECK (dnkeysrttoestemming4 IS NOT NULL),
CONSTRAINT cfk_tbkophdfst3en4mba_dnkeysrttoestemming3 FOREIGN KEY (dnkeysrttoestemming3)
REFERENCES public.tbsrttoestemming(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkophdfst3en4mba_dnkeysrttoestemming4 FOREIGN KEY (dnkeysrttoestemming4)
REFERENCES public.tbsrttoestemming(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbkophdfst3en4mba
IS 'Koppeltabel die MBA activiteiten (tbsrttoestemming)van hoofdstuk 3 koppelt aan MBA activiteiten (tbsrttoestemming) van hoofdstuk 4 of 5 of 2';
COMMENT ON COLUMN public.tbkophdfst3en4mba.dnkey
IS 'Primary key van de koppeltabel';
COMMENT ON COLUMN public.tbkophdfst3en4mba.dnkeysrttoestemming3
IS 'Foreign key naar tbsrttoestemming hoofdstuk 3 MBA activiteit';
COMMENT ON COLUMN public.tbkophdfst3en4mba.dnkeysrttoestemming4
IS 'Foreign key naar tbsrttoestemming hoofdstuk 4 of 5 of 2 MBA activiteit';
CREATE UNIQUE INDEX idu_tbkophdfst3en4mba_keysrttoesteming34 ON public.tbkophdfst3en4mba
USING btree (dnkeysrttoestemming3, dnkeysrttoestemming4);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 26/10/2026 11:10 |
|