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
Referenced
There are no tables referenced by table tbcorrespbijlages
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbcorrespbijlages (
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
)
WITH (oids = false);
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 10-5-2021 13:56 |
![]() ![]() ![]() |