Datadictionary OpenWave 3.1.23
Previous topic Chapter index Next topic

Table: tbcorafschriften

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Koppeltabel tussen een uitgaande correspondentiekaart en een lijst van afschriften (cobtacadressen die cc per mail moeten ontvangen bij uigaande correspondentie

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbcorafschriften_dnkey_seq'::regclass)

Primary key.

 

dnkeycorrespondentie

integer

 

 

 

 

Foreign key naar TbCorrespondentie.dnkey

 

dnkeydefafschriften

integer

 

 

 

 

Foreign key naar TbDefAfschriften.dnkey

 

dnkeycontactadressen

integer

 

 

 

 

Foreign key naar Tbcontactadressen.dnkey

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_corafschr_keycontact

dnkeycontactadressen

public.tbcontactadressen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbcorafschr_keycorresp

dnkeycorrespondentie

public.tbcorrespondentie

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbcorafschr_keydefaf

dnkeydefafschriften

public.tbdefafschriften

dnkey

Set Null

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

cnn_corafschr_keycontact

dnkeycontactadressen IS NOT NULL

 

cnn_corafschr_keycorresp

dnkeycorrespondentie IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbcorafschriften

btree

 

dnkey

 

idx_corafschr_keycorresp

btree

 

dnkeycorrespondentie

 

 

 

idx_corafschr_keydefafschr

btree

 

dnkeydefafschriften

 

 

 

 

Triggers

There are no triggers for table tbcorafschriften

 

Rules

There are no rules for table tbcorafschriften

 

Referenced

There are no tables referenced by table tbcorafschriften

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbcorafschriften (
 dnkey SERIAL,
 dnkeycorrespondentie INTEGER,
 dnkeydefafschriften INTEGER,
 dnkeycontactadressen INTEGER,
 CONSTRAINT cpk_tbcorafschriften PRIMARY KEY(dnkey),
 CONSTRAINT cnn_corafschr_keycontact CHECK (dnkeycontactadressen IS NOT NULL),
 CONSTRAINT cnn_corafschr_keycorresp CHECK (dnkeycorrespondentie IS NOT NULL),
 CONSTRAINT cfk_corafschr_keycontact FOREIGN KEY (dnkeycontactadressen)
   REFERENCES public.tbcontactadressen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
,
 CONSTRAINT cfk_tbcorafschr_keycorresp FOREIGN KEY (dnkeycorrespondentie)
   REFERENCES public.tbcorrespondentie(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
,
 CONSTRAINT cfk_tbcorafschr_keydefaf FOREIGN KEY (dnkeydefafschriften)
   REFERENCES public.tbdefafschriften(dnkey)
   ON DELETE SET NULL
   ON UPDATE NO ACTION
   NOT DEFERRABLE

)
WITH (oids = false);

COMMENT ON TABLE public.tbcorafschriften
IS 'Koppeltabel tussen een uitgaande correspondentiekaart en een lijst van afschriften (cobtacadressen die cc per mail moeten ontvangen bij uigaande correspondentie';

COMMENT ON COLUMN public.tbcorafschriften.dnkey
IS 'Primary key.';

COMMENT ON COLUMN public.tbcorafschriften.dnkeycorrespondentie
IS 'Foreign key naar TbCorrespondentie.dnkey';

COMMENT ON COLUMN public.tbcorafschriften.dnkeydefafschriften
IS 'Foreign key naar TbDefAfschriften.dnkey';

COMMENT ON COLUMN public.tbcorafschriften.dnkeycontactadressen
IS 'Foreign key naar Tbcontactadressen.dnkey';

CREATE INDEX idx_corafschr_keycorresp ON public.tbcorafschriften
 USING btree (dnkeycorrespondentie);

CREATE INDEX idx_corafschr_keydefafschr ON public.tbcorafschriften
 USING btree (dnkeydefafschriften);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 10-5-2021 13:56
Previous topic Chapter index Next topic