Datadictionary OpenWave 3.1.25 |
|
Table: tbcorrespbijlages
Datadictionary OpenWave 3.1.25 |
|
Table: tbcorrespbijlages
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met bijlages dubbel gelinkt aan tbcorrespondentie (geregisteerde documenten)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbcorrespbijlages_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeycorrespondentie |
integer |
|
|
|
|
Foreign key naar tbcorrespondentie.dnkey (geregistreerd document) waar de bijlage bijhoort |
|
|
dnkeybijlage |
integer |
|
|
|
|
Foreign key naar tbcorrespondentie.dnkey naar de bijlage |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbcorrespbijl_keybijlage |
dnkeybijlage |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbcorrespbijl_keycorresp |
dnkeycorrespondentie |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbcorrespbijl_keybijlage |
dnkeybijlage IS NOT NULL |
|
cnn_tbcorrespbijl_keycorresp |
dnkeycorrespondentie IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbcorrespbijlages |
btree |
|
dnkey |
|
|
|
idu_correspbijl_keycorresp |
btree |
|
dnkeycorrespondentie, dnkeybijlage |
|
|
|
Triggers
There are no triggers for table tbcorrespbijlages
Rules
There are no rules for table tbcorrespbijlages
Policies
There are no policies for table tbcorrespbijlages
Referenced
There are no tables referenced by table tbcorrespbijlages
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeycorrespondentie INTEGER,
dnkeybijlage INTEGER,
CONSTRAINT cpk_tbcorrespbijlages PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbcorrespbijl_keybijlage CHECK (dnkeybijlage IS NOT NULL),
CONSTRAINT cnn_tbcorrespbijl_keycorresp CHECK (dnkeycorrespondentie IS NOT NULL),
CONSTRAINT cfk_tbcorrespbijl_keybijlage FOREIGN KEY (dnkeybijlage)
REFERENCES public.tbcorrespondentie(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbcorrespbijl_keycorresp FOREIGN KEY (dnkeycorrespondentie)
REFERENCES public.tbcorrespondentie(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbcorrespbijlages
IS 'Tabel met bijlages dubbel gelinkt aan tbcorrespondentie (geregisteerde documenten)';
COMMENT ON COLUMN public.tbcorrespbijlages.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbcorrespbijlages.dnkeycorrespondentie
IS 'Foreign key naar tbcorrespondentie.dnkey (geregistreerd document) waar de bijlage bijhoort';
COMMENT ON COLUMN public.tbcorrespbijlages.dnkeybijlage
IS 'Foreign key naar tbcorrespondentie.dnkey naar de bijlage';
CREATE UNIQUE INDEX idu_correspbijl_keycorresp ON public.tbcorrespbijlages
USING btree (dnkeycorrespondentie, dnkeybijlage);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|